The schema directory contains two files: my database schema and the id-table schema.
The generated sql files are: create-db.sql sumo-schema.sql id-table-schema.sql mysql-id-table-init.sql xptool-schema-idtable-init.sql I am afraid the error is not here! Frederic Nicholas Wheeler wrote: > 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]> > -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
