db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Thomas Fischer <tfisc...@apache.org>
Subject Re: create-db.sql and default database
Date Sat, 02 Apr 2005 05:36:52 GMT
Laran,

you have used 'default' as database name. 'default' is a reseverd word in 
Mysql (and in many other databases) and should not be used as name of a 
database or table or column.

Please choose another name.

         Thomas

On Fri, 1 Apr 2005, Laran Evans wrote:

> I'm running Torque 3.1.1 (torque itself and generator) against MySQL 
> 4.1.10a-nt.
>
> When I run create-db the sql file that is generated contains the text:
>
> ---
> drop database if exists default;
> create database default;
> ---
>
> When I run the target I get :
>
> ---
> [sql] Failed to execute:  drop database if exists default
> [sql] java.sql.SQLException: You have an error in your SQL syntax; check t
> he manual that corresponds to your MySQL server version for the right syntax 
> to
> use near 'default' at line 1
> [sql] Failed to execute:  create database default
> [sql] java.sql.SQLException: You have an error in your SQL syntax; check t
> he manual that corresponds to your MySQL server version for the right syntax 
> to
> use near 'default' at line 1
> [sql] 0 of 2 SQL statements executed successfully
>
> Is there a way around this? I have set the name of my schema in the build 
> file.
>
> Thanks
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
> For additional commands, e-mail: torque-user-help@db.apache.org
>
>

---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org


Mime
View raw message