Hi Roy Thank you for your hint. Unless I am wrong, there is nothing in my configs which specified de database named "default" to be created. These config files have been taken from the binary distribution of torque-3.0-b2. I tried also "ant -f build-torque project-create-db" in the torque directory and the create-db.sql contains lines related to the "default" database.
Anyway, I followed your idea of updating createdb.vm and it's fine now. Frederic Roy Truelove wrote: > Hey Frederic, > > It seems that somewhere in the configs you have specificed a database > named "default".. I'd do a text search on the config files and see where it > might be popping up. If you actually do want a db named default, then take > a look at the createdb.vm file under Torque's templates\sql\db-init > directory for your specific database. If you edit that as needed, torque > should skip the steps you'd like to skip. > > Take it easy, > Roy > > ----- Original Message ----- > From: "Frederic Gedin" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Thursday, July 11, 2002 3:23 AM > Subject: Default database generated by Torque > > > >>Hello >> >> >>I started a brand new project and decided for this to start with the >>decoupled version of torque (3.0-b2). >> >>Everything works fine except that the target "project-create-db" >>generates instructions to create a database name "default" in addition >>to the creation of my application database. >> >>create-db.sql: >>drop database if exists default; <-- I don't need this one >>create database default; <-- This one generates a syntax error >>drop database if exists sumo; <-- This is my database, it's OK >>create database sumo; >> >>Creation messages: >> [sql] Failed to execute: drop database if exists default >> [sql] java.sql.SQLException: Syntax error or access violation: >>You have an error in your SQL syntax near 'default' at line 1 >> [sql] Failed to execute: create database default >> [sql] java.sql.SQLException: Syntax error or access violation: >>You have an error in your SQL syntax near 'default' at line 1 >> [sql] 2 of 4 SQL statements executed successfully >> >> >>Is there a way to avoid such a behavior? >> >>Frederic >> >> >>-- >>To unsubscribe, e-mail: >> > <mailto:[EMAIL PROTECTED]> > >>For additional commands, e-mail: >> > <mailto:[EMAIL PROTECTED]> > > > -- > To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> > For additional commands, e-mail: <mailto:[EMAIL PROTECTED]> > -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
