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
|