[OJB-developers] "tests" target results against MySql

SourceForge Headquarters 225 Broadway Suite 1600 San Diego, CA 92101 +1 (858) 422-6466

Hi,

These are the messages I get when I run the OJB "tests" target with a =
MySql database
(after following the steps in =
http://objectbridge.sourceforge.net/rdbms-support.html. Yeah, I ran the =
target twice :-)

C:\Java\ojb-0.7.343>build tests
Buildfile: build.xml

init:

prepare:

tests:
     [move] Moving 1 files to C:\Java\ojb-0.7.343\src\test\setup
using switches: -HSQLDB, -ORACLE, -MS_ACCESS, -INSTANTDB, -DB2, =
-POSTGRESQL, +MY
SQL, -INFORMIX
.
     [move] Moving 1 files to C:\Java\ojb-0.7.343\src\test\setup
     [copy] Copying 1 files to C:\Java\ojb-0.7.343\build\test\setup
     [java] [BOOT] INFO: DB url:  jdbc:mysql://localhost:3306/ojbtest
     [java] [BOOT] INFO: Driver:  Mark Matthews' MySQL Driver
     [java] [BOOT] INFO: Version: 2.0.11
     [java] [BOOT] ERROR: General error: Unknown table 'blob_test'
     [java] java.sql.SQLException: General error: Unknown table =
'blob_test'
     [java]     at org.gjt.mm.mysql.MysqlIO.sendCommand(Unknown Source)
     [java]     at org.gjt.mm.mysql.MysqlIO.sqlQueryDirect(Unknown =
Source)
     [java]     at org.gjt.mm.mysql.MysqlIO.sqlQuery(Unknown Source)
     [java]     at org.gjt.mm.mysql.Connection.execSQL(Unknown Source)
     [java] [BOOT] ERROR: Syntax error or access violation: You have an =
error in
 your SQL syntax near 'LONGVARBINARY, CLOB_VALUE_ LONGVARCHAR )' at line =
1
     [java]     at org.gjt.mm.mysql.Connection.execSQL(Unknown Source)
     [java]     at org.gjt.mm.mysql.Statement.executeUpdate(Unknown =
Source)
     [java]     at =
org.gjt.mm.mysql.jdbc2.Statement.executeUpdate(Unknown Source
)
     [java]     at ojb.broker.util.SampleThread.run(ScriptTool.java:541)
     [java]     at java.lang.Thread.run(Thread.java:484)
     [java] java.sql.SQLException: Syntax error or access violation: You =
have an
 error in your SQL syntax near 'LONGVARBINARY, CLOB_VALUE_ LONGVARCHAR =
)' at lin
e 1
     [java]     at org.gjt.mm.mysql.MysqlIO.sendCommand(Unknown Source)
     [java]     at org.gjt.mm.mysql.MysqlIO.sqlQueryDirect(Unknown =
Source)
     [java]     at org.gjt.mm.mysql.MysqlIO.sqlQuery(Unknown Source)
     [java]     at org.gjt.mm.mysql.Connection.execSQL(Unknown Source)
     [java]     at org.gjt.mm.mysql.Connection.execSQL(Unknown Source)
     [java]     at org.gjt.mm.mysql.Statement.executeUpdate(Unknown =
Source)
     [java]     at =
org.gjt.mm.mysql.jdbc2.Statement.executeUpdate(Unknown Source
)
     [java]     at ojb.broker.util.SampleThread.run(ScriptTool.java:541)
     [java]     at java.lang.Thread.run(Thread.java:484)
     [java] [BOOT] ERROR: General error: Unknown table 'ojb_nrm'
     [java] java.sql.SQLException: General error: Unknown table =
'ojb_nrm'
     [java]     at org.gjt.mm.mysql.MysqlIO.sendCommand(Unknown Source)
     [java]     at org.gjt.mm.mysql.MysqlIO.sqlQueryDirect(Unknown =
Source)
     [java]     at org.gjt.mm.mysql.MysqlIO.sqlQuery(Unknown Source)
     [java]     at org.gjt.mm.mysql.Connection.execSQL(Unknown Source)
     [java] [BOOT] ERROR: Invalid argument value: Too big column length =
for colu
mn 'OID_' (max =3D 255). Use BLOB instead
     [java]     at org.gjt.mm.mysql.Connection.execSQL(Unknown Source)
     [java]     at org.gjt.mm.mysql.Statement.executeUpdate(Unknown =
Source)
     [java]     at =
org.gjt.mm.mysql.jdbc2.Statement.executeUpdate(Unknown Source
)
     [java]     at ojb.broker.util.SampleThread.run(ScriptTool.java:541)
     [java]     at java.lang.Thread.run(Thread.java:484)
     [java] java.sql.SQLException: Invalid argument value: Too big =
