Hi, > The test fails (see at the end of this message: Failed to execute: ECHO could be ignored (indicate hsql does not support 'ECHO' command)
> Not implemented and further : "Tests run: 156, Failures: 1, Errors: 0, > Time elapsed: 10,594 sec"). > > Is this normal ? Yes, using the CVS. That's why we write test cases ;-) Normally all failures will be fixed till next release. No, first time I heared that rc3 has a failure running the test suite (using default configuration) against hsql. Have a look in the junit log files to see what's going wrong. ([db-ojb]/target/test/test-xxx.txt) regards, Armin ----- Original Message ----- From: "Semiosys (Elie Naulleau)" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, June 04, 2003 11:23 AM Subject: junit tests failed for hsql and mysql (RC3) > > I try to run the command suggested inthe ojb doc after its installation > to make sure everything works: > > bin/build.sh junit > > I did this with the RC3 release of ojb and with the cvs version too. > > The test fails (see at the end of this message: Failed to execute: ECHO > Not implemented and further : "Tests run: 156, Failures: 1, Errors: 0, > Time elapsed: 10,594 sec"). > > Is this normal ? > > > Furthermore, I tried to switch from hsql to mysql, changing the database > profile to mysql, creating an ojb database and rerun the junit tests. > The tests failed again and generated errors and failires (the ojb > database was however populated with multiple tables and records inside > the tables). > It seems first that torque is generating invalid sql for mysql : > > [torque-create-db] Resolver: used database.dtd from > org.apache.torque.engine.database.transform package > [sql] Executing file: > C:\devkit\ojb\jakarta-ojb\target\src\sql\create-db.sql > [sql] Failed to execute: drop database if exists > @DATABASE_DEFAULT@ > [sql] java.sql.SQLException: 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 '@DATABASE_DEFAULT@' at line 1" > [sql] Failed to execute: create database @DATABASE_DEFAULT@ > [sql] java.sql.SQLException: 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 '@DATABASE_DEFAULT@' at line 1" > [sql] 0 of 2 SQL statements executed successfully > > > Did you experience the same and how did you fixed that ? > > > Thanks a lot, > Elie > > > Extract of the bin/build command log : > > getJSQLDriver: > > project-sql-classpath: > [echo] +------------------------------------------+ > [echo] | | > [echo] | Generating SQL for OJB Testsuite! | > [echo] | enJoy! | > [echo] | | > [echo] +------------------------------------------+ > [torque-sql] Using contextProperties file: > C:\devkit\ojb\jakarta-ojb\build.properties > [torque-sql] Using classpath > [torque-sql] Generating to file > C:\devkit\ojb\jakarta-ojb\target\src\sql\report.ojbtest.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 > > project-create-db-classpath: > [echo] > [echo] driver="org.hsqldb.jdbcDriver" > [echo] url="jdbc:hsqldb:target/test/OJB" > [echo] userid="sa" > [echo] password="" > [echo] > [torque-create-db] Using classpath > [torque-create-db] Generating to file > C:\devkit\ojb\jakarta-ojb\target\src\sql\create-db.sql > [torque-create-db] Resolver: used database.dtd from > org.apache.torque.engine.database.transform package > [torque-create-db] Resolver: used database.dtd from > org.apache.torque.engine.database.transform package > [sql] Executing file: > C:\devkit\ojb\jakarta-ojb\target\src\sql\create-db.sql > [sql] Failed to execute: ECHO Not implemented > [sql] java.sql.SQLException: Unexpected token: ECHO in statement > [ECHO Not implemented] > [sql] 0 of 1 SQL statements executed successfully > > 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: > C:\devkit\ojb\jakarta-ojb\build.properties > [torque-datasql] Using classpath > [torque-datasql] Generating to file > C:\devkit\ojb\jakarta-ojb\target\src\sql\ojbtest-data.sql > [torque-datasql] Resolver: used database.dtd from > org.apache.torque.engine.database.transform package > [torque-datasql] Resolver: used > C:\devkit\ojb\jakarta-ojb\src\schema\ojbtest-data.dtd > > project-insert-sql: > [torque-insert-sql] Our new url -> jdbc:hsqldb:target/test/OJB > [torque-insert-sql] Executing file: > C:\devkit\ojb\jakarta-ojb\target\src\sql\ojbtest-schema.sql > [torque-insert-sql] Executing file: > C:\devkit\ojb\jakarta-ojb\target\src\sql\ojbcore-schema.sql > [torque-insert-sql] Executing file: > C:\devkit\ojb\jakarta-ojb\target\src\sql\ojbtest-data.sql > [torque-insert-sql] 261 of 261 SQL statements executed successfully > > junit-no-compile-no-prepare: > [junit] Running org.apache.ojb.broker.AllTests > [junit] Tests run: 225, Failures: 0, Errors: 0, Time elapsed: 23,61 > sec > [junit] Running org.apache.ojb.odmg.AllTests > [junit] [BOOT] INFO: OJB.properties: > file:/C:/devkit/ojb/jakarta-ojb/target/test/ojb/OJB.properties > [junit] Tests run: 156, Failures: 1, Errors: 0, Time elapsed: 10,594 > sec > [junit] TEST org.apache.ojb.odmg.AllTests FAILED > [junit] Running org.apache.ojb.soda.AllTests > [junit] [BOOT] INFO: OJB.properties: > file:/C:/devkit/ojb/jakarta-ojb/target/test/ojb/OJB.properties > [junit] Tests run: 3, Failures: 0, Errors: 0, Time elapsed: 5 sec > [junit] Running org.apache.ojb.otm.AllTests > [junit] Tests run: 56, Failures: 0, Errors: 1, Time elapsed: 7,203 > sec > [junit] TEST org.apache.ojb.otm.AllTests FAILED > > junit-no-compile: > > junit: > > > > --------------------------------------------------------------------- > 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]
