<!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 quick response. <br>
<span
style="font-size: 11pt; font-family: "Calibri","sans-serif"; color: windowtext;"
lang="EN-US"><o:p></o:p></span>
<blockquote
cite="mid:!&!AAAAAAAAAAAYAAAAAAAAACnGWmDPjatNrG2fqilf47fCgAAAEAAAAKYhaJ0ABoxIkwacuwOlnx8BAAAAAA==@gempi.com.br"
type="cite">
<div class="Section1">
<p class="MsoNormal" style="text-indent: 35.4pt;"><span
style="font-size: 11pt; font-family: "Calibri","sans-serif"; color: windowtext;"
lang="EN-US">The
first point that is clear now is that we are talking about two
different
products: Berkeley DB Java Edition and Berkeley DB 11gR2. I
was not thinking that way and now it explains some of my questions. If
I understand correctly, you created a java wrapper in order to expose
the
SQLite API for Java applications, but in essence it is a set
of C libraries.</span></p>
</div>
</blockquote>
<br>
I thought that might be part of the confusion. :-) My apologies that
this wasn't clear earlier. Both Berkeley DB 11gR2 and SQLite are C
libraries. The Java API wrappers for both libraries have been around
for a long time. Neither of them are new to this release. <br>
<br>
<blockquote
cite="mid:!&!AAAAAAAAAAAYAAAAAAAAACnGWmDPjatNrG2fqilf47fCgAAAEAAAAKYhaJ0ABoxIkwacuwOlnx8BAAAAAA==@gempi.com.br"
type="cite">
<div class="Section1">
<p class="MsoNormal" style="text-indent: 35.4pt;"><span
style="font-size: 11pt; font-family: "Calibri","sans-serif"; color: windowtext;"
lang="EN-US"><o:p></o:p></span></p>
<ul type="disc">
<li class="MsoNormal" style=""><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: 36pt;"><span
style="font-size: 11pt; font-family: "Calibri","sans-serif";">The
application we
are working on is a ADF Java Desktop Application. It uses ADF Swing. It
can operates is
two modes: Connected to a corporate Oracle 11g Database or Disconnected
using a
local Berkeley Database. In the connected
mode we use ADF Business Components to do the object-relational mapping
and
create Entities, Views, Associations, etc. These components
are used by the ADF Swing components in the UI, via data binding model.
Our goal is to do
the same approach using Berkeley DB 11gR2. The idea is to have
the same data model in the two databases, in order to use the same ADF
Business
Components already created. Depending on the
context (connected or disconnected), we just need to change the
database
connection and the application would just works,
no matter the database is Oracle 11g or Berkeley. Does it makes
sense?</span></p>
</div>
</blockquote>
I'll let the ADF/Swing folks address the ADF-related questions. <br>
<br>
With regards to the data model, it "should work", assuming that the
data model implements a common set of data types and features. The
Oracle Database and Spatial capabilities are not 100% compatible with
the SQLite database and Spatial capabilities. I have not yet spent any
time looking into the differences between the two. I'm not sure if the
same ADF Business Components can work against both data sources. <br>
<br>
<blockquote
cite="mid:!&!AAAAAAAAAAAYAAAAAAAAACnGWmDPjatNrG2fqilf47fCgAAAEAAAAKYhaJ0ABoxIkwacuwOlnx8BAAAAAA==@gempi.com.br"
type="cite">
<div class="Section1">
<p class="MsoPlainText" style="margin-left: 36pt;"><span
style="font-size: 11pt; font-family: "Calibri","sans-serif";"><o:p></o:p></span></p>
<span style="font-size: 11pt; font-family: "Calibri","sans-serif";"
lang="EN-US"><o:p></o:p></span>
<ul type="disc">
<li class="MsoNormal" style=""><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="margin-left: 36pt;"><span
style="font-size: 11pt; font-family: "Calibri","sans-serif";"
lang="EN-US">We
have a requirement to store geometries extracted from Oracle Spatial
(sdo_geometry) into BDB. Is it supported?<o:p></o:p></span></p>
</div>
</blockquote>
SQLite has support for spatial data types and functions. See <a
href="http://www.sqlite.org/rtree.html">http://www.sqlite.org/rtree.html</a>.
Since it is built on top of the sqlite3() API, it works with Berkeley
DB 11gR2 as well. We've done some initial testing in-house, and the
SQLite spatial tests appear to pass on Berkeley DB 11gR2. As I
mentioned before, I have not yet looking into how the SQLite and Oracle
Database spatial packages differ.<br>
<br>
<blockquote
cite="mid:!&!AAAAAAAAAAAYAAAAAAAAACnGWmDPjatNrG2fqilf47fCgAAAEAAAAKYhaJ0ABoxIkwacuwOlnx8BAAAAAA==@gempi.com.br"
type="cite">
<div class="Section1">
<p class="MsoNormal" style="text-indent: 35.4pt;"><span
style="font-size: 11pt; font-family: "Calibri","sans-serif"; color: rgb(31, 73, 125);"
lang="EN-US"><o:p></o:p></span><span
style="font-size: 11pt; font-family: "Calibri","sans-serif"; color: windowtext;"
lang="EN-US">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
style="font-size: 11pt; font-family: "Calibri","sans-serif"; color: windowtext;"
lang="EN-US">I’ll
let you know about the progress.</span></p>
</div>
</blockquote>
<br>
Thanks. We'll be interested to hear how you're doing. <br>
<br>
Regards, <br>
<br>
Dave<br>
<br>
<div class="moz-signature">-- <br>
<a href="http://www.oracle.com" target="_blank"><img
src="cid:part1.07010006.04080805@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.00030102.01040103@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>