Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p><strong>Try the following:</strong></p> <ul> <li>Uninstall the application (just to make sure nothing is being cached)</li> <li>Go to the application-descriptor.xml </li> <li>Remove the JSONStore optional feature</li> <li>Build</li> <li>Make sure <code>armeabi/libdatabase_sqlite.so</code>, <code>x86/libdatabase_sqlcipher.so</code> and <code>sqlcipher.jar</code> are removed from the <code>native</code> folder under your Android environment. See the picture below under <strong>Files you care about</strong>.</li> <li>Go to application-descriptor.xml </li> <li>Enable the JSONStore optional feature</li> <li>Build</li> <li>Make sure <code>armeabi/libdatabase_sqlite.so</code>, <code>x86/libdatabase_sqlcipher.so</code> and <code>sqlcipher.jar</code> are back. Look at the <strong>FYI</strong> section for more details.</li> <li>Refresh the native Android project on Eclipse.</li> <li>Run on an emulator or device.</li> </ul> <p><strong>FYI</strong> </p> <p>The size and MD5 hashes on my machine (Mac OSX 10.9) for the working libraries. Size was determined with <code>ls -al</code> and the MD5 hash was generated with <code>md5 [file]</code>.</p> <p><strong>sqlcipher.jar</strong></p> <pre><code>Size: 103300 MD5 Hash: 8d7f4d682994158096763c24e3d79fb2 </code></pre> <p><strong>armeabi/libdatabase_sqlite.so</strong></p> <pre><code>Size: 365644 MD5 Hash: 07c4cf69d038c3fdcc7dd0490841ea3d </code></pre> <p><strong>x86/libdatabase_sqlcipher.so</strong></p> <pre><code>Size: 367020 MD5 Hash: 38756d70d256f8e5982ed9789705457f </code></pre> <p><strong>The files you care about:</strong></p> <p><img src="https://i.stack.imgur.com/l1Otl.png" alt="Files"></p> <p><strong>Still not working?</strong></p> <ul> <li>Create a new Worklight Project with v6.1 (won't work with other versions).</li> <li>Create a new Hybrid Application.</li> <li>Create an Android environments.</li> <li>Go to the application-descriptor.xml</li> <li>Enable JSONStore.</li> <li>Build.</li> <li>Confirm JSONStore works there. </li> </ul> <p>Here's a quick example:</p> <pre><code>var collections = { customers : { searchFields : { 'CUSTOMERCODE' : 'string' } } }; WL.JSONStore.init(collections) .then(function () { return WL.JSONStore.get('customers').add({'CUSTOMERCODE' : '456'}); }) .then(function () { return WL.JSONStore.get('customers').findAll(); }) .then(function (res) { alert(JSON.stringify(res)); }) .fail(function (err) { alert(err.toString()); }); }); </code></pre> <ul> <li>Copy <code>armeabi/libdatabase_sqlite.so</code>, <code>x86/libdatabase_sqlcipher.so</code> and <code>sqlcipher.jar</code> from that newly created project that works in Android v4.4 to your existing project. Make sure you build, uninstall a previous version of the app and refresh the native project before you send it to the device or emulator. </li> </ul>
    singulars
    1. This table or related slice is empty.
    1. POIBM Worklight 6.1 JsonStore issue on Android 4.4
      singulars
      1. PTQuestion
    1. PTAnswer
    1. UScnandreu
    1. UScnandreu
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POIBM Worklight 6.1 JsonStore issue on Android 4.4
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTAcceptedByOriginator
    1. COI have just tried this approach, but no success. Same exception is coming.
      singulars
      1. PO
      1. USSteve
    2. COI updated the my answer, try and let me know.
      singulars
      1. PO
      1. UScnandreu
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload