Hi,
I am using torque-3.0- rc1. I get following error message when I run
create-db
[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] 2 of 4 SQL statements executed successfully
My create-db sql has following lines:
drop database if exists UMail;
create database UMail;
drop database if exists default;
create database default;
My sqldb.map contains following line
#Sqlfile -> Database map
#Fri Nov 15 14:38:03 EST 2002
project-schema.sql=UMail
id-table-schema.sql=default
>From my search on torque/turbine archives I know that other ppl have had
this problem with earlier versions of torque. However, I did not find any
good solution for this problem. If I don't have to, then, I dont want to
delete certain lines from my sql file or path createdb.vm file so that it
ignores default database.
The fact that it worked for me with earlier versions and others have had
same problems with earlier version makes me think that its some
configuration that I have skipped.
Does any one know how I can resolve it.
Thanks for ur time
Anm01
--
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>
