Brian Lipa wrote:
[snip]
> EXCEPTION:
>
> 13:28:22,229 INFO java.sql.SQLException:
> Error during query: Unexpected Exception:
> java.lang.NegativeArraySizeException message
> given: null
>
> Nested Stack Trace:
>
>
> ** BEGIN NESTED EXCEPTION **
>
> java.lang.NegativeArraySizeException
>
> STACKTRACE:
>
> java.lang.NegativeArraySizeException
> at
> com.mysql.jdbc.MysqlIO.getResultSet(MysqlIO.java:2
> 80)
> at
> com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java
> :1325)
> at
> com.mysql.jdbc.MysqlIO.sqlQuery(MysqlIO.java:1224)
>
> at
> com.mysql.jdbc.Connection.execSQL(Connection.java:
> 2248)
> at
> com.mysql.jdbc.Connection.execSQL(Connection.java:
> 2208)
> at
> com.mysql.jdbc.Connection.execSQL(Connection.java:
> 2189)
> at
> com.mysql.jdbc.Connection.unsetMaxRows(Connection.
> java:2325)
> at
> com.mysql.jdbc.Statement.close(Statement.java:809)
>
> at
> com.mysql.jdbc.PreparedStatement.close(PreparedSta
> tement.java:1281)
[snip]
Brian,
What version of the JDBC driver is this? Since you're setting maxRows(), you might want to try Connector/J 3.1.6, as it has a more robust way of clearing the rest of the unused rows off the wire (or you could actually formulate your query to return the number of rows that you want, which is probably more efficient).
-Mark
Mark Matthews
Consulting Member Technical Staff - MySQL Enterprise Tools
Oracle
http://www.mysql.com/products/enterprise/monitor.html