I'm using mysql-4.1.2b-alpha-win.zip and mysql-connector-java-3.1.2-alpha.zip
to access db via JDBC.

The column is mediumint(9)
It was created using type mediumint, somehow it was changed to mdiumint(9)
I think there may be a problem in the size...

java.sql.SQLException: Unknown type '9 in column 0 of 3 in binary-encoded result set.
 at com.mysql.jdbc.MysqlIO.unpackBinaryResultSetRow(MysqlIO.java:3888)
 at com.mysql.jdbc.MysqlIO.nextRow(MysqlIO.java:1211)
 at com.mysql.jdbc.MysqlIO.readSingleRowSet(MysqlIO.java:2036)
 at com.mysql.jdbc.MysqlIO.getResultSet(MysqlIO.java:395)
 at com.mysql.jdbc.MysqlIO.readResultsForQueryOrUpdate(MysqlIO.java:1824)
 at com.mysql.jdbc.MysqlIO.readAllResults(MysqlIO.java:1278)
 at 
com.mysql.jdbc.ServerPreparedStatement.serverExecute(ServerPreparedStatement.java:1283)
 at 
com.mysql.jdbc.ServerPreparedStatement.executeInternal(ServerPreparedStatement.java:903)
 at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1622)

Any ideas to correct this? Or any workarounds?

Reply via email to