Library Version 11.2.5.3

Library Version 12.1.6.1

- + - +

Building the Android JDBC Driver			Building the Android JDBC + Driver
Prev	Chapter 4. Building Berkeley DB for Android	Chapter 4. Building Berkeley DB for + Android	Next

@@ -32,32 +34,40 @@

Building the Android JDBC Driver

Building the Android JDBC + Driver

- This section describes how to build and use the BDB JDBC driver - for Android. Note that the BDB JDBC driver cannot currently be - built on a Windows platform. + The JDBC API is an alternative to the drop-in replacement. + It is possible to build Berkeley DB SQL for Android in such a + way that a JDBC API is exposed to Android application + developers. This is done using the Android NDK. +

+ This section describes how to build and use the BDB JDBC + driver for Android. Note that the BDB JDBC driver cannot + currently be built on a Windows platform.

-
- Download and install the Android SDK. The installation - instructions can be found here: +
+ Download and install the Android SDK. The + installation instructions can be found here:

- http://developer.android.com/sdk/installing.html + http://developer.android.com/sdk/installing/index.html
- Download and install the Android NDK. It can be found here: + Download and install the Android NDK. It can be + found here:

- http://developer.android.com/sdk/ndk/index.html + http://developer.android.com/tools/sdk/ndk/index.html
@@ -72,56 +82,56 @@ Berkeley DB package from here:

- http://www.oracle.com/technetwork/database/berkeleydb/downloads/index.html + http://www.oracle.com/technetwork/database/database-technologies/berkeleydb/downloads/index.html

- Note that you must be using a 5.3.x or higher - version of the product in order for these - instructions to work. Once you have the package, - unpack it: + Note that you must be using a 5.3.x or + higher version of the product in order for + these instructions to work. Once you have the + package, unpack it:
```
$ tar zxvf db-x.y.z.tar.gz
 $ cd db-x.y.z
```
-
- Where x.y.z the major, minor, - and point release version of the Berkeley DB - distribution which you are using. +
+ Where x.y.z the major, + minor, and point release version of the + Berkeley DB distribution which you are using.

- Also, note that in the following instructions, the - directory denoted by db-x.y.z, - above, is referred to as - <db>. + Also, note that in the following + instructions, the directory denoted by + db-x.y.z, above, is + referred to as <db>.
-
- Build an x86/x64 JDBC package. This is required - because the building process will generate target - files which are required to build Android NDK. - Also, the built JAR file can be imported by - eclipse, which will then convert it to the Android - Dalvik JAR format. +
+ Build an x86/x64 JDBC package. This is + required because the building process will + generate target files which are required to + build Android NDK. Also, the built JAR file + can be imported by eclipse, which will then + convert it to the Android Dalvik JAR format.
-
+
To do this, edit - <db>/lang/sql/jdbc/SQLit/Database.java + <db>/lang/sql/jdbc/SQLit/Database.java and replace all instances of - System.loadLibrary("sqlite_jni") + System.loadLibrary("sqlite_jni") with - System.loadLibrary("oracle-jdbc"). + System.loadLibrary("oracle-jdbc").

- Once you have done this, configure and make the - library. The following example shows the minimum - configuration options that you need to use in order - to configure the Berkeley DB JDBC driver. For your - particular installation, other configuration - options might be interesting to you. See - Configuring Berkeley DB - and - Android Configuration Options - for more information. + Once you have done this, configure and make + the library. The following example shows the + minimum configuration options that you need to + use in order to configure the Berkeley DB JDBC + driver. For your particular installation, + other configuration options might be + interesting to you. See Configuring Berkeley DB and + Android Configuration + Options for + more information.
```
cd <db>/build_unix
 ../dist/configure --enable-jdbc && make
```
@@ -129,9 +139,37 @@ $ cd db-x.y.z

+ Enable encryption if required. +

+ By default, encryption is disabled. To enable it, + edit + <db>/build_android/jdbc/jni/Android.mk + and change BDB_ENABLE_ENCRYPTION + from false to + true. +

+ After enabling encryption, use pragma + key to set the password. You must do + this before performing any database operations. For + example: +

 # ./dbsql test.db
