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]>
