I am trying to run the sample projects for torque 3.0 b4.
"default" is a reserved word in mysql so trying to name a table default
will always fail. But I have modified all the .properties files but can
not stop this error:
ant -f build-torque.xml create-db
Buildfile: build-torque.xml
create-db-check:
create-db:
[torque-data-model] Generating to file
/home/user/torque/torque-3.0-b4/src/sql/create-db.sql
[torque-data-model] Resolver: used database.dtd from
org.apache.torque.engine.database.transform package
[torque-data-model] Resolver: used database.dtd from
org.apache.torque.engine.database.transform package
[echo]
[echo] Executing the create-db.sql script ...
[echo]
[sql] Executing file:
/home/user/torque/torque-3.0-b4/src/sql/create-db.sql
[sql] Failed to execute: drop database if exists default
[sql] java.sql.SQLException: Syntax error or access violation:
You have an error in your SQL syntax near 'default' at line 1
[sql] Failed to execute: create database default
[sql] java.sql.SQLException: Syntax error or access violation:
You have an error in your SQL syntax near 'default' at line 1
[sql] 0 of 2 SQL statements executed successfully
BUILD SUCCESSFUL
Total time: 4 seconds
how do I modify the name of the database because
modifying torque.database.name seems to have no effect at all.
"default" is always generated into this file: src/sql/create-db.sql
--
Vincent Stoessel
Linux Systems Developer
vincent xaymaca.com
--
To unsubscribe, e-mail: <mailto:turbine-torque-user-unsubscribe@;jakarta.apache.org>
For additional commands, e-mail: <mailto:turbine-torque-user-help@;jakarta.apache.org>
