Hello,

I have a case, where the new serverside prepared statements fail to execute, whereas the old-style java driver prepared statements correctly executes. I suspect it might be due to a ';' character in an enclosed string, but I am not sure. Here is the stack trace with driver's extra debug info:

Query being executed when exception was thrown:

com.mysql.jdbc.ServerPreparedStatement[27] - INSERT INTO PBDCompany(mulCompanyId, muiSectorId, msCode, msKnownAs, msName, msOfficialName, mdtFounded, mulAddressId, mulInvoiceAddressId, mulMailAddressId, mulPersonId, mulContactId, msTaxNo, msTaxOffice, msCountryCode, msDescription, msExtProps, mulType, muiProcessId, muhStateId, mulUpdUserId, mdtUpdTime, mulInsUserId, mdtInsTime, mulUpdCnt, mulSrvUpdCnt) VALUES(10103, null, 'MCM', 'HELI AIR MONACO', 'HELI AIR MONACO', 'HELI AIR MONACO', '1976-01-01 00:00:00', 10103, null, null, null, 10081, null, null, 'MC', null, 'EXEC:Jacques Crovetto;', 0, 5, 1, NULL, NULL, 1, '2004-09-16 15:37:32', 0, 0)

2004-09-16 15:37:44,590 INFO [STDOUT] at com.mysql.jdbc.ServerPreparedStatement.executeBatch(ServerPreparedStatement. java:803)

2004-09-16 15:37:44,590 INFO [STDOUT] at org.jboss.resource.adapter.jdbc.WrappedStatement.executeBatch(WrappedStateme nt.java:759)

.. (some more)

Hope the above explains the situation.

More info on my environment:

Linux miranda.lan 2.6.8-1.521 #1 Mon Aug 16 09:01:18 EDT 2004 i686 i686 i386 GNU/Linux

MySQL Ver 14.6 Distrib 4.1.4-gamma, for pc-linux (i686)

Connector/J 3.1.4-beta

j2sdk-1.4.2_05

(the same error also happens in Windows version of MySQL server 4.1.4-gamma.)

Regards,

Gokhan Demir