[BDB 11gR2 Beta] [#18298] First Questions about DBD 11gR2

[Brian Fry]

Yes, he should be able to create a connection to SQLite from JDev.

I have to admit not knowing a lot about the capabilities of SQLite, but 
you should be able to create a connection to any third party database 
with a JDBC driver. The best reference is the help topic in Jdev called 
"Connecting to Non-Oracle Databases". SQLite is not specifically 
documented, since we don't yet certify with it, but the general steps 
should be the same as with any of the other DBs that are documented:




To connect to a non-Oracle database, you must perform the series of 
tasks described here.

Creating a database connection:
Create a library containing the JDBC drivers.
Create a database connection.
In the Create Database Connection dialog, enter the appropriate values 
for the database.
Finally, you must configure your projects to use the correct data types.


-- Brian


On 3/5/2010 5:48 AM, Sandra Whitman wrote:
> Hi Brian,  Kent,
>
> Does what Luis is doing look like it should work?
>
> Thanks,
> 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