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

[Sandra Whitman]

Hi Luis,

I realized I did not get back to you on the date/time functions.  The 
SQLite documentation at: http://sqlite.org/lang.html has a section on 
Date and Time Functions at:
http://sqlite.org/lang_datefunc.html

If there is anything else, just let me know.

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