Need help for OJB0.9.8 & mysql 3.23.52 on Linux 8.0 for var @DATABASE_DEFAULT@

["M.Abdur Rasheed" <ma...@hotmail.com>]

Hi all,

I'm using JDK 1.4, mysql 3.23.52 with ojb-0.9.8 on the Redhat 8.0. I 
configured the project.properties and profile/mysql.profile according. When 
there is database named ojb not available in the dbserver, it does not 
populate the databse. However when i createdan empty database manually it 
will populate the database.

In the bin/build.sh prepare-testdb following error occured.

      [sql] Executing file: 
/home/mura/jakarta-ojb-0.9.8/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: You 
have an error in your SQL syntax near '@DATABASE_DEFAULT@' at line 1
      [sql] Failed to execute: create database @DATABASE_DEFAULT@
      [sql] java.sql.SQLException: Syntax error or access violation: You 
have an error in your SQL syntax near '@DATABASE_DEFAULT@' at line 1
      [sql] 0 of 2 SQL statements executed successfully

In the bin/build.sh junit following error occured.

unit-no-compile-no-prepare:
    [junit] Running org.apache.ojb.broker.AllTests
    [junit] [BOOT] INFO: OJB.properties: 
file:/home/mura/jakarta-ojb-0.9.8/target/test/ojb/OJB.properties
    [junit] Tests run: 163, Failures: 4, Errors: 2, Time elapsed: 183.904 
sec
    [junit] TEST org.apache.ojb.broker.AllTests FAILED
    [junit] Running org.apache.ojb.odmg.AllTests
    [junit] [BOOT] INFO: OJB.properties: 
file:/home/mura/jakarta-ojb-0.9.8/target/test/ojb/OJB.properties
    [junit] Tests run: 144, Failures: 1, Errors: 0, Time elapsed: 116.315 
sec
    [junit] TEST org.apache.ojb.odmg.AllTests FAILED
    [junit] Running org.apache.ojb.soda.AllTests
    [junit] [BOOT] INFO: OJB.properties: 
file:/home/mura/jakarta-ojb-0.9.8/target/test/ojb/OJB.properties
    [junit] Tests run: 3, Failures: 0, Errors: 0, Time elapsed: 7.877 sec

junit-no-compile:

junit:


In the end I got the BUILD SUCCESSFUL message but there are Failures and 
errors which should not have to present. Attached are the outputs in files. 
bin/build.sh prepare-testdb output is in build-prepare-testdb-out and 
bin/build.sh junit output is in build-junit-out.

I really appriciate any help in this regard.

Regards
M. Abdur Rasheed



_________________________________________________________________
Add photos to your e-mail with MSN 8. Get 2 months FREE*. 
http://join.msn.com/?page=features/featuredemail