Hi Nicholas
Extract from my sumo-schema.xml file: <database name="sumo" package="org.jaluna.sumo.om"> Extract from my Torque.properties file torque.database.default=sumo torque.database.sumo.driver = org.gjt.mm.mysql.Driver torque.database.sumo.url = jdbc:mysql://127.0.0.1/sumo torque.database.sumo.username = root torque.database.sumo.password = As you see, it seems to be correct. By the way, I tried to elimite the line "torque.database.default=sumo" but it did not change anything. Frederic Nicholas Wheeler wrote: > In your sumo-schema.xml file you need to be sure and name the database > there. > EX: <database name="sumo"> > > Then also in your Torque.properties specify > torque.database.default=sumo > torque.database.sumo.driver = > ... > > At 03:11 PM 7/12/2002 +0200, you wrote: > >> 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]> > > > > -- > 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]>
