Bug #3921 | Data inserts using preparedStatement fail + hang db | ||
---|---|---|---|
Submitted: | 27 May 2004 23:17 | Modified: | 27 May 2004 23:44 |
Reporter: | Charles Syers | Email Updates: | |
Status: | Not a Bug | Impact on me: | |
Category: | Connector / J | Severity: | S2 (Serious) |
Version: | 3.1.1-alpha + 5.0.0-alpha-max | OS: | Windows (Windows XP / SP1) |
Assigned to: | Mark Matthews | CPU Architecture: | Any |
[27 May 2004 23:17]
Charles Syers
[27 May 2004 23:44]
Mark Matthews
This behavior happens because there are changes in MySQL-4.1's prepared statement protocol that have yet to be merged into 5.0, and supporting both versions of the protocol is not straightforward, and will not be supported (ever). You will either have to wait for MySQL-4.1.2 to be released, at which point all of the changes in 4.1.2 will be propagated into MySQL-5.0.1 before it is released, or you can disable server-side prepared statements by adding 'useServerPrepStmts=false' as a JDBC URL property.
[6 Jun 2004 22:22]
Koen Heene
I had a similar problem using ConnectorJ 3.1.1 with MySQL 4.1.2 Linux. (The problem did NOT happen when using ConnectorJ 3.1.1 with MySQL 4.1.1 Windows.) I solved the problem using the tip from Mark Matthews (useServerPrepStmts=false). But then again, isn't it better/more efficient to use useServerPrepStmts=true? It is a bit of a struggle to find out which version of ConnectorJ is -exactly- compatible with which version of MySQL daemon. Maybe a table in the docs would be nice. Koen Heene