As you noticed, 'create-db' really only does the bare minimum to earn
its name. :-)
You need 'insert-sql' to create the tables and such. It will attempt to
execute your xyz-schema.sql file.
On Thu, 2005-10-13 at 11:16 -0400, Trey Long wrote:
> Create-Db seems to be stopping short of it's full task, let me see if I
> can explain my problem. Also, if you experts out there see any other
> problems with my configuration or whatever else I send over, please give
> me advice.
>
> I have torque deployed using ant and I am currently testing the process
> of going from MSSQL to MySql. I believe the 'ant create-db' is supposed
> to read the {projectname}-schema.xml and create the database via the
> connection properties in the build.properties file.
>
> If I have everything right so far let's move on, the only think that it
> generates in the 'source\sql\create-db.sql' file is this:
> drop database if exists torque;
> create database torque;
>
> Any ideas why it stops there? Ant doesn't seem to gripe about anything
> as far as I can tell either.
> create-db-check:
>
> create-db:
> [torque-data-model] Using classpath
> [torque-data-model] Generating to file *path*\trunk\source\sql\create-db.sql
> [torque-data-model] Oct 13, 2005 11:02:46 AM
> org.apache.torque.engine.database.transform.XmlToAppData parseFile
> [torque-data-model] INFO: Parsing file: 'test-schema.xml'
> [torque-data-model] Oct 13, 2005 11:02:46 AM
> org.apache.torque.engine.database.transform.DTDResolver resolveEntity
> [torque-data-model] INFO: Resolver: used database.dtd from
> 'org.apache.torque.engine.database.transform' package
> [echo]
> [echo] Executing the create-db.sql script ...
> [echo]
> [sql] Executing file: *path*\trunk\source\sql\create-db.sql
> [sql] 2 of 2 SQL statements executed successfully
>
> BUILD SUCCESSFUL
> Total time: 3 seconds
>
>
> And the config file seems ok to me.
> torque.project = test
> #MYSQL SECTION
> torque.database = mysql
> torque.database.type = mysql
> torque.database.adaptor = mysql
> torque.targetPackage = com.provima.pcsw.mysql
>
> torque.database.createUrl = jdbc:mysql://localhost/test
> torque.database.buildUrl = jdbc:mysql://localhost/test
> torque.database.driver = org.gjt.mm.mysql.Driver
> torque.database.user = root
> torque.database.password = password
> torque.database.host = localhost
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
>
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
