search

krummas / DrizzleJDBC

A BSD licensed JDBC driver for Drizzle and MySQL
BSD 3-Clause "New" or "Revised" License
31 stars 22 forks source link

Is drizzle JDBC support autoreconnect connection string? #14

Open Haseena opened 11 years ago

Haseena commented 11 years ago

I am using MariaDB 5.5, I tested the auto reconnect feature of the server by setting wait_timeout parameter in the my.ini file. From my code, I created a connection string with autoreconnect option. It is worked fine with mysql jdbc connector. But using drizzle jdbc, it shows an error.

Error log is

SQLException information Error msg: Could not ping: Incomplete read! Expected 4, got -1 SQLSTATE: 08 Error code: -1 java.sql.SQLNonTransientConnectionException: Could not ping: Incomplete read! Expected 4, got -1 at org.drizzle.jdbc.internal.SQLExceptionMapper.get(SQLExceptionMapper.java:97) at org.drizzle.jdbc.DrizzleConnection.isValid(DrizzleConnection.java:950)

krummas commented 11 years ago

Hi

No it is not yet supported, it is quite difficult to get right with transactions etc

I might have a look and fix it soon