<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;}
@font-face
{font-family:Consolas;
panose-1:2 11 6 9 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p.MsoPlainText, li.MsoPlainText, div.MsoPlainText
{mso-style-priority:99;
mso-style-link:"Plain Text Char";
margin:0cm;
margin-bottom:.0001pt;
font-size:10.5pt;
font-family:Consolas;}
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";}
span.PlainTextChar
{mso-style-name:"Plain Text Char";
mso-style-priority:99;
mso-style-link:"Plain Text";
font-family:Consolas;}
span.BalloonTextChar
{mso-style-name:"Balloon Text Char";
mso-style-priority:99;
mso-style-link:"Balloon Text";
font-family:"Tahoma","sans-serif";}
.MsoChpDefault
{mso-style-type:export-only;}
@page Section1
{size:612.0pt 792.0pt;
margin:70.85pt 3.0cm 70.85pt 3.0cm;}
div.Section1
{page:Section1;}
-->
</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 lang=PT-BR link=blue vlink=purple>
<div class=Section1>
<p class=MsoPlainText><span lang=EN-US>Hi Sandra,<o:p></o:p></span></p>
<p class=MsoPlainText><span lang=EN-US><o:p> </o:p></span></p>
<p class=MsoPlainText><span lang=EN-US> Now that SQLite is ok, I took some
time to play with some SQL Statements in order<o:p></o:p></span></p>
<p class=MsoPlainText><span lang=EN-US>to create tables that I could use in my
ADF Project.<o:p></o:p></span></p>
<p class=MsoPlainText><span lang=EN-US> I have a question about the way
that SQLite handles datatypes.<o:p></o:p></span></p>
<p class=MsoPlainText><span lang=EN-US> In some tables I need to create
date and timestamp columns. I learnt that SQLite does not<o:p></o:p></span></p>
<p class=MsoPlainText><span lang=EN-US>have a specific datatype to store this
type of information, but a function can be used<o:p></o:p></span></p>
<p class=MsoPlainText><span lang=EN-US>to define the format for storage. I'll
look for information about this process but if have some<o:p></o:p></span></p>
<p class=MsoPlainText><span lang=EN-US>please send to me.<o:p></o:p></span></p>
<p class=MsoPlainText><span lang=EN-US> I also tried to use the SQLite jdbc.jar
to configure a JDeveloper JDBC connection to SQLite but<o:p></o:p></span></p>
<p class=MsoPlainText><span lang=EN-US>is not working.<o:p></o:p></span></p>
<p class=MsoPlainText><span lang=EN-US> This is what I did:<o:p></o:p></span></p>
<p class=MsoPlainText><span lang=EN-US><o:p> </o:p></span></p>
<p class=MsoPlainText><span lang=EN-US> 1. Create a new ADF Desktop Application.<o:p></o:p></span></p>
<p class=MsoPlainText><span lang=EN-US> 2. In the Model project, start the
wizard to create Business components from Tables.<o:p></o:p></span></p>
<p class=MsoPlainText><span lang=EN-US> </span><img width=698 height=498
id="Picture_x0020_1" src="cid:image001.png@01CABC4F.3B492C90"><span lang=EN-US><o:p></o:p></span></p>
<p class=MsoPlainText><span lang=EN-US><o:p> </o:p></span></p>
<p class=MsoPlainText><span lang=EN-US> 3. Click to create a new
connection<o:p></o:p></span></p>
<p class=MsoPlainText><span lang=EN-US><o:p> </o:p></span></p>
<p class=MsoPlainText><span lang=EN-US> </span><img width=638 height=404
id="Picture_x0020_2" src="cid:image002.png@01CABC4F.3B492C90"><span lang=EN-US><o:p></o:p></span></p>
<p class=MsoPlainText><span lang=EN-US><o:p> </o:p></span></p>
<p class=MsoPlainText><span lang=EN-US> 4. In the connection type select
Generic JDBC<o:p></o:p></span></p>
<p class=MsoPlainText><span lang=EN-US><o:p> </o:p></span></p>
<p class=MsoPlainText><span lang=EN-US> </span><img width=558 height=558
id="Picture_x0020_4" src="cid:image003.png@01CABC4F.A0EF0E20"><span lang=EN-US><o:p></o:p></span></p>
<p class=MsoPlainText><span lang=EN-US> <o:p></o:p></span></p>
<p class=MsoPlainText><span lang=EN-US> 5. Create a new Driver Class using
SQLite jdbc.jar<o:p></o:p></span></p>
<p class=MsoPlainText><span lang=EN-US><o:p> </o:p></span></p>
<p class=MsoPlainText><span lang=EN-US> </span><img width=572 height=160
id="Picture_x0020_5" src="cid:image004.png@01CABC4F.A0EF0E20"><span lang=EN-US><o:p></o:p></span></p>
<p class=MsoPlainText><span lang=EN-US><o:p> </o:p></span></p>
<p class=MsoPlainText><span lang=EN-US> 6. Creat a URL pointing to test
database, but the test connection fails.<o:p></o:p></span></p>
<p class=MsoPlainText><span lang=EN-US><o:p> </o:p></span></p>
<p class=MsoPlainText><span lang=EN-US> </span><img width=561 height=559
id="Picture_x0020_6" src="cid:image005.png@01CABC50.455B5720"><span lang=EN-US><o:p></o:p></span></p>
<p class=MsoPlainText><span lang=EN-US> <o:p></o:p></span></p>
<p class=MsoPlainText><span lang=EN-US> Could you help me on these steps?<o:p></o:p></span></p>
<p class=MsoPlainText><span lang=EN-US><o:p> </o:p></span></p>
<p class=MsoPlainText><span lang=EN-US>Regards,<o:p></o:p></span></p>
<p class=MsoPlainText><span lang=EN-US><o:p> </o:p></span></p>
<p class=MsoPlainText><span lang=EN-US>Luis<o:p></o:p></span></p>
<p class=MsoPlainText><span lang=EN-US><o:p> </o:p></span></p>
<p class=MsoPlainText><span lang=EN-US>-----Original Message-----<o:p></o:p></span></p>
<p class=MsoPlainText><span lang=EN-US>From: Sandra Whitman
[mailto:sandra.whitman@oracle.com] <o:p></o:p></span></p>
<p class=MsoPlainText>Sent: quarta-feira, 3 de março de 2010 17:23<o:p></o:p></p>
<p class=MsoPlainText><span lang=EN-US>To: Luis Paolini<o:p></o:p></span></p>
<p class=MsoPlainText><span lang=EN-US>Cc: 'George Feinberg'; 'Dave Segleau';
'Kent Rollins'; 'Fernando Targa'; 'Sleepycat Software Support';
bdb-beta-feedback@oss.oracle.com<o:p></o:p></span></p>
<p class=MsoPlainText><span lang=EN-US>Subject: Re: [BDB 11gR2 Beta] [#18298]
First Questions about DBD 11gR2<o:p></o:p></span></p>
<p class=MsoPlainText><span lang=EN-US><o:p> </o:p></span></p>
<p class=MsoPlainText><span lang=EN-US>Hi Luis,<o:p></o:p></span></p>
<p class=MsoPlainText><span lang=EN-US><o:p> </o:p></span></p>
<p class=MsoPlainText><span lang=EN-US>I just wanted to follow up and see how
you are doing. Are you able to <o:p></o:p></span></p>
<p class=MsoPlainText><span lang=EN-US>SQLite with an ADF project? <o:p></o:p></span></p>
<p class=MsoPlainText><span lang=EN-US><o:p> </o:p></span></p>
<p class=MsoPlainText><span lang=EN-US>Thanks,<o:p></o:p></span></p>
<p class=MsoPlainText><span lang=EN-US>Sandra<o:p></o:p></span></p>
<p class=MsoPlainText><span lang=EN-US><o:p> </o:p></span></p>
<p class=MsoPlainText><span lang=EN-US>Luis Paolini wrote:<o:p></o:p></span></p>
<p class=MsoPlainText><span lang=EN-US>><o:p> </o:p></span></p>
<p class=MsoPlainText><span lang=EN-US>> George,<o:p></o:p></span></p>
<p class=MsoPlainText><span lang=EN-US>><o:p> </o:p></span></p>
<p class=MsoPlainText><span lang=EN-US>> <o:p></o:p></span></p>
<p class=MsoPlainText><span lang=EN-US>><o:p> </o:p></span></p>
<p class=MsoPlainText><span lang=EN-US>> As you suggested, I
executed some SQL statements from <o:p></o:p></span></p>
<p class=MsoPlainText><span lang=EN-US>> the SQLITE console and looks like
that everything is fine.<o:p></o:p></span></p>
<p class=MsoPlainText><span lang=EN-US>><o:p> </o:p></span></p>
<p class=MsoPlainText><span lang=EN-US>> The test.db file
was created and the test.db-jornal <o:p></o:p></span></p>
<p class=MsoPlainText><span lang=EN-US>> directory was populated with a few
files (_db.001 to _db.006, <o:p></o:p></span></p>
<p class=MsoPlainText><span lang=EN-US>> _db.register and log.0000000001).<o:p></o:p></span></p>
<p class=MsoPlainText><span lang=EN-US>><o:p> </o:p></span></p>
<p class=MsoPlainText><span lang=EN-US>> So, am I good to
go?<o:p></o:p></span></p>
<p class=MsoPlainText><span lang=EN-US>><o:p> </o:p></span></p>
<p class=MsoPlainText><span lang=EN-US>> Now, I will create
some tables and try to use them in <o:p></o:p></span></p>
<p class=MsoPlainText><span lang=EN-US>> a ADF project, creating business
components based on them.<o:p></o:p></span></p>
<p class=MsoPlainText><span lang=EN-US>><o:p> </o:p></span></p>
<p class=MsoPlainText><span lang=EN-US>> <o:p></o:p></span></p>
<p class=MsoPlainText><span lang=EN-US>><o:p> </o:p></span></p>
<p class=MsoPlainText><span lang=EN-US>> Regards,<o:p></o:p></span></p>
<p class=MsoPlainText><span lang=EN-US>><o:p> </o:p></span></p>
<p class=MsoPlainText><span lang=EN-US>> <o:p></o:p></span></p>
<p class=MsoPlainText><span lang=EN-US>><o:p> </o:p></span></p>
<p class=MsoPlainText><span lang=EN-US>> Luis<o:p></o:p></span></p>
<p class=MsoPlainText><span lang=EN-US>><o:p> </o:p></span></p>
<p class=MsoPlainText><span lang=EN-US>> <o:p></o:p></span></p>
<p class=MsoPlainText><span lang=EN-US>><o:p> </o:p></span></p>
<p class=MsoPlainText><span lang=EN-US>> <o:p></o:p></span></p>
<p class=MsoPlainText><span lang=EN-US>><o:p> </o:p></span></p>
<p class=MsoPlainText><span lang=EN-US>> *From:* George Feinberg </span><a
href="mailto:[mailto:george.feinberg@oracle.com]"><span lang=EN-US>[mailto:george.feinberg@oracle.com]</span></a><span
lang=EN-US><o:p></o:p></span></p>
<p class=MsoPlainText>> *Sent:* domingo, 28 de fevereiro de 2010 10:47<o:p></o:p></p>
<p class=MsoPlainText><span lang=EN-US>> *To:* Luis Paolini<o:p></o:p></span></p>
<p class=MsoPlainText><span lang=EN-US>> *Cc:* 'Fernando Targa'; 'Kent
Rollins'; 'Dave Segleau'; 'Sleepycat <o:p></o:p></span></p>
<p class=MsoPlainText><span lang=EN-US>> Software Support'; </span><a
href="mailto:bdb-beta-feedback@oss.oracle.com"><span lang=EN-US>bdb-beta-feedback@oss.oracle.com</span></a><span
lang=EN-US>; 'Sandra Whitman'<o:p></o:p></span></p>
<p class=MsoPlainText><span lang=EN-US>> *Subject:* Re: [BDB 11gR2 Beta]
[#18298] First Questions about DBD 11gR2<o:p></o:p></span></p>
<p class=MsoPlainText><span lang=EN-US>><o:p> </o:p></span></p>
<p class=MsoPlainText><span lang=EN-US>> <o:p></o:p></span></p>
<p class=MsoPlainText><span lang=EN-US>><o:p> </o:p></span></p>
<p class=MsoPlainText><span lang=EN-US>> Luis,<o:p></o:p></span></p>
<p class=MsoPlainText><span lang=EN-US>><o:p> </o:p></span></p>
<p class=MsoPlainText><span lang=EN-US>> <o:p></o:p></span></p>
<p class=MsoPlainText><span lang=EN-US>><o:p> </o:p></span></p>
<p class=MsoPlainText><span lang=EN-US>> Have you had any luck executing SQL
from the test?<o:p></o:p></span></p>
<p class=MsoPlainText><span lang=EN-US>><o:p> </o:p></span></p>
<p class=MsoPlainText><span lang=EN-US>> If it builds successfully it should
work and it appears that it<o:p></o:p></span></p>
<p class=MsoPlainText><span lang=EN-US>><o:p> </o:p></span></p>
<p class=MsoPlainText><span lang=EN-US>> it partially there. A test.db file
should have been created<o:p></o:p></span></p>
<p class=MsoPlainText><span lang=EN-US>><o:p> </o:p></span></p>
<p class=MsoPlainText><span lang=EN-US>> as well as the test-db-journal
directory.<o:p></o:p></span></p>
<p class=MsoPlainText><span lang=EN-US>><o:p> </o:p></span></p>
<p class=MsoPlainText><span lang=EN-US>> <o:p></o:p></span></p>
<p class=MsoPlainText><span lang=EN-US>><o:p> </o:p></span></p>
<p class=MsoPlainText><span lang=EN-US>> Regards,<o:p></o:p></span></p>
<p class=MsoPlainText><span lang=EN-US>><o:p> </o:p></span></p>
<p class=MsoPlainText><span lang=EN-US>> George<o:p></o:p></span></p>
<p class=MsoPlainText><span lang=EN-US>><o:p> </o:p></span></p>
<p class=MsoPlainText><span lang=EN-US>> <o:p></o:p></span></p>
<p class=MsoPlainText><span lang=EN-US>><o:p> </o:p></span></p>
<p class=MsoPlainText><span lang=EN-US>> On Feb 26, 2010, at 6:57 AM, Luis
Paolini wrote:<o:p></o:p></span></p>
<p class=MsoPlainText><span lang=EN-US>><o:p> </o:p></span></p>
<p class=MsoPlainText><span lang=EN-US>><o:p> </o:p></span></p>
<p class=MsoPlainText><span lang=EN-US>><o:p> </o:p></span></p>
<p class=MsoPlainText><span lang=EN-US>> Hi George,<o:p></o:p></span></p>
<p class=MsoPlainText><span lang=EN-US>><o:p> </o:p></span></p>
<p class=MsoPlainText><span lang=EN-US>> <o:p></o:p></span></p>
<p class=MsoPlainText><span lang=EN-US>><o:p> </o:p></span></p>
<p class=MsoPlainText><span lang=EN-US>> I followed your
instructions and had success building <o:p></o:p></span></p>
<p class=MsoPlainText><span lang=EN-US>> the db library, db_sql and
db_sql_jdbc projects, but when I executed<o:p></o:p></span></p>
<p class=MsoPlainText><span lang=EN-US>><o:p> </o:p></span></p>
<p class=MsoPlainText><span lang=EN-US>> the command for test in
build_windows/Win32/Debug I got a SQLITE <o:p></o:p></span></p>
<p class=MsoPlainText><span lang=EN-US>> prompt and the test.db-journal
directory was created but it is empty.<o:p></o:p></span></p>
<p class=MsoPlainText><span lang=EN-US>><o:p> </o:p></span></p>
<p class=MsoPlainText><span lang=EN-US>> Should I execute
any command on SQLITE prompt?<o:p></o:p></span></p>
<p class=MsoPlainText><span lang=EN-US>><o:p> </o:p></span></p>
<p class=MsoPlainText><span lang=EN-US>> See below the files
created in <o:p></o:p></span></p>
<p class=MsoPlainText><span lang=EN-US>> build_windows\Win32\Debug
directory.<o:p></o:p></span></p>
<p class=MsoPlainText><span lang=EN-US>><o:p> </o:p></span></p>
<p class=MsoPlainText><span lang=EN-US>> <o:p></o:p></span></p>
<p class=MsoPlainText><span lang=EN-US>><o:p> </o:p></span></p>
<p class=MsoPlainText><span lang=EN-US>>
<image001.png><o:p></o:p></span></p>
<p class=MsoPlainText><span lang=EN-US>><o:p> </o:p></span></p>
<p class=MsoPlainText><span lang=EN-US>> <o:p></o:p></span></p>
<p class=MsoPlainText><span lang=EN-US>><o:p> </o:p></span></p>
<p class=MsoPlainText><span lang=EN-US>> Regards,<o:p></o:p></span></p>
<p class=MsoPlainText><span lang=EN-US>><o:p> </o:p></span></p>
<p class=MsoPlainText><span lang=EN-US>> <o:p></o:p></span></p>
<p class=MsoPlainText><span lang=EN-US>><o:p> </o:p></span></p>
<p class=MsoPlainText><span lang=EN-US>> Luis<o:p></o:p></span></p>
<p class=MsoPlainText><span lang=EN-US>><o:p> </o:p></span></p>
<p class=MsoPlainText><span lang=EN-US>> <o:p></o:p></span></p>
<p class=MsoPlainText><span lang=EN-US>><o:p> </o:p></span></p>
<p class=MsoPlainText><span lang=EN-US>><o:p> </o:p></span></p>
<p class=MsoPlainText><span lang=EN-US>><o:p> </o:p></span></p>
<p class=MsoPlainText><span lang=EN-US>> __________ Information from ESET
NOD32 Antivirus, version of virus <o:p></o:p></span></p>
<p class=MsoPlainText><span lang=EN-US>> signature database 4904 (20100301)
__________<o:p></o:p></span></p>
<p class=MsoPlainText><span lang=EN-US>><o:p> </o:p></span></p>
<p class=MsoPlainText><span lang=EN-US>> The message was checked by ESET
NOD32 Antivirus.<o:p></o:p></span></p>
<p class=MsoPlainText><span lang=EN-US>><o:p> </o:p></span></p>
<p class=MsoPlainText><span lang=EN-US>> </span><a href="http://www.eset.com"><span
lang=EN-US>http://www.eset.com</span></a><span lang=EN-US><o:p></o:p></span></p>
<p class=MsoPlainText><span lang=EN-US>><o:p> </o:p></span></p>
<p class=MsoPlainText><span lang=EN-US>><o:p> </o:p></span></p>
<p class=MsoPlainText><span lang=EN-US>><o:p> </o:p></span></p>
<p class=MsoPlainText><span lang=EN-US>> __________ Information from ESET
NOD32 Antivirus, version of virus <o:p></o:p></span></p>
<p class=MsoPlainText><span lang=EN-US>> signature database 4904 (20100301)
__________<o:p></o:p></span></p>
<p class=MsoPlainText><span lang=EN-US>><o:p> </o:p></span></p>
<p class=MsoPlainText><span lang=EN-US>> The message was checked by ESET
NOD32 Antivirus.<o:p></o:p></span></p>
<p class=MsoPlainText><span lang=EN-US>><o:p> </o:p></span></p>
<p class=MsoPlainText><span lang=EN-US>> </span><a href="http://www.eset.com"><span
lang=EN-US>http://www.eset.com</span></a><span lang=EN-US><o:p></o:p></span></p>
<p class=MsoPlainText><span lang=EN-US>>
------------------------------------------------------------------------<o:p></o:p></span></p>
<p class=MsoPlainText><span lang=EN-US>><o:p> </o:p></span></p>
<p class=MsoPlainText><span lang=EN-US>>
_______________________________________________<o:p></o:p></span></p>
<p class=MsoPlainText><span lang=EN-US>> BDB-BETA-FEEDBACK mailing list<o:p></o:p></span></p>
<p class=MsoPlainText><span lang=EN-US>> </span><a
href="mailto:BDB-BETA-FEEDBACK@oss.oracle.com"><span lang=EN-US>BDB-BETA-FEEDBACK@oss.oracle.com</span></a><span
lang=EN-US><o:p></o:p></span></p>
<p class=MsoPlainText><span lang=EN-US>> </span><a
href="http://oss.oracle.com/mailman/listinfo/bdb-beta-feedback"><span
lang=EN-US>http://oss.oracle.com/mailman/listinfo/bdb-beta-feedback</span></a><span
lang=EN-US><o:p></o:p></span></p>
<p class=MsoPlainText><span lang=EN-US><o:p> </o:p></span></p>
<p class=MsoPlainText><span lang=EN-US><o:p> </o:p></span></p>
<p class=MsoPlainText><span lang=EN-US>__________ Information from ESET NOD32
Antivirus, version of virus signature database 4913 (20100303) __________<o:p></o:p></span></p>
<p class=MsoPlainText><span lang=EN-US><o:p> </o:p></span></p>
<p class=MsoPlainText><span lang=EN-US>The message was checked by ESET NOD32
Antivirus.<o:p></o:p></span></p>
<p class=MsoPlainText><span lang=EN-US><o:p> </o:p></span></p>
<p class=MsoPlainText><a href="http://www.eset.com"><span lang=EN-US>http://www.eset.com</span></a><span
lang=EN-US><o:p></o:p></span></p>
<p class=MsoPlainText><span lang=EN-US><o:p> </o:p></span></p>
<p class=MsoPlainText><span lang=EN-US><o:p> </o:p></span></p>
<p class=MsoPlainText><span lang=EN-US> <o:p></o:p></span></p>
<p class=MsoPlainText><span lang=EN-US><o:p> </o:p></span></p>
<p class=MsoPlainText><span lang=EN-US>__________ Information from ESET NOD32
Antivirus, version of virus signature database 4917 (20100305) __________<o:p></o:p></span></p>
<p class=MsoPlainText><span lang=EN-US><o:p> </o:p></span></p>
<p class=MsoPlainText><span lang=EN-US>The message was checked by ESET NOD32
Antivirus.<o:p></o:p></span></p>
<p class=MsoPlainText><span lang=EN-US><o:p> </o:p></span></p>
<p class=MsoPlainText><a href="http://www.eset.com">http://www.eset.com</a><o:p></o:p></p>
<p class=MsoPlainText> <o:p></o:p></p>
</div>
<BR><BR>__________ Information from ESET NOD32 Antivirus, version of virus signature database 4917 (20100305) __________<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>