<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
Luis,<br>
<br>
Thanks for the reply. I wanted to follow up on Sandra's email from this
morning. We're looking into your questions in more depth, but I just
want to make sure we understand what it is that you're trying to do so
that we're answering the right questions. We understand that you have
existing applications, built with various Oracle development tools.
Some of these applications use the Oracle Database Server and some
apparently use Berkeley DB Java Edition. <br>
<ul>
<li>Specifically, which application development tool are you trying
to use to build <i>this </i>application? <br>
</li>
<li>Is this a new application, specifically for the mobile platform?
Or is it a single application with two modes: a) connected to an Oracle
Server database and b) disconnected, running on a smartphone device
with SQLite/Berkeley DB installed locally? <br>
</li>
<li>Does this new application plan to use Berkeley DB 11gR2 via the
SQL API, which is based on SQLite? </li>
<li>Does this new application plan to access the SQLite/Berkeley DB
database via JDBC? <br>
</li>
<li>Does this new application plan on using capabilities of the
SQLite spatial functionality, just simple SQL or something else? <br>
</li>
</ul>
With regards to your recent question: <br>
<blockquote>"I used to work with BDB as a single jar file (like
je-3.3.87.jar) that was referenced in a JDeveloper Application. For
deployment, this jar file was packed with my application libraries and
files to be deploy to the client. Now it seems that this process must
be changed. The way to install BDB in a windows machine will consider
some Dlls installation. Is this correct?"<br>
</blockquote>
Berkeley DB Java Edition is not the same library as the Berkeley DB
11gR2 Beta release. They are two separate products. Berkeley DB Java
Edition does not have support for a SQL API -- it provides a Key/Value
pair API, a Java collections API and a Data Persistence Layer API for
POJO-style Java Object persistence. The Berkeley DB 11gR2 Beta release
library is written in C, has the same API support and is the product
that is introducing a new SQL API, based on integration of the SQLite
library. How you build, link and deploy Berkeley DB Java Edition vs
Berkeley DB is different. <br>
<br>
In the case of Berkeley DB Java Edition, being referenced in a
JDeveloper Application, all you needed was the Berkeley DB Java Edition
jar file. <br>
<br>
In the case of Berkeley DB 11gR2 Beta, the SQL API is based on SQLite.
As such, your build, link and deployment process would be different
than using Berkeley DB Java Edition. Essentially, you would want to do
the following: <br>
a) build the Berkeley DB 11gR2 library from source; <br>
b) <span class="Apple-style-span"
style="border-collapse: separate; color: rgb(0, 0, 0); font-family: 'Times New Roman'; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; font-size: medium;"><span
class="Apple-style-span"
style="font-family: Verdana,Arial,'Bitstream Vera Sans',Helvetica,sans-serif; font-size: 13px;"><big><font
face="Times New Roman, Times, serif">download the SQLite JD</font><font
face="Times New Roman, Times, serif">BC driver package from<span
class="Apple-converted-space"> </span><a class="moz-txt-link-freetext"
href="http://www.ch-werner.de/javasqlite/"
style="border-bottom: 1px dotted rgb(187, 187, 187); text-decoration: none; color: rgb(187, 0, 0);">http://www.ch-werner.de/javasqlite/</a>;</font></big></span></span><big><font
face="Times New Roman, Times, serif"><br>
<small>c) using the package and the instructions from step b), build a
sqlite.jar and libsqlite_jni.dll based on the libsqlite3.dll that was
built/generated from step a)</small><span class="Apple-style-span"
style="border-collapse: separate; color: rgb(0, 0, 0); font-family: 'Times New Roman'; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; font-size: medium;"><span
class="Apple-style-span"
style="font-family: Verdana,Arial,'Bitstream Vera Sans',Helvetica,sans-serif; font-size: 13px;">,</span></span></font><span
class="Apple-style-span"
style="border-collapse: separate; color: rgb(0, 0, 0); font-family: 'Times New Roman'; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; font-size: medium;"><span
class="Apple-style-span"
style="font-family: Verdana,Arial,'Bitstream Vera Sans',Helvetica,sans-serif; font-size: 13px;"><br>
</span></span></big>d) you should then be able to build and run a Java
application that calls the SQLite Java interface using the JDBC driver
from step c), <br>
<br>
Does this make sense and does it help you make forward progress? <br>
<blockquote></blockquote>
If we're still not in sync with regards to what you're trying to do, we
can either continue to have this discussion via email or get on a
conference call. Please let me know if you would like to schedule a
call and what time works best for you. I just want to make sure that we
properly understand what it is that you are trying to build. <br>
<br>
Regards, <br>
<br>
Dave<br>
<br>
On 2/17/2010 4:20 AM, Luis Paolini wrote:
<blockquote
cite="mid:!&!AAAAAAAAAAAYAAAAAAAAACnGWmDPjatNrG2fqilf47fCgAAAEAAAACJ11Sc9TEVGrx+ifFT9tPMBAAAAAA==@gempi.com.br"
type="cite">
<pre wrap="">Hi Sandra,
Thank you for the answers.
I have an additional question based on the answer for question 2.
Additional Question 2:
I used to work with BDB as a single jar file (like je-3.3.87.jar)
that was referenced in a JDeveloper Application.
For deployment, this jar file was packed with my application
libraries and files to be deploy to the client.
Now it seems that this process must be changed. The way to install
BDB in a windows machine will consider some
Dlls installation. Is this correct?
Regards,
Luis Paolini
-----Original Message-----
From: Sandra Whitman [<a class="moz-txt-link-freetext" href="mailto:sandra.whitman@oracle.com">mailto:sandra.whitman@oracle.com</a>]
Sent: domingo, 14 de fevereiro de 2010 22:48
To: Luis Paolini
Cc: <a class="moz-txt-link-abbreviated" href="mailto:bdb-beta-feedback@oss.oracle.com">bdb-beta-feedback@oss.oracle.com</a>; <a class="moz-txt-link-abbreviated" href="mailto:support@sleepycat.com">support@sleepycat.com</a>; Whitman,Sandra
Subject: Re: [BDB 11gR2 Beta] [#18298] First Questions about DBD 11gR2
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 <a class="moz-txt-link-freetext" href="http://www.ch-werner.de/sqliteodbc/">http://www.ch-werner.de/sqliteodbc/</a> and the
open source JDBC driver from <a class="moz-txt-link-freetext" href="http://www.ch-werner.de/javasqlite">http://www.ch-werner.de/javasqlite</a>.
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
</pre>
</blockquote>
<div class="moz-signature">-- <br>
<a href="http://www.oracle.com" target="_blank"><img
src="cid:part1.07090205.01050507@oracle.com" alt="Oracle" width="114"
border="0" height="26"></a><br>
<font color="#666666" face="Verdana, Arial, Helvetica, sans-serif"
size="2">David Segleau | Director Product Management - Berkeley DB<br>
Phone: +1 425 945 8533 | Mobile: +1 408 420 7350 <br>
<font color="#ff0000">Oracle</font> Database Engineering<br>
</font><br>
<a href="http://www.oracle.com/commitment" target="_blank"><img
src="cid:part2.00010406.02050102@oracle.com" alt="Green Oracle"
width="44" align="abscenter" border="0" height="28"></a>
<font color="#4b7d42" face="Verdana, Arial, Helvetica, sans-serif"
size="1">Oracle is committed to developing practices and products that
help protect the environment</font>
<!-- This signature was generated by the MyDesktop Oracle Business Signature utility version 3.5.7 --></div>
</body>
</html>