Mysql unit test questions

[Andrew McCall <am...@cy-nap.com>]

Hi,

	I've compiled OJB with bin\build.bat jar under windows and the unit tests 
run fine. Then as the next step I modified the build.properties and 
mysql.profile to point to my mysql server (the latest stable version) and 
ran the unit tests again, this is what I get:
	
junit-no-compile-no-prepare:
     [junit] Running org.apache.ojb.broker.AllTests
     [junit] Tests run: 247, Failures: 4, Errors: 2, Time elapsed: 96.709 sec
     [junit] TEST org.apache.ojb.broker.AllTests FAILED
     [junit] Running org.apache.ojb.odmg.AllTests
     [junit] [BOOT] INFO: OJB.properties: 
file:/C:/temp/db-ojb-1.0.rc4/target/test/ojb/OJB.properties
     [junit] Tests run: 160, Failures: 2, Errors: 0, Time elapsed: 21.17 sec
     [junit] TEST org.apache.ojb.odmg.AllTests FAILED
     [junit] Running org.apache.ojb.soda.AllTests
     [junit] [BOOT] INFO: OJB.properties: 
file:/C:/temp/db-ojb-1.0.rc4/target/test/ojb/OJB.properties
     [junit] Tests run: 3, Failures: 0, Errors: 0, Time elapsed: 4.026 sec
     [junit] Running org.apache.ojb.otm.AllTests
     [junit] Tests run: 73, Failures: 0, Errors: 0, Time elapsed: 19.408 sec

The tests it is failing are all rollback tests (it expects <77> found <87> 
or something similar) and the errors are SQLExceptions on two sub query 
tests. Since mysql 4.0 doesn't support either, is this normal? If it is 
what is the impact and are there any pitfalls that I should watch out for 
when using ojb?

Cheers,
Andrew 



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