Return-Path: 
 <torque-user-return-4382-apmail-db-torque-user-archive=db.apache.org@db.apache.org>
Delivered-To: apmail-db-torque-user-archive@www.apache.org
Received: (qmail 68241 invoked from network); 5 Mar 2004 16:52:08 -0000
Received: from daedalus.apache.org (HELO mail.apache.org) (208.185.179.12)
  by minotaur-2.apache.org with SMTP; 5 Mar 2004 16:52:08 -0000
Received: (qmail 17273 invoked by uid 500); 5 Mar 2004 16:51:52 -0000
Delivered-To: apmail-db-torque-user-archive@db.apache.org
Received: (qmail 17149 invoked by uid 500); 5 Mar 2004 16:51:51 -0000
Mailing-List: contact torque-user-help@db.apache.org; run by ezmlm
Precedence: bulk
List-Unsubscribe: <mailto:torque-user-unsubscribe@db.apache.org>
List-Subscribe: <mailto:torque-user-subscribe@db.apache.org>
List-Help: <mailto:torque-user-help@db.apache.org>
List-Post: <mailto:torque-user@db.apache.org>
List-Id: "Apache Torque Users List" <torque-user.db.apache.org>
Reply-To: "Apache Torque Users List" <torque-user@db.apache.org>
Delivered-To: mailing list torque-user@db.apache.org
Received: (qmail 17103 invoked from network); 5 Mar 2004 16:51:51 -0000
Received: from unknown (HELO NTSERV01.InformativeResearch.com) (65.163.59.170)
  by daedalus.apache.org with SMTP; 5 Mar 2004 16:51:51 -0000
Received: by ntserv01.informativeresearch.com with Internet Mail Service
 (5.5.2657.72)
	id <F7PWMNZR>; Fri, 5 Mar 2004 08:54:27 -0800
Message-ID: 
 <961883FD16B5854AA73F31449A3EC8F302248CA6@ntserv01.informativeresearch.com>
From: Benjamin Yu <BenjaminY@InformativeResearch.com>
To: 'Apache Torque Users List' <torque-user@db.apache.org>
Subject: RE: [Newbie] Trouble executing create-db for mysql
Date: Fri, 5 Mar 2004 08:54:26 -0800 
MIME-Version: 1.0
X-Mailer: Internet Mail Service (5.5.2657.72)
Content-Type: text/plain;
	charset="iso-8859-1"
X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N
X-Spam-Rating: minotaur-2.apache.org 1.6.2 0/1000/N

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