+dbsql> pragma key="xyzzy";
+dbsql> create table t1(x);
+dbsql> .quit
+
+# ./dbsql test.db
+dbsql> pragma key="xyzzy";
+dbsql> .tables
+t1

- Build the Android NDK: + Build the Android NDK:

$ cd <db>/build_android/jdbc/jni
 $ <ndk-install-directory>/ndk-build

@@ -152,29 +190,29 @@ $ <ndk-install-directory>/ndk-build

- Having built the JDBC driver, you can now use it with your project. - You can do this using Eclipse and the ADT plugin, which you can get - from here: +

+ Having built the JDBC driver, you can now use it with your + project. You can do this using Eclipse and the ADT plugin, + which you can get from here:

-
- Start Eclipse and create an Android project. Use: +
+ Start Eclipse and create an Android project. Use:
- - test_jdbc as the Android project - name. + test_jdbc as the Android + project name.
- @@ -183,18 +221,18 @@ $ <ndk-install-directory>/ndk-build
- -
  +
  For the package name, use - example.jdbc. + example.jdbc.
-
- This results in an empty code file. Copy and paste the - following example code into that file: +
+ This results in an empty code file. Copy and paste + the following example code into that file:
```
package example.testjdbc;
 
@@ -285,8 +323,8 @@ public class Test_jdbcActivity extends Activity {
 } 
```

- Copy the following files into place: +

+ Copy the following files into place:

$ cd <workspace>/test_jdbc
 $ mkdir -p libs/armeabi
@@ -295,18 +333,16 @@ libs/armeabi
 $ cp -r <db>/build_unix/jdbc/sqlite.jar libs

-
- Back in Eclipse, right click the project name, and select - the refresh option to reload the project - from the directory. The two new files that were copied into - place in the previous step are now included in the project - view. +
+ Back in Eclipse, right click the project name, and + select the refresh option to reload + the project from the directory. The two new files that + were copied into place in the previous step are now + included in the project view.
-
- Convert the JAR file to the Android Dalvik format: -
+
Convert the JAR file to the Android Dalvik format:
1. @@ -316,7 +352,8 @@ $ cp -r <db>/build_unix/jdbc/sqlite.jar libs
2. - Choose Build Path -> Configure Build Path + Choose Build Path -> Configure + Build Path
3. @@ -325,39 +362,42 @@ $ cp -r <db>/build_unix/jdbc/sqlite.jar libs
4. -
  - Click Add JARS. +
  + Click Add JARS.
-
- Run the project: +
+ Run the project:
1. - Choose Property -> Android - and select any one of the usable build targets. + Choose Property -> + Android and select any one of + the usable build targets.
2. -
  - Right click the project. Choose Run As -> Android +
  + Right click the project. Choose + Run As -> Android
-
- Verify your installation. After a short pause (depending - on the speed of your system), the application logo is - displayed. Use the Android adb command line application to - make sure the application is running as expected: +
+ Verify your installation. After a short pause + (depending on the speed of your system), the + application logo is displayed. Use the Android adb + command line application to make sure the application + is running as expected:
```
$ cd <android-sdk>/platform-tools
 $ ./adb logcat
@@ -368,9 +408,9 @@ I/System.out(  539): French_Roast   8.99
 I/System.out(  539): Espresso   9.99
 I/System.out(  539): Colombian_Decaf   8.99
 I/System.out(  539): French_Roast_Decaf   9.99
```
-
+
You can also check if the database - (example.db) exists in the + (example.db) exists in the emulator:
```
$ ./adb shell ls /data/data/example.testjdbc
@@ -378,7 +418,8 @@ example.db
 example.db-journal
 lib 
```
- Finally, check the database using the BDB SQL shell: + Finally, check the database using the BDB SQL + shell:
```
 $ ./adb push <db>/build_android/jdbc/libs/armeabi/dbsql \
@@ -414,11 +455,13 @@ dbsql> .quit 
```
Next - Chapter 4. Building Berkeley DB for Android + Chapter 4. Building Berkeley DB for + Android Home - Android Configuration Options + Android Configuration + Options