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.
