<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:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<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:"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;}
/* 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
{mso-style-priority:99;
mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
font-size:12.0pt;
font-family:"Times New Roman","serif";
color:black;}
p.MsoAcetate, li.MsoAcetate, div.MsoAcetate
{mso-style-priority:99;
mso-style-link:"Balloon Text Char";
margin:0cm;
margin-bottom:.0001pt;
font-size:8.0pt;
font-family:"Tahoma","sans-serif";
color:black;}
p.MsoListParagraph, li.MsoListParagraph, div.MsoListParagraph
{mso-style-priority:34;
margin-top:0cm;
margin-right:0cm;
margin-bottom:0cm;
margin-left:36.0pt;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman","serif";
color:black;}
span.EmailStyle18
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
span.BalloonTextChar
{mso-style-name:"Balloon Text Char";
mso-style-priority:99;
mso-style-link:"Balloon Text";
font-family:"Tahoma","sans-serif";
color:black;}
.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:554005552;
mso-list-type:hybrid;
mso-list-template-ids:2042933808 -95631806 68550681 68550683 68550671 68550681 68550683 68550671 68550681 68550683;}
@list l0:level1
{mso-level-tab-stop:none;
mso-level-number-position:left;
margin-left:53.25pt;
text-indent:-18.0pt;}
ol
{margin-bottom:0cm;}
ul
{margin-bottom:0cm;}
-->
</style>
<!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="2050" />
</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 lang=EN-US style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:windowtext'>Brian,<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'> I created a test application to try the
workaround that you mentioned in the last email, but it didn’t work as
expected.<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'> Maybe I’m missing something.<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'> Please see below the steps I did.<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=MsoListParagraph style='margin-left:53.25pt;text-indent:-18.0pt;
mso-list:l0 level1 lfo1'><![if !supportLists]><span lang=EN-US
style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:windowtext'><span
style='mso-list:Ignore'>1.<span style='font:7.0pt "Times New Roman"'>
</span></span></span><![endif]><span lang=EN-US style='font-size:11.0pt;
font-family:"Calibri","sans-serif";color:windowtext'>Create the same table in Oracle
XE database and in SQLite database.<o:p></o:p></span></p>
<p class=MsoListParagraph style='margin-left:53.25pt'><span lang=EN-US
style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:windowtext'>Oracle
XE: <o:p></o:p></span></p>
<p class=MsoListParagraph style='margin-left:53.25pt'><span lang=EN-US
style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:windowtext'>CREATE
TABLE ICATB_BANCO_FINANCEIRO<o:p></o:p></span></p>
<p class=MsoListParagraph style='margin-left:53.25pt'><span lang=EN-US
style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:windowtext'>(<o:p></o:p></span></p>
<p class=MsoListParagraph style='margin-left:53.25pt'><span lang=EN-US
style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:windowtext'>
BNF_ID NUMBER(19) not null,<o:p></o:p></span></p>
<p class=MsoListParagraph style='margin-left:53.25pt'><span lang=EN-US
style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:windowtext'>
BNF_NM VARCHAR2(100) not null,<o:p></o:p></span></p>
<p class=MsoListParagraph style='margin-left:53.25pt'><span lang=EN-US
style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:windowtext'>
BNF_CD NUMBER(10) not null<o:p></o:p></span></p>
<p class=MsoListParagraph style='margin-left:53.25pt'><span lang=EN-US
style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:windowtext'>);<o:p></o:p></span></p>
<p class=MsoListParagraph style='margin-left:53.25pt'><span lang=EN-US
style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:windowtext'><o:p> </o:p></span></p>
<p class=MsoListParagraph style='margin-left:53.25pt'><span lang=EN-US
style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:windowtext'>SQLite:<o:p></o:p></span></p>
<p class=MsoListParagraph style='margin-left:53.25pt'><span lang=EN-US
style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:windowtext'>CREATE
TABLE ICATB_BANCO_FINANCEIRO (BNF_ID INTEGER PRIMARY KEY ASC, BNF_NM TEXT,
BNF_CD INTEGER);<o:p></o:p></span></p>
<p class=MsoListParagraph style='margin-left:53.25pt'><span lang=EN-US
style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:windowtext'><o:p> </o:p></span></p>
<p class=MsoListParagraph style='margin-left:53.25pt;text-indent:-18.0pt;
mso-list:l0 level1 lfo1'><![if !supportLists]><span lang=EN-US
style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:windowtext'><span
style='mso-list:Ignore'>2.<span style='font:7.0pt "Times New Roman"'>
</span></span></span><![endif]><span lang=EN-US style='font-size:11.0pt;
font-family:"Calibri","sans-serif";color:windowtext'>Insert 3 records into the
ICATB_BANCO_FINANCEIRO table. (In Oracle XE and SQLite)<o:p></o:p></span></p>
<p class=MsoListParagraph style='margin-left:53.25pt'><span lang=EN-US
style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:windowtext'>INSERT
INTO ICATB_BANCO_FINANCEIRO(BNF_ID,BNF_NM,BNF_CD) VALUES (1,'Banco1',1);<o:p></o:p></span></p>
<p class=MsoListParagraph style='margin-left:53.25pt'><span lang=EN-US
style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:windowtext'>INSERT
INTO ICATB_BANCO_FINANCEIRO(BNF_ID,BNF_NM,BNF_CD) VALUES (2,'Banco2',2);<o:p></o:p></span></p>
<p class=MsoListParagraph style='margin-left:53.25pt'><span lang=EN-US
style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:windowtext'>INSERT
INTO ICATB_BANCO_FINANCEIRO(BNF_ID,BNF_NM,BNF_CD) VALUES (3,'Banco3',3);<o:p></o:p></span></p>
<p class=MsoListParagraph style='margin-left:53.25pt'><span lang=EN-US
style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:windowtext'><o:p> </o:p></span></p>
<p class=MsoListParagraph style='margin-left:53.25pt;text-indent:-18.0pt;
mso-list:l0 level1 lfo1'><![if !supportLists]><span lang=EN-US
style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:windowtext'><span
style='mso-list:Ignore'>3.<span style='font:7.0pt "Times New Roman"'>
</span></span></span><![endif]><span lang=EN-US style='font-size:11.0pt;
font-family:"Calibri","sans-serif";color:windowtext'>Using JDeveloper, create a
new ADF Java Desktop Application<o:p></o:p></span></p>
<p class=MsoListParagraph style='margin-left:53.25pt;text-indent:-18.0pt;
mso-list:l0 level1 lfo1'><![if !supportLists]><span lang=EN-US
style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:windowtext'><span
style='mso-list:Ignore'>4.<span style='font:7.0pt "Times New Roman"'>
</span></span></span><![endif]><span lang=EN-US style='font-size:11.0pt;
font-family:"Calibri","sans-serif";color:windowtext'>Create a Database
connection for Oracle XE database:<o:p></o:p></span></p>
<p class=MsoListParagraph style='margin-left:53.25pt;text-indent:-18.0pt;
mso-list:l0 level1 lfo1'><![if !supportLists]><span lang=EN-US
style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:windowtext'><span
style='mso-list:Ignore'>5.<span style='font:7.0pt "Times New Roman"'>
</span></span></span><![endif]><span lang=EN-US style='font-size:11.0pt;
font-family:"Calibri","sans-serif";color:windowtext'>Using ADF BC Wizard,
create an Entity Object and a View Object (updatable).<o:p></o:p></span></p>
<p class=MsoListParagraph style='margin-left:53.25pt;text-indent:-18.0pt;
mso-list:l0 level1 lfo1'><![if !supportLists]><span lang=EN-US
style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:windowtext'><span
style='mso-list:Ignore'>6.<span style='font:7.0pt "Times New Roman"'>
</span></span></span><![endif]><span lang=EN-US style='font-size:11.0pt;
font-family:"Calibri","sans-serif";color:windowtext'>Create a Jpanel<o:p></o:p></span></p>
<p class=MsoListParagraph style='margin-left:53.25pt;text-indent:-18.0pt;
mso-list:l0 level1 lfo1'><![if !supportLists]><span lang=EN-US
style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:windowtext'><span
style='mso-list:Ignore'>7.<span style='font:7.0pt "Times New Roman"'>
</span></span></span><![endif]><span lang=EN-US style='font-size:11.0pt;
font-family:"Calibri","sans-serif";color:windowtext'>Using the DataControl,
drag-n-drop the 3 attributes into the jPanel.<o:p></o:p></span></p>
<p class=MsoListParagraph style='margin-left:53.25pt;text-indent:-18.0pt;
mso-list:l0 level1 lfo1'><![if !supportLists]><span lang=EN-US
style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:windowtext'><span
style='mso-list:Ignore'>8.<span style='font:7.0pt "Times New Roman"'>
</span></span></span><![endif]><span lang=EN-US style='font-size:11.0pt;
font-family:"Calibri","sans-serif";color:windowtext'>Using the Datacontrol, drag-n-drop
some operations into the JPanel (Create, Delete, Commit, First, Last, Next and
Previous).<o:p></o:p></span></p>
<p class=MsoNormal style='margin-left:35.4pt'><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 style='margin-left:53.25pt'><span style='font-size:11.0pt;
font-family:"Calibri","sans-serif";color:windowtext'><img width=396 height=175
id="Picture_x0020_55" src="cid:image007.png@01CAC8F1.6FEB8520"></span><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'><o:p> </o:p></span></p>
<p class=MsoListParagraph style='margin-left:53.25pt;text-indent:-18.0pt;
mso-list:l0 level1 lfo1'><![if !supportLists]><span lang=EN-US
style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:windowtext'><span
style='mso-list:Ignore'>9.<span style='font:7.0pt "Times New Roman"'>
</span></span></span><![endif]><span lang=EN-US style='font-size:11.0pt;
font-family:"Calibri","sans-serif";color:windowtext'>Run the application to
check if everything is working.<o:p></o:p></span></p>
<p class=MsoListParagraph style='margin-left:53.25pt;text-indent:-18.0pt;
mso-list:l0 level1 lfo1'><![if !supportLists]><span lang=EN-US
style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:windowtext'><span
style='mso-list:Ignore'>10.<span style='font:7.0pt "Times New Roman"'>
</span></span></span><![endif]><span lang=EN-US style='font-size:11.0pt;
font-family:"Calibri","sans-serif";color:windowtext'>Create a Database
connection for SQLite.<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 style='margin-left:17.85pt;text-indent:35.4pt'><span
style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:windowtext'><img
width=560 height=559 id="Picture_x0020_64"
src="cid:image008.png@01CAC8F1.6FEB8520"></span><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'><o:p> </o:p></span></p>
<p class=MsoListParagraph style='margin-left:53.25pt;text-indent:-18.0pt;
mso-list:l0 level1 lfo1'><![if !supportLists]><span lang=EN-US
style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:windowtext'><span
style='mso-list:Ignore'>11.<span style='font:7.0pt "Times New Roman"'>
</span></span></span><![endif]><span lang=EN-US style='font-size:11.0pt;
font-family:"Calibri","sans-serif";color:windowtext'>Edit the Model.jpx file to
switch the connection to SQLite.<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 style='margin-left:53.25pt'><span style='font-size:11.0pt;
font-family:"Calibri","sans-serif";color:windowtext'><img width=698 height=378
id="Picture_x0020_73" src="cid:image009.png@01CAC8F1.6FEB8520"></span><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'><o:p> </o:p></span></p>
<p class=MsoListParagraph style='margin-left:53.25pt;text-indent:-18.0pt;
mso-list:l0 level1 lfo1'><![if !supportLists]><span lang=EN-US
style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:windowtext'><span
style='mso-list:Ignore'>12.<span style='font:7.0pt "Times New Roman"'>
</span></span></span><![endif]><span lang=EN-US style='font-size:11.0pt;
font-family:"Calibri","sans-serif";color:windowtext'>Run the Application<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 style='margin-left:35.25pt'><span lang=EN-US
style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:windowtext'>At
this point, I got an error related to the JDBC Connection.<o:p></o:p></span></p>
<p class=MsoNormal style='margin-left:35.25pt'><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 style='margin-left:35.25pt'><span style='font-size:11.0pt;
font-family:"Calibri","sans-serif";color:windowtext'><img width=660 height=166
id="Picture_x0020_33" src="cid:image005.png@01CAC8F0.FDCFCA00"></span><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'><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'> Translating the message: JBO-26061: Error
opening the JDBC Connection.<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'> Clicking on the “Details” button
I got:<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'> </span><span style='font-size:11.0pt;
font-family:"Calibri","sans-serif";color:windowtext'><img width=663 height=196
id="Picture_x0020_42" src="cid:image006.png@01CAC8F0.FDCFCA00"></span><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'><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'> This is the JDev logfile:<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'> Exception in thread "main"
oracle.jbo.DMLException: JBO-26061: Erro ao abrir a conexão JDBC.<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'> at
oracle.jbo.server.ConnectionPool.createConnection(ConnectionPool.java:205)<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'> at oracle.jbo.server.ConnectionPool.instantiateResource(ConnectionPool.java:164)<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'> at
oracle.jbo.pool.ResourcePool.createResource(ResourcePool.java:590)<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'> at
oracle.jbo.pool.ResourcePool.useResource(ResourcePool.java:323)<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'> at
oracle.jbo.server.ConnectionPool.getConnectionInternal(ConnectionPool.java:100)<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'> at
oracle.jbo.server.ConnectionPool.getConnection(ConnectionPool.java:66)<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'> at
oracle.jbo.server.ConnectionPoolManagerImpl.getConnection(ConnectionPoolManagerImpl.java:52)<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'> at
oracle.jbo.server.URLConnectionHelper.getConnection(URLConnectionHelper.java:129)<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'> at
oracle.jbo.server.DBTransactionImpl.establishNewConnection(DBTransactionImpl.java:940)<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'> at
oracle.jbo.server.DBTransactionImpl.initTransaction(DBTransactionImpl.java:1108)<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'> at
oracle.jbo.server.DBTransactionImpl.initTxn(DBTransactionImpl.java:6368)<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'> at
oracle.jbo.server.DBTransactionImpl2.connect(DBTransactionImpl2.java:130)<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'> at
oracle.jbo.common.ampool.DefaultConnectionStrategy.connect(DefaultConnectionStrategy.java:213)<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'> at
oracle.jbo.server.ApplicationPoolMessageHandler.doPoolConnect(ApplicationPoolMessageHandler.java:553)<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'> at
oracle.jbo.server.ApplicationPoolMessageHandler.doPoolMessage(ApplicationPoolMessageHandler.java:409)<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'> at oracle.jbo.server.ApplicationModuleImpl.doPoolMessage(ApplicationModuleImpl.java:8534)<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'> at
oracle.jbo.common.ampool.ApplicationPoolImpl.sendPoolMessage(ApplicationPoolImpl.java:4392)<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'> at
oracle.jbo.common.ampool.ApplicationPoolImpl.prepareApplicationModule(ApplicationPoolImpl.java:2388)<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'> at oracle.jbo.common.ampool.ApplicationPoolImpl.doCheckout(ApplicationPoolImpl.java:2204)<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'> at
oracle.jbo.common.ampool.ApplicationPoolImpl.useApplicationModule(ApplicationPoolImpl.java:3088)<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'> at
oracle.jbo.common.ampool.SessionCookieImpl.useApplicationModule(SessionCookieImpl.java:460)<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'> at
oracle.jbo.common.ampool.SessionCookieImpl.useApplicationModule(SessionCookieImpl.java:431)<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'> at
oracle.jbo.common.ampool.SessionCookieImpl.useApplicationModule(SessionCookieImpl.java:426)<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'> at oracle.adf.model.bc4j.DCJboDataControl.initializeApplicationModule(DCJboDataControl.java:513)<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'> at
oracle.adf.model.bc4j.DCJboDataControl.getApplicationModule(DCJboDataControl.java:856)<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'> at
oracle.adf.model.binding.DCBindingContainer.setDataControl(DCBindingContainer.java:554)<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'> at oracle.jbo.uicli.jui.JUPanelBinding.useDefaultDataControl(JUPanelBinding.java:912)<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'> at
oracle.jbo.uicli.jui.JUPanelBinding.setup(JUPanelBinding.java:125)<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'> at
oracle.jbo.uicli.controls.JUTestFrame.createBindingCtxAndSetUpMenu(JUTestFrame.java:165)<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'> at oracle.jbo.uicli.controls.JUTestFrame.<init>(JUTestFrame.java:117)<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'> at
oracle.jbo.uicli.controls.JUTestFrame.startTestFrame(JUTestFrame.java:80)<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'> at demo.view.Panel1.main(Panel1.java:181)<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'>Caused by: java.sql.SQLException: No suitable driver found
for jdbc:sqlite:D:\Downloads\Oracle\Berkeley_Beta\db-5.0.11\db-5.0.11\build_windows\Win32\Debug\test.db<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'> at
java.sql.DriverManager.getConnection(DriverManager.java:602)<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'> at
java.sql.DriverManager.getConnection(DriverManager.java:154)<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'> at
oracle.jbo.server.URLConnectionHelper.getConnection(URLConnectionHelper.java:144)<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'> at
oracle.jbo.server.URLConnectionHelper.getConnectionFromDriver(URLConnectionHelper.java:50)<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'> at
oracle.jbo.server.ConnectionPool.createConnection(ConnectionPool.java:193)<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'> ... 31 more<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'>## Detail 0 ##<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'>java.sql.SQLException: No suitable driver found for
jdbc:sqlite:D:\Downloads\Oracle\Berkeley_Beta\db-5.0.11\db-5.0.11\build_windows\Win32\Debug\test.db<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'> at
java.sql.DriverManager.getConnection(DriverManager.java:602)<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'> at java.sql.DriverManager.getConnection(DriverManager.java:154)<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'> at
oracle.jbo.server.URLConnectionHelper.getConnection(URLConnectionHelper.java:144)<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'> at
oracle.jbo.server.URLConnectionHelper.getConnectionFromDriver(URLConnectionHelper.java:50)<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'> at oracle.jbo.server.ConnectionPool.createConnection(ConnectionPool.java:193)<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'> at
oracle.jbo.server.ConnectionPool.instantiateResource(ConnectionPool.java:164)<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'> at
oracle.jbo.pool.ResourcePool.createResource(ResourcePool.java:590)<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'> at oracle.jbo.pool.ResourcePool.useResource(ResourcePool.java:323)<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'> at
oracle.jbo.server.ConnectionPool.getConnectionInternal(ConnectionPool.java:100)<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'> at
oracle.jbo.server.ConnectionPool.getConnection(ConnectionPool.java:66)<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'> at
oracle.jbo.server.ConnectionPoolManagerImpl.getConnection(ConnectionPoolManagerImpl.java:52)<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'> at
oracle.jbo.server.URLConnectionHelper.getConnection(URLConnectionHelper.java:129)<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'> at
oracle.jbo.server.DBTransactionImpl.establishNewConnection(DBTransactionImpl.java:940)<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'> at
oracle.jbo.server.DBTransactionImpl.initTransaction(DBTransactionImpl.java:1108)<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'> at
oracle.jbo.server.DBTransactionImpl.initTxn(DBTransactionImpl.java:6368)<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'> at
oracle.jbo.server.DBTransactionImpl2.connect(DBTransactionImpl2.java:130)<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'> at
oracle.jbo.common.ampool.DefaultConnectionStrategy.connect(DefaultConnectionStrategy.java:213)<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'> at
oracle.jbo.server.ApplicationPoolMessageHandler.doPoolConnect(ApplicationPoolMessageHandler.java:553)<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'> at
oracle.jbo.server.ApplicationPoolMessageHandler.doPoolMessage(ApplicationPoolMessageHandler.java:409)<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'> at oracle.jbo.server.ApplicationModuleImpl.doPoolMessage(ApplicationModuleImpl.java:8534)<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'> at
oracle.jbo.common.ampool.ApplicationPoolImpl.sendPoolMessage(ApplicationPoolImpl.java:4392)<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'> at
oracle.jbo.common.ampool.ApplicationPoolImpl.prepareApplicationModule(ApplicationPoolImpl.java:2388)<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'> at
oracle.jbo.common.ampool.ApplicationPoolImpl.doCheckout(ApplicationPoolImpl.java:2204)<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'> at
oracle.jbo.common.ampool.ApplicationPoolImpl.useApplicationModule(ApplicationPoolImpl.java:3088)<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'> at
oracle.jbo.common.ampool.SessionCookieImpl.useApplicationModule(SessionCookieImpl.java:460)<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'> at
oracle.jbo.common.ampool.SessionCookieImpl.useApplicationModule(SessionCookieImpl.java:431)<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'> at oracle.jbo.common.ampool.SessionCookieImpl.useApplicationModule(SessionCookieImpl.java:426)<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'> at
oracle.adf.model.bc4j.DCJboDataControl.initializeApplicationModule(DCJboDataControl.java:513)<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'> at
oracle.adf.model.bc4j.DCJboDataControl.getApplicationModule(DCJboDataControl.java:856)<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'> at
oracle.adf.model.binding.DCBindingContainer.setDataControl(DCBindingContainer.java:554)<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'> at
oracle.jbo.uicli.jui.JUPanelBinding.useDefaultDataControl(JUPanelBinding.java:912)<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'> at
oracle.jbo.uicli.jui.JUPanelBinding.setup(JUPanelBinding.java:125)<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'> at
oracle.jbo.uicli.controls.JUTestFrame.createBindingCtxAndSetUpMenu(JUTestFrame.java:165)<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'> at
oracle.jbo.uicli.controls.JUTestFrame.<init>(JUTestFrame.java:117)<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'> at
oracle.jbo.uicli.controls.JUTestFrame.startTestFrame(JUTestFrame.java:80)<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'> at demo.view.Panel1.main(Panel1.java:181)<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'> Could you please check, if I’m using
the workaround as expected?<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><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'>
Brian Fry [mailto:brian.fry@oracle.com] <br>
<b>Sent:</b> sexta-feira, 19 de março de 2010 13:03<br>
<b>To:</b> Luis Paolini<br>
<b>Cc:</b> 'Joe Huang'; sandra.whitman@oracle.com; 'Fernando Targa';
kent.rollins@oracle.com; dave.segleau@oracle.com; 'Sleepycat Software Support';
george.feinberg@oracle.com; bdb-beta-feedback@oss.oracle.com<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>Great!<br>
<br>
Luis, we found a bug that prevents using the ADF BC wizards at design time
directly against SQLite. We're working on addressing this (or at least finding
a better workaround), but in the mean time, we would suggest that you create an
identical database schema in an Oracle database, and develop against that. As
described in the "developing for multiple databases" how to, use the
SQL92 SQL flavor and Java type mappings. You can then switch the connection
definition to test running against SQLite. If we get a better workaround, we
will keep you posted.<br>
<br>
-- Brian<br>
<br>
<br>
On 3/19/2010 3:56 AM, Luis Paolini wrote: <o:p></o:p></p>
<div>
<p>Joe, <o:p></o:p></p>
<p> <o:p></o:p></p>
<p>
<span lang=EN-US>Thanks for the information. I got Zentus JDBC driver and
followed the steps. </span><o:p></o:p></p>
<p><span lang=EN-US>
It worked as expected and I could connect to my SQLite test database. </span><o:p></o:p></p>
<p><span lang=EN-US> </span><o:p></o:p></p>
<p><span lang=EN-US>Regards, </span><o:p></o:p></p>
<p><span lang=EN-US> </span><o:p></o:p></p>
<p><span lang=EN-US>Luis </span><o:p></o:p></p>
<p><span lang=EN-US> </span><o:p></o:p></p>
<div>
<div>
<p><b><span lang=EN-US>From:</span></b><span lang=EN-US> Joe Huang [<a
href="mailto:JOE.HUANG@oracle.com">mailto:JOE.HUANG@oracle.com</a>] <br>
<b>Sent:</b> quarta-feira, 17 de março de 2010 22:27<br>
<b>To:</b> <a href="mailto:brian.fry@oracle.com">brian.fry@oracle.com</a>; <a
href="mailto:sandra.whitman@oracle.com">sandra.whitman@oracle.com</a><br>
<b>Cc:</b> Luis Paolini; Fernando Targa; <a
href="mailto:kent.rollins@oracle.com">kent.rollins@oracle.com</a>; <a
href="mailto:dave.segleau@oracle.com">dave.segleau@oracle.com</a>; Sleepycat
Software Support; <a href="mailto:george.feinberg@oracle.com">george.feinberg@oracle.com</a>;
<a href="mailto:bdb-beta-feedback@oss.oracle.com">bdb-beta-feedback@oss.oracle.com</a><br>
<b>Subject:</b> RE: [BDB 11gR2 Beta] [#18298] First Questions about DBD 11gR2 </span><o:p></o:p></p>
</div>
</div>
<p><span lang=EN-US> </span><o:p></o:p></p>
<p><span lang=EN-US>Sure - a couple of steps. First, you will need to
download a JDBC driver that can connect to a SQLite database. We had
tested against Zentus driver, which is an open source driver that you can
download from Zentus. I downloaded the driver and had installed to a
directory called c:\zentus. This should give me a file
sqlitejdbc-v0xx.jar in c:\zentus, where xx is the exact version number you
download. </span><o:p></o:p></p>
<p><span lang=EN-US> </span><o:p></o:p></p>
<p><span lang=EN-US>To connect to SQLite DB, I would first create a new
database connection in JDeveloper, and then configure the connection as follows
– please reference the screen shot below: </span><o:p></o:p></p>
<p><span lang=EN-US> </span><o:p></o:p></p>
<p><span lang=EN-US><img border=0 width=560 height=560 id="_x0000_i1025"
src="cid:image001.png@01CAC8EF.95210AB0"></span><o:p></o:p></p>
<p><span lang=EN-US> </span><o:p></o:p></p>
<p><span lang=EN-US>1. First in the Connection Type drop
down, select Generic JDBC. Click “New” next to the driver
class drop down, and type org.sqlite.JDBC in the name of the driver class. </span><o:p></o:p></p>
<p><span lang=EN-US> </span><o:p></o:p></p>
<p><span lang=EN-US> </span><o:p></o:p></p>
<p><span lang=EN-US><img border=0 width=370 height=147 id="_x0000_i1026"
src="cid:image002.png@01CAC8EF.95210AB0"></span><o:p></o:p></p>
<p><span lang=EN-US> </span><o:p></o:p></p>
<p><span lang=EN-US>2. Click browse, and then click New in
the dialog box below: </span><o:p></o:p></p>
<p><span lang=EN-US><img border=0 width=637 height=500 id="_x0000_i1027"
src="cid:image003.png@01CAC8EF.95210AB0"></span><o:p></o:p></p>
<p><span lang=EN-US> </span><o:p></o:p></p>
<p><span lang=EN-US>3. Click Add Entry in the dialog box
below, and then select the sqlitejdbc-v0xx.jar on your file system. After
you select the jar file, you should see this jar added to the class path. </span><o:p></o:p></p>
<p><span lang=EN-US><img border=0 width=350 height=500 id="_x0000_i1028"
src="cid:image004.png@01CAC8EF.95210AB0"></span><o:p></o:p></p>
<p><span lang=EN-US> </span><o:p></o:p></p>
<p><span lang=EN-US>4. Click OK and then OK to return to the
DB Connection creation screen. </span><o:p></o:p></p>
<p><span lang=EN-US>5. In the JDBC URL window, type this
jdbc:sqlite:<Path to your SQLite/BDB data file>. For example,
jdbc:sqlite:C:\Documents and
Settings\jhhuang\Desktop\sqlite-3_6_22\MOBILEFOD.db, where MOBILEFOD.db is the
SQLite file containing my data. </span><o:p></o:p></p>
<p><span lang=EN-US>6. Leave user name/password
blank. SQLite connection does not need ID/password. </span><o:p></o:p></p>
<p><span lang=EN-US>7. Click “Test
Connection” If this is configured correctly, this should succeed. </span><o:p></o:p></p>
<p><span lang=EN-US> </span><o:p></o:p></p>
<p><span lang=EN-US> </span><o:p></o:p></p>
<p><span lang=EN-US>Thanks, </span><o:p></o:p></p>
<p><span lang=EN-US> </span><o:p></o:p></p>
<p><span lang=EN-US>Joe Huang </span><o:p></o:p></p>
<p><span lang=EN-US>Senior Principal Product Manager </span><o:p></o:p></p>
<p><span lang=EN-US>Mobile Platform, ADF/JDeveloper </span><o:p></o:p></p>
<p><span lang=EN-US>Product Development </span><o:p></o:p></p>
<p><span lang=EN-US>ORACLE </span><o:p></o:p></p>
<p><span lang=EN-US>650-506-2271 (Office) </span><o:p></o:p></p>
<p><span lang=EN-US>510-282-0369 (Mobile) </span><o:p></o:p></p>
<p><span lang=EN-US> </span><o:p></o:p></p>
<p><span lang=EN-US>Product Info: <a
href="http://www.oracle.com/technology/tech/wireless/adf_mobile.html">http://www.oracle.com/technology/tech/wireless/adf_mobile.html</a>
</span><o:p></o:p></p>
<p><span lang=EN-US>Demos: <a href="http://stshld.oracle.com:8888/demo">http://stshld.oracle.com:8888/demo</a>
</span><o:p></o:p></p>
<p><span lang=EN-US>ADF Mobile Client Demo on YouTube: <a
href="http://www.youtube.com/watch?v=6LvUDCbCKQg">http://www.youtube.com/watch?v=6LvUDCbCKQg</a>
</span><o:p></o:p></p>
<p><span lang=EN-US> </span><o:p></o:p></p>
<p><span lang=EN-US> </span><o:p></o:p></p>
<p><span lang=EN-US>-----Original Message-----<br>
From: Brian Fry <br>
Sent: Wednesday, March 17, 2010 6:01 PM<br>
To: Sandra Whitman; Joe Huang<br>
Cc: Luis Paolini; Fernando Targa; Kent Rollins; Dave Segleau; Sleepycat
Software Support; George Feinberg; <a
href="mailto:bdb-beta-feedback@oss.oracle.com">bdb-beta-feedback@oss.oracle.com</a><br>
Subject: Re: [BDB 11gR2 Beta] [#18298] First Questions about DBD 11gR2 </span><o:p></o:p></p>
<p><span lang=EN-US> </span><o:p></o:p></p>
<p><span lang=EN-US>Joe -- </span><o:p></o:p></p>
<p><span lang=EN-US> </span><o:p></o:p></p>
<p><span lang=EN-US>I remember you had pointed to some instructions for
connecting to </span><o:p></o:p></p>
<p><span lang=EN-US>SQLite. Could you share that? </span><o:p></o:p></p>
<p><span lang=EN-US> </span><o:p></o:p></p>
<p><span lang=EN-US>Luis -- </span><o:p></o:p></p>
<p><span lang=EN-US> </span><o:p></o:p></p>
<p><span lang=EN-US>FYI, in some of our initial testing we've run into some
roadblocks with </span><o:p></o:p></p>
<p><span lang=EN-US>ADF BC design time wizards and SQLite. We've logged some
bugs, but it's </span><o:p></o:p></p>
<p><span lang=EN-US>not clear if there are workarounds in the mean time. </span><o:p></o:p></p>
<p><span lang=EN-US> </span><o:p></o:p></p>
<p><span lang=EN-US>-- Brian </span><o:p></o:p></p>
<p><span lang=EN-US> </span><o:p></o:p></p>
<p><span lang=EN-US> </span><o:p></o:p></p>
<p><span lang=EN-US>On 3/17/2010 12:04 PM, Sandra Whitman wrote: </span><o:p></o:p></p>
<p><span lang=EN-US>> Hi Brian, Luis, </span><o:p></o:p></p>
<p><span lang=EN-US>> </span><o:p></o:p></p>
<p><span lang=EN-US>> Has there been any progress on this issue? </span><o:p></o:p></p>
<p><span lang=EN-US>> </span><o:p></o:p></p>
<p><span lang=EN-US>> Brian, </span><o:p></o:p></p>
<p><span lang=EN-US>> </span><o:p></o:p></p>
<p><span lang=EN-US>> You had mentioned in a previous email that any SQL92
database was </span><o:p></o:p></p>
<p><span lang=EN-US>> generally supported with a JDBC driver, but since this
was not </span><o:p></o:p></p>
<p><span lang=EN-US>> certified, that bugs may exist. Do you think Luis is
encountering one </span><o:p></o:p></p>
<p><span lang=EN-US>> of those scenarios, and a bug needs to be logged? Or
do you think </span><o:p></o:p></p>
<p><span lang=EN-US>> something else is preventing the connection to SQLite
using a JDBC </span><o:p></o:p></p>
<p><span lang=EN-US>> driver from a JDeveloper Application? </span><o:p></o:p></p>
<p><span lang=EN-US>> </span><o:p></o:p></p>
<p><span lang=EN-US>> </span><o:p></o:p></p>
<p><span lang=EN-US>> Thank you, </span><o:p></o:p></p>
<p><span lang=EN-US>> Sandra </span><o:p></o:p></p>
<p><span lang=EN-US>> </span><o:p></o:p></p>
<p><span lang=EN-US>> </span><o:p></o:p></p>
<p><span lang=EN-US>> </span><o:p></o:p></p>
<p><span lang=EN-US>> </span><o:p></o:p></p>
<p><span lang=EN-US>> </span><o:p></o:p></p>
<p><span lang=EN-US>> </span><o:p></o:p></p>
<p><span lang=EN-US>> </span><o:p></o:p></p>
<p><span lang=EN-US>> Luis Paolini wrote: </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> Hi Brian, </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> Thanks for the document which describes some
gotchas working with </span><o:p></o:p></p>
<p><span lang=EN-US>>> non-Oracle databases and ADF Business components. </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> I still had no luck connecting to SQLite using
JDBC driver from a </span><o:p></o:p></p>
<p><span lang=EN-US>>> JDeveloper Application. </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> I tried to create a database connection using two
different approaches. </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> The first one, using Database Navigator, as
described in the document </span><o:p></o:p></p>
<p><span lang=EN-US>>> you sent to me. </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> The Second one, I just create a POJO to connect to
SQLite. </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> public Connection getConnection(){ </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> Connection conn = null; </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> SQLite.Database db = null; </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> try { </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> Class.forName("SQLite.JDBCDriver").newInstance();
</span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> conn = </span><o:p></o:p></p>
<p><span lang=EN-US>>>
(Connection)DriverManager.getConnection("jdbc:sqlite:/D:/Downloads/Oracle/Berkeley_Beta/db-5.0.11/db-5.0.11/build_windows/Win32/Debug/test.db");
</span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> java.lang.reflect.Method m = </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>>
conn.getClass().getMethod("getSQLiteDatabase", null); </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> db = (SQLite.Database) m.invoke(conn, null); </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> } catch (Exception e) { </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> e.printStackTrace(); </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> } </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> return conn; </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> } </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> Error Message: </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> Unable to load sqlite_jni:
java.lang.UnsatisfiedLinkError: </span><o:p></o:p></p>
<p><span lang=EN-US>>>
D:\Downloads\Oracle\Berkeley_Beta\db-5.0.11\db-5.0.11\build_windows\Win32\Debug\sqlite_jni.dll:
</span><o:p></o:p></p>
<p><span lang=EN-US>>> Can't find dependent libraries </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> Before running both cases, I did two
configurations on JDeveloper. </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> 1. Added the library sqlite.jar in the classpath </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> 2. Added the parameter </span><o:p></o:p></p>
<p><span lang=EN-US>>>
-Djava.library.path=D:\Downloads\Oracle\Berkeley_Beta\db-5.0.11\db-5.0.11\build_windows\Win32\Debug
</span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> in the Launch Setting (Java Options). </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> I’m running JDeveloper 11.1.1.2.0 </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> Regards, </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> Luis </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> -----Original Message----- </span><o:p></o:p></p>
<p><span lang=EN-US>>> From: Brian Fry [<a
href="mailto:brian.fry@oracle.com">mailto:brian.fry@oracle.com</a>] </span><o:p></o:p></p>
<p><span lang=EN-US>>> Sent: sexta-feira, 5 de março de 2010 19:00 </span><o:p></o:p></p>
<p><span lang=EN-US>>> To: Sandra Whitman </span><o:p></o:p></p>
<p><span lang=EN-US>>> Cc: Luis Paolini; 'George Feinberg'; 'Dave
Segleau'; 'Kent Rollins'; </span><o:p></o:p></p>
<p><span lang=EN-US>>> 'Fernando Targa'; 'Sleepycat Software Support'; </span><o:p></o:p></p>
<p><span lang=EN-US>>> <a href="mailto:bdb-beta-feedback@oss.oracle.com">bdb-beta-feedback@oss.oracle.com</a>
</span><o:p></o:p></p>
<p><span lang=EN-US>>> Subject: Re: [BDB 11gR2 Beta] [#18298] First
Questions about DBD 11gR2 </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> SQLite is not tested (certified) in the currently
available release. </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> However, we generally support any SQL92 database
with a JDBC driver. </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> Since it has not been certified, there may be bugs
that we don't know </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> about. If you encounter bugs, I can work with you
to get them logged so </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> our engineers can work on them. </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> Can you confirm which JDeveloper version you are
using (Help > About)? </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> You may also want to refer to this document which
describes some gotchas </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> working with non-Oracle databases and ADF Business
components: </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> <a
href="http://www.oracle.com/technology/products/jdev/11/how-tos/multidatabaseapp.html">http://www.oracle.com/technology/products/jdev/11/how-tos/multidatabaseapp.html</a>
</span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> -- Brian </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> On 3/5/2010 5:44 AM, Sandra Whitman wrote: </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> > </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> > Thank you for the update Luis, </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> > </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> > I'll check into the data types. As for the
ADF question, we are still </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> > investigating what is supported. Perhaps
someone else on the email </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> > list will have more information on that. </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> > </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> > Best Regards, </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> > Sandra </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> > </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> > Luis Paolini wrote: </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> Hi Sandra, </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> Now that SQLite is ok, I took some time
to play with some SQL </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> Statements in order </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> to create tables that I could use in my
ADF Project. </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> I have a question about the way that
SQLite handles datatypes. </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> In some tables I need to create date and
timestamp columns. I </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> learnt that SQLite does not </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> have a specific datatype to store this
type of information, but a </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> function can be used </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> to define the format for storage. I'll
look for information about </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> this process but if have some </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> please send to me. </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> I also tried to use the SQLite jdbc.jar
to configure a </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> JDeveloper JDBC connection to SQLite but </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> is not working. </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> This is what I did: </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> 1. Create a new ADF Desktop Application. </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> 2. In the Model project, start the wizard
to create Business </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> components from Tables. </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> 3. Click to create a new connection </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> 4. In the connection type select Generic
JDBC </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> 5. Create a new Driver Class using SQLite
jdbc.jar </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> 6. Creat a URL pointing to test database,
but the test </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> connection fails. </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> Could you help me on these steps? </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> Regards, </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> Luis </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> -----Original Message----- </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> From: Sandra Whitman [<a
href="mailto:sandra.whitman@oracle.com">mailto:sandra.whitman@oracle.com</a>] </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> Sent: quarta-feira, 3 de março de 2010
17:23 </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> To: Luis Paolini </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> Cc: 'George Feinberg'; 'Dave Segleau';
'Kent Rollins'; 'Fernando </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> Targa'; 'Sleepycat Software Support'; </span><o:p></o:p></p>
<p><span lang=EN-US>>> <a href="mailto:bdb-beta-feedback@oss.oracle.com">bdb-beta-feedback@oss.oracle.com</a>
</span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> Subject: Re: [BDB 11gR2 Beta] [#18298]
First Questions about DBD </span><o:p></o:p></p>
<p><span lang=EN-US>>> 11gR2 </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> Hi Luis, </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> I just wanted to follow up and see how
you are doing. Are you able to </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> SQLite with an ADF project? </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> Thanks, </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> Sandra </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> Luis Paolini wrote: </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> > </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> > George, </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> > </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> > </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> > </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> > As you suggested, I executed some
SQL statements from </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> > the SQLITE console and looks like
that everything is fine. </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> > </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> > The test.db file was created and the
test.db-jornal </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> > directory was populated with a few
files (_db.001 to _db.006, </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> > _db.register and log.0000000001). </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> > </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> > So, am I good to go? </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> > </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> > Now, I will create some tables and
try to use them in </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> > a ADF project, creating business
components based on them. </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> > </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> > </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> > </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> > Regards, </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> > </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> > </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> > </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> > Luis </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> > </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> > </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> > </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> > </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> > </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> > *From:* George Feinberg [<a
href="mailto:george.feinberg@oracle.com">mailto:george.feinberg@oracle.com</a>]
</span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> <a
href="mailto:%5Bmailto:george.feinberg@oracle.com%5D"><mailto:%5Bmailto:george.feinberg@oracle.com%5D></a>
</span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> > *Sent:* domingo, 28 de fevereiro de
2010 10:47 </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> > *To:* Luis Paolini </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> > *Cc:* 'Fernando Targa'; 'Kent
Rollins'; 'Dave Segleau'; 'Sleepycat </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> > Software Support'; <a
href="mailto:bdb-beta-feedback@oss.oracle.com">bdb-beta-feedback@oss.oracle.com</a>
</span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> <a
href="mailto:bdb-beta-feedback@oss.oracle.com"><mailto:bdb-beta-feedback@oss.oracle.com></a>;
'Sandra Whitman' </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> > *Subject:* Re: [BDB 11gR2 Beta]
[#18298] First Questions about DBD </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> 11gR2 </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> > </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> > </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> > </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> > Luis, </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> > </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> > </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> > </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> > Have you had any luck executing SQL
from the test? </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> > </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> > If it builds successfully it should
work and it appears that it </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> > </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> > it partially there. A test.db file
should have been created </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> > </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> > as well as the test-db-journal
directory. </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> > </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> > </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> > </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> > Regards, </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> > </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> > George </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> > </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> > </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> > </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> > On Feb 26, 2010, at 6:57 AM, Luis
Paolini wrote: </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> > </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> > </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> > </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> > Hi George, </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> > </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> > </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> > </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> > I followed your instructions and had
success building </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> > the db library, db_sql and
db_sql_jdbc projects, but when I </span><o:p></o:p></p>
<p><span lang=EN-US>>> executed </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> > </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> > the command for test in
build_windows/Win32/Debug I got a SQLITE </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> > prompt and the test.db-journal
directory was created but it is </span><o:p></o:p></p>
<p><span lang=EN-US>>> empty. </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> > </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> > Should I execute any command on
SQLITE prompt? </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> > </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> > See below the files created in </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> > build_windows\Win32\Debug directory.
</span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> > </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> > </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> > </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> > <image001.png> </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> > </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> > </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> > </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> > Regards, </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> > </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> > </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> > </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> > Luis </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> > </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> > </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> > </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> > </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> > </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> > __________ Information from ESET
NOD32 Antivirus, version of virus </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> > signature database 4904 (20100301)
__________ </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> > </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> > The message was checked by ESET
NOD32 Antivirus. </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> > </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> > <a href="http://www.eset.com">http://www.eset.com</a>
</span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> > </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> > </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> > </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> > __________ Information from ESET
NOD32 Antivirus, version of virus </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> > signature database 4904 (20100301)
__________ </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> > </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> > The message was checked by ESET
NOD32 Antivirus. </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> > </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> > <a href="http://www.eset.com">http://www.eset.com</a>
</span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> > </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> </span><o:p></o:p></p>
<p><span lang=EN-US>>>
------------------------------------------------------------------------ </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> > </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> >
_______________________________________________ </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> > BDB-BETA-FEEDBACK mailing list </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> > <a
href="mailto:BDB-BETA-FEEDBACK@oss.oracle.com">BDB-BETA-FEEDBACK@oss.oracle.com</a>
</span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> <a
href="mailto:BDB-BETA-FEEDBACK@oss.oracle.com"><mailto:BDB-BETA-FEEDBACK@oss.oracle.com></a>
</span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> > <a
href="http://oss.oracle.com/mailman/listinfo/bdb-beta-feedback">http://oss.oracle.com/mailman/listinfo/bdb-beta-feedback</a>
</span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> __________ Information from ESET NOD32
Antivirus, version of virus </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> signature database 4913 (20100303)
__________ </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> The message was checked by ESET NOD32
Antivirus. </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> <a href="http://www.eset.com">http://www.eset.com</a>
</span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> __________ Information from ESET NOD32
Antivirus, version of virus </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> signature database 4917 (20100305)
__________ </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> The message was checked by ESET NOD32
Antivirus. </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> <a href="http://www.eset.com">http://www.eset.com</a>
</span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> __________ Information from ESET NOD32
Antivirus, version of virus </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> signature database 4917 (20100305)
__________ </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> The message was checked by ESET NOD32
Antivirus. </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> >> <a href="http://www.eset.com">http://www.eset.com</a>
</span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> __________ Information from ESET NOD32 Antivirus,
version of virus </span><o:p></o:p></p>
<p><span lang=EN-US>>> signature database 4919 (20100305) __________ </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> The message was checked by ESET NOD32 Antivirus. </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> <a href="http://www.eset.com">http://www.eset.com</a>
</span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> __________ Information from ESET NOD32 Antivirus,
version of virus </span><o:p></o:p></p>
<p><span lang=EN-US>>> signature database 4944 (20100314) __________ </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> The message was checked by ESET NOD32 Antivirus. </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> <a href="http://www.eset.com">http://www.eset.com</a>
</span><o:p></o:p></p>
<p><span lang=EN-US>>>
------------------------------------------------------------------------ </span><o:p></o:p></p>
<p><span lang=EN-US>>> </span><o:p></o:p></p>
<p><span lang=EN-US>>> _______________________________________________ </span><o:p></o:p></p>
<p><span lang=EN-US>>> BDB-BETA-FEEDBACK mailing list </span><o:p></o:p></p>
<p><span lang=EN-US>>> <a href="mailto:BDB-BETA-FEEDBACK@oss.oracle.com">BDB-BETA-FEEDBACK@oss.oracle.com</a>
</span><o:p></o:p></p>
<p><span lang=EN-US>>> <a
href="http://oss.oracle.com/mailman/listinfo/bdb-beta-feedback">http://oss.oracle.com/mailman/listinfo/bdb-beta-feedback</a>
</span><o:p></o:p></p>
<p><span lang=EN-US> </span><o:p></o:p></p>
</div>
<p class=MsoNormal><br>
<br>
__________ Information from ESET NOD32 Antivirus, version of virus signature
database 4957 (20100319) __________<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 4962 (20100321) __________<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>