db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Robert Taylor" <rtay...@mulework.com>
Subject RE: [Newbie] Trouble executing create-db for mysql
Date Fri, 05 Mar 2004 17:12:52 GMT
Spot on Ben! 

I feel like such an idiot. I'm still getting used to all the config settings.
Thanks.

robert

> -----Original Message-----
> From: Benjamin Yu [mailto:BenjaminY@InformativeResearch.com]
> Sent: Friday, March 05, 2004 11:54 AM
> To: 'Apache Torque Users List'
> Subject: RE: [Newbie] Trouble executing create-db for mysql
> 
> 
> Are you sure your torque.database property is set to "mysql" not "mssql"?
> The MS SQL create-db sql isn't implemented yet (3.1 release).
> 
> -Ben
> 
> -----Original Message-----
> From: Robert Taylor [mailto:rtaylor@mulework.com]
> Sent: Friday, March 05, 2004 7:37 AM
> To: torque-user@db.apache.org
> Subject: [Newbie] Trouble executing create-db for mysql
> 
> 
> Greetings: 
> 
> I'm just starting to use Torque (torque-gen-3.1) and I'm trying to create a
> new database.
> I can successfully run the "sql" target defined in build-torque.xml and I 
> see that the correct DDL statements are generated for my target database;
> mysql.
> 
> When I run the "create-db" target, the corresponding create-db.sql file
> created
> only contains a single line:
> 
> ECHO Not implemented
> 
> Subsequently I get the following error message:
> 
>      [echo]
>      [echo]       Executing the create-db.sql script ...
>      [echo]
>       [sql] Executing file: F:\api\apache\db\Copy of
> torque-gen-3.1\src\sql\crea
> te-db.sql
>       [sql] Failed to execute:  ECHO Not implemented
>       [sql] java.sql.SQLException: Syntax error or access violation,
> message fr
> om server: "You have an error in your SQL syntax.  Check the manual that
> corresp
> onds to your MySQL server version for the right syntax to use near 'ECHO Not
> imp
> lemented' at line 1"
>       [sql] 0 of 1 SQL statements executed successfully
> 
> I search the archives for "ECHO" and found nothing.
> 
> I had the same problem when using MSSQL but found out that I had to create
> the
> database and tables manually. Is the same true for mysql?
> 
> 
> Any suggestions/help would be appreciated.
> 
> robert
> 
> ---------------------------------------------------------------------
> 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
> 

---------------------------------------------------------------------
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