I'll try it for you again when I get a chance. I didn't run any of the .sh scripts at first. I just ran 'ant junit' after configuring OJB for MySQL. I did run the .sh scripts at one point in time and I seem to recall having the path problem you mentioned with the binary tar, but I believed it worked in the source tar.
I also used MySQL 3.23. Eric -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Friday, June 13, 2003 5:08 AM To: [EMAIL PROTECTED] Subject: RE: RC3 Test Failures with MySQL I think the problem is on the ant build.xml ... like someone said (on another reply), there should be a filter somewhere... the problem is: it doesnt exist. Modifying the @---@ parameters it will work only in your environment... the next time someone else install OJB (and use it with MySQL), it has to figure out what has happened and do it all over again. Ant should do everything by itself... you should one only have to say what you want ant to do (prepare-tutorials, compile,...). Even though, these errors occur, the schema is written to the database, the data also and the tutorial works (at least in my case). I had to change all of the bin scripts because they were missing some ../ on some paths ( BUG ) to run the tutorials with: cd bin ./tutorialX.sh (maybe if you do this, you will see that you can run the tutorials, even with the error messages) The unique message could be because of the MySQL database version... i am using 3.23 ... maybe in 4.XX? or the mapping isnt correct (it makes sense that all parts of a primary key must be not null). (assuming that the tutorial preparation with MySQL has worked, at least once, without giving any error messages) I used the root mysql account to run the ant command and it still gave me the same messages. (no problem with user database permissions) Pedro Salgado ------- P&G -----Message d'origine----- First modify @DATABASE_DEFAULT@ by a name (objtest) I don't remember where u modify this :P When you configure your connection, try to give the login and pass to the root(if u have not modify Login:root and they have no pass). It should work better. If it didnt work better add another user to your database,then grant him with all create, delete insert, drop for each table. it should work a few :-) -----Message d'origine----- De : Eric Northam [mailto:[EMAIL PROTECTED] Envoye : vendredi 6 juin 2003 15:41 A : '[EMAIL PROTECTED]' Objet : RC3 Test Failures with MySQL <mailto:[EMAIL PROTECTED]> I grabbed the source RC3 distro and ran the the unit tests under MySQL and received the following errors were printed out: [torque-create-db] Resolver: used database.dtd from org.apache.torque.engine.database.transform package [sql] Executing file: C:\jakarta\db-ojb-1.0.rc3.src\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 SQ L syntax near '@DATABASE_DEFAULT@' <mailto:'@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 SQ L syntax near '@DATABASE_DEFAULT@' <mailto:'@DATABASE_DEFAULT@'> at line 1" [sql] 0 of 2 SQL statements executed successfully ... [torque-insert-sql] Failed to execute: CREATE TABLE REF_REPOSITORY_FK ( REP_ID INTEGER NOT NULL, REF_FK INTEGER, REFA_FK INTEGER, REFB_FK INTEGER, NAME VARCHAR (100), PRIMARY KEY(REP_ID,REF_FK,REFA_FK,REFB_FK) ) [torque-insert-sql] java.sql.SQLException: General error, message from server: "All parts of a PRIMARY KEY must be NOT NULL; If you need NULL in a key, use UNIQUE instead" Here's the summary: junit-no-compile-no-prepare: [junit] Running org.apache.ojb.broker.AllTests [junit] Tests run: 209, Failures: 4, Errors: 4, Time elapsed: 95.652 sec [junit] TEST org.apache.ojb.broker.AllTests FAILED [junit] Running org.apache.ojb.odmg.AllTests [junit] [BOOT] INFO: OJB.properties: file:/C:/jakarta/db-ojb-1.0.rc3.src/target/test/ojb/OJB.properties [junit] Tests run: 156, Failures: 3, Errors: 1, Time elapsed: 25.426 sec [junit] TEST org.apache.ojb.odmg.AllTests FAILED [junit] Running org.apache.ojb.soda.AllTests [junit] [BOOT] INFO: OJB.properties: file:/C:/jakarta/db-ojb-1.0.rc3.src/target/test/ojb/OJB.properties [junit] Tests run: 3, Failures: 0, Errors: 0, Time elapsed: 6.649 sec [junit] Running org.apache.ojb.otm.AllTests [junit] Tests run: 1, Failures: 0, Errors: 0, Time elapsed: 7.17 sec I didn't see anything posted on the todo.html page so I assume they shouldn't occur. DISCLAIMER: The information contained in this e-mail is, unless otherwise indicated, confidential and is intended solely for the use of the named addressee. Access, copying or re-use of the e-mail or any information contained therein by any other person is not authorized. If you are not the intended recipient please notify us immediately by returning the e-mail to the originator. --------------------------------------------------------------------- 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] DISCLAIMER: The information contained in this e-mail is, unless otherwise indicated, confidential and is intended solely for the use of the named addressee. Access, copying or re-use of the e-mail or any information contained therein by any other person is not authorized. If you are not the intended recipient please notify us immediately by returning the e-mail to the originator.
