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

[Alex Gorrod]

Hi Sandra,

I'm not aware of anything else. I know some of the engineers in CDC have 
been working with JDBC and ODBC, so they might have more information.

- Alex

On 18/02/2010 2:56 AM, Sandra Whitman wrote:
> Hi Alex, Michael,
>
> Will we be providing more examples for Java once the JDBC work is complete?
>
> I did point out the JDBC example you had mentioned at:
> http://www.ch-werner.de/javasqlite/test.java
>
> When I searched, I pretty much found the same, starting with:
> http://www.ch-werner.de/javasqlite/overview-summary.html
>
> Is there anything else?
>
>
> Thanks,
> Sandra
>
>
> -------- Original Message --------
> Subject: 	RE: [BDB 11gR2 Beta] [#18298] First Questions about DBD 11gR2
> Date: 	Wed, 17 Feb 2010 10:25:33 -0200
> From: 	Luis Paolini<git at gempi.com.br>
> To: 	'Sandra Whitman'<sandra.whitman at oracle.com>
> References:
> <!&!AAAAAAAAAAAYAAAAAAAAACnGWmDPjatNrG2fqilf47fCgAAAEAAAAPw93OIO0eJAv4Kk2HbxQMEBAAAAAA==@gempi.com.br>
> <4B7899A2.40008 at oracle.com>  <4B78C77B.4020602 at oracle.com>
>
>
>
> Hi Sandra,
>
> 	I checked the SQLite documentation page looking for examples and
> tutorials but found nothing
> using Java.
> 	Are there some examples and tutorials for Java?
>
> Regards,
>
> Luis
>
> -----Original Message-----
> From: Sandra Whitman [mailto:sandra.whitman at oracle.com]
> Sent: segunda-feira, 15 de fevereiro de 2010 02:03
> To: Luis Paolini
> Cc: bdb-beta-feedback at oss.oracle.com; support at sleepycat.com
> Subject: Re: [BDB 11gR2 Beta] [#18298] First Questions about DBD 11gR2
>
> 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
>>
>>
>>
>
>
> __________ Information from ESET NOD32 Antivirus, version of virus signature
> database 4866 (20100214) __________
>
> The message was checked by ESET NOD32 Antivirus.
>
> http://www.eset.com
>
>
>
>
> __________ Information from ESET NOD32 Antivirus, version of virus signature
> database 4873 (20100217) __________
>
> The message was checked by ESET NOD32 Antivirus.
>
> http://www.eset.com
>
>
>
>
> _______________________________________________
> BDB-BETA-FEEDBACK mailing list
> BDB-BETA-FEEDBACK at oss.oracle.com
> http://oss.oracle.com/mailman/listinfo/bdb-beta-feedback