db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Trey Long <james_l...@provima.com>
Subject Re: Create-db
Date Thu, 13 Oct 2005 17:03:44 GMT
Ahhhh. For some reason that didn't click with me. I love stupid 
mistakes, they are so easy to resolve.

Hilco Wijbenga wrote:

>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: torque-user-unsubscribe@db.apache.org
>>For additional commands, e-mail: torque-user-help@db.apache.org
>>
>>    
>>
>
>
>---------------------------------------------------------------------
>To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
>For additional commands, e-mail: torque-user-help@db.apache.org
>
>  
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message