[BDB 11gR2 Beta] [#18298] First Questions about DBD 11gR2
Brian Fry
brian.fry at oracle.com
Wed Mar 24 18:22:30 PDT 2010
Luis --
I apologize for taking so long to respond. It took me a while to clear
some time in my schedule to try this out.
Try putting in dummy values for the username and password for the SQLite
connection. It seems that ADF BC doesn't like the notion of not having
database credentials.
Note also that you can have multiple connections stored for the ADF BC
configuration, so you can easily swap connections without having to edit
the connection details each time:
-- Brian
On 3/21/2010 8:27 AM, Luis Paolini wrote:
>
> Brian,
>
> I created a test application to try the workaround
> that you mentioned in the last email, but it didn't work as expected.
>
> Maybe I'm missing something.
>
> Please see below the steps I did.
>
> 1. Create the same table in Oracle XE database and in SQLite database.
>
> Oracle XE:
>
> CREATE TABLE ICATB_BANCO_FINANCEIRO
>
> (
>
> BNF_ID NUMBER(19) not null,
>
> BNF_NM VARCHAR2(100) not null,
>
> BNF_CD NUMBER(10) not null
>
> );
>
> SQLite:
>
> CREATE TABLE ICATB_BANCO_FINANCEIRO (BNF_ID INTEGER PRIMARY KEY ASC,
> BNF_NM TEXT, BNF_CD INTEGER);
>
> 2. Insert 3 records into the ICATB_BANCO_FINANCEIRO table. (In Oracle
> XE and SQLite)
>
> INSERT INTO ICATB_BANCO_FINANCEIRO(BNF_ID,BNF_NM,BNF_CD) VALUES
> (1,'Banco1',1);
>
> INSERT INTO ICATB_BANCO_FINANCEIRO(BNF_ID,BNF_NM,BNF_CD) VALUES
> (2,'Banco2',2);
>
> INSERT INTO ICATB_BANCO_FINANCEIRO(BNF_ID,BNF_NM,BNF_CD) VALUES
> (3,'Banco3',3);
>
> 3. Using JDeveloper, create a new ADF Java Desktop Application
>
> 4. Create a Database connection for Oracle XE database:
>
> 5. Using ADF BC Wizard, create an Entity Object and a View Object
> (updatable).
>
> 6. Create a Jpanel
>
> 7. Using the DataControl, drag-n-drop the 3 attributes into the jPanel.
>
> 8. Using the Datacontrol, drag-n-drop some operations into the JPanel
> (Create, Delete, Commit, First, Last, Next and Previous).
>
> 9. Run the application to check if everything is working.
>
> 10. Create a Database connection for SQLite.
>
> `
>
> 11. Edit the Model.jpx file to switch the connection to SQLite.
>
> 12. Run the Application
>
> At this point, I got an error related to the JDBC Connection.
>
> Translating the message: JBO-26061: Error opening the
> JDBC Connection.
>
> Clicking on the "Details" button I got:
>
> This is the JDev logfile:
>
> Exception in thread "main" oracle.jbo.DMLException:
> JBO-26061: Erro ao abrir a conexão JDBC.
>
> at
> oracle.jbo.server.ConnectionPool.createConnection(ConnectionPool.java:205)
>
>
> at
> oracle.jbo.server.ConnectionPool.instantiateResource(ConnectionPool.java:164)
>
>
> at
> oracle.jbo.pool.ResourcePool.createResource(ResourcePool.java:590)
>
> at
> oracle.jbo.pool.ResourcePool.useResource(ResourcePool.java:323)
>
> at
> oracle.jbo.server.ConnectionPool.getConnectionInternal(ConnectionPool.java:100)
>
>
> at
> oracle.jbo.server.ConnectionPool.getConnection(ConnectionPool.java:66)
>
> at
> oracle.jbo.server.ConnectionPoolManagerImpl.getConnection(ConnectionPoolManagerImpl.java:52)
>
>
> at
> oracle.jbo.server.URLConnectionHelper.getConnection(URLConnectionHelper.java:129)
>
>
> at
> oracle.jbo.server.DBTransactionImpl.establishNewConnection(DBTransactionImpl.java:940)
>
>
> at
> oracle.jbo.server.DBTransactionImpl.initTransaction(DBTransactionImpl.java:1108)
>
>
> at
> oracle.jbo.server.DBTransactionImpl.initTxn(DBTransactionImpl.java:6368)
>
> at
> oracle.jbo.server.DBTransactionImpl2.connect(DBTransactionImpl2.java:130)
>
> at
> oracle.jbo.common.ampool.DefaultConnectionStrategy.connect(DefaultConnectionStrategy.java:213)
>
>
> at
> oracle.jbo.server.ApplicationPoolMessageHandler.doPoolConnect(ApplicationPoolMessageHandler.java:553)
>
>
> at
> oracle.jbo.server.ApplicationPoolMessageHandler.doPoolMessage(ApplicationPoolMessageHandler.java:409)
>
>
> at
> oracle.jbo.server.ApplicationModuleImpl.doPoolMessage(ApplicationModuleImpl.java:8534)
>
>
> at
> oracle.jbo.common.ampool.ApplicationPoolImpl.sendPoolMessage(ApplicationPoolImpl.java:4392)
>
>
> at
> oracle.jbo.common.ampool.ApplicationPoolImpl.prepareApplicationModule(ApplicationPoolImpl.java:2388)
>
>
> at
> oracle.jbo.common.ampool.ApplicationPoolImpl.doCheckout(ApplicationPoolImpl.java:2204)
>
>
> at
> oracle.jbo.common.ampool.ApplicationPoolImpl.useApplicationModule(ApplicationPoolImpl.java:3088)
>
>
> at
> oracle.jbo.common.ampool.SessionCookieImpl.useApplicationModule(SessionCookieImpl.java:460)
>
>
> at
> oracle.jbo.common.ampool.SessionCookieImpl.useApplicationModule(SessionCookieImpl.java:431)
>
>
> at
> oracle.jbo.common.ampool.SessionCookieImpl.useApplicationModule(SessionCookieImpl.java:426)
>
>
> at
> oracle.adf.model.bc4j.DCJboDataControl.initializeApplicationModule(DCJboDataControl.java:513)
>
>
> at
> oracle.adf.model.bc4j.DCJboDataControl.getApplicationModule(DCJboDataControl.java:856)
>
>
> at
> oracle.adf.model.binding.DCBindingContainer.setDataControl(DCBindingContainer.java:554)
>
>
> at
> oracle.jbo.uicli.jui.JUPanelBinding.useDefaultDataControl(JUPanelBinding.java:912)
>
>
> at
> oracle.jbo.uicli.jui.JUPanelBinding.setup(JUPanelBinding.java:125)
>
> at
> oracle.jbo.uicli.controls.JUTestFrame.createBindingCtxAndSetUpMenu(JUTestFrame.java:165)
>
>
> at
> oracle.jbo.uicli.controls.JUTestFrame.<init>(JUTestFrame.java:117)
>
> at
> oracle.jbo.uicli.controls.JUTestFrame.startTestFrame(JUTestFrame.java:80)
>
> at demo.view.Panel1.main(Panel1.java:181)
>
> Caused by: java.sql.SQLException: No suitable driver found for
> jdbc:sqlite:D:\Downloads\Oracle\Berkeley_Beta\db-5.0.11\db-5.0.11\build_windows\Win32\Debug\test.db
>
>
> at
> java.sql.DriverManager.getConnection(DriverManager.java:602)
>
> at
> java.sql.DriverManager.getConnection(DriverManager.java:154)
>
> at
> oracle.jbo.server.URLConnectionHelper.getConnection(URLConnectionHelper.java:144)
>
>
> at
> oracle.jbo.server.URLConnectionHelper.getConnectionFromDriver(URLConnectionHelper.java:50)
>
>
> at
> oracle.jbo.server.ConnectionPool.createConnection(ConnectionPool.java:193)
>
>
> ... 31 more
>
> ## Detail 0 ##
>
> java.sql.SQLException: No suitable driver found for
> jdbc:sqlite:D:\Downloads\Oracle\Berkeley_Beta\db-5.0.11\db-5.0.11\build_windows\Win32\Debug\test.db
>
>
> at
> java.sql.DriverManager.getConnection(DriverManager.java:602)
>
> at
> java.sql.DriverManager.getConnection(DriverManager.java:154)
>
> at
> oracle.jbo.server.URLConnectionHelper.getConnection(URLConnectionHelper.java:144)
>
>
> at
> oracle.jbo.server.URLConnectionHelper.getConnectionFromDriver(URLConnectionHelper.java:50)
>
>
> at
> oracle.jbo.server.ConnectionPool.createConnection(ConnectionPool.java:193)
>
>
> at
> oracle.jbo.server.ConnectionPool.instantiateResource(ConnectionPool.java:164)
>
>
> at
> oracle.jbo.pool.ResourcePool.createResource(ResourcePool.java:590)
>
> at
> oracle.jbo.pool.ResourcePool.useResource(ResourcePool.java:323)
>
> at
> oracle.jbo.server.ConnectionPool.getConnectionInternal(ConnectionPool.java:100)
>
>
> at
> oracle.jbo.server.ConnectionPool.getConnection(ConnectionPool.java:66)
>
> at
> oracle.jbo.server.ConnectionPoolManagerImpl.getConnection(ConnectionPoolManagerImpl.java:52)
>
>
> at
> oracle.jbo.server.URLConnectionHelper.getConnection(URLConnectionHelper.java:129)
>
>
> at
> oracle.jbo.server.DBTransactionImpl.establishNewConnection(DBTransactionImpl.java:940)
>
>
> at
> oracle.jbo.server.DBTransactionImpl.initTransaction(DBTransactionImpl.java:1108)
>
>
> at
> oracle.jbo.server.DBTransactionImpl.initTxn(DBTransactionImpl.java:6368)
>
> at
> oracle.jbo.server.DBTransactionImpl2.connect(DBTransactionImpl2.java:130)
>
> at
> oracle.jbo.common.ampool.DefaultConnectionStrategy.connect(DefaultConnectionStrategy.java:213)
>
>
> at
> oracle.jbo.server.ApplicationPoolMessageHandler.doPoolConnect(ApplicationPoolMessageHandler.java:553)
>
>
> at
> oracle.jbo.server.ApplicationPoolMessageHandler.doPoolMessage(ApplicationPoolMessageHandler.java:409)
>
>
> at
> oracle.jbo.server.ApplicationModuleImpl.doPoolMessage(ApplicationModuleImpl.java:8534)
>
>
> at
> oracle.jbo.common.ampool.ApplicationPoolImpl.sendPoolMessage(ApplicationPoolImpl.java:4392)
>
>
> at
> oracle.jbo.common.ampool.ApplicationPoolImpl.prepareApplicationModule(ApplicationPoolImpl.java:2388)
>
>
> at
> oracle.jbo.common.ampool.ApplicationPoolImpl.doCheckout(ApplicationPoolImpl.java:2204)
>
>
> at
> oracle.jbo.common.ampool.ApplicationPoolImpl.useApplicationModule(ApplicationPoolImpl.java:3088)
>
>
> at
> oracle.jbo.common.ampool.SessionCookieImpl.useApplicationModule(SessionCookieImpl.java:460)
>
>
> at
> oracle.jbo.common.ampool.SessionCookieImpl.useApplicationModule(SessionCookieImpl.java:431)
>
>
> at
> oracle.jbo.common.ampool.SessionCookieImpl.useApplicationModule(SessionCookieImpl.java:426)
>
>
> at
> oracle.adf.model.bc4j.DCJboDataControl.initializeApplicationModule(DCJboDataControl.java:513)
>
>
> at
> oracle.adf.model.bc4j.DCJboDataControl.getApplicationModule(DCJboDataControl.java:856)
>
>
> at
> oracle.adf.model.binding.DCBindingContainer.setDataControl(DCBindingContainer.java:554)
>
>
> at
> oracle.jbo.uicli.jui.JUPanelBinding.useDefaultDataControl(JUPanelBinding.java:912)
>
>
> at
> oracle.jbo.uicli.jui.JUPanelBinding.setup(JUPanelBinding.java:125)
>
> at
> oracle.jbo.uicli.controls.JUTestFrame.createBindingCtxAndSetUpMenu(JUTestFrame.java:165)
>
>
> at
> oracle.jbo.uicli.controls.JUTestFrame.<init>(JUTestFrame.java:117)
>
> at
> oracle.jbo.uicli.controls.JUTestFrame.startTestFrame(JUTestFrame.java:80)
>
> at demo.view.Panel1.main(Panel1.java:181)
>
> Could you please check, if I'm using the workaround as
> expected?
>
> Regards,
>
> Luis
>
> *From:* Brian Fry [mailto:brian.fry at oracle.com]
> *Sent:* sexta-feira, 19 de março de 2010 13:03
> *To:* Luis Paolini
> *Cc:* 'Joe Huang'; sandra.whitman at oracle.com; 'Fernando Targa';
> kent.rollins at oracle.com; dave.segleau at oracle.com; 'Sleepycat Software
> Support'; george.feinberg at oracle.com; bdb-beta-feedback at oss.oracle.com
> *Subject:* Re: [BDB 11gR2 Beta] [#18298] First Questions about DBD 11gR2
>
> Great!
>
> Luis, we found a bug that prevents using the ADF BC wizards at design
> time directly against SQLite. We're working on addressing this (or at
> least finding a better workaround), but in the mean time, we would
> suggest that you create an identical database schema in an Oracle
> database, and develop against that. As described in the "developing
> for multiple databases" how to, use the SQL92 SQL flavor and Java type
> mappings. You can then switch the connection definition to test
> running against SQLite. If we get a better workaround, we will keep
> you posted.
>
> -- Brian
>
>
> On 3/19/2010 3:56 AM, Luis Paolini wrote:
>
> Joe,
>
> Thanks for the information. I got Zentus JDBC driver and followed the
> steps.
>
> It worked as expected and I could connect to my SQLite
> test database.
>
> Regards,
>
> Luis
>
> *From:* Joe Huang [mailto:JOE.HUANG at oracle.com]
> *Sent:* quarta-feira, 17 de março de 2010 22:27
> *To:* brian.fry at oracle.com <mailto:brian.fry at oracle.com>;
> sandra.whitman at oracle.com <mailto:sandra.whitman at oracle.com>
> *Cc:* Luis Paolini; Fernando Targa; kent.rollins at oracle.com
> <mailto:kent.rollins at oracle.com>; dave.segleau at oracle.com
> <mailto:dave.segleau at oracle.com>; Sleepycat Software Support;
> george.feinberg at oracle.com <mailto:george.feinberg at oracle.com>;
> bdb-beta-feedback at oss.oracle.com <mailto:bdb-beta-feedback at oss.oracle.com>
> *Subject:* RE: [BDB 11gR2 Beta] [#18298] First Questions about DBD 11gR2
>
> Sure - a couple of steps. First, you will need to download a JDBC
> driver that can connect to a SQLite database. We had tested against
> Zentus driver, which is an open source driver that you can download
> from Zentus. I downloaded the driver and had installed to a directory
> called c:\zentus. This should give me a file sqlitejdbc-v0xx.jar in
> c:\zentus, where xx is the exact version number you download.
>
> To connect to SQLite DB, I would first create a new database
> connection in JDeveloper, and then configure the connection as follows
> -- please reference the screen shot below:
>
> 1. First in the Connection Type drop down, select Generic JDBC.
> Click "New" next to the driver class drop down, and type
> org.sqlite.JDBC in the name of the driver class.
>
> 2. Click browse, and then click New in the dialog box below:
>
> 3. Click Add Entry in the dialog box below, and then select the
> sqlitejdbc-v0xx.jar on your file system. After you select the jar
> file, you should see this jar added to the class path.
>
> 4. Click OK and then OK to return to the DB Connection creation
> screen.
>
> 5. In the JDBC URL window, type this jdbc:sqlite:<Path to your
> SQLite/BDB data file>. For example, jdbc:sqlite:C:\Documents and
> Settings\jhhuang\Desktop\sqlite-3_6_22\MOBILEFOD.db, where
> MOBILEFOD.db is the SQLite file containing my data.
>
> 6. Leave user name/password blank. SQLite connection does not
> need ID/password.
>
> 7. Click "Test Connection" If this is configured correctly, this
> should succeed.
>
> Thanks,
>
> Joe Huang
>
> Senior Principal Product Manager
>
> Mobile Platform, ADF/JDeveloper
>
> Product Development
>
> ORACLE
>
> 650-506-2271 (Office)
>
> 510-282-0369 (Mobile)
>
> Product Info:
> http://www.oracle.com/technology/tech/wireless/adf_mobile.html
>
> Demos: http://stshld.oracle.com:8888/demo
>
> ADF Mobile Client Demo on YouTube:
> http://www.youtube.com/watch?v=6LvUDCbCKQg
>
> -----Original Message-----
> From: Brian Fry
> Sent: Wednesday, March 17, 2010 6:01 PM
> To: Sandra Whitman; Joe Huang
> Cc: Luis Paolini; Fernando Targa; Kent Rollins; Dave Segleau;
> Sleepycat Software Support; George Feinberg;
> bdb-beta-feedback at oss.oracle.com <mailto:bdb-beta-feedback at oss.oracle.com>
> Subject: Re: [BDB 11gR2 Beta] [#18298] First Questions about DBD 11gR2
>
> Joe --
>
> I remember you had pointed to some instructions for connecting to
>
> SQLite. Could you share that?
>
> Luis --
>
> FYI, in some of our initial testing we've run into some roadblocks with
>
> ADF BC design time wizards and SQLite. We've logged some bugs, but it's
>
> not clear if there are workarounds in the mean time.
>
> -- Brian
>
> On 3/17/2010 12:04 PM, Sandra Whitman wrote:
>
> > Hi Brian, Luis,
>
> >
>
> > Has there been any progress on this issue?
>
> >
>
> > Brian,
>
> >
>
> > You had mentioned in a previous email that any SQL92 database was
>
> > generally supported with a JDBC driver, but since this was not
>
> > certified, that bugs may exist. Do you think Luis is encountering one
>
> > of those scenarios, and a bug needs to be logged? Or do you think
>
> > something else is preventing the connection to SQLite using a JDBC
>
> > driver from a JDeveloper Application?
>
> >
>
> >
>
> > Thank you,
>
> > Sandra
>
> >
>
> >
>
> >
>
> >
>
> >
>
> >
>
> >
>
> > Luis Paolini wrote:
>
> >>
>
> >> Hi Brian,
>
> >>
>
> >> Thanks for the document which describes some gotchas working with
>
> >> non-Oracle databases and ADF Business components.
>
> >>
>
> >> I still had no luck connecting to SQLite using JDBC driver from a
>
> >> JDeveloper Application.
>
> >>
>
> >> I tried to create a database connection using two different approaches.
>
> >>
>
> >> The first one, using Database Navigator, as described in the document
>
> >> you sent to me.
>
> >>
>
> >> The Second one, I just create a POJO to connect to SQLite.
>
> >>
>
> >> public Connection getConnection(){
>
> >>
>
> >> Connection conn = null;
>
> >>
>
> >> SQLite.Database db = null;
>
> >>
>
> >> try {
>
> >>
>
> >> Class.forName("SQLite.JDBCDriver").newInstance();
>
> >>
>
> >> conn =
>
> >>
> (Connection)DriverManager.getConnection("jdbc:sqlite:/D:/Downloads/Oracle/Berkeley_Beta/db-5.0.11/db-5.0.11/build_windows/Win32/Debug/test.db");
>
>
> >>
>
> >>
>
> >> java.lang.reflect.Method m =
>
> >>
>
> >> conn.getClass().getMethod("getSQLiteDatabase", null);
>
> >>
>
> >> db = (SQLite.Database) m.invoke(conn, null);
>
> >>
>
> >> } catch (Exception e) {
>
> >>
>
> >> e.printStackTrace();
>
> >>
>
> >> }
>
> >>
>
> >> return conn;
>
> >>
>
> >> }
>
> >>
>
> >> Error Message:
>
> >>
>
> >> Unable to load sqlite_jni: java.lang.UnsatisfiedLinkError:
>
> >>
> D:\Downloads\Oracle\Berkeley_Beta\db-5.0.11\db-5.0.11\build_windows\Win32\Debug\sqlite_jni.dll:
>
>
> >> Can't find dependent libraries
>
> >>
>
> >> Before running both cases, I did two configurations on JDeveloper.
>
> >>
>
> >> 1. Added the library sqlite.jar in the classpath
>
> >>
>
> >> 2. Added the parameter
>
> >>
> -Djava.library.path=D:\Downloads\Oracle\Berkeley_Beta\db-5.0.11\db-5.0.11\build_windows\Win32\Debug
>
>
> >>
>
> >>
>
> >> in the Launch Setting (Java Options).
>
> >>
>
> >> I'm running JDeveloper 11.1.1.2.0
>
> >>
>
> >> Regards,
>
> >>
>
> >> Luis
>
> >>
>
> >> -----Original Message-----
>
> >> From: Brian Fry [mailto:brian.fry at oracle.com]
>
> >> Sent: sexta-feira, 5 de março de 2010 19:00
>
> >> To: Sandra Whitman
>
> >> Cc: Luis Paolini; 'George Feinberg'; 'Dave Segleau'; 'Kent Rollins';
>
> >> 'Fernando Targa'; 'Sleepycat Software Support';
>
> >> bdb-beta-feedback at oss.oracle.com
> <mailto:bdb-beta-feedback at oss.oracle.com>
>
> >> Subject: Re: [BDB 11gR2 Beta] [#18298] First Questions about DBD 11gR2
>
> >>
>
> >> 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
> <mailto: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>
>
> >>
>
> >> >> <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>
>
> >>
>
> >> >> <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
>
> >>
>
> >> __________ Information from ESET NOD32 Antivirus, version of virus
>
> >> signature database 4919 (20100305) __________
>
> >>
>
> >> The message was checked by ESET NOD32 Antivirus.
>
> >>
>
> >> http://www.eset.com
>
> >>
>
> >>
>
> >>
>
> >> __________ Information from ESET NOD32 Antivirus, version of virus
>
> >> signature database 4944 (20100314) __________
>
> >>
>
> >> 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 4957 (20100319) __________
>
> The message was checked by ESET NOD32 Antivirus.
>
> http://www.eset.com
>
>
>
> __________ Information from ESET NOD32 Antivirus, version of virus
> signature database 4962 (20100321) __________
>
> 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/20100324/5bedc05c/attachment-0001.html
-------------- next part --------------
A non-text attachment was scrubbed...
Name: moz-screenshot-21.png
Type: image/png
Size: 16084 bytes
Desc: not available
Url : http://oss.oracle.com/pipermail/bdb-beta-feedback/attachments/20100324/5bedc05c/attachment-0011.png
-------------- next part --------------
A non-text attachment was scrubbed...
Name: moz-screenshot-20.png
Type: image/png
Size: 7795 bytes
Desc: not available
Url : http://oss.oracle.com/pipermail/bdb-beta-feedback/attachments/20100324/5bedc05c/attachment-0012.png
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: image/png
Size: 6167 bytes
Desc: not available
Url : http://oss.oracle.com/pipermail/bdb-beta-feedback/attachments/20100324/5bedc05c/attachment-0013.png
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: image/png
Size: 51430 bytes
Desc: not available
Url : http://oss.oracle.com/pipermail/bdb-beta-feedback/attachments/20100324/5bedc05c/attachment-0014.png
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: image/png
Size: 25580 bytes
Desc: not available
Url : http://oss.oracle.com/pipermail/bdb-beta-feedback/attachments/20100324/5bedc05c/attachment-0015.png
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: image/png
Size: 12955 bytes
Desc: not available
Url : http://oss.oracle.com/pipermail/bdb-beta-feedback/attachments/20100324/5bedc05c/attachment-0016.png
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: image/png
Size: 23090 bytes
Desc: not available
Url : http://oss.oracle.com/pipermail/bdb-beta-feedback/attachments/20100324/5bedc05c/attachment-0017.png
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: image/png
Size: 20730 bytes
Desc: not available
Url : http://oss.oracle.com/pipermail/bdb-beta-feedback/attachments/20100324/5bedc05c/attachment-0018.png
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: image/png
Size: 6287 bytes
Desc: not available
Url : http://oss.oracle.com/pipermail/bdb-beta-feedback/attachments/20100324/5bedc05c/attachment-0019.png
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: image/png
Size: 27095 bytes
Desc: not available
Url : http://oss.oracle.com/pipermail/bdb-beta-feedback/attachments/20100324/5bedc05c/attachment-0020.png
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: image/png
Size: 12452 bytes
Desc: not available
Url : http://oss.oracle.com/pipermail/bdb-beta-feedback/attachments/20100324/5bedc05c/attachment-0021.png
More information about the BDB-BETA-FEEDBACK
mailing list