Hi there. I compiled TDK2.2 on Cygwin Win2k with a ssh tunnelled connection
to a Postgres 7.3 database.
In your HowTo, at D A T A B A S E S E T T I N G S, you only mention mySQL
Setup.
I feel the following should be mentioned:
Original:
database = mysql
databaseDriver = org.gjt.mm.mysql.Driver
databaseUrl = jdbc:mysql://localhost/newapp
The first 'database' relates to a directory located in
WEB-INF/lib/torque-3.0.jar called
sql/db-init . Do jar -tf ../lib/torque-3.0.jar to find out what your
database is called. I was doing postgres, and my directory was postgresql.
For the databaseDriver, ant will look in all jar files in WEB-INF/lib . Copy
your database driver in there. I had to put pg73jdbc3.jar in there to find
org.postgresql.Driver .
Also, on postgres, torque did not create the table. I hade to do createdb
newapp to get it to work.
So my postgres build.propertes section looked like:
# -------------------------------------------------------------------
#
# D A T A B A S E S E T T I N G S
#
# -------------------------------------------------------------------
#database.name = newapp
#database = ${target.database}
#createDatabaseUrl = ${createDatabaseUrl}
#buildDatabaseUrl = ${buildDatabaseUrl}
#databaseUrl = ${databaseUrl}
#databaseDriver = ${database.driver}
#databaseUser = ${databaseUser}
#databasePassword = ${databasePassword}
#databaseHost = ${databaseHost}
database = postgresql
databaseDriver = org.postgresql.Driver
databaseUrl = jdbc:postgresql://localhost/newapp
databaseUser = postgres
#databasePassword = dbPassword
databaseHost = localhost
torque.database.name = newapp
torque.database.manualCreation = false
torque.database.driver = org.postgresql.Driver
torque.database.createUrl = jdbc:postgresql://localhost/newapp
torque.database.buildUrl = jdbc:postgresql://localhost/newapp
torque.database.user = postgres
#torque.database.password = dbPassword
Don't forget I was ssh tunnelling the postgres port to a Linux Server [i.e.
-L 5432:127.0.0.1:5432 ]
If you could amend the HowTo to include this semantic type stuff, it would
help those trying it all out. [
http://jakarta.apache.org/turbine/tdk/tdk-howto.html ]
Cheers,
Terry.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
