krummas/DrizzleJDBC — Issue #2: useAffectedRows property for MySQL
Author: mtillberg
Created: 2012-01-03 19:24:20+00:00
State: open

Add support for useAffectedRows property in MySQL connections. From the MySQL 5.1 jdbc driver source, this appears to be enabled by default, and seems to be required for JDBC compliance (see http://dev.mysql.com/doc/refman/5.0/en/connector-j-reference-configuration-properties.html). I would suggest adding the following to the constructor in org/drizzle/jdbc/internal/mysql/MySQLProtocol.java:

if(!"true".equals(info.getProperty("useAffectedRows"))) {
capabilities.add(MySQLServerCapabilities.FOUND_ROWS);
}