Bug #26541 Can not add data to a table with a SMALLINT column through JDBC (in MatLab)
Submitted: 21 Feb 2007 20:10 Modified: 23 Feb 2007 22:16
Reporter: [ name withheld ] Email Updates:
Status: Closed Impact on me:
Category:Connector / J Severity:S3 (Non-critical)
Version:3.1.8 OS:Linux (SUSE)
Assigned to: CPU Architecture:Any

[21 Feb 2007 20:10] [ name withheld ]
Trying to insert data using fastinsert in MatLab into a table with a column of type SMALLINT UNSIGNED results in the following error (the weird characters included):

??? No method 'setShort' with matching signature found for class 'com.mysql.jdbc.ServerPreparedStatement'.

Error in ==> database.fastinsert at 161
            StatementObject.setShort(j,tmp)  ����������������

How to repeat:
1. create a table with a column of type SMALLINT UNSIGNED
2. open a connection to the table in MatLab using the JDBC connector
3. use fastinsert() to insert data into the table
[21 Feb 2007 21:24] Mark Matthews
First, try upgrading to a newer version of Connector/J (5.0.4 is the current stable version). I looked, and that method exists, so without seeing what Matlab's doing reflection-wise to try and find the method, I won't be able to reproduce this on my own.

Let us know if 5.0.4 doesn't solve the issue for you.
[23 Feb 2007 22:16] [ name withheld ]
Thanks Mark. I wasn't aware of the newer version. I've tested it and this bug seems to not be present in 5.0.4.