My Oracle Support Banner

How to Synchronize Data with Berkeley DB and Oracle Mobile Server 10.3.0.3.0 (Doc ID 1195354.1)

Last updated on JANUARY 08, 2020

Applies to:

Oracle Lite - Version 10.3.0.3.0 to 10.3.0.3.0 [Release 10.3]
Information in this document applies to any platform.
***Checked for relevance on 29-Aug-2013***

Details

Oracle Mobile Server 10.3.0.3.0 support to Synchronize the data from  Berkeley DB (BDB) 5.0 and higher.

NOTE: The data used below are not actual PRODUCTION or Customer Data.  They are being used ONLY to demonstrate the problem/solution discussed in this note.


But there is no simple Mobile Client for BDB, here the steps to do it:


Actions

Step 1: download BDB 5.0.26 from http://www.oracle.com/technetwork/database/berkeleydb/downloads/index-082944.html
I used the zip file: Berkeley DB 5.0.26.zip, with AES encryption (39M)
Building the Berkeley DB using these Doc
http://download.oracle.com/docs/cd/E17076_01/html/installation/build_win.html#id3766607


Step 2: Rename Binaries
Once you have built the binaries (libdb_sql50.dll and dbsql.exe) rename those files to sqlite3.dll and sqlite3.exe.

Step 3: Copy File to the Mobile Server
Copy those files to the Mobile Server under the following path:
$ORACLE_HOME/mobile_oc4j/j2ee/mobileserver/applications/mobileserver/setup/common/win32/sqlite


Modify the following file:
$ORACLE_HOME/mobile_oc4j/j2ee/mobileserver/applications/mobileserver/setup/dmc/common/sqlite_win32.inf

Add the following entry that is in bold lettering:

<item>
<src>/common/win32/sqlite/sqlite3.dll</src>
<des>$APP_DIR$\bin\sqlite3.dll</des>
</item>
<item>
<src>/common/win32/sqlite/sqlite3.exe</src>
<des>$APP_DIR$\bin\sqlite3.exe</des>
</item>



This is optional. The sqlite3.exe is equivalent to msql or sql*plus.

Step 4: Install the mobile client for SQLite WIN32 and configure a Mobile Application for SQLite WIN32 with a publication and a Publication Item for SQLite based on select * from scott.dept.


Step5: Synchronize using msync

Step6:  Open An Ms Dos box:
cd C:\mobileclient\sqlite\sqlite_db\<NAME>
sqlite3 PUB_BDB.db
Berkeley DB 11g Release 2, library version 11.2.5.0.26: (June 25, 2010)
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
dbsql> select * from dept;
3|TEST|TEST
4|TEST|TEST
10|ACCOUNTING|NEW YORK
20|RESEARCH|DALLAS
30|SALES|CHICAGO
40|OPERATIONS|BOSTON
1|LOC|25
2|LOC|paris
dbsql>


The other option is to apply the one-off  <Patch 11671293> + <Patch11837664> which will create a new Mobile client for BDB. It is best option to configure the Mobile Server.

Contacts

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Details
Actions
Contacts
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.