Hi,
being completely new to OJB I first tried to set up V1.0 RC6 and ran "ant perf-test"
successfully against the built in HSQL database.
As the intended target database is Oracle 9i in a second step I changed the profile to
be used to "oracle9i" in file "build.properties".
It is not possible to prepare the test database not to think of a working performance
test.
I searched the doc, the faq and the mail archive for a similar problem without finding
any information about such an error.
Please have a look the following excerpt from the command line:
<_____________
C:\spielwiese\workspace\ojb>ant prepare-testdb
Buildfile: build.xml
splash:
set-archive-name:
set-archive-name-date:
detect-jdk:
check-jdk12proxy-classes:
check-jndi-classes:
use-jdk12:
use-jdk13:
use-jdk14:
[echo] detected JDK 1.4
init:
prepare:
checkP6Spy:
useP6Spy:
[echo] using P6Spy to trace JDBC calls.
dontUseP6Spy:
prepare-repository:
[delete] Deleting directory C:\spielwiese\workspace\ojb\target\test
[copy] Copying 24 files to C:\spielwiese\workspace\ojb\target\test\ojb
[copy] Copying 1 file to C:\spielwiese\workspace\ojb\target\test
[copy] Copying 1 file to C:\spielwiese\workspace\ojb\target\test
prepare-testdb:
[copy] Copying 4 files to C:\spielwiese\workspace\ojb\target\test
initJNETSQLServer:
getJSQLDriver:
check-use-classpath:
check-run-only-on-schema-change:
sql-check:
sql:
[echo] +------------------------------------------+
[echo] | |
[echo] | Generating SQL for YOUR Torque project! |
[echo] | Woo hoo! |
[echo] | |
[echo] +------------------------------------------+
sql-classpath:
[torque-sql] Using contextProperties file: C:\spielwiese\workspace\ojb\build.pro
perties
[torque-sql] Using classpath
[torque-sql] Generating to file C:\spielwiese\workspace\ojb\target\test\sql\repo
rt.ojbtest.sql.generation
[torque-sql] Parsing file: 'ojbcore-schema.xml'
[torque-sql] (transform.DTDResolver 128 ) Resolver: used database.
dtd from org.apache.torque.engine.database.transform package
[torque-sql] Parsing file: 'ojbtest-schema.xml'
[torque-sql] (transform.DTDResolver 128 ) Resolver: used database.
dtd from org.apache.torque.engine.database.transform package
sql-template:
create-db-check:
create-db:
datasql:
[echo] +-----------------------------------------------+
[echo] | |
[echo] | Generating SQL from data XML ! |
[echo] | Woo hoo! |
[echo] | |
[echo] +-----------------------------------------------+
[torque-data-sql] Using contextProperties file: C:\spielwiese\workspace\ojb\buil
d.properties
[torque-data-sql] Using classpath
[torque-data-sql] Generating to file C:\spielwiese\workspace\ojb\target\test\sql
\ojbtest-data.sql
[torque-data-sql] Parsing file: 'ojbtest-schema.xml'
[torque-data-sql] (transform.DTDResolver 128 ) Resolver: used data
base.dtd from org.apache.torque.engine.database.transform package
[torque-data-sql] Resolver: used C:\spielwiese\workspace\ojb\target\test\ojbtest
-data.dtd
insert-sql:
[torque-sql-exec] Our new url -> jdbc:oracle:thin:@192.168.212.141:1521:KWPT
[torque-sql-exec] Executing file: C:\spielwiese\workspace\ojb\target\test\sql\oj
btest-schema.sql
[torque-sql-exec] Failed to execute: ALTER TABLE COLLECTION_COLLECTIBLE_CCC ADD
CONSTRAINT COLLECTION_COLLECTIBLE_CC_FK_1 FOREIGN KEY (GAT_ID) REFERENCES COLLEC
TION_GATHERER (GAT_ID)
[torque-sql-exec] java.sql.SQLException: ORA-02264: name already used by an existing
constraint
[torque-sql-exec] Executing file: C:\spielwiese\workspace\ojb\target\test\sql\oj
bcore-schema.sql
[torque-sql-exec] Failed to execute: DROP TABLE OJB_DMAP_ENTRIES CASCADE CONSTRA
INTS
[torque-sql-exec] java.sql.SQLException: ORA-00942: table or view does not exist
[torque-sql-exec] Failed to execute: CREATE TABLE OJB_DMAP_ENTRIES ( ID NUMBER N
OT NULL, DMAP_ID NUMBER NOT NULL, KEY_OID BLOB, VALUE_OID BLOB )
[torque-sql-exec] java.sql.SQLException: ORA-03237: Initial Extent of specified
size cannot be allocated in tablespace (OPERATING_DATA)
[torque-sql-exec] Failed to execute: ALTER TABLE OJB_DMAP_ENTRIES ADD CONSTRAINT
OJB_DMAP_ENTRIES_PK PRIMARY KEY (ID)
[torque-sql-exec] java.sql.SQLException: ORA-00942: table or view does not exist
[torque-sql-exec] Executing file: C:\spielwiese\workspace\ojb\target\test\sql\oj
btest-data.sql
[torque-sql-exec] 649 of 653 SQL statements executed successfully
BUILD SUCCESSFUL
Total time: 2 minutes 16 seconds
______________>
Any help is highly appreciated.
Best regards
Wolfram Herkendell
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
