Frederic Have you looked in the schema directory to see if there is another some_database_name-schema.xml file under /schema or perhaps something in the generated SQL under src/sql/ ? Torque just looks for all files *-schema.xml and I believe excutes all .sql that it can find in those directories. I am grasping at straws here.
-Nicholas At 04:00 PM 7/12/2002 +0200, you wrote: >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]> -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
