[BDB 11gR2 Beta] [#18298] First Questions about DBD 11gR2
Brian Fry
brian.fry at oracle.com
Fri Mar 5 13:59:44 PST 2010
SQLite is not tested (certified) in the currently available release.
However, we generally support any SQL92 database with a JDBC driver.
Since it has not been certified, there may be bugs that we don't know
about. If you encounter bugs, I can work with you to get them logged so
our engineers can work on them.
Can you confirm which JDeveloper version you are using (Help > About)?
You may also want to refer to this document which describes some gotchas
working with non-Oracle databases and ADF Business components:
http://www.oracle.com/technology/products/jdev/11/how-tos/multidatabaseapp.html
-- Brian
On 3/5/2010 5:44 AM, Sandra Whitman wrote:
>
> Thank you for the update Luis,
>
> I'll check into the data types. As for the ADF question, we are still
> investigating what is supported. Perhaps someone else on the email
> list will have more information on that.
>
> Best Regards,
> Sandra
>
> Luis Paolini wrote:
>>
>> 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:george.feinberg at oracle.com]
>> <mailto:%5Bmailto:george.feinberg at oracle.com%5D>
>>
>> > *Sent:* domingo, 28 de fevereiro de 2010 10:47
>>
>> > *To:* Luis Paolini
>>
>> > *Cc:* 'Fernando Targa'; 'Kent Rollins'; 'Dave Segleau'; 'Sleepycat
>>
>> > Software Support'; bdb-beta-feedback at oss.oracle.com
>> <mailto: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
>>
>> >
>> >
>> >
>> > __________ Information from ESET NOD32 Antivirus, version of virus
>>
>> > signature database 4904 (20100301) __________
>>
>> >
>> > The message was checked by ESET NOD32 Antivirus.
>>
>> >
>> > http://www.eset.com
>>
>> >
>> ------------------------------------------------------------------------
>>
>> >
>> > _______________________________________________
>>
>> > BDB-BETA-FEEDBACK mailing list
>>
>> > BDB-BETA-FEEDBACK at oss.oracle.com
>> <mailto:BDB-BETA-FEEDBACK at oss.oracle.com>
>>
>> > 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
>>
>>
>>
>>
>>
>>
>>
>>
>>
>> __________ Information from ESET NOD32 Antivirus, version of virus
>> signature database 4917 (20100305) __________
>>
>>
>>
>> The message was checked by ESET NOD32 Antivirus.
>>
>>
>>
>> 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
More information about the BDB-BETA-FEEDBACK
mailing list