[BDB 11gR2 Beta] [#18298] First Questions about DBD 11gR2
Luis Paolini
git at gempi.com.br
Fri Mar 5 05:40:28 PST 2010
Hi Sandra,
Now that SQLite is ok, I took some time to play with some SQL
Statements in order
to create tables that I could use in my ADF Project.
I have a question about the way that SQLite handles datatypes.
In some tables I need to create date and timestamp columns. I learnt
that SQLite does not
have a specific datatype to store this type of information, but a function
can be used
to define the format for storage. I'll look for information about this
process but if have some
please send to me.
I also tried to use the SQLite jdbc.jar to configure a JDeveloper JDBC
connection to SQLite but
is not working.
This is what I did:
1. Create a new ADF Desktop Application.
2. In the Model project, start the wizard to create Business
components from Tables.
3. Click to create a new connection
4. In the connection type select Generic JDBC
5. Create a new Driver Class using SQLite jdbc.jar
6. Creat a URL pointing to test database, but the test connection
fails.
Could you help me on these steps?
Regards,
Luis
-----Original Message-----
From: Sandra Whitman [mailto:sandra.whitman at oracle.com]
Sent: quarta-feira, 3 de março de 2010 17:23
To: Luis Paolini
Cc: 'George Feinberg'; 'Dave Segleau'; 'Kent Rollins'; 'Fernando Targa';
'Sleepycat Software Support'; bdb-beta-feedback at oss.oracle.com
Subject: Re: [BDB 11gR2 Beta] [#18298] First Questions about DBD 11gR2
Hi Luis,
I just wanted to follow up and see how you are doing. Are you able to
SQLite with an ADF project?
Thanks,
Sandra
Luis Paolini wrote:
>
> George,
>
>
>
> As you suggested, I executed some SQL statements from
> the SQLITE console and looks like that everything is fine.
>
> The test.db file was created and the test.db-jornal
> directory was populated with a few files (_db.001 to _db.006,
> _db.register and log.0000000001).
>
> So, am I good to go?
>
> Now, I will create some tables and try to use them in
> a ADF project, creating business components based on them.
>
>
>
> Regards,
>
>
>
> Luis
>
>
>
>
>
> *From:* George Feinberg <mailto:[mailto:george.feinberg at oracle.com]>
[mailto:george.feinberg at oracle.com]
> *Sent:* domingo, 28 de fevereiro de 2010 10:47
> *To:* Luis Paolini
> *Cc:* 'Fernando Targa'; 'Kent Rollins'; 'Dave Segleau'; 'Sleepycat
> Software Support'; <mailto:bdb-beta-feedback at oss.oracle.com>
bdb-beta-feedback at oss.oracle.com; 'Sandra Whitman'
> *Subject:* Re: [BDB 11gR2 Beta] [#18298] First Questions about DBD 11gR2
>
>
>
> Luis,
>
>
>
> Have you had any luck executing SQL from the test?
>
> If it builds successfully it should work and it appears that it
>
> it partially there. A test.db file should have been created
>
> as well as the test-db-journal directory.
>
>
>
> Regards,
>
> George
>
>
>
> On Feb 26, 2010, at 6:57 AM, Luis Paolini wrote:
>
>
>
> Hi George,
>
>
>
> I followed your instructions and had success building
> the db library, db_sql and db_sql_jdbc projects, but when I executed
>
> the command for test in build_windows/Win32/Debug I got a SQLITE
> prompt and the test.db-journal directory was created but it is empty.
>
> Should I execute any command on SQLITE prompt?
>
> See below the files created in
> build_windows\Win32\Debug directory.
>
>
>
> <image001.png>
>
>
>
> Regards,
>
>
>
> Luis
>
>
>
>
>
> __________ Information from ESET NOD32 Antivirus, version of virus
> signature database 4904 (20100301) __________
>
> The message was checked by ESET NOD32 Antivirus.
>
> <http://www.eset.com> http://www.eset.com
>
>
>
> __________ Information from ESET NOD32 Antivirus, version of virus
> signature database 4904 (20100301) __________
>
> The message was checked by ESET NOD32 Antivirus.
>
> <http://www.eset.com> http://www.eset.com
> ------------------------------------------------------------------------
>
> _______________________________________________
> BDB-BETA-FEEDBACK mailing list
> <mailto:BDB-BETA-FEEDBACK at oss.oracle.com>
BDB-BETA-FEEDBACK at oss.oracle.com
> <http://oss.oracle.com/mailman/listinfo/bdb-beta-feedback>
http://oss.oracle.com/mailman/listinfo/bdb-beta-feedback
__________ Information from ESET NOD32 Antivirus, version of virus signature
database 4913 (20100303) __________
The message was checked by ESET NOD32 Antivirus.
<http://www.eset.com> http://www.eset.com
__________ Information from ESET NOD32 Antivirus, version of virus signature
database 4917 (20100305) __________
The message was checked by ESET NOD32 Antivirus.
http://www.eset.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://oss.oracle.com/pipermail/bdb-beta-feedback/attachments/20100305/e676f89a/attachment-0001.html
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: image/png
Size: 62992 bytes
Desc: not available
Url : http://oss.oracle.com/pipermail/bdb-beta-feedback/attachments/20100305/e676f89a/attachment-0005.png
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: image/png
Size: 41433 bytes
Desc: not available
Url : http://oss.oracle.com/pipermail/bdb-beta-feedback/attachments/20100305/e676f89a/attachment-0006.png
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: image/png
Size: 51608 bytes
Desc: not available
Url : http://oss.oracle.com/pipermail/bdb-beta-feedback/attachments/20100305/e676f89a/attachment-0007.png
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: image/png
Size: 24711 bytes
Desc: not available
Url : http://oss.oracle.com/pipermail/bdb-beta-feedback/attachments/20100305/e676f89a/attachment-0008.png
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: image/png
Size: 54596 bytes
Desc: not available
Url : http://oss.oracle.com/pipermail/bdb-beta-feedback/attachments/20100305/e676f89a/attachment-0009.png
More information about the BDB-BETA-FEEDBACK
mailing list