I Downloaded DB2 7.2 UDB last night to start testing. I will be testing on the
following:
Oracle 9i
SQL Server 2000
DB2 7.2 UDB
HSQLDB
MYSQL
PostGres
SAP DB
I'm trying to find a way to automate the testing and post the results back to the
group.
cheers,
Matthew
-----Original Message-----
From: Russell Smyth [mailto:[EMAIL PROTECTED]]
Sent: Tue 10/15/2002 7:15 AM
To: 'OJB Users List'
Cc:
Subject: RE: OJB on AS400
I will also be using OJB against AS400 - our initial testing was with the
straight DB2 profile, and so
far has worked ok (minimal read-only testing). Unfortunately it may be a
week or so before I get to do
more testing (other priorities :-( )
The error reports you are reciving look similar (number of failures, etc) to
what I see on DB2/UDB - Windows, so I am guessing there is some work to be
done there - untill recently it has not been easy
to run the tests against DB2.
If you are running against DB2 or AS400 it would be advisable to get ojb and
torque from CVS,
as there have been several recent improvements to torque and ojb relating to
db2. Some of
these changes may also need to be moved to the 400.. I haven't quite dug
into that yet.
Also, be sure you are using the latest Java Toolbox for AS400 drivers.
Please keep us posted with your 400/OJB experiences - it will be crucial to
me at least!
Russell
> -----Original Message-----
> From: teletype [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, October 15, 2002 5:10 AM
> To: [EMAIL PROTECTED]
> Subject: OJB on AS400
>
>
> Hello,
>
> I'm developing for the AS400 platform and would like to use
> OJB for persistence. I've adapted the db2 profile to create
> on for DB2 on AS400 and replaced turbine-3.0-b3 with
> turbine-3.0-b4 and its dependent jars.
> The prepare-testdb have been run succesfully. After that
> I've tried junit that conluded with a lot of errors.
>
> Hereby I include it for review:
>
> E:\jakarta-ojb-0.9.7>ant junit
> Buildfile: build.xml
>
> set-archive-name:
>
> set-archive-name-date:
>
> detect-jdk:
>
> use-jdk12:
>
> use-jdk13:
>
> use-jdk14:
> [echo] detected JDK 1.4
>
> init:
>
> prepare:
>
> preprocess:
> [echo] using switches: +JDK13, +JDBC30
>
> [java] .....................................................
> ...............
> ............................................................
> ....................
> ............................................................
> ....................
> ............................................................
> ....................
> ............................................................
> ....................
> ............................................................
> ....................
> ............................................................
> ....................
> ...............................
>
> [java] .....................................................
> ...............
> ............................................................
> ....................
> ..................................................
>
> main:
> [javac] Compiling 579 source files to E:\jakarta-ojb-
> 0.9.7\target\classes
> [javac] E:\jakarta-ojb-0.9.7
> \target\src\org\apache\ojb\broker\util\pooling\W
> rappedPreparedStatement.java:481: warning: setUnicodeStream
> (int,java.io.InputStr
> eam,int) in java.sql.PreparedStatement has been deprecated
> [javac] public void setUnicodeStream(int
> parameterIndex, InputStream x,
> int length)
> [javac] ^
> [javac] E:\jakarta-ojb-0.9.7
> \target\src\org\apache\ojb\broker\util\pooling\W
> rappedPreparedStatement.java:485: warning: setUnicodeStream
> (int,java.io.InputStr
> eam,int) in java.sql.PreparedStatement has been deprecated
> [javac] pstmt.setUnicodeStream(parameterIndex,
> x, length);
> [javac] ^
> [javac] 2 warnings
> [javac] Compiling 198 source files to E:\jakarta-ojb-
> 0.9.7\target\classestes
> t
>
> useP6Spy:
>
> dontUseP6Spy:
> [echo] NOT using P6Spy
>
> prepare-repository:
> [delete] Deleting directory E:\jakarta-ojb-0.9.7
> \target\test
> [copy] Copying 14 files to E:\jakarta-ojb-0.9.7
> \target\test\ojb
> [copy] Copying 1 file to E:\jakarta-ojb-0.9.7
> \target\test
> [copy] Copying 1 file to E:\jakarta-ojb-0.9.7
> \target\test
>
> prepare-testdb:
>
> project-sql-classpath:
> [echo] +------------------------------------------+
> [echo] | |
> [echo] | Generating SQL for OJB Testsuite! |
> [echo] | enJoy! |
> [echo] | |
> [echo] +------------------------------------------+
> [torque-sql] Using contextProperties file: E:\jakarta-ojb-
> 0.9.7\build.properties
>
> [torque-sql] Using classpath
> [torque-sql] Generating to file E:\jakarta-ojb-0.9.7
> \target\src\sql\report.ojbte
> st.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
> [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
>
> project-create-db-classpath:
>
> project-datasql-classpath:
> [echo] +-----------------------------------------------
> +
> [echo] |
> |
> [echo] | Generating SQL from data XML !
> |
> [echo] | enJoy!
> |
> [echo] |
> |
> [echo] +-----------------------------------------------
> +
> [echo] taking build.properties from: build.properties
> [torque-datasql] Using contextProperties file: E:\jakarta-
> ojb-0.9.7\build.proper
> ties
> [torque-datasql] Using classpath
> [torque-datasql] Generating to file E:\jakarta-ojb-0.9.7
> \target\src\sql\ojbtest-
> data.sql
> [torque-datasql] Resolver: used database.dtd from
> org.apache.torque.engine.datab
> ase.transform package
> [torque-datasql] Resolver: used database.dtd from
> org.apache.torque.engine.datab
> ase.transform package
> [torque-datasql] Resolver: used E:\jakarta-ojb-0.9.7
> \src\schema\ojbtest-data.dtd
>
> [torque-datasql] Error Line: 128 Row: 11 Msg: The content
> of element type "datas
> et" must
> match "(Article*,Books*,Cds*,ProductGroup*,OrderPosition*,Tr
> ee*,Treegro
> up*,AbTable*,Product*,Person*,Project*,Task*,PersonProject*,
> FamilyMember*,Locked
> ByVersion*,LockedByTimestamp*,BlobTest*,MdtestMaster*,Mdtest
> DetailFkinpk*,Mdtest
> DetailFknopk*,GraphNode*,GraphEdge*,Point*)".
>
> project-insert-sql:
> [torque-insert-sql] Our new url ->
> jdbc:as400://appello2/OJBTEST
> [torque-insert-sql] Executing file: E:\jakarta-ojb-0.9.7
> \target\src\sql\ojbtest-
> schema.sql
> [torque-insert-sql] Executing file: E:\jakarta-ojb-0.9.7
> \target\src\sql\ojbcore-
> schema.sql
> [torque-insert-sql] Executing file: E:\jakarta-ojb-0.9.7
> \target\src\sql\ojbtest-
> data.sql
> [torque-insert-sql] 291 of 291 SQL statements executed
> successfully
>
> junit-no-compile-no-prepare:
> [junit] Running org.apache.ojb.broker.AllTests
> [junit] [BOOT] INFO: OJB.properties: file:/E:/jakarta-
> ojb-0.9.7/target/test/
> ojb/OJB.properties
> [junit] Tests run: 124, Failures: 68, Errors: 47, Time
> elapsed: 21,782 sec
> [junit] java.lang.OutOfMemoryError
> [junit] Exception in thread "main"
> [junit] TEST org.apache.ojb.broker.AllTests FAILED
> [junit] Running org.apache.ojb.odmg.AllTests
> [junit] [BOOT] INFO: OJB.properties: file:/E:/jakarta-
> ojb-0.9.7/target/test/
> ojb/OJB.properties
> [junit] Tests run: 128, Failures: 11, Errors: 39, Time
> elapsed: 18,596 sec
> [junit] java.lang.OutOfMemoryError
> [junit] Exception in thread "main"
> [junit] TEST org.apache.ojb.odmg.AllTests FAILED
> [junit] Running org.apache.ojb.soda.AllTests
> [junit] [BOOT] INFO: OJB.properties: file:/E:/jakarta-
> ojb-0.9.7/target/test/
> ojb/OJB.properties
> [junit] Tests run: 3, Failures: 3, Errors: 0, Time
> elapsed: 6,229 sec
> [junit] TEST org.apache.ojb.soda.AllTests FAILED
>
> junit-no-compile:
>
> junit:
>
> BUILD SUCCESSFUL
> Total time: 4 minutes 57 seconds
>
> Regards.
>
>
>
>
> --
> To unsubscribe, e-mail:
> <mailto:[EMAIL PROTECTED]>
> For additional commands, e-mail:
> <mailto:[EMAIL PROTECTED]>
>
--
To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
<<winmail.dat>>
-- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
