[prev in list] [next in list] [prev in thread] [next in thread] 

List:       turbine-torque-user
Subject:    Re: Create-db
From:       Trey Long <james_long () provima ! com>
Date:       2005-10-13 17:03:44
Message-ID: 434E9370.7040604 () provima ! com
[Download RAW message or body]


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
>
>  
>


[prev in list] [next in list] [prev in thread] [next in thread]