1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
|
<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
<title>Chapter 4. Building Berkeley DB for Android</title>
<link rel="stylesheet" href="gettingStarted.css" type="text/css" />
<meta name="generator" content="DocBook XSL Stylesheets V1.73.2" />
<link rel="start" href="index.html" title="Berkeley DB Installation and Build Guide" />
<link rel="up" href="index.html" title="Berkeley DB Installation and Build Guide" />
<link rel="prev" href="debug_printlog.html" title="Reviewing Berkeley DB log files" />
<link rel="next" href="build_android_jdbc.html" title="Building the Android JDBC Driver" />
</head>
<body>
<div xmlns="" class="navheader">
<div class="libver">
<p>Library Version 12.1.6.1</p>
</div>
<table width="100%" summary="Navigation header">
<tr>
<th colspan="3" align="center">Chapter 4. Building Berkeley DB for
Android</th>
</tr>
<tr>
<td width="20%" align="left"><a accesskey="p" href="debug_printlog.html">Prev</a> </td>
<th width="60%" align="center"> </th>
<td width="20%" align="right"> <a accesskey="n" href="build_android_jdbc.html">Next</a></td>
</tr>
</table>
<hr />
</div>
<div class="chapter" lang="en" xml:lang="en">
<div class="titlepage">
<div>
<div>
<h2 class="title"><a id="build_android_intro"></a>Chapter 4. Building Berkeley DB for
Android</h2>
</div>
</div>
</div>
<div class="toc">
<p>
<b>Table of Contents</b>
</p>
<dl>
<dt>
<span class="sect1">
<a href="build_android_intro.html#build_android">Building the Drop-In Replacement
for Android</a>
</span>
</dt>
<dd>
<dl>
<dt>
<span class="sect2">
<a href="build_android_intro.html#build_android_migrate">Migrating from SQLite to
Berkeley DB</a>
</span>
</dt>
</dl>
</dd>
<dt>
<span class="sect1">
<a href="build_android_jdbc.html">Building the Android JDBC
Driver</a>
</span>
</dt>
<dt>
<span class="sect1">
<a href="build_android_config.html">Android Configuration
Options</a>
</span>
</dt>
<dt>
<span class="sect1">
<a href="build_android_adfmobile.html">Using the JDBC Driver in ADF Mobile for Android</a>
</span>
</dt>
</dl>
</div>
<p>
Berkeley DB provides support for the Android platform
enabling you to develop and deploy a wide range of mobile
applications and services. Android provides SQLite as the
default database for developing applications that need
database support. Berkeley DB SQL API is fully compatible with
SQLite and can be used as a replacement. The
<code class="literal">build_android</code> directory in the Berkeley
DB distribution contains a makefile,
<code class="literal">Android.mk</code>, for building a drop-in
replacement for SQLite.
</p>
<p>
Oracle offers two different solutions for building the BDB
SQL API for Android. The first creates a library that can be
used as a drop-in replacement for SQLite on Android. The
second creates a JDBC driver for Android.
</p>
<div class="sect1" lang="en" xml:lang="en">
<div class="titlepage">
<div>
<div>
<h2 class="title" style="clear: both"><a id="build_android"></a>Building the Drop-In Replacement
for Android</h2>
</div>
</div>
</div>
<div class="toc">
<dl>
<dt>
<span class="sect2">
<a href="build_android_intro.html#build_android_migrate">Migrating from SQLite to
Berkeley DB</a>
</span>
</dt>
</dl>
</div>
<p>
This section describes how to build a library that can be
used as a drop-in replacement for SQLite on Android.
</p>
<div class="note" style="margin-left: 0.5in; margin-right: 0.5in;">
<h3 class="title">Note</h3>
<p>
A drop in replacement refers to replacing all instances
of SQLite in an Android OS build with Berkeley DB SQL. All
databases will be created in the Berkeley DB SQL format
including any created with the Java SQLite.* API. This
solution requires that users re-compile a custom Android
OS image (it is only relevant for platform/device
vendors).
</p>
</div>
<div class="orderedlist">
<ol type="1">
<li>
<p>
Download and compile the Android source tree.
</p>
<p>
The compiling process takes time but is a one time
activity. For information on downloading and compiling
the Android source code, see <a class="ulink" href="http://source.android.com/source/download.html" target="_top">http://source.android.com/source/download.html</a>.
</p>
</li>
<li>
<p>
Copy the Berkeley DB code into the Android build
tree.
</p>
<pre class="programlisting">$ cd <root>/external/sqlite/dist
$ tar zxf ${DB_PATH} </pre>
<p>
where <root> is the root of the Android
source tree and ${DB_PATH} is the path where you saved
the <code class="literal">db-xx.tar.gz</code> version of the
Berkeley DB distribution.
</p>
</li>
<li>
<p>
Update the Android build file to identify Berkeley
DB.
</p>
<p>
Replace the <code class="literal">Android.mk</code> file with
the one from the Berkeley DB source tree by doing the
following:
</p>
<pre class="programlisting">$ cd <root>/external/sqlite/dist
$ mv Android.mk Android.mk.sqlite
$ cp ${DB_INSTALL}/build_android/Android.mk ./ </pre>
<p>
where ${DB_INSTALL} is the directory into which you
installed the Berkeley DB library.
</p>
</li>
<li>
<p>
Tuning parameters.
</p>
<p>
The configuration options for performance tuning
can be added/edited in the
<code class="literal">Android.mk</code> file by modifying
<code class="literal">LOCAL_CFLAGS</code> located in the
<code class="literal">build libsqlite replacement</code>
section. For more information, see <a class="xref" href="build_android_config.html" title="Android Configuration Options">Android Configuration
Options</a>.
</p>
<p>
It is also possible to change these settings using
PRAGMA commands or through the <a href="../api_reference/C/configuration_reference.html" class="olink">DB_CONFIG</a> file.
</p>
</li>
<li>
<p>
Build the new Android image.
</p>
<p>
To build the Android image with Berkeley DB SQL
included, do the following:
</p>
<pre class="programlisting">$ cd <root>
$ . build/envsetup.sh
$ make clean-libsqlite
$ mmm -B external/sqlite/dist
$ make snod
</pre>
<p>
You can locate the new image in
<code class="literal"><root>/out/target/product/generic</code>.
</p>
</li>
</ol>
</div>
<div class="sect2" lang="en" xml:lang="en">
<div class="titlepage">
<div>
<div>
<h3 class="title"><a id="build_android_migrate"></a>Migrating from SQLite to
Berkeley DB</h3>
</div>
</div>
</div>
<p>
This section describes how to enable automatic conversion
of SQLite format databases to Berkeley DB SQL when they are
opened. To do this, you must first make sure that the
<code class="literal">-DBDBSQL_CONVERT_SQLITE</code> option is added
to <code class="literal">LOCAL_CFLAGS</code> when you configure your
Berkeley DB database build.
</p>
<div class="orderedlist">
<ol type="1">
<li>
<p>
Build a static SQLite shell for Android platform.
</p>
<p>
Create a script, build_sqlite3_shell.sh, in the
<root>/external/sqlite/dist directory.
</p>
<pre class="programlisting">
#!/bin/bash
# This script shows how to use built-in toolchain to build
# sqlite3 shell, which is required by Berkeley DB SQL
# on-the-fly migration feature.
# Note: these variables should be set per active Android source tree
# We assume $PWD=$ROOT/external/sqlite/dist
ROOT=${PWD}/../../..
TOOLCHAIN=${ROOT}/prebuilt/linux-x86/toolchain/arm-eabi-4.4.0
CC=${TOOLCHAIN}/bin/arm-eabi-gcc
LIB="${ROOT}/out/target/product/generic/obj/lib"
INCLUDE="${ROOT}/ndk/build/platforms/android-8/arch-arm/usr/include"
# CFLAGS should be set per Android.mk.sqlite (the original
# version of SQLite's Android.mk)
CFLAGS="-DHAVE_USLEEP=1 -DSQLITE_THREADSAFE=1 -DNDEBUG=1 \
-DSQLITE_DEFAULT_JOURNAL_SIZE_LIMIT=1048576 \
-DSQLITE_ENABLE_MEMORY_MANAGEMENT=1 \
-DSQLITE_DEFAULT_AUTOVACUUM=1 \
-DSQLITE_TEMP_STORE=3 -DSQLITE_ENABLE_FTS3 \
-DSQLITE_ENABLE_FTS3_BACKWARDS -DTHREADSAFE=1"
CFLAGS="${CFLAGS} -I${INCLUDE}"
LDFLAGS="-ldl -nostdlib -Wl,--gc-sections -lc -llog -lgcc \
-Wl,--no-undefined,-z,nocopyreloc ${LIB}/crtend_android.o \
${LIB}/crtbegin_dynamic.o -L${LIB} -Wl,-rpath,${LIB}"
${CC} -DANDROID -DOS_ANDROID --sysroot="${SYSROOT}" -mandroid \
-fvisibility=hidden -ffunction-sections -fdata-sections \
-fPIC ${LDFLAGS} ${CFLAGS} \
sqlite3.c shell.c -o sqlite3orig
</pre>
<p>
Ensure you adjust the variables as per your actual
Android environment. This script is suited for Android
2.2.
</p>
</li>
<li>
<p>
Execute the build_sqlite3_shell.sh script and to
get the static sqlite3 shell utility - sqlite3orig.
</p>
</li>
<li>
<p>
Change the system image file.
</p>
<p>
Use the <code class="literal">xyaffs2</code> utiltiy to
decompress the <code class="literal">system.img</code> and get
the directory system.
</p>
<pre class="programlisting">$ xyaffs2 ./system.img system</pre>
<p>
Add static sqlite3 shell utility.
</p>
<pre class="programlisting">$ cp <root>/external/sqlite/dist/sqlite3orig \
system/xbin/sqlite3orig</pre>
<p>
Use the <code class="literal">mkyaffs2image</code> utility to
rebuild <code class="literal">system.img</code> from the changed
directory system.
</p>
<pre class="programlisting">$ mkyaffs2image -f $PWD/system system.img</pre>
<div class="note" style="margin-left: 0.5in; margin-right: 0.5in;">
<h3 class="title">Note</h3>
<p>
To open the database in the
<code class="literal">SQLite</code> format use the
<code class="literal">sqlite3orig</code> command.
</p>
</div>
</li>
</ol>
</div>
</div>
</div>
</div>
<div class="navfooter">
<hr />
<table width="100%" summary="Navigation footer">
<tr>
<td width="40%" align="left"><a accesskey="p" href="debug_printlog.html">Prev</a> </td>
<td width="20%" align="center"> </td>
<td width="40%" align="right"> <a accesskey="n" href="build_android_jdbc.html">Next</a></td>
</tr>
<tr>
<td width="40%" align="left" valign="top">Reviewing Berkeley DB log files </td>
<td width="20%" align="center">
<a accesskey="h" href="index.html">Home</a>
</td>
<td width="40%" align="right" valign="top"> Building the Android JDBC
Driver</td>
</tr>
</table>
</div>
</body>
</html>
|
