I ran the sql generated by torque as you suggested (the 3 files it created: create-db.sql, ojbcore-schema.sql and project-schema.sql) and they are fine. No error from MySQL 5.0 and all the tables are created.
I am suspecting something subtile such as the order of the jar, or other configuration settings or file location. I have class variables set to the top of their respective directories: JAVA_HOME=/usr/lib/j2sdk1.5-sun/bin ANT_HOME=/usr/share/ant/bin Am i missing any other ones? Laurent Thomas Dudziak wrote: >On 2/27/06, Laurent Sacaut <[EMAIL PROTECTED]> wrote: > > > >>Here are the settings from build.properties in ojb: >> >> > ><snip> > >These all look ok. > > > >>I left the build-torque.xml file untouched, but I noticed that in the >><path id="torque-classpath"> section, it is trying to include files I >>don't have such as >>commons-lang-1.0.1.jar <-- using commons.lang.1.2.1.jar instead >>village-2.0-dev-20030825.jar >>xercesImpl-2.0.2.jar <-- using xerces.jar instead >>xmlParserAPIs-2.0.2.jar >> >> > >Yep, that's ok. > > > >>Any idea or suggestions? >> >> > >It's a bit strange, the SQL that MySql complains about (CREATE TABLE >Client ...), works without problems in MySQL 4.1. >Could you try to execute the SQL that Torque generated (in >build/database) manually via the mysql commandline ? If that fails, >could you send me the SQL (off the list if you want) ? > >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]
