Problems with maven torque:create-db

[Mi...@RingPower.com]

Hello,

I have the following setup:

OS WIN2K Professional
JDK 1.4.2_08
MAVEN 1.0.2
Tom Cat 4.0
My SQL 4.1

I followed the directions in following post http://marc.theaimsgroup.com/?i
=%3C4225D189.8050809%20()%20chaos-inc%20!%20de%3Ehowever I am getting an
error when I do a maven torque:create-db.  The error I receive is:

torque:create-db:
    [torque-data-model] Using classpath
    [torque-data-model] Generating to file C:\Program Files\Apache Tomcat 4.0\webapps\ringpower\target\sql\create-db.sql

BUILD FAILED
File...... C:\Documents and Settings\Michael Mann\.maven\cache\maven-torque-plugin-3.1.1\plugin.jelly
Element... torque-data-model
Line...... 376
Column.... 49
org.apache.torque.engine.EngineException: java.net.UnknownHostException: database_3_1.dtd
Total time: 3 seconds
Finished at: Tue Apr 05 13:01:07 EDT 2005

When I execute this command it creates the schema files in the target/xml directory fine; however the sql created in target/sql is empty.
I did some debugging and set the create database manually flag to true and this was successful; however the sql file was not generated.  I have
downloaded the dtd for the schema files locally and set their references accordingly in the schema xml files.  I have reloaded the cache for the
torque and turbine jars,
 and I have still had no luck.

I used maven to set up my projecrt using maven -Dturbine.setup.properties= ./build.properties turbine:setup

I also set up the database in mysql and tested it from the command line to make sure the user below could access the database with mysql -h127.0.0.1
-unew-user -pnew-user-password; use new-database.

Any help on this matter would be appreciated.

My resulting build.properties file is below for reference:

# ------------------------------------------------------------------------
# P A R A M E T E R   F O R   B U I L D I N G
#
# $Id: build.properties,v 1.3 2004/10/31 16:11:36 henning Exp $
#
# ------------------------------------------------------------------------

#
# Application Server configuration
#
maven.appserver.home =      C:/Program Files/Apache Tomcat 4.0
maven.appserver.name =      tomcat

#
# Initial ID values for the ID_TABLE
#
initialID = 1100
initialIDValue = 100
initialIDStep = 10

torque.database.driver =    org.gjt.mm.mysql.Driver
torque.database.user =      new-user
torque.database.password =  new-user-password
torque.database.buildUrl =  jdbc:mysql://127.0.0.1/new-database
torque.database.createUrl = jdbc:mysql://127.0.0.1/

torque.database.manualCreation = true



---------------------------------------------------------------------
To unsubscribe, e-mail: turbine-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: turbine-user-help@jakarta.apache.org