Edith,
I also had the same problem. I traced it down to the test case
testDeleteUnidirectional function in MtoNmapping testcase of the Persistence Broker.
In this
function, it gets stuck when it is trying to store the project. I started
running the testcases individually avoiding this testcase. After running
the test cases to the end I tried running the specific test case again. It
passed and now I can run all the testcases in sequence. I have not traced
out what the problem is yet. I thought it was a problem specific to DB2 or
the scripts I was running to populate the test data. I have not gone
beyond this in tracing the problem as it is working with the current data
set and set up that is in the database and I have not got around to
cleaning up the database and recreating the setup to find out what the
real problem is.
Hope your problem is the same and this gets you in going forward. If you
find out more on this please let me know.
Regards Jose
[EMAIL PROTECTED]
09/02/2002 07:23 PM
Please respond to "OJB Users List"
To: [EMAIL PROTECTED]
cc:
Subject: how to setup OJB with Oracle
Hello,
I am new to OJB. I run tutorial 2 without any problem.
I am now trying to use OJB with Oracle.
The build script (build prepare testdb) works well : I get the tables and
data in my database.
I just had to change database = Oracle to database = oracle in the
oracle.profile file othewise I got errors.
Now, a problem arises as I try the "verifiying the installation step" with
the build junit script :
I don't get any error message, it starts running and just hangs and
anything more is happening.
I read the archive and saw that Anu has exactly the same problem with db2.
Any idea about what is happening ?
Thanks in advance.
Edith.
___________________________________________________
Logs :
D:\Comor\OJB\logiciel-0.9.5\jakarta-ojb-0.9.5>.\bin\build junit
Buildfile: build.xml
set-archive-name:
set-archive-name-date:
detect-jdk:
use-jdk12:
use-jdk13:
[echo] detected JDK 1.3
use-jdk14:
init:
prepare:
preprocess:
[echo] using switches: +JDK13, -JDBC30
[java]
........................................................................................
....................................................................................................
....................................................................................................
....................................................................................................
....................................................................................................
...........................................................
[java]
........................................................................................
....................................................................................................
....
main:
[javac] Compiling 547 source files to
D:\Comor\OJB\logiciel-0.9.5\jakarta-ojb-0.9.5\target\class
es
[javac]
D:\Comor\OJB\logiciel-0.9.5\jakarta-ojb-0.9.5\target\src\org\apache\ojb\broker\util\pool
ing\WrappedPreparedStatement.java:99: warning:
setUnicodeStream(int,java.io.InputStream,int) in java
.sql.PreparedStatement has been deprecated
[javac] public class WrappedPreparedStatement implements
PreparedStatement
[javac] ^
[javac]
D:\Comor\OJB\logiciel-0.9.5\jakarta-ojb-0.9.5\target\src\org\apache\ojb\broker\util\pool
ing\WrappedPreparedStatement.java:487: warning:
setUnicodeStream(int,java.io.InputStream,int) in jav
a.sql.PreparedStatement has been deprecated
[javac] pstmt.setUnicodeStream(parameterIndex, x, length);
[javac] ^
[javac] 2 warnings
[javac] Compiling 192 source files to
D:\Comor\OJB\logiciel-0.9.5\jakarta-ojb-0.9.5\target\class
estest
useP6Spy:
dontUseP6Spy:
[echo] NOT using P6Spy
prepare-testdb:
[delete] Deleting directory
D:\Comor\OJB\logiciel-0.9.5\jakarta-ojb-0.9.5\target\test
[copy] Copying 1 file to
D:\Comor\OJB\logiciel-0.9.5\jakarta-ojb-0.9.5\target\test
[copy] Copying 1 file to
D:\Comor\OJB\logiciel-0.9.5\jakarta-ojb-0.9.5\target\test
[copy] Copying 1 file to
D:\Comor\OJB\logiciel-0.9.5\jakarta-ojb-0.9.5\target\test
[copy] Copying 1 file to
D:\Comor\OJB\logiciel-0.9.5\jakarta-ojb-0.9.5\target\test
[copy] Copying 14 files to
D:\Comor\OJB\logiciel-0.9.5\jakarta-ojb-0.9.5\target\test\ojb
project-sql-classpath:
[echo] +------------------------------------------+
[echo] | |
[echo] | Generating SQL for OJB Testsuite! |
[echo] | enJoy! |
[echo] | |
[echo] +------------------------------------------+
[torque-sql] Using contextProperties file:
D:\Comor\OJB\logiciel-0.9.5\jakarta-ojb-0.9.5\build.prope
rties
[torque-sql] Using classpath
[torque-sql] Generating to file
D:\Comor\OJB\logiciel-0.9.5\jakarta-ojb-0.9.5\target\src\sql\report.
ojbtest.sql.generation
[torque-sql] Resolver: used database.dtd from
org.apache.torque.engine.database.transform package
[torque-sql] Resolver: used database.dtd from
org.apache.torque.engine.database.transform package
[torque-sql] Resolver: used database.dtd from
org.apache.torque.engine.database.transform package
[torque-sql] Resolver: used database.dtd from
org.apache.torque.engine.database.transform package
project-create-db-classpath:
project-datasql-classpath:
[echo] +-----------------------------------------------+
[echo] | |
[echo] | Generating SQL from data XML ! |
[echo] | enJoy! |
[echo] | |
[echo] +-----------------------------------------------+
[echo] taking build.properties from: build.properties
[torque-datasql] Using contextProperties file:
D:\Comor\OJB\logiciel-0.9.5\jakarta-ojb-0.9.5\build.p
roperties
[torque-datasql] Using classpath
[torque-datasql] Generating to file
D:\Comor\OJB\logiciel-0.9.5\jakarta-ojb-0.9.5\target\src\sql\ojb
test-data.sql
[torque-datasql] Resolver: used database.dtd from
org.apache.torque.engine.database.transform packag
e
[torque-datasql] Resolver: used database.dtd from
org.apache.torque.engine.database.transform packag
e
[torque-datasql] Resolver: used
D:\Comor\OJB\logiciel-0.9.5\jakarta-ojb-0.9.5\src\schema\ojbtest-dat
a.dtd
project-insert-sql:
[torque-insert-sql] Our new url -> jdbc:oracle:thin:@BDTS:1527:oem
[torque-insert-sql] Executing file:
D:\Comor\OJB\logiciel-0.9.5\jakarta-ojb-0.9.5\target\src\sql\ojb
test-schema.sql
[torque-insert-sql] Executing file:
D:\Comor\OJB\logiciel-0.9.5\jakarta-ojb-0.9.5\target\src\sql\ojb
core-schema.sql
[torque-insert-sql] Failed to execute: DROP TABLE OJB_DMAP_ENTRIES CASCADE
CONSTRAINTS
[torque-insert-sql] java.sql.SQLException: ORA-00942: table or view does
not exist
[torque-insert-sql] Failed to execute: CREATE TABLE OJB_DMAP_ENTRIES ( ID
NUMBER NOT NULL, DMAP_ID N
UMBER NOT NULL, KEY_OID LONG RAW, VALUE_OID LONG RAW )
[torque-insert-sql] java.sql.SQLException: ORA-01754: a table may contain
only one column of type LO
NG
[torque-insert-sql] Failed to execute: ALTER TABLE OJB_DMAP_ENTRIES ADD
CONSTRAINT OJB_DMAP_ENTRIES_
PK PRIMARY KEY (ID)
[torque-insert-sql] java.sql.SQLException: ORA-00942: table or view does
not exist
[torque-insert-sql] Executing file:
D:\Comor\OJB\logiciel-0.9.5\jakarta-ojb-0.9.5\target\src\sql\ojb
test-data.sql
[torque-insert-sql] Failed to execute: INSERT INTO Artikel
(Artikel_Nr,Artikelname,Lieferanten_Nr,Ka
tegorie_Nr,Liefereinheit,Einzelpreis,Lagerbestand,BestellteEinheiten,MindestBestand,Auslaufartikel)
VALUES (5,'Chef Anton�s Gumbo Mix',2,2,'36 boxes',21.35,0,0,0,1)
[torque-insert-sql] java.sql.SQLException: ORA-00917: missing comma
[torque-insert-sql] Failed to execute: INSERT INTO Artikel
(Artikel_Nr,Artikelname,Lieferanten_Nr,Ka
tegorie_Nr,Liefereinheit,Einzelpreis,Lagerbestand,BestellteEinheiten,MindestBestand,Auslaufartikel)
VALUES (6,'Grandma�s Boysenberry Spread',3,2,'12 - 8 oz
jars',25.0,120,0,25,0)
[torque-insert-sql] java.sql.SQLException: ORA-00917: missing comma
....
[torque-insert-sql] Failed to execute: INSERT INTO CDS
(Artikel_Nr,Artikelname,Lieferanten_Nr,Katego
rie_Nr,Liefereinheit,Einzelpreis,Lagerbestand,BestellteEinheiten,MindestBestand,Auslaufartikel,LABEL
,MUSICIANS) VALUES (201,'STREETSOUL',12,5,'12
boxes',25.0,32,0,15,0,'Virgin Records','Guru�s Jazzmat
azz')
[torque-insert-sql] java.sql.SQLException: ORA-00917: missing comma
[torque-insert-sql] 270 of 283 SQL statements executed successfully
junit-no-compile-no-prepare:
[junit] Running org.apache.ojb.broker.AllTests
[junit] [BOOT] INFO: OJB.properties:
file:/D:/Comor/OJB/logiciel-0.9.5/jakarta-ojb-0.9.5/target/
test/ojb/OJB.properties
______________________________________________
and then nothing more is happening ...
----------------
Les donnees et renseignements contenus dans ce message sont personnels,
confidentiels et secrets. Ce message est adresse a l'individu ou l'entite
dont les coordonnees figurent ci-dessus. Si vous n'etes pas le bon
destinataire, nous vous demandons de ne pas lire, copier, utiliser ou
divulguer cette communication. Nous vous prions de notifier cette erreur a
l'expediteur et d'effacer immediatement cette communication de votre
systeme.
The information contained in this message is privileged, confidential, and
protected from disclosure. This message is intended for the individual or
entity adressed herein. If you are not the intended recipient, please do
not read, copy, use or disclose this communication to others ;also please
notify the sender by replying to this message, and then delete it from
your system.
