Re: setup-db problems

2006-02-28 Thread Thomas Dudziak
On 3/1/06, Laurent Sacaut <[EMAIL PROTECTED]> wrote: > I tested the sql statements generated by torque in project--schema under > build/database directly in the mysql command-line AND using mysqlcc and > they work just fine. Please use a tool that uses the JDBC driver, e.g. Squirrel SQL, or Ant's

Re: setup-db problems

2006-02-28 Thread Laurent Sacaut
Hi Tom, I tested the sql statements generated by torque in project--schema under build/database directly in the mysql command-line AND using mysqlcc and they work just fine. I then created a small java class with a simple jdbc connection to run the same statment and i got some interesting results.

Re: setup-db problems

2006-02-28 Thread Thomas Dudziak
On 2/28/06, Laurent Sacaut <[EMAIL PROTECTED]> wrote: > 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

Re: setup-db problems

2006-02-27 Thread Laurent Sacaut
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 se

Re: setup-db problems

2006-02-27 Thread Thomas Dudziak
On 2/27/06, Laurent Sacaut <[EMAIL PROTECTED]> wrote: > Here are the settings from build.properties in ojb: These all look ok. > I left the build-torque.xml file untouched, but I noticed that in the > section, it is trying to include files I > don't have such as > commons-lang-1.0.1.jar<-

Re: setup-db problems

2006-02-27 Thread Laurent Sacaut
Hi Tom, Here are the settings from build.properties in ojb: " header sniped... ... cdAlias=prom8 databaseName=product_manager_8 databaseUser=root databasePassword= # For MySQL this would look like: dbmsName=MySQL jdbcLevel=3.0 jdbcRuntimeDriver=com.mysql.jdbc.Driver urlProtocol=jdbc urlSubproto

Re: setup-db problems

2006-02-27 Thread Thomas Dudziak
On 2/24/06, Laurent Sacaut <[EMAIL PROTECTED]> wrote: > When trying to run the setup-db ant task from the build file, I am > getting an error coming from the build-torque.xml file. > I modified builds.properties and OJB.properties to fit my test project > but can get it to run. > > I created the da