[BDB 11gR2 Beta] [#18298] First Questions about DBD 11gR2
Luis Paolini
git at gempi.com.br
Sun Mar 21 08:27:40 PDT 2010
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:1
00)
at
oracle.jbo.server.ConnectionPool.getConnection(ConnectionPool.java:66)
at
oracle.jbo.server.ConnectionPoolManagerImpl.getConnection(ConnectionPoolMana
gerImpl.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:1
108)
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(DefaultConnection
Strategy.java:213)
at
oracle.jbo.server.ApplicationPoolMessageHandler.doPoolConnect(ApplicationPoo
lMessageHandler.java:553)
at
oracle.jbo.server.ApplicationPoolMessageHandler.doPoolMessage(ApplicationPoo
lMessageHandler.java:409)
at
oracle.jbo.server.ApplicationModuleImpl.doPoolMessage(ApplicationModuleImpl.
java:8534)
at
oracle.jbo.common.ampool.ApplicationPoolImpl.sendPoolMessage(ApplicationPool
Impl.java:4392)
at
oracle.jbo.common.ampool.ApplicationPoolImpl.prepareApplicationModule(Applic
ationPoolImpl.java:2388)
at
oracle.jbo.common.ampool.ApplicationPoolImpl.doCheckout(ApplicationPoolImpl.
java:2204)
at
oracle.jbo.common.ampool.ApplicationPoolImpl.useApplicationModule(Applicatio
nPoolImpl.java:3088)
at
oracle.jbo.common.ampool.SessionCookieImpl.useApplicationModule(SessionCooki
eImpl.java:460)
at
oracle.jbo.common.ampool.SessionCookieImpl.useApplicationModule(SessionCooki
eImpl.java:431)
at
oracle.jbo.common.ampool.SessionCookieImpl.useApplicationModule(SessionCooki
eImpl.java:426)
at
oracle.adf.model.bc4j.DCJboDataControl.initializeApplicationModule(DCJboData
Control.java:513)
at
oracle.adf.model.bc4j.DCJboDataControl.getApplicationModule(DCJboDataControl
.java:856)
at
oracle.adf.model.binding.DCBindingContainer.setDataControl(DCBindingContaine
r.java:554)
at
oracle.jbo.uicli.jui.JUPanelBinding.useDefaultDataControl(JUPanelBinding.jav
a:912)
at
oracle.jbo.uicli.jui.JUPanelBinding.setup(JUPanelBinding.java:125)
at
oracle.jbo.uicli.controls.JUTestFrame.createBindingCtxAndSetUpMenu(JUTestFra
me.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_wind
ows\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(URLConnectionH
elper.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_wind
ows\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(URLConnectionH
elper.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:1
00)
at
oracle.jbo.server.ConnectionPool.getConnection(ConnectionPool.java:66)
at
oracle.jbo.server.ConnectionPoolManagerImpl.getConnection(ConnectionPoolMana
gerImpl.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:1
108)
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(DefaultConnection
Strategy.java:213)
at
oracle.jbo.server.ApplicationPoolMessageHandler.doPoolConnect(ApplicationPoo
lMessageHandler.java:553)
at
oracle.jbo.server.ApplicationPoolMessageHandler.doPoolMessage(ApplicationPoo
lMessageHandler.java:409)
at
oracle.jbo.server.ApplicationModuleImpl.doPoolMessage(ApplicationModuleImpl.
java:8534)
at
oracle.jbo.common.ampool.ApplicationPoolImpl.sendPoolMessage(ApplicationPool
Impl.java:4392)
at
oracle.jbo.common.ampool.ApplicationPoolImpl.prepareApplicationModule(Applic
ationPoolImpl.java:2388)
at
oracle.jbo.common.ampool.ApplicationPoolImpl.doCheckout(ApplicationPoolImpl.
java:2204)
at
oracle.jbo.common.ampool.ApplicationPoolImpl.useApplicationModule(Applicatio
nPoolImpl.java:3088)
at
oracle.jbo.common.ampool.SessionCookieImpl.useApplicationModule(SessionCooki
eImpl.java:460)
at
oracle.jbo.common.ampool.SessionCookieImpl.useApplicationModule(SessionCooki
eImpl.java:431)
at
oracle.jbo.common.ampool.SessionCookieImpl.useApplicationModule(SessionCooki
eImpl.java:426)
at
oracle.adf.model.bc4j.DCJboDataControl.initializeApplicationModule(DCJboData
Control.java:513)
at
oracle.adf.model.bc4j.DCJboDataControl.getApplicationModule(DCJboDataControl
.java:856)
at
oracle.adf.model.binding.DCBindingContainer.setDataControl(DCBindingContaine
r.java:554)
at
oracle.jbo.uicli.jui.JUPanelBinding.useDefaultDataControl(JUPanelBinding.jav
a:912)
at
oracle.jbo.uicli.jui.JUPanelBinding.setup(JUPanelBinding.java:125)
at
oracle.jbo.uicli.controls.JUTestFrame.createBindingCtxAndSetUpMenu(JUTestFra
me.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; sandra.whitman at oracle.com
Cc: Luis Paolini; 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
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
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/Be
rkeley_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\De
bug\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\bu
ild_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
>> 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.h
tml
>>
>>
>> -- 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>
<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
>> 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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://oss.oracle.com/pipermail/bdb-beta-feedback/attachments/20100321/e31d0d90/attachment-0001.html
-------------- 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/20100321/e31d0d90/attachment-0009.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/20100321/e31d0d90/attachment-0010.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/20100321/e31d0d90/attachment-0011.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/20100321/e31d0d90/attachment-0012.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/20100321/e31d0d90/attachment-0013.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/20100321/e31d0d90/attachment-0014.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/20100321/e31d0d90/attachment-0015.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/20100321/e31d0d90/attachment-0016.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/20100321/e31d0d90/attachment-0017.png
More information about the BDB-BETA-FEEDBACK
mailing list