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.
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]
>
>
