On Monday, November 26, 2001, at 12:26 PM, Martin Poeschl wrote:
> btw. i'm testing torque on linux + mysql/postgres/oracle
>
> it would be great if anyone could run the tests on any other platform /
> rdbms and send the results!
Martin, Jason,
Finally got my repositories in order here at home so I could help test
Torque.
I had to update ant to get the test to work. What's the minimum version
of ant required? I know that it is > 1.3 and <= 1.4.1. It would be
useful to include that in the README.txt. I thought I'd ask before
changing README.txt myself to specify that 1.4.1 or better is required.
I updated to the latest code from CVS at about 8:30 pm Mountain Time
November 26.
-Eric
Here's a diff of my testProfile (I'm using the jdbc jar distributed with
PostgreSQL):
<diff>
Index: profile/postgres.profile
===================================================================
RCS file: /home/cvs/jakarta-turbine-torque/profile/postgres.profile,v
retrieving revision 1.6
diff -u -r1.6 postgres.profile
--- profile/postgres.profile 2001/11/24 17:42:38 1.6
+++ profile/postgres.profile 2001/11/27 03:55:12
@@ -1,7 +1,7 @@
# location of jar that you will be using for testing
# so that it can be copied into the dist/lib directory.
-torque.testDatabaseJar = ${lib.repo}/postgres7.2dev.jar
+torque.testDatabaseJar = ${lib.repo}/postgresql.jar
torque.idMethod = idbroker
torque.defaultDatabase = bookstore
@@ -67,7 +67,7 @@
createDatabaseUrl = jdbc:postgresql://127.0.0.1:5432/template1
databaseUrl = jdbc:postgresql://127.0.0.1:5432/bookstore
databaseDriver = org.postgresql.Driver
-databaseUser = mpoeschl
+databaseUser = dobbs
databasePassword =
databaseHost = 127.0.0.1
</diff>
And here's the test results:
<testResults>
[localhost:~/java/projects/jakarta-turbine-torque] dobbs% ant test
Buildfile: build.xml
init:
check.velocity:
check.xerces:
check.village:
check.log4j:
check.commons-collections:
check.commons-util:
check.jdbc:
env:
[echo] java.home =
/System/Library/Frameworks/JavaVM.framework/Versions/1.3.1/Home
[echo] user.home = /Users/dobbs
[echo] lib.repo = /Users/dobbs/java/lib
[echo] village.jar = /Users/dobbs/java/lib/village-1.5.2.jar
[echo] velocity.jar = /Users/dobbs/java/lib/velocity-1.3-dev.jar
[echo] xerces.jar = /Users/dobbs/java/lib/xerces-1.4.3.jar
[echo] log4j.jar = /Users/dobbs/java/lib/log4j-1.1.3.jar
[echo] jdbc.jar = /Users/dobbs/java/lib/jdbc2_0-stdext.jar
[echo] junit.jar = /Users/dobbs/java/lib/junit-3.7.jar
[echo] commons-collections.jar =
/Users/dobbs/java/lib/commons-collections.jar
[echo] commons-util.jar = /Users/dobbs/java/lib/commons-
util-0.1-dev.jar
prepare:
[mkdir] Created dir:
/Users/dobbs/java/projects/jakarta-turbine-torque/bin
[mkdir] Created dir:
/Users/dobbs/java/projects/jakarta-turbine-torque/bin/classes
compile:
[javac] Compiling 80 source files to
/Users/dobbs/java/projects/jakarta-turbine-torque/bin/classes
[copy] Copying 1 file to
/Users/dobbs/java/projects/jakarta-turbine-
torque/bin/classes/org/apache/torque/engine/database/transform
jar:
[jar] Building jar:
/Users/dobbs/java/projects/jakarta-turbine-torque/bin/torque-1.0.jar
test:
filterTokens:
test-libs:
[mkdir] Created dir:
/Users/dobbs/java/projects/jakarta-turbine-torque/bin/test/lib
[copy] Copying 1 file to
/Users/dobbs/java/projects/jakarta-turbine-torque/bin/test/lib
[copy] Copying 1 file to
/Users/dobbs/java/projects/jakarta-turbine-torque/bin/test/lib
[copy] Copying 1 file to
/Users/dobbs/java/projects/jakarta-turbine-torque/bin/test/lib
[copy] Copying 1 file to
/Users/dobbs/java/projects/jakarta-turbine-torque/bin/test/lib
[copy] Copying 1 file to
/Users/dobbs/java/projects/jakarta-turbine-torque/bin/test/lib
[copy] Copying 1 file to
/Users/dobbs/java/projects/jakarta-turbine-torque/bin/test/lib
[copy] Copying 1 file to
/Users/dobbs/java/projects/jakarta-turbine-torque/bin/test/lib
[copy] Copying 1 file to
/Users/dobbs/java/projects/jakarta-turbine-torque/bin/test/lib
[copy] Copying 1 file to
/Users/dobbs/java/projects/jakarta-turbine-torque/bin/test/lib
test-templates:
[copy] Copying 155 files to
/Users/dobbs/java/projects/jakarta-turbine-torque/bin/test/templates
[copy] Copied 1 empty directory to
/Users/dobbs/java/projects/jakarta-turbine-torque/bin/test/templates
test:
[echo] Copying profile into distribution directory:
profile/postgres.profile
[copy] Copying 1 file to
/Users/dobbs/java/projects/jakarta-turbine-torque/bin/test/rttest
[copy] Copying 2 files to
/Users/dobbs/java/projects/jakarta-turbine-torque/bin/test/rttest/schema
[copy] Copying 5 files to
/Users/dobbs/java/projects/jakarta-turbine-
torque/bin/test/rttest/src/java
[copy] Copying 1 file to
/Users/dobbs/java/projects/jakarta-turbine-torque/bin/test/rttest
test-pre-runtime:
test-create-db:
project-create-db:
[torque-create-db] Generating to file
/Users/dobbs/java/projects/jakarta-turbine-
torque/bin/test/rttest/src/sql/create-db.sql
[torque-create-db] Resolver: used database.dtd from
org.apache.torque.engine.database.transform package
[torque-create-db] Resolver: used database.dtd from
org.apache.torque.engine.database.transform package
[sql] Executing file:
/Users/dobbs/java/projects/jakarta-turbine-
torque/bin/test/rttest/src/sql/create-db.sql
[sql] 2 of 2 SQL statements executed successfully
test-project-sql:
project-sql:
[echo] +------------------------------------------+
[echo] | |
[echo] | Generating SQL for YOUR Turbine project! |
[echo] | Woo hoo! |
[echo] | |
[echo] +------------------------------------------+
[torque-sql] Generating to file
/Users/dobbs/java/projects/jakarta-turbine-
torque/bin/test/rttest/src/sql/report.torque.sql.generation
[torque-sql] Resolver: used database.dtd from
org.apache.torque.engine.database.transform package
[torque-sql] Resolver: used database.dtd from
org.apache.torque.engine.database.transform package
test-id-table-init-sql:
id-table-init-sql:
[echo] +------------------------------------------+
[echo] | |
[echo] | Generating initialization SQL |
[echo] | for ID Broker system! |
[echo] | |
[echo] +------------------------------------------+
[torque-sql] Generating to file
/Users/dobbs/java/projects/jakarta-turbine-
torque/bin/test/rttest/src/sql/postgresql-id-table-init.sql
[torque-sql] Resolver: used database.dtd from
org.apache.torque.engine.database.transform package
[torque-sql] Resolver: used database.dtd from
org.apache.torque.engine.database.transform package
test-project-insert-sql:
project-insert-sql:
[torque-insert-sql] Our new url ->
jdbc:postgresql://127.0.0.1:5432/bookstore
[torque-insert-sql] Executing file:
/Users/dobbs/java/projects/jakarta-turbine-
torque/bin/test/rttest/src/sql/id-table-schema.sql
[torque-insert-sql] Failed to execute: drop table ID_TABLE
[torque-insert-sql] java.sql.SQLException: ERROR: table "id_table" does
not exist
[torque-insert-sql] Executing file:
/Users/dobbs/java/projects/jakarta-turbine-
torque/bin/test/rttest/src/sql/bookstore-schema.sql
[torque-insert-sql] Failed to execute: drop table book
[torque-insert-sql] java.sql.SQLException: ERROR: table "book" does not
exist
[torque-insert-sql] Failed to execute: drop table author
[torque-insert-sql] java.sql.SQLException: ERROR: table "author" does
not exist
[torque-insert-sql] Executing file:
/Users/dobbs/java/projects/jakarta-turbine-
torque/bin/test/rttest/src/sql/bookstore-schema-idtable-init.sql
[torque-insert-sql] 7 of 10 SQL statements executed successfully
test-project-om:
project-om:
[echo] +------------------------------------------+
[echo] | |
[echo] | Generating Peer-based Object Model for |
[echo] | YOUR Turbine project! Woo hoo! |
[echo] | |
[echo] +------------------------------------------+
[torque-om] Generating to file
/Users/dobbs/java/projects/jakarta-turbine-
torque/bin/test/rttest/src/java/report.torque.om.generation
[torque-om] Resolver: used database.dtd from
org.apache.torque.engine.database.transform package
[torque-om] Resolver: used database.dtd from
org.apache.torque.engine.database.transform package
compile:
[mkdir] Created dir:
/Users/dobbs/java/projects/jakarta-turbine-
torque/bin/test/rttest/bin/classes
[javac] Compiling 11 source files to
/Users/dobbs/java/projects/jakarta-turbine-
torque/bin/test/rttest/bin/classes
filterTokens:
test-runtime:
[echo]
/Users/dobbs/java/lib/log4j-1.1.3.jar
/Users/dobbs/java/lib/jdbc2_0-stdext.jar
/Users/dobbs/java/lib/commons-collections.jar
/Users/dobbs/java/lib/commons-util-0.1-dev.jar
/Users/dobbs/java/lib/village-1.5.2.jar
./bin/classes
./bin/test/rttest/bin/classes
/Users/dobbs/java/lib/postgresql.jar
[copy] Copying 1 file to
/Users/dobbs/java/projects/jakarta-turbine-torque/bin/test/rttest
test-post-runtime:
test-project-datadtd:
project-datadtd:
[echo] +-----------------------------------------------+
[echo] | |
[echo] | Generating Data DTD for YOUR Turbine project! |
[echo] | Woo hoo! |
[echo] | |
[echo] +-----------------------------------------------+
[torque-datadtd] Generating to file
/Users/dobbs/java/projects/jakarta-turbine-
torque/bin/test/rttest/src/report.bookstore.datadtd.generation
[torque-datadtd] Resolver: used database.dtd from
org.apache.torque.engine.database.transform package
[torque-datadtd] Resolver: used database.dtd from
org.apache.torque.engine.database.transform package
test-project-datadump:
project-datadump:
[echo] +-----------------------------------------------+
[echo] | |
[echo] | Dumping the data from database into XML |
[echo] | Woo hoo! |
[echo] | |
[echo] +-----------------------------------------------+
[echo] taking build.properties from: build.properties
[torque-datadump] Generating to file
/Users/dobbs/java/projects/jakarta-turbine-
torque/bin/test/rttest/src/report.bookstore.datadump.generation
[torque-datadump] Resolver: used database.dtd from
org.apache.torque.engine.database.transform package
[torque-datadump] Resolver: used database.dtd from
org.apache.torque.engine.database.transform package
[torque-datadump] Fetching data for table book
[torque-datadump] Fetching data for table author
..........................................................................
....................................
test-project-jdbc:
project-jdbc:
[echo] +-----------------------------------------------+
[echo] | |
[echo] | Generating XML from JDBC connection ! |
[echo] | Woo hoo! |
[echo] | |
[echo] +-----------------------------------------------+
[echo] taking build.properties from: build.properties
[torque-jdbc] Torque - JDBCToXMLSchema starting
[torque-jdbc]
[torque-jdbc] Your DB settings are:
[torque-jdbc] driver : org.postgresql.Driver
[torque-jdbc] URL : jdbc:postgresql://127.0.0.1:5432/bookstore
[torque-jdbc] user : dobbs
[torque-jdbc] password :
[torque-jdbc] schema : ${databaseSchema}
[torque-jdbc] DB driver sucessfuly instantiated
[torque-jdbc] DB connection established
[torque-jdbc] Getting table list...
[torque-jdbc] Building column/table map...
[torque-jdbc] Processing table: id_table
[torque-jdbc] java.lang.NullPointerException
[torque-jdbc] java.lang.NullPointerException
[torque-jdbc] at
org.apache.torque.task.TorqueJDBCTransformTask.getForeignKeys
(TorqueJDBCTransformTask.java:514)
[torque-jdbc] at
org.apache.torque.task.TorqueJDBCTransformTask.generateXML
(TorqueJDBCTransformTask.java:276)
[torque-jdbc] at
org.apache.torque.task.TorqueJDBCTransformTask.execute
(TorqueJDBCTransformTask.java:197)
[torque-jdbc] at
org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:104)
[torque-jdbc] at org.apache.tools.ant.Task.perform(Task.java:217)
[torque-jdbc] at org.apache.tools.ant.Target.execute(Target.java:184)
[torque-jdbc] at
org.apache.tools.ant.Target.performTasks(Target.java:202)
[torque-jdbc] at
org.apache.tools.ant.Project.executeTarget(Project.java:601)
[torque-jdbc] at
org.apache.tools.ant.taskdefs.Ant.execute(Ant.java:266)
[torque-jdbc] at org.apache.tools.ant.Task.perform(Task.java:217)
[torque-jdbc] at org.apache.tools.ant.Target.execute(Target.java:184)
[torque-jdbc] at
org.apache.tools.ant.Target.performTasks(Target.java:202)
[torque-jdbc] at
org.apache.tools.ant.Project.executeTarget(Project.java:601)
[torque-jdbc] at
org.apache.tools.ant.taskdefs.Ant.execute(Ant.java:266)
[torque-jdbc] at
org.apache.tools.ant.taskdefs.CallTarget.execute(CallTarget.java:120)
[torque-jdbc] at org.apache.tools.ant.Task.perform(Task.java:217)
[torque-jdbc] at org.apache.tools.ant.Target.execute(Target.java:184)
[torque-jdbc] at
org.apache.tools.ant.Target.performTasks(Target.java:202)
[torque-jdbc] at
org.apache.tools.ant.Project.executeTarget(Project.java:601)
[torque-jdbc] at
org.apache.tools.ant.taskdefs.Ant.execute(Ant.java:266)
[torque-jdbc] at
org.apache.tools.ant.taskdefs.CallTarget.execute(CallTarget.java:120)
[torque-jdbc] at org.apache.tools.ant.Task.perform(Task.java:217)
[torque-jdbc] at org.apache.tools.ant.Target.execute(Target.java:184)
[torque-jdbc] at
org.apache.tools.ant.Target.performTasks(Target.java:202)
[torque-jdbc] at
org.apache.tools.ant.Project.executeTarget(Project.java:601)
[torque-jdbc] at
org.apache.tools.ant.taskdefs.Ant.execute(Ant.java:266)
[torque-jdbc] at org.apache.tools.ant.Task.perform(Task.java:217)
[torque-jdbc] at org.apache.tools.ant.Target.execute(Target.java:184)
[torque-jdbc] at
org.apache.tools.ant.Target.performTasks(Target.java:202)
[torque-jdbc] at
org.apache.tools.ant.Project.executeTarget(Project.java:601)
[torque-jdbc] at
org.apache.tools.ant.Project.executeTargets(Project.java:560)
[torque-jdbc] at org.apache.tools.ant.Main.runBuild(Main.java:454)
[torque-jdbc] at org.apache.tools.ant.Main.start(Main.java:153)
[torque-jdbc] at org.apache.tools.ant.Main.main(Main.java:176)
[torque-jdbc]
[torque-jdbc] Torque - JDBCToXMLSchema finished
BUILD SUCCESSFUL
Total time: 46 seconds
[localhost:~/java/projects/jakarta-turbine-torque] dobbs%
</testResults>
--
To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
