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***
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:
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
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:
Modify the following file:
Add the following entry that is in bold lettering:
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:
Berkeley DB 11g Release 2, library version 188.8.131.52.26: (June 25, 2010)
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
dbsql> select * from dept;
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.
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