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

[Sandra Whitman]

Hi Luis,

I just wanted to let you know that I have a little more information on 
examples using the BDB SQLite Interface.  To recap from the previous email:

Question 6:
Are there any examples using BDB SQLite Interfaces?

Answer 6:
The BDB SQLite interface examples are under the distribution
at sql\examples\c.

There is also a JDBC example available on the ch-werner website at:
http://www.ch-werner.de/javasqlite/test.java

The SQLite documentation page also contains examples and tutorials.  It 
is located at:
http://sqlite.org/docs.html


Thanks again,
Sandra
Sandra Whitman
Oracle Global Customer Support

Sandra Whitman wrote:
> Hi Luis,
>
>
> Thank you again for your email.  I have been investigating your 
> questions and do have some answers which I will list below in the 
> question/answer section.  I am still doing some more research 
> regarding ADF and JDBC access and will get back to you on those. In 
> the mean time if you have any other questions, or if I did not 
> completely answer something, please let me know.
>
>
> Question 1:
> Is necessary to build BDB from source files?
>
> Answer 1:
> At the current time you do need to build Berkeley DB from source.  
> This requires Visual Studio C++.  You can use the free Express version 
> available from Microsoft.com.  We will however consider a pre-built 
> version for the future.
>
>
> Question 2:
> How is the BDB jar file obtained?
>
> Answer 2:
> What are the plans for the Berkeley DB jar file?  Is that to be used 
> with ADF?  I am still checking, but a jar file may not be
> needed for this.  If a Berkeley DB jar file is needed, it can be built 
> with Version 1.5 or 1.6 of the Java JDK.
>
>
> Question 3:
> How is BDB configured to support SQL?
>
> Answer 3:
> SQL support is built automatically on Windows. The SQL library is 
> built as libdb_sql50.dll in the Release mode or libdb_sql50d.dll in 
> the Debug mode. An SQL command line interpreter called 
> db_sql_shell.exe is also built.
>
> Please take a look in the documentation titled "Building the SQL API - 
> Chapter 5. Building Berkeley DB for Windows"
>
> From there:
> Building the SQL API
>
> Binary Compatibility With SQLite
>
> SQL support is built automatically on Windows. The SQL library is 
> built as libdb_sql50.dll in the Release mode or libdb_sql50d.dll in 
> the Debug mode. An SQL command line interpreter called 
> db_sql_shell.exe is also built.
> Binary Compatibility With SQLite
>
> Both libdb_sql50.dll and libdb_sql50d.dll are compatible with 
> sqlite3.dll. You can rename libdb_sql50.dll to sqlite3.dll and 
> db_sql_shell.exe to sqlite3.exe, and use these applications as a 
> replacement for the standard SQLite binaries with same names.
>
>
> Question 4:
> Are the SQLite data types are supported by Oracle ADF?
>
> Answer 4:
> I am still investigating this point.  However, the ADF  components 
> support SQLite so there should not be a problem here.
> I will get back to you on this though.
>
>
> Question 5:
> Is any documentation available regarding JDBC access to the database.
>
> Answer 5:
> The ODBC and JDBC drivers are not included in the initial Beta release 
> package, but they are supported and they will be included in the 
> production release. In order to build the drivers, please download the 
> open source ODBC driver from http://www.ch-werner.de/sqliteodbc/ and 
> the open source JDBC driver from http://www.ch-werner.de/javasqlite.
>
>
> Question 6:
> Are there any examples using BDB SQLite Interfaces?
>
> Answer:
> The BDB SQLite interface examples are under the distribution at 
> sql\examples\c.
>
>
> Best Regards,
> Sandra
> Sandra Whitman
> Oracle Global Customer Support
>
>
>