column length
 for column 'OID_' (max =3D 255). Use BLOB instead
     [java]     at org.gjt.mm.mysql.MysqlIO.sendCommand(Unknown Source)
     [java]     at org.gjt.mm.mysql.MysqlIO.sqlQueryDirect(Unknown =
Source)
     [java]     at org.gjt.mm.mysql.MysqlIO.sqlQuery(Unknown Source)
     [java]     at org.gjt.mm.mysql.Connection.execSQL(Unknown Source)
     [java]     at org.gjt.mm.mysql.Connection.execSQL(Unknown Source)
     [java]     at org.gjt.mm.mysql.Statement.executeUpdate(Unknown =
Source)
     [java]     at =
org.gjt.mm.mysql.jdbc2.Statement.executeUpdate(Unknown Source
)
     [java]     at ojb.broker.util.SampleThread.run(ScriptTool.java:541)
     [java]     at java.lang.Thread.run(Thread.java:484)
     [java] [BOOT] ERROR: General error: Unknown table =
'ojb_dlist_entries'
     [java] java.sql.SQLException: General error: Unknown table =
'ojb_dlist_entri
es'
     [java]     at org.gjt.mm.mysql.MysqlIO.sendCommand(Unknown Source)
     [java]     at org.gjt.mm.mysql.MysqlIO.sqlQueryDirect(Unknown =
Source)
     [java]     at org.gjt.mm.mysql.MysqlIO.sqlQuery(Unknown Source)
     [java]     at org.gjt.mm.mysql.Connection.execSQL(Unknown Source)
     [java] [BOOT] ERROR: Invalid argument value: Too big column length =
for colu
mn 'OID_' (max =3D 255). Use BLOB instead
     [java]     at org.gjt.mm.mysql.Connection.execSQL(Unknown Source)
     [java]     at org.gjt.mm.mysql.Statement.executeUpdate(Unknown =
Source)
     [java]     at =
org.gjt.mm.mysql.jdbc2.Statement.executeUpdate(Unknown Source
)
     [java]     at ojb.broker.util.SampleThread.run(ScriptTool.java:541)
     [java]     at java.lang.Thread.run(Thread.java:484)
     [java] java.sql.SQLException: Invalid argument value: Too big =
column length
 for column 'OID_' (max =3D 255). Use BLOB instead
     [java]     at org.gjt.mm.mysql.MysqlIO.sendCommand(Unknown Source)
     [java]     at org.gjt.mm.mysql.MysqlIO.sqlQueryDirect(Unknown =
Source)
     [java]     at org.gjt.mm.mysql.MysqlIO.sqlQuery(Unknown Source)
     [java]     at org.gjt.mm.mysql.Connection.execSQL(Unknown Source)
     [java]     at org.gjt.mm.mysql.Connection.execSQL(Unknown Source)
     [java]     at org.gjt.mm.mysql.Statement.executeUpdate(Unknown =
Source)
     [java]     at =
org.gjt.mm.mysql.jdbc2.Statement.executeUpdate(Unknown Source
)
     [java]     at ojb.broker.util.SampleThread.run(ScriptTool.java:541)
     [java]     at java.lang.Thread.run(Thread.java:484)
          [java] [BOOT] ERROR: General error: Unknown table =
'ojb_dset_entries'
[java] java.sql.SQLException: General error: Unknown table =
'ojb_dset_entries'
     [java]     at org.gjt.mm.mysql.MysqlIO.sendCommand(Unknown Source)
     [java]     at org.gjt.mm.mysql.MysqlIO.sqlQueryDirect(Unknown =
Source)
     [java]     at org.gjt.mm.mysql.MysqlIO.sqlQuery(Unknown Source)
     [java]     at org.gjt.mm.mysql.Connection.execSQL(Unknown Source)
     [java]     at org.gjt.mm.mysql.Connection.execSQL(Unknown Source)
     [java]     at org.gjt.mm.mysql.Statement.executeUpdate(Unknown =
Source)
     [java]     at =
org.gjt.mm.mysql.jdbc2.Statement.executeUpdate(Unknown Source
)
     [java]     at ojb.broker.util.SampleThread.run(ScriptTool.java:541)
     [java] [BOOT] ERROR: Invalid argument value: Too big column length =
for colu
mn 'OID_' (max =3D 255). Use BLOB instead
     [java]     at java.lang.Thread.run(Thread.java:484)
     [java] java.sql.SQLException: Invalid argument value: Too big =
column length
 for column 'OID_' (max =3D 255). Use BLOB instead
     [java]     at org.gjt.mm.mysql.MysqlIO.sendCommand(Unknown Source)
     [java]     at org.gjt.mm.mysql.MysqlIO.sqlQueryDirect(Unknown =
Source)
     [java]     at org.gjt.mm.mysql.MysqlIO.sqlQuery(Unknown Source)
     [java]     at org.gjt.mm.mysql.Connection.execSQL(Unknown Source)
     [java]     at org.gjt.mm.mysql.Connection.execSQL(Unknown Source)
     [java]     at org.gjt.mm.mysql.Statement.executeUpdate(Unknown =
Source)
     [java]     at =
