Return-Path: <goffredo@almirena.com>
Mailing-List: contact turbine-torque-user-help@jakarta.apache.org;
 run by ezmlm
Delivered-To: mailing list turbine-torque-user@jakarta.apache.org
Received: (qmail 2180 invoked by uid 98); 3 Jan 2003 10:18:20 -0000
X-Antivirus: nagoya (v4218 created Aug 14 2002)
Received: (qmail 1785 invoked from network); 3 Jan 2003 10:18:17 -0000
Received: from daedalus.apache.org (HELO apache.org) (63.251.56.142)
  by nagoya.betaversion.org with SMTP; 3 Jan 2003 10:18:17 -0000
Received: (qmail 69149 invoked by uid 500); 3 Jan 2003 10:16:47 -0000
Received: (qmail 69131 invoked from network); 3 Jan 2003 10:16:46 -0000
Received: from unknown (HELO egwene.twibble.org) (203.217.29.134)
  by daedalus.apache.org with SMTP; 3 Jan 2003 10:16:46 -0000
Received: by egwene.twibble.org (Postfix, from userid 48)
	id 7749020F1F4; Fri,  3 Jan 2003 21:16:57 +1100 (EST)
Received: from 203.4.251.195 ( [203.4.251.195])
	as user goffredo@localhost by twibble.org with HTTP;
	Fri,  3 Jan 2003 21:16:57 +1100
Message-ID: <1041589017.3e156319190f3@twibble.org>
Date: Fri,  3 Jan 2003 21:16:57 +1100
From: goffredo@almirena.com
To: Turbine Torque Users List <turbine-torque-user@jakarta.apache.org>
Subject: SQL ERRORS - query
References: 
 <8B71702EEB4FD311AF9F000629381CE704C54B9D@intertechy.INTERTECH.MSFT>
In-Reply-To: 
 <8B71702EEB4FD311AF9F000629381CE704C54B9D@intertechy.INTERTECH.MSFT>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
User-Agent: Internet Messaging Program (IMP) 3.1
X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N

Hi All,

I am trying to get the bookstore example working. I have created the
bookstore.xml in the schema/ directory, and I have run ant -f
build-torque.xml succesfully. Files now exist where they should .


But when I run 'ant -f build-torque.xml create-db' I get two sql ERRORS,
that point back to a problem with the create-db.sql script created by
Torque:

$ cat create-bb.sql
drop database bookstore;
create database bookstore;
drop database default;		<--- Where does this come from?
create database default;	<---  "     "	"    "	  "

Now I don't understand where the "default" database comes from.
Should it be there or have I not done something right in the properties
files?

I am not sure what's wrong.

Regards
Goffredo.


ERRORS listed below
------------------------------------------------------------
$ ant -f build-torque.xml create-db
Buildfile: build-torque.xml

create-db-check:
create-db:
[torque-data-model] Generating to file /home/fred/tmp2/torque-3.0/src/sql/creat
[torque-data-model] Resolver: used database.dtd from org.apache.torque.engine.d
[torque-data-model] Resolver: used database.dtd from org.apache.torque.engine.d
     [echo]
     [echo]	  Executing the create-db.sql script ...
     [echo]
     [echo] driver=org.postgresql.Driver
     [echo] password=
     [echo] userid=fred
     [echo] url=jdbc:postgresql://127.0.0.1:5432/mydb_junk
      [sql] Executing file: /home/fred/tmp2/torque-3.0/src/sql/create-db.sql
      [sql] Failed to execute: drop database default
      [sql] java.sql.SQLException: ERROR:  parser: parse error at or near 
              "default"
      [sql] Failed to execute: create database default
      [sql] java.sql.SQLException: ERROR:  parser: parse error at or near 
              "default"
      [sql] 2 of 4 SQL statements executed successfully

BUILD SUCCESSFUL