You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@turbine.apache.org by Eric Dobbs <er...@dobbse.net> on 2001/12/01 01:42:29 UTC
Re: more successful Torque tests: oracle and sapdb -- not exactly
Hi All.
I ran the tests against SAP DB and Oracle from a Win2K box.
SAP DB worked fine. But Oracle choked on the data-dump.
So I double-checked the Oracle test again from OS X and it
is choking in the same way. I must not have been paying
attention when I ran the tests earlier.
Here are some details:
On Friday, November 30, 2001, at 09:49 AM, Eric Dobbs wrote:
> Here's the version info for the Databases
> Oracle version: Oracle8 Enterprise Edition Release 8.0.5.1.0 -
> Production
> Linux Kernel: Linux version 2.2.14-5.0smp
>
> SAP DB version: Kernel 7.3.0 Build 008-000-054-008
> Windows 2000: 5.00.2195 Service Pack 1
Torque is installed on the same Windows 2000 box.
-Eric
ps. If I can make the time, I'll see if I can test from Win2K to
PostgreSQL on OS X next week.
D:\java\projects\jakarta-turbine-torque>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 = d:\jdk1.3\jre
[echo] user.home = D:\Documents and Settings\edobbs
[echo] lib.repo = d:/java/lib
[echo] village.jar = d:/java/lib/village-1.5.2.jar
[echo] velocity.jar = d:/java/lib/velocity-1.3-dev.jar
[echo] xerces.jar = d:/java/lib/xerces-1.4.4.jar
[echo] log4j.jar = d:/java/lib/log4j-1.1.3.jar
[echo] jdbc.jar = d:/java/lib/jdbc2_0-stdext.jar
[echo] junit.jar = d:/java/lib/junit-3.7.jar
[echo] commons-collections.jar = d:/java/lib/commons-collections.jar
[echo] commons-util.jar = d:/java/lib/commons-util-0.1-dev.jar
prepare:
compile:
jar:
test:
filterTokens:
test-libs:
test-templates:
test:
[echo] Copying profile into distribution directory:
profile/dobbs.oracle.profile
[copy] Copying 1 file to D:\java\projects\jakarta-turbine-
torque\bin\test\rttest
[copy] Copying 2 files to D:\java\projects\jakarta-turbine-
torque\bin\test\rttest\schema
[copy] Copying 1 file to D:\java\projects\jakarta-turbine-
torque\bin\test\rttest
test-pre-runtime:
test-create-db:
project-create-db:
[torque-create-db] Generating to file
D:\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: D:\java\projects\jakarta-turbine-
torque\bin\test\rttest\src\sql\create-db.sql
[sql] 0 of 0 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 D:\java\projects\jakarta-turbine-
torque\bin\test\rttest\src\sql\report.torque.sql.genera
tion
[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 D:\java\projects\jakarta-turbine-
torque\bin\test\rttest\src\sql\oracle-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:oracle:thin:@linuxdb:1521:dev
[torque-insert-sql] Executing file:
D:\java\projects\jakarta-turbine-
torque\bin\test\rttest\src\sql\id-table-schema.sql
[torque-insert-sql] Executing file:
D:\java\projects\jakarta-turbine-
torque\bin\test\rttest\src\sql\bookstore-schema.sql
[torque-insert-sql] Executing file:
D:\java\projects\jakarta-turbine-
torque\bin\test\rttest\src\sql\bookstore-schema-idt
able-init.sql
[torque-insert-sql] 13 of 13 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 D:\java\projects\jakarta-turbine-
torque\bin\test\rttest\src\java\report.torque.om.generat
ion
[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:
[javac] Compiling 6 source files to
D:\java\projects\jakarta-turbine-torque\bin\test\rttest\bin\classes
filterTokens:
test-runtime:
[echo]
d:/java/lib/log4j-1.1.3.jar
d:/java/lib/jdbc2_0-stdext.jar
d:/java/lib/commons-collections.jar
d:/java/lib/commons-util-0.1-dev.jar
d:/java/lib/village-1.5.2.jar
./bin/classes
./bin/test/rttest/bin/classes
d:/java/lib/oracle_jdbc.jar
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
D:\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
D:\java\projects\jakarta-turbine-
torque\bin\test\rttest\src\report.bookstore.datadu
mp.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] SQLException :
[torque-datadump] java.sql.SQLException: Invalid operation for forward
only resultset : isLast
[torque-datadump] at
oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:168)
[torque-datadump] at
oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:210)
[torque-datadump] at
oracle.jdbc.driver.OracleResultSetImpl.isLast(OracleResultSetImpl.java:288)
[torque-datadump] at
org.apache.torque.task.TorqueDataDumpTask$TableTool.hasNext
(TorqueDataDumpTask.java:351)
[torque-datadump] at
org.apache.velocity.runtime.directive.Foreach.render(Foreach.java:340)
[torque-datadump] at
org.apache.velocity.runtime.parser.node.ASTDirective.render(ASTDirective.java:
153)
[torque-datadump] at
org.apache.velocity.runtime.parser.node.ASTBlock.render(ASTBlock.java:94)
[torque-datadump] at
org.apache.velocity.runtime.directive.Foreach.render(Foreach.java:344)
[torque-datadump] at
org.apache.velocity.runtime.parser.node.ASTDirective.render(ASTDirective.java:
153)
[torque-datadump] at
org.apache.velocity.runtime.parser.node.ASTBlock.render(ASTBlock.java:94)
[torque-datadump] at
org.apache.velocity.runtime.directive.Foreach.render(Foreach.java:344)
[torque-datadump] at
org.apache.velocity.runtime.parser.node.ASTDirective.render(ASTDirective.java:
153)
[torque-datadump] at
org.apache.velocity.runtime.parser.node.ASTBlock.render(ASTBlock.java:94)
[torque-datadump] at
org.apache.velocity.runtime.directive.Foreach.render(Foreach.java:344)
[torque-datadump] at
org.apache.velocity.runtime.parser.node.ASTDirective.render(ASTDirective.java:
153)
[torque-datadump] at
org.apache.velocity.runtime.parser.node.SimpleNode.render(SimpleNode.java:
271)
[torque-datadump] at
org.apache.velocity.Template.merge(Template.java:296)
[torque-datadump] at
org.apache.velocity.texen.Generator.parse(Generator.java:360)
[torque-datadump] at
org.apache.velocity.texen.ant.TexenTask.execute(TexenTask.java:521)
[torque-datadump] at
org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:104)
[torque-datadump] at
org.apache.tools.ant.Task.perform(Task.java:217)
[torque-datadump] at
org.apache.tools.ant.Target.execute(Target.java:184)
[torque-datadump] at
org.apache.tools.ant.Target.performTasks(Target.java:202)
[torque-datadump] at
org.apache.tools.ant.Project.executeTarget(Project.java:601)
[torque-datadump] at
org.apache.tools.ant.taskdefs.Ant.execute(Ant.java:266)
[torque-datadump] at
org.apache.tools.ant.Task.perform(Task.java:217)
[torque-datadump] at
org.apache.tools.ant.Target.execute(Target.java:184)
[torque-datadump] at
org.apache.tools.ant.Target.performTasks(Target.java:202)
[torque-datadump] at
org.apache.tools.ant.Project.executeTarget(Project.java:601)
[torque-datadump] at
org.apache.tools.ant.taskdefs.Ant.execute(Ant.java:266)
[torque-datadump] at
org.apache.tools.ant.taskdefs.CallTarget.execute(CallTarget.java:120)
[torque-datadump] at
org.apache.tools.ant.Task.perform(Task.java:217)
[torque-datadump] at
org.apache.tools.ant.Target.execute(Target.java:184)
[torque-datadump] at
org.apache.tools.ant.Target.performTasks(Target.java:202)
[torque-datadump] at
org.apache.tools.ant.Project.executeTarget(Project.java:601)
[torque-datadump] at
org.apache.tools.ant.taskdefs.Ant.execute(Ant.java:266)
[torque-datadump] at
org.apache.tools.ant.taskdefs.CallTarget.execute(CallTarget.java:120)
[torque-datadump] at
org.apache.tools.ant.Task.perform(Task.java:217)
[torque-datadump] at
org.apache.tools.ant.Target.execute(Target.java:184)
[torque-datadump] at
org.apache.tools.ant.Target.performTasks(Target.java:202)
[torque-datadump] at
org.apache.tools.ant.Project.executeTarget(Project.java:601)
[torque-datadump] at
org.apache.tools.ant.taskdefs.Ant.execute(Ant.java:266)
[torque-datadump] at
org.apache.tools.ant.Task.perform(Task.java:217)
[torque-datadump] at
org.apache.tools.ant.Target.execute(Target.java:184)
[torque-datadump] at
org.apache.tools.ant.Target.performTasks(Target.java:202)
[torque-datadump] at
org.apache.tools.ant.Project.executeTarget(Project.java:601)
[torque-datadump] at
org.apache.tools.ant.Project.executeTargets(Project.java:560)
[torque-datadump] at
org.apache.tools.ant.Main.runBuild(Main.java:454)
[torque-datadump] at org.apache.tools.ant.Main.start(Main.java:153)
[torque-datadump] at org.apache.tools.ant.Main.main(Main.java:176)
[torque-datadump] Fetching data for table author
[torque-datadump] SQLException :
[torque-datadump] java.sql.SQLException: Invalid operation for forward
only resultset : isLast
[torque-datadump] at
oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:168)
[torque-datadump] at
oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:210)
[torque-datadump] at
oracle.jdbc.driver.OracleResultSetImpl.isLast(OracleResultSetImpl.java:288)
[torque-datadump] at
org.apache.torque.task.TorqueDataDumpTask$TableTool.hasNext
(TorqueDataDumpTask.java:351)
[torque-datadump] at
org.apache.velocity.runtime.directive.Foreach.render(Foreach.java:340)
[torque-datadump] at
org.apache.velocity.runtime.parser.node.ASTDirective.render(ASTDirective.java:
153)
[torque-datadump] at
org.apache.velocity.runtime.parser.node.ASTBlock.render(ASTBlock.java:94)
[torque-datadump] at
org.apache.velocity.runtime.directive.Foreach.render(Foreach.java:344)
[torque-datadump] at
org.apache.velocity.runtime.parser.node.ASTDirective.render(ASTDirective.java:
153)
[torque-datadump] at
org.apache.velocity.runtime.parser.node.ASTBlock.render(ASTBlock.java:94)
[torque-datadump] at
org.apache.velocity.runtime.directive.Foreach.render(Foreach.java:344)
[torque-datadump] at
org.apache.velocity.runtime.parser.node.ASTDirective.render(ASTDirective.java:
153)
[torque-datadump] at
org.apache.velocity.runtime.parser.node.ASTBlock.render(ASTBlock.java:94)
[torque-datadump] at
org.apache.velocity.runtime.directive.Foreach.render(Foreach.java:344)
[torque-datadump] at
org.apache.velocity.runtime.parser.node.ASTDirective.render(ASTDirective.java:
153)
[torque-datadump] at
org.apache.velocity.runtime.parser.node.SimpleNode.render(SimpleNode.java:
271)
[torque-datadump] at
org.apache.velocity.Template.merge(Template.java:296)
[torque-datadump] at
org.apache.velocity.texen.Generator.parse(Generator.java:360)
[torque-datadump] at
org.apache.velocity.texen.ant.TexenTask.execute(TexenTask.java:521)
[torque-datadump] at
org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:104)
[torque-datadump] at
org.apache.tools.ant.Task.perform(Task.java:217)
[torque-datadump] at
org.apache.tools.ant.Target.execute(Target.java:184)
[torque-datadump] at
org.apache.tools.ant.Target.performTasks(Target.java:202)
[torque-datadump] at
org.apache.tools.ant.Project.executeTarget(Project.java:601)
[torque-datadump] at
org.apache.tools.ant.taskdefs.Ant.execute(Ant.java:266)
[torque-datadump] at
org.apache.tools.ant.Task.perform(Task.java:217)
[torque-datadump] at
org.apache.tools.ant.Target.execute(Target.java:184)
[torque-datadump] at
org.apache.tools.ant.Target.performTasks(Target.java:202)
[torque-datadump] at
org.apache.tools.ant.Project.executeTarget(Project.java:601)
[torque-datadump] at
org.apache.tools.ant.taskdefs.Ant.execute(Ant.java:266)
[torque-datadump] at
org.apache.tools.ant.taskdefs.CallTarget.execute(CallTarget.java:120)
[torque-datadump] at
org.apache.tools.ant.Task.perform(Task.java:217)
[torque-datadump] at
org.apache.tools.ant.Target.execute(Target.java:184)
[torque-datadump] at
org.apache.tools.ant.Target.performTasks(Target.java:202)
[torque-datadump] at
org.apache.tools.ant.Project.executeTarget(Project.java:601)
[torque-datadump] at
org.apache.tools.ant.taskdefs.Ant.execute(Ant.java:266)
[torque-datadump] at
org.apache.tools.ant.taskdefs.CallTarget.execute(CallTarget.java:120)
[torque-datadump] at
org.apache.tools.ant.Task.perform(Task.java:217)
[torque-datadump] at
org.apache.tools.ant.Target.execute(Target.java:184)
[torque-datadump] at
org.apache.tools.ant.Target.performTasks(Target.java:202)
[torque-datadump] at
org.apache.tools.ant.Project.executeTarget(Project.java:601)
[torque-datadump] at
org.apache.tools.ant.taskdefs.Ant.execute(Ant.java:266)
[torque-datadump] at
org.apache.tools.ant.Task.perform(Task.java:217)
[torque-datadump] at
org.apache.tools.ant.Target.execute(Target.java:184)
[torque-datadump] at
org.apache.tools.ant.Target.performTasks(Target.java:202)
[torque-datadump] at
org.apache.tools.ant.Project.executeTarget(Project.java:601)
[torque-datadump] at
org.apache.tools.ant.Project.executeTargets(Project.java:560)
[torque-datadump] at
org.apache.tools.ant.Main.runBuild(Main.java:454)
[torque-datadump] at org.apache.tools.ant.Main.start(Main.java:153)
[torque-datadump] at org.apache.tools.ant.Main.main(Main.java:176)
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 : oracle.jdbc.driver.OracleDriver
[torque-jdbc] URL : jdbc:oracle:thin:@linuxdb:1521:dev
[torque-jdbc] user : dobbs
[torque-jdbc] password : dobbs
[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]
[torque-jdbc] Torque - JDBCToXMLSchema finished
BUILD SUCCESSFUL
Total time: 32 seconds
--
To unsubscribe, e-mail: <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>