Thanks. i 'm afraid i need to repatch distributed torque-gen-3.1.1.jar to have TIMESTAMP jdbc type created for java.sql.Date and java.sql.timestamp as i wrote in an old old post. (specific to oracle 9i and older )
Does someone confirm that ? On 2/3/06, Armin Waibel <[EMAIL PROTECTED]> wrote: > > 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] > >