[BDB 11gR2 Beta] [#18298] First Questions about DBD 11gR2

[George Feinberg]

Sandra,

Dave just replied to Luis.  I have related/similar information.  The team in
China is doing JDBC testing and some of this is covered in SR 18099.
I just verified that the JDBC driver works, at least on Linux.
Windows will be different and I have not verified that.  It appears that the
referenced web site has a prebuilt DLL and jar file that can be used.
The issue for Windows is then building a version of 11gR2 that 
creates sqlite3.dll vs the "DB" name.

The current default for the Windows library name is libdb_sql50.dll.  I don't know if
the additional change has been made to enable it to build sqlite3.dll; it does not
appear to be in the tree.  The project file could be modified in-place to do that.

Here's what I did on Linux:

Build DB SQL using:
      --enable-sql --enable-sql_compat --prefix=/home/gmf/install

See this page for download/build information for the JDBC driver
        http://www.ch-werner.de/javasqlite/overview-summary.html

Download javasqlite-20100131.tar.gz and un-tar it.

Build:
        $cd javasqlite-20100131
        $./configure --with-sqlite3=/home/gmf/install --prefix=/home/gmf/install
        NOTE: I needed to manually add "-lpthread" to LIBS in Makefile or it would not build
        $ make
        $ make install
        NOTE: libsqlite_jni.{la,so} were installed to <>/install/lib sqlite.jar
        installed to <>/install/share/java/sqlite.jar

Copy test from driver source and compile it:
	In some directory:
        $ cp <javasqlite-20100131>/doc/test3.java .
        $ javac -classpath /home/gmf/install/share/java/sqlite.jar  test3.java

Run test:
        $ java -Djava.library.path=/home/gmf/install/lib -classpath /home/gmf/install/share/java/sqlite.jar:.  test3

Verify that it used the DB SQL library vs regular SQLite by
seeing ./db3 and ./db3-journal

Documentation for the driver is in <javasqlite-20100131>/doc

George