org.gjt.mm.mysql.jdbc2.Statement.executeUpdate(Unknown Source
)
     [java]     at ojb.broker.util.SampleThread.run(ScriptTool.java:541)
     [java]     at java.lang.Thread.run(Thread.java:484)
     [java] [BOOT] ERROR: General error: Unknown table =
'ojb_dmap_entries'
     [java] java.sql.SQLException: General error: Unknown table =
'ojb_dmap_entrie
s'
     [java]     at org.gjt.mm.mysql.MysqlIO.sendCommand(Unknown Source)
     [java]     at org.gjt.mm.mysql.MysqlIO.sqlQueryDirect(Unknown =
Source)
     [java]     at org.gjt.mm.mysql.MysqlIO.sqlQuery(Unknown Source)
     [java]     at org.gjt.mm.mysql.Connection.execSQL(Unknown Source)
     [java] [BOOT] ERROR: Invalid argument value: Too big column length =
for colu
mn 'KEY_OID' (max =3D 255). Use BLOB instead
     [java]     at org.gjt.mm.mysql.Connection.execSQL(Unknown Source)
     [java]     at org.gjt.mm.mysql.Statement.executeUpdate(Unknown =
Source)
     [java]     at =
org.gjt.mm.mysql.jdbc2.Statement.executeUpdate(Unknown Source
)
     [java]     at ojb.broker.util.SampleThread.run(ScriptTool.java:541)
     [java]     at java.lang.Thread.run(Thread.java:484)
     [java] java.sql.SQLException: Invalid argument value: Too big =
column length
 for column 'KEY_OID' (max =3D 255). Use BLOB instead
     [java]     at org.gjt.mm.mysql.MysqlIO.sendCommand(Unknown Source)
     [java]     at org.gjt.mm.mysql.MysqlIO.sqlQueryDirect(Unknown =
Source)
     [java]     at org.gjt.mm.mysql.MysqlIO.sqlQuery(Unknown Source)
     [java]     at org.gjt.mm.mysql.Connection.execSQL(Unknown Source)
     [java]     at org.gjt.mm.mysql.Connection.execSQL(Unknown Source)
     [java]     at org.gjt.mm.mysql.Statement.executeUpdate(Unknown =
Source)
     [java]     at =
org.gjt.mm.mysql.jdbc2.Statement.executeUpdate(Unknown Source
)
     [java]     at ojb.broker.util.SampleThread.run(ScriptTool.java:541)
     [java]     at java.lang.Thread.run(Thread.java:484)

BUILD SUCCESSFUL

Total time: 14 seconds
------------------------------------------------------------

I'm going to run the "performance" target tomorrow. I just wanted to =
understand why are all these exceptions about.
Looks like MySql support is broken with the defaults of the =
src\test\setup\db-setup.sql file=20

After the "successful" tests target, I tried to run the junit target and =
received 2 failures:

...   <snip> ...
    [junit] .[DEFAULT] WARN: problems with platform =
ojb.broker.platforms.Platfor
mMySQLImpl: ojb.broker.platforms.PlatformMySQLImpl
    [junit] [DEFAULT] WARN: OJB will use PlatformDefaultImpl instead
    [junit] .[DEFAULT] WARN: problems with platform =
ojb.broker.platforms.Platfor
mMySQLImpl: ojb.broker.platforms.PlatformMySQLImpl
    [junit] [DEFAULT] WARN: OJB will use PlatformDefaultImpl instead
    [junit] F
    [junit] Time: 53.888
    [junit] There were 2 failures:
    [junit] 1) =
testEscaping(test.ojb.broker.PersistenceBrokerTest)junit.framewor
k.AssertionFailedError: after inserting an object it should be equal to =
its re-r
ead pendant expected:<Single quote 'article > but was:<Single quote =
'article>
    [junit]     at =
test.ojb.broker.PersistenceBrokerTest.testEscaping(Persistenc
eBrokerTest.java:494)
    [junit] 2) =
testTimestampLock(test.ojb.broker.OptimisticLockingTest)junit.fra
mework.AssertionFailedError: Should throw an Optimistic Lock exception
    [junit]     at =
test.ojb.broker.OptimisticLockingTest.testTimestampLock(Optim
isticLockingTest.java:205)
    [junit]
    [junit] FAILURES!!!
    [junit] Tests run: 46,  Failures: 2,  Errors: 0
    [junit]

BUILD FAILED

C:\Java\ojb-0.7.343\build.xml:299: Java returned: -1

----------------------------------------------------------

I found an sql script to create the OJB internal tables for MySql in the =
sourceforge.net OJB forums while ago, and that is the schema I have been =
using before trying the new steps in the documentation. This is the =
first time I try to run the "tests" target. Besides the versioning =
tables, it looks like the schema hasn't changed, has it?

Here is the script:
http://sourceforge.net/forum/message.php?msg_id=3D1457503

I'll try to run the junit target against this schema, and post the =
results.

Aditional info:
MySql database version: 3.23.46
mm.mysql JDBC driver version: 2.0.11

Thanks in advance,

Ricardo Arguello