Hello Gus, As far as the newsgroup: its quality not quantity here :-)
I am using MySql4.0 with OJB. I am using the PersistenceBroker and ODMG APIs with good success. I am waiting until the JDO support is a little more solid before I switch over to that API. Bob c ---------------------------------------------------------------- Bob Celestino SAS Research and Development 919 - 531 - 9425 [EMAIL PROTECTED] SAS - The Power to Know > -----Original Message----- > From: Gus Heck [mailto:[EMAIL PROTECTED] > Sent: Tuesday, November 11, 2003 2:44 PM > To: OJB Users List > Subject: Re: Mysql4.0? > > > Wow this list is quiet. I'm used to Ant lists that are > 80+message a day > :).... > > Is anyone out there using MySQL 4.0 with OJB (particular for JDO) ? > > -Gus > > Gus Heck wrote: > > > Is MySQL 4.0 supported? > > > > I ran the regression tests against my database > (/usr/sbin/mysqld Ver > > 4.0.14-standard for pc-linux on i686) and got the following: > > > > junit-no-compile-no-prepare: > > [junit] Running org.apache.ojb.broker.AllTests > > [junit] Tests run: 247, Failures: 5, Errors: 2, Time elapsed: > > 41.511 sec > > > > > > [junit] TEST org.apache.ojb.broker.AllTests FAILED > > [junit] Running org.apache.ojb.odmg.AllTests > > [junit] [BOOT] INFO: OJB.properties: > > file:/home/gus/zip/db-ojb-1.0.rc4/target/test/ojb/OJB.properties > > [junit] Tests run: 160, Failures: 2, Errors: 0, Time elapsed: > > 11.521 sec > > > > > > [junit] TEST org.apache.ojb.odmg.AllTests FAILED > > [junit] Running org.apache.ojb.soda.AllTests > > [junit] [BOOT] INFO: OJB.properties: > > file:/home/gus/zip/db-ojb-1.0.rc4/target/test/ojb/OJB.properties > > [junit] Tests run: 3, Failures: 0, Errors: 0, Time > elapsed: 2.474 > > sec > > > > > > [junit] Running org.apache.ojb.otm.AllTests > > [junit] Tests run: 73, Failures: 0, Errors: 0, Time > elapsed: 14.209 > > sec > > > > when I tracked down the failing tests they turned out to be: > > > > ******** in broker.AllTests: > > > > Testcase: testSubQuery2 took 0.056 sec > > Caused an ERROR > > Syntax error or access violation, message from server: > "You have an > > error in your SQL syntax. Check the manual that > corresponds to your > > MySQL server version for the right syntax to use near > 'SELECT DISTINCT > > A0.Kategorie_Nr FROM Artikel A0)' at line 1" > > > > Testcase: testSubQuery2Testcase: testSubQuery1 took 0.018 sec > > Caused an ERROR > > Syntax error or access violation, message from server: > "You have an > > error in your SQL syntax. Check the manual that > corresponds to your > > MySQL server version for the right syntax to use near 'SELECT > > avg(A0.Einzelpreis) FROM Artikel A0 WHERE A0.Artikelname" > > > > Testcase: testReportPathExpressionForExtents2 took 0.005 sec > > FAILED > > Testcase: testDeleteWithRemovalAwareCollection took 0.018 sec > > FAILED > > Testcase: testUserRollbackClearCache took 0.299 sec > > FAILED > > Testcase: testUserRollbackClearCacheTestcase: > testUserRollback took > > 0.198 sec > > FAILED > > Testcase: testUserRollbackTestcase: testRollback took 0.031 sec > > FAILED > > > > ******** in odmg.AllTests: > > > > > > Testcase: testStoreThreePersons took 0.017 sec > > FAILED > > Testcase: testUserRollbackWithCheckpoint took 0.1 sec > > FAILED > > > > > > Are these known problems? Are they known to be harmless? > or am I in > > trouble here? > > > > -Gus > > > > > > > > > ------------------------------------------------------------ > --------- > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > For additional commands, e-mail: [EMAIL PROTECTED] > > > > > > ------------------------------------------------------------ > --------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
