Bruno CROS wrote:
Bang in the bull 's eye!!
the embedded dtd was not 3_0_1 but 3_1. I just change the value and it find
the database.dtd file included en torque.jar
Then i have to add to my build.properties
torque.database.user=xxxx
and
torque.database.password=xxxxx
and the famous
torque.delimiter=/ (apparently needed for Oracle9i)
now i get an error about OJB_DMAP_ENTRIES table !!
here is the ant trace :
StdErr
[torque-sql-exec] Failed to execute: CREATE TABLE OJB_DMAP_ENTRIES (
ID NUMBER NOT NULL, DMAP_ID NUMBER NOT NULL, KEY_OID LONG RAW, VALUE_OID
LONG RAW )
[torque-sql-exec] java.sql.SQLException: ORA-01754: a table may
contain only one column of type LONG
[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
Is this table needed ? why oracle does not want to cretae iot !!? It's
amazing.
The table is only needed if you use odmg-api with a specific DMap
implementation. Normally you never it.
http://db.apache.org/ojb/docu/guides/platforms.html#OJB+internal+tables
regards,
Armin
Thanks for you help.
On 2/3/06, Thomas Dudziak <[EMAIL PROTECTED]> wrote:
On 2/3/06, Bruno CROS <[EMAIL PROTECTED]> wrote:
First you will find the ant trace of setup-db task, the torque error is
painted in red.
Second, you will find my build.properties used by the task.
[torque-sql] 2006-02-03 13:21:48,578 [main] INFO
org.apache.torque.engine.database.transform.DTDResolver - Resolver: used
' http://db.apache.org/torque/dtd/database_3_0_1.dtd'
StdErr
BUILD FAILED
"build-torque.xml" :
file:C:/@Dev/Mathieu/ojb/src/schema/build-torque.xml:203:
org.apache.torque.engine .EngineException: java.net.UnknownHostException
:
db.apache.org en ligne 203
This seems to be the core problem: Ant cannot access the server
hosting the DTD ( db.apache.org), probably because of a Firewall. In
the Ant target that generates the schema, you can specify the DTD to
use for the schema. There, I thiink, you should use the value
http://db.apache.org/torque/dtd/database_3_1.dtd
because that should be the one that is contained in the torque jar
(which Ant therefore does not have to fetch from the internet).
Tom
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
