RE: several junit test cases failed with RC3 running against db/2 v8

[Mahler Thomas <th...@itellium.com>]

Hi Akhil,


> Hi all,
> 
> I just ran junit target for RC3 and found  8 test cases 
> failed.. rest all
> passed.
> also there was one error in test-db creation... is this normal...

We do not check against DB2 on a regular basis, so I assume it's normal that
some things go out of sync.
If certain DDL statements fail the testcases relying on those tables are
doomed to fail...

cheers,
Thomas

> I had earlier ran all test cases with RC2 successfully.
> 
> Here is the summary of tests...
> 
> could not attach the bigger log (tests-broker.txt) becuase 
> mailer-daemon
> does not like big mails....
> Fine can mail if anybody is interested.
> 
> thanks in advance
> kumaakh
> 
> ====
> [torque-insert-sql] Our new url -> jdbc:db2:SAMPLE
> [torque-insert-sql] Executing file: C:
> \java\db-ojb-1.0.rc_3\target\src\sql\ojbte
> st-schema.sql
> [torque-insert-sql] Failed to execute: ALTER TABLE 
> REF_REPOSITORY_FK ADD
> PRIMARY
>  KEY (REP_ID,REF_FK,REFA_FK,REFB_FK)
> [torque-insert-sql] COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI
> Driver][DB2/NT] SQL
> 0542N  "REF_FK" cannot be a column of a primary key or unique 
> key because
> it can
>  contain null values.  SQLSTATE=42831
> [torque-insert-sql] Executing file: C:
> \java\db-ojb-1.0.rc_3\target\src\sql\ojbco
> re-schema.sql
> [torque-insert-sql] Executing file: C:
> \java\db-ojb-1.0.rc_3\target\src\sql\ojbte
> st-data.sql
> [torque-insert-sql] 427 of 428 SQL statements executed successfully
> 
> junit-no-compile-no-prepare:
>     [junit] Running org.apache.ojb.broker.AllTests
>     [junit] Tests run: 209, Failures: 4, Errors: 2, Time 
> elapsed: 45.225
> sec
>     [junit] TEST org.apache.ojb.broker.AllTests FAILED
>     [junit] Running org.apache.ojb.odmg.AllTests
>     [junit] [BOOT] INFO: OJB.properties:
> file:/C:/java/db-ojb-1.0.rc_3/target/te
> st/ojb/OJB.properties
>     [junit] Tests run: 156, Failures: 1, Errors: 1, Time 
> elapsed: 18.727
> sec
>     [junit] TEST org.apache.ojb.odmg.AllTests FAILED
>     [junit] Running org.apache.ojb.soda.AllTests
>     [junit] [BOOT] INFO: OJB.properties:
> file:/C:/java/db-ojb-1.0.rc_3/target/te
> st/ojb/OJB.properties
>     [junit] Tests run: 3, Failures: 0, Errors: 0, Time 
> elapsed: 3.575 sec
>     [junit] Running org.apache.ojb.otm.AllTests
>     [junit] Tests run: 1, Failures: 0, Errors: 0, Time 
> elapsed: 4.446 sec
> 
> junit-no-compile:
> 
> junit:
> 
> BUILD SUCCESSFUL
> Total time: 4 minutes 43 seconds
> ==================
> (See attached file: tests-broker.txt)
> (See attached file: tests-odmg.txt)
> (See attached file: tests-odmg.txt)
> 


---------------------------------------------------------------------
To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-user-help@db.apache.org