<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:q="http://schemas.xmlsoap.org/soap/envelope/" xmlns:rtc="http://microsoft.com/officenet/conferencing" xmlns:Repl="http://schemas.microsoft.com/repl/" xmlns:mt="http://schemas.microsoft.com/sharepoint/soap/meetings/" xmlns:x2="http://schemas.microsoft.com/office/excel/2003/xml" xmlns:ppda="http://www.passport.com/NameSpace.xsd" xmlns:ois="http://schemas.microsoft.com/sharepoint/soap/ois/" xmlns:dir="http://schemas.microsoft.com/sharepoint/soap/directory/" xmlns:ds="http://www.w3.org/2000/09/xmldsig#" xmlns:dsp="http://schemas.microsoft.com/sharepoint/dsp" xmlns:udc="http://schemas.microsoft.com/data/udc" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:sub="http://schemas.microsoft.com/sharepoint/soap/2002/1/alerts/" xmlns:ec="http://www.w3.org/2001/04/xmlenc#" xmlns:sp="http://schemas.microsoft.com/sharepoint/" xmlns:sps="http://schemas.microsoft.com/sharepoint/soap/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:udcs="http://schemas.microsoft.com/data/udc/soap" xmlns:udcxf="http://schemas.microsoft.com/data/udc/xmlfile" xmlns:udcp2p="http://schemas.microsoft.com/data/udc/parttopart" xmlns:wf="http://schemas.microsoft.com/sharepoint/soap/workflow/" xmlns:dsss="http://schemas.microsoft.com/office/2006/digsig-setup" xmlns:dssi="http://schemas.microsoft.com/office/2006/digsig" xmlns:mdssi="http://schemas.openxmlformats.org/package/2006/digital-signature" xmlns:mver="http://schemas.openxmlformats.org/markup-compatibility/2006" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns:mrels="http://schemas.openxmlformats.org/package/2006/relationships" xmlns:spwp="http://microsoft.com/sharepoint/webpartpages" xmlns:ex12t="http://schemas.microsoft.com/exchange/services/2006/types" xmlns:ex12m="http://schemas.microsoft.com/exchange/services/2006/messages" xmlns:pptsl="http://schemas.microsoft.com/sharepoint/soap/SlideLibrary/" xmlns:spsl="http://microsoft.com/webservices/SharePointPortalServer/PublishedLinksService" xmlns:Z="urn:schemas-microsoft-com:" xmlns:st="" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<meta name=Generator content="Microsoft Word 12 (filtered medium)">
<!--[if !mso]>
<style>
v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style>
<![endif]-->
<style>
<!--
/* Font Definitions */
@font-face
{font-family:Wingdings;
panose-1:5 0 0 0 0 0 0 0 0 0;}
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:Verdana;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:Consolas;
panose-1:2 11 6 9 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman","serif";
color:black;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p.MsoPlainText, li.MsoPlainText, div.MsoPlainText
{mso-style-priority:99;
mso-style-link:"Plain Text Char";
margin:0cm;
margin-bottom:.0001pt;
font-size:10.5pt;
font-family:Consolas;}
pre
{mso-style-priority:99;
mso-style-link:"HTML Preformatted Char";
margin:0cm;
margin-bottom:.0001pt;
font-size:10.0pt;
font-family:"Courier New";
color:black;}
span.apple-style-span
{mso-style-name:apple-style-span;}
span.apple-converted-space
{mso-style-name:apple-converted-space;}
span.HTMLPreformattedChar
{mso-style-name:"HTML Preformatted Char";
mso-style-priority:99;
mso-style-link:"HTML Preformatted";
font-family:Consolas;
color:black;}
span.EmailStyle21
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
span.PlainTextChar
{mso-style-name:"Plain Text Char";
mso-style-priority:99;
mso-style-link:"Plain Text";
font-family:Consolas;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page Section1
{size:612.0pt 792.0pt;
margin:70.85pt 3.0cm 70.85pt 3.0cm;}
div.Section1
{page:Section1;}
/* List Definitions */
@list l0
{mso-list-id:1495410159;
mso-list-template-ids:-556370844;}
@list l0:level1
{mso-level-number-format:bullet;
mso-level-text:\F0B7;
mso-level-tab-stop:36.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
ol
{margin-bottom:0cm;}
ul
{margin-bottom:0cm;}
-->
</style>
<!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body bgcolor=white lang=PT-BR link=blue vlink=purple>
<div class=Section1>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:windowtext'>Hi Dave,<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:windowtext'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:windowtext'> </span><span
lang=EN-US style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:windowtext'>Thanks for the additional information.<o:p></o:p></span></p>
<p class=MsoNormal style='text-indent:35.4pt'><span lang=EN-US
style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:windowtext'>The
first point that is clear now is that we are talking about two different
products: Berkeley DB Java Edition and Berkeley DB 11gR2.<o:p></o:p></span></p>
<p class=MsoNormal style='text-indent:35.4pt'><span lang=EN-US
style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:windowtext'>I
was not thinking that way and now it explains some of my questions.<o:p></o:p></span></p>
<p class=MsoNormal style='text-indent:35.4pt'><span lang=EN-US
style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:windowtext'>If
I understand correctly, you created a java wrapper in order to expose the
SQLite API for Java applications, but in essence it is <o:p></o:p></span></p>
<p class=MsoNormal style='text-indent:35.4pt'><span lang=EN-US
style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:windowtext'>a set
of C libraries.<o:p></o:p></span></p>
<p class=MsoNormal style='text-indent:35.4pt'><span lang=EN-US
style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:windowtext'>About
you questions:<o:p></o:p></span></p>
<ul type=disc>
<li class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;
mso-list:l0 level1 lfo1'><span lang=EN-US>Specifically, which application
development tool are you trying to use to build <i>this </i>application? <o:p></o:p></span></li>
</ul>
<p class=MsoPlainText style='margin-left:36.0pt'><span lang=EN-US
style='font-size:11.0pt;font-family:"Calibri","sans-serif"'>The application we
are working on is a ADF Java Desktop Application. It uses ADF Swing.<o:p></o:p></span></p>
<p class=MsoPlainText style='margin-left:36.0pt'><span lang=EN-US
style='font-size:11.0pt;font-family:"Calibri","sans-serif"'>It can operates is
two modes: Connected to a corporate Oracle 11g Database or Disconnected using a
local Berkeley Database.<o:p></o:p></span></p>
<p class=MsoPlainText style='margin-left:36.0pt'><span lang=EN-US
style='font-size:11.0pt;font-family:"Calibri","sans-serif"'>In the connected
mode we use ADF Business Components to do the object-relational mapping and
create Entities, Views, Associations, etc. <o:p></o:p></span></p>
<p class=MsoPlainText style='margin-left:36.0pt'><span lang=EN-US
style='font-size:11.0pt;font-family:"Calibri","sans-serif"'>These components
are used by the ADF Swing components in the UI, via data binding model.<o:p></o:p></span></p>
<p class=MsoPlainText style='margin-left:36.0pt'><span lang=EN-US
style='font-size:11.0pt;font-family:"Calibri","sans-serif"'>Our goal is to do
the same approach using Berkeley DB 11gR2.<o:p></o:p></span></p>
<p class=MsoPlainText style='margin-left:36.0pt'><span lang=EN-US
style='font-size:11.0pt;font-family:"Calibri","sans-serif"'>The idea is to have
the same data model in the two databases, in order to use the same ADF Business
Components already created.<o:p></o:p></span></p>
<p class=MsoPlainText style='margin-left:36.0pt'><span lang=EN-US
style='font-size:11.0pt;font-family:"Calibri","sans-serif"'>Depending on the
context (connected or disconnected), we just need to change the database
connection and the application <o:p></o:p></span></p>
<p class=MsoPlainText style='margin-left:36.0pt'><span lang=EN-US
style='font-size:11.0pt;font-family:"Calibri","sans-serif"'>would just works,
no matter the database is Oracle 11g or Berkeley. <o:p></o:p></span></p>
<p class=MsoPlainText style='margin-left:36.0pt'><span style='font-size:11.0pt;
font-family:"Calibri","sans-serif"'>Does it makes sense?<o:p></o:p></span></p>
<ul type=disc>
<li class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;
mso-list:l0 level1 lfo1'><span lang=EN-US>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? <o:p></o:p></span></li>
</ul>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;
margin-left:35.4pt'><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri","sans-serif"'>This
is a new application but not for the mobile platform. It is a single
application with two modes: a) connected to as Oracle Server database and b)
disconnected, running on a Windows PC.<o:p></o:p></span></p>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;
margin-left:35.4pt'><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri","sans-serif"'>We
have some requests to develop applications for the mobile platform and we think
that BDB 11gR2 fits perfectly, but not this one. <o:p></o:p></span></p>
<ul type=disc>
<li class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;
mso-list:l0 level1 lfo1'><span lang=EN-US>Does this new application plan
to use Berkeley DB 11gR2 via the SQL API, which is based on SQLite? <o:p></o:p></span></li>
</ul>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;
margin-left:36.0pt'><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri","sans-serif"'>Yes.
We will use Berkeley DB 11gR2 via SQL API with Oracle ADF.<o:p></o:p></span></p>
<ul type=disc>
<li class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;
mso-list:l0 level1 lfo1'><span lang=EN-US>Does this new application plan
to access the SQLite/Berkeley DB database via JDBC? <o:p></o:p></span></li>
</ul>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;
margin-left:36.0pt'><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri","sans-serif"'>Yes.
This is a requirement to create ADF Business Components.<o:p></o:p></span></p>
<ul type=disc>
<li class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;
mso-list:l0 level1 lfo1'><span lang=EN-US>Does this new application plan
on using capabilities of the SQLite spatial functionality, just simple SQL
or something else? <o:p></o:p></span></li>
</ul>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;
margin-left:36.0pt'><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri","sans-serif"'>We
have a requirement to store geometries extracted from Oracle Spatial
(sdo_geometry) into BDB. Is it supported?<o:p></o:p></span></p>
<p class=MsoNormal style='text-indent:35.4pt'><span lang=EN-US
style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal style='text-indent:35.4pt'><span lang=EN-US
style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:windowtext'>I’ll
try to build BDB 11gR2 using the source files, following the instructions that you
and Sandra gave me.<o:p></o:p></span></p>
<p class=MsoNormal style='text-indent:35.4pt'><span lang=EN-US
style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:windowtext'>I’ll
let you know about the progress.<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:windowtext'><o:p> </o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:windowtext'>Regards,<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:windowtext'><o:p> </o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:windowtext'>Luis<o:p></o:p></span></p>
<p class=MsoNormal style='text-indent:35.4pt'><span lang=EN-US
style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal style='text-indent:35.4pt'><span lang=EN-US
style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'> <o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<div>
<div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0cm 0cm 0cm'>
<p class=MsoNormal><b><span lang=EN-US style='font-size:10.0pt;font-family:
"Tahoma","sans-serif";color:windowtext'>From:</span></b><span lang=EN-US
style='font-size:10.0pt;font-family:"Tahoma","sans-serif";color:windowtext'>
Dave Segleau [mailto:dave.segleau@oracle.com] <br>
<b>Sent:</b> quarta-feira, 17 de fevereiro de 2010 17:07<br>
<b>To:</b> Luis Paolini<br>
<b>Cc:</b> Sandra Whitman; Kent Rollins; bdb-beta-feedback@oss.oracle.com;
Sleepycat Software Support; Claudio Ferreira<br>
<b>Subject:</b> Re: [BDB 11gR2 Beta] [#18298] First Questions about DBD 11gR2<o:p></o:p></span></p>
</div>
</div>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal>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. <o:p></o:p></p>
<ul type=disc>
<li class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;
mso-list:l0 level1 lfo1'>Specifically, which application development tool
are you trying to use to build <i>this </i>application? <o:p></o:p></li>
<li class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;
mso-list:l0 level1 lfo1'>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? <o:p></o:p></li>
<li class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;
mso-list:l0 level1 lfo1'>Does this new application plan to use Berkeley DB
11gR2 via the SQL API, which is based on SQLite? <o:p></o:p></li>
<li class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;
mso-list:l0 level1 lfo1'>Does this new application plan to access the
SQLite/Berkeley DB database via JDBC? <o:p></o:p></li>
<li class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;
mso-list:l0 level1 lfo1'>Does this new application plan on using
capabilities of the SQLite spatial functionality, just simple SQL or
something else? <o:p></o:p></li>
</ul>
<p class=MsoNormal>With regards to your recent question: <o:p></o:p></p>
<p class=MsoNormal>"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?"<o:p></o:p></p>
<p class=MsoNormal>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>download the SQLite JDBC driver package from</span><span
class=apple-converted-space> </span><span class=apple-style-span><a
href="http://www.ch-werner.de/javasqlite/"><span style='color:#BB0000;
text-decoration:none'>http://www.ch-werner.de/javasqlite/</span></a>;</span><span
style='font-size:13.5pt'><br>
</span>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)<span class=apple-style-span><span
style='font-size:10.0pt;font-family:"Verdana","sans-serif"'>,</span></span><span
style='font-size:10.0pt;font-family:"Verdana","sans-serif"'><br>
</span>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? <o:p></o:p></p>
<p class=MsoNormal>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: <o:p></o:p></p>
<pre>Hi Sandra,<o:p></o:p></pre><pre><o:p> </o:p></pre><pre> Thank you for the answers.<o:p></o:p></pre><pre> I have an additional question based on the answer for question 2.<o:p></o:p></pre><pre><o:p> </o:p></pre><pre> Additional Question 2:<o:p></o:p></pre><pre> I used to work with BDB as a single jar file (like je-3.3.87.jar)<o:p></o:p></pre><pre>that was referenced in a JDeveloper Application.<o:p></o:p></pre><pre> For deployment, this jar file was packed with my application<o:p></o:p></pre><pre>libraries and files to be deploy to the client.<o:p></o:p></pre><pre> Now it seems that this process must be changed. The way to install<o:p></o:p></pre><pre>BDB in a windows machine will consider some<o:p></o:p></pre><pre> Dlls installation. Is this correct?<o:p></o:p></pre><pre><o:p> </o:p></pre><pre>Regards,<o:p></o:p></pre><pre><o:p> </o:p></pre><pre>Luis Paolini<o:p></o:p></pre><pre><o:p> </o:p></pre><pre><o:p> </o:p></pre><pre>-----Original Message-----<o:p></o:p></pre><pre>From: Sandra Whitman [<a
href="mailto:sandra.whitman@oracle.com">mailto:sandra.whitman@oracle.com</a>] <o:p></o:p></pre><pre>Sent: domingo, 14 de fevereiro de 2010 22:48<o:p></o:p></pre><pre>To: Luis Paolini<o:p></o:p></pre><pre>Cc: <a
href="mailto:bdb-beta-feedback@oss.oracle.com">bdb-beta-feedback@oss.oracle.com</a>; <a
href="mailto:support@sleepycat.com">support@sleepycat.com</a>; Whitman,Sandra<o:p></o:p></pre><pre>Subject: Re: [BDB 11gR2 Beta] [#18298] First Questions about DBD 11gR2<o:p></o:p></pre><pre><o:p> </o:p></pre><pre>Hi Luis,<o:p></o:p></pre><pre><o:p> </o:p></pre><pre><o:p> </o:p></pre><pre>Thank you again for your email. I have been investigating your <o:p></o:p></pre><pre>questions and do have some answers which I will list below in the <o:p></o:p></pre><pre>question/answer section. I am still doing some more research regarding <o:p></o:p></pre><pre>ADF and JDBC access and will get back to you on those. In the mean time <o:p></o:p></pre><pre>if you have any other questions, or if I did not completely answer <o:p></o:p></pre><pre>something, please let me know.<o:p></o:p></pre><pre><o:p> </o:p></pre><pre><o:p> </o:p></pre><pre>Question 1:<o:p></o:p></pre><pre>Is necessary to build BDB from source files?<o:p></o:p></pre><pre><o:p> </o:p></pre><pre>Answer 1:<o:p></o:p></pre><pre>At the current time you do need to build Berkeley DB from source. This <o:p></o:p></pre><pre>requires Visual Studio C++. You can use the free Express version <o:p></o:p></pre><pre>available from Microsoft.com. We will however consider a pre-built <o:p></o:p></pre><pre>version for the future.<o:p></o:p></pre><pre><o:p> </o:p></pre><pre>Question 2:<o:p></o:p></pre><pre>How is the BDB jar file obtained?<o:p></o:p></pre><pre><o:p> </o:p></pre><pre>Answer 2:<o:p></o:p></pre><pre>What are the plans for the Berkeley DB jar file? Is that to be used <o:p></o:p></pre><pre>with ADF? I am still checking, but a jar file may not be<o:p></o:p></pre><pre>needed for this. If a Berkeley DB jar file is needed, it can be built <o:p></o:p></pre><pre>with Version 1.5 or 1.6 of the Java JDK.<o:p></o:p></pre><pre><o:p> </o:p></pre><pre><o:p> </o:p></pre><pre>Question 3:<o:p></o:p></pre><pre>How is BDB configured to support SQL?<o:p></o:p></pre><pre><o:p> </o:p></pre><pre>Answer 3:<o:p></o:p></pre><pre>SQL support is built automatically on Windows. The SQL library is built <o:p></o:p></pre><pre>as libdb_sql50.dll in the Release mode or libdb_sql50d.dll in the Debug <o:p></o:p></pre><pre>mode. An SQL command line interpreter called db_sql_shell.exe is also <o:p></o:p></pre><pre>built.<o:p></o:p></pre><pre><o:p> </o:p></pre><pre>Please take a look in the documentation titled "Building the SQL API - <o:p></o:p></pre><pre>Chapter 5. Building Berkeley DB for Windows"<o:p></o:p></pre><pre><o:p> </o:p></pre><pre> From there:<o:p></o:p></pre><pre>Building the SQL API<o:p></o:p></pre><pre><o:p> </o:p></pre><pre>Binary Compatibility With SQLite<o:p></o:p></pre><pre><o:p> </o:p></pre><pre>SQL support is built automatically on Windows. The SQL library is built <o:p></o:p></pre><pre>as libdb_sql50.dll in the Release mode or libdb_sql50d.dll in the Debug <o:p></o:p></pre><pre>mode. An SQL command line interpreter called db_sql_shell.exe is also built.<o:p></o:p></pre><pre>Binary Compatibility With SQLite<o:p></o:p></pre><pre><o:p> </o:p></pre><pre>Both libdb_sql50.dll and libdb_sql50d.dll are compatible with <o:p></o:p></pre><pre>sqlite3.dll. You can rename libdb_sql50.dll to sqlite3.dll and <o:p></o:p></pre><pre>db_sql_shell.exe to sqlite3.exe, and use these applications as a <o:p></o:p></pre><pre>replacement for the standard SQLite binaries with same names.<o:p></o:p></pre><pre><o:p> </o:p></pre><pre><o:p> </o:p></pre><pre>Question 4:<o:p></o:p></pre><pre>Are the SQLite data types are supported by Oracle ADF?<o:p></o:p></pre><pre><o:p> </o:p></pre><pre>Answer 4:<o:p></o:p></pre><pre>I am still investigating this point. However, the ADF components <o:p></o:p></pre><pre>support SQLite so there should not be a problem here.<o:p></o:p></pre><pre>I will get back to you on this though.<o:p></o:p></pre><pre><o:p> </o:p></pre><pre><o:p> </o:p></pre><pre>Question 5:<o:p></o:p></pre><pre>Is any documentation available regarding JDBC access to the database.<o:p></o:p></pre><pre><o:p> </o:p></pre><pre>Answer 5:<o:p></o:p></pre><pre>The ODBC and JDBC drivers are not included in the initial Beta release <o:p></o:p></pre><pre>package, but they are supported and they will be included in the <o:p></o:p></pre><pre>production release. In order to build the drivers, please download the <o:p></o:p></pre><pre>open source ODBC driver from <a
href="http://www.ch-werner.de/sqliteodbc/">http://www.ch-werner.de/sqliteodbc/</a> and the <o:p></o:p></pre><pre>open source JDBC driver from <a
href="http://www.ch-werner.de/javasqlite">http://www.ch-werner.de/javasqlite</a>.<o:p></o:p></pre><pre><o:p> </o:p></pre><pre><o:p> </o:p></pre><pre>Question 6:<o:p></o:p></pre><pre>Are there any examples using BDB SQLite Interfaces?<o:p></o:p></pre><pre><o:p> </o:p></pre><pre>Answer:<o:p></o:p></pre><pre>The BDB SQLite interface examples are under the distribution at <o:p></o:p></pre><pre>sql\examples\c.<o:p></o:p></pre><pre><o:p> </o:p></pre><pre><o:p> </o:p></pre><pre>Best Regards,<o:p></o:p></pre><pre>Sandra<o:p></o:p></pre><pre>Sandra Whitman<o:p></o:p></pre><pre>Oracle Global Customer Support<o:p></o:p></pre><pre> <o:p></o:p></pre>
<div>
<p class=MsoNormal>-- <br>
<a href="http://www.oracle.com" target="_blank"><span style='text-decoration:
none'><img border=0 width=114 height=26 id="_x0000_i1049"
src="cid:image001.gif@01CAAFF5.F37EC420" alt=Oracle></span></a><br>
<span style='font-size:10.0pt;font-family:"Verdana","sans-serif";color:#666666'>David
Segleau | Director Product Management - Berkeley DB<br>
Phone: +1 425 945 8533 | Mobile: +1 408 420 7350 <br>
</span><span style='font-size:10.0pt;font-family:"Verdana","sans-serif";
color:red'>Oracle</span><span style='font-size:10.0pt;font-family:"Verdana","sans-serif";
color:#666666'> Database Engineering<br>
</span><br>
<a href="http://www.oracle.com/commitment" target="_blank"><span
style='text-decoration:none'><img border=0 width=44 height=28 id="_x0000_i1050"
src="cid:image002.gif@01CAAFF5.F37EC420" alt="Green Oracle"></span></a><span
style='font-size:7.5pt;font-family:"Verdana","sans-serif";color:#4B7D42'>Oracle
is committed to developing practices and products that help protect the
environment</span> <o:p></o:p></p>
</div>
<p class=MsoNormal><br>
<br>
__________ Information from ESET NOD32 Antivirus, version of virus signature
database 4875 (20100217) __________<br>
<br>
The message was checked by ESET NOD32 Antivirus.<br>
<br>
<a href="http://www.eset.com">http://www.eset.com</a><o:p></o:p></p>
</div>
<BR><BR>__________ Information from ESET NOD32 Antivirus, version of virus signature database 4875 (20100217) __________<BR><BR>The message was checked by ESET NOD32 Antivirus.<BR><BR><A HREF="http://www.eset.com">http://www.eset.com</A><BR> </body>
</html>