Bug #25328 Resultset.getObject on a BIT(64) type returns java.lang.String

Description:
I am using MySql 5.0.27.
Driver : mysql connector/j 3.1.12

ResultSet.getObject() returns a java.lang.String instead of a bytearray.

How to repeat:
I have a table with the following DDL:

create table Binary_Tab (BINARY_VAL BIT(64) NULL);

I do the following from a JSP.

Connection conn = getConnection();//code omitted for getConnection()

    String insertString = "insert into Binary_Tab values(null)";
    Statement statement = conn.createStatement();
    statement.executeUpdate(insertString);

    byte[] bytearr = new byte[8];
    String sbyteval = null;
    // to get the bytearray value
    for (int count = 0; count < 8; count++) {
        sbyteval = Integer.toString(count % 255);
        bytearr[count] = Byte.parseByte(sbyteval);
    }

    String binTabUpdate = "update Binary_Tab set BINARY_VAL=?";
    PreparedStatement pstmt = conn.prepareStatement(binTabUpdate);
   pstmt.setObject(1,bytearr,java.sql.Types.BINARY);
    pstmt.executeUpdate();
    pstmt.close();
    String binTabQuery = "Select BINARY_VAL from Binary_Tab";
     ResultSet resultSet = statement.executeQuery(binTabQuery);
    resultSet.next();
     Object object = resultSet.getObject(1);
    System.out.println("resultSet.getObject(1).getClass() = " + object.getClass().getName());
    byte[] oRetVal = (byte[]) object;
   
   
    

It throws a ClassCastException when tryin to cast object to byte array as it is a java.lang.String object.

Thank you for a problem report. Please, try to repeat with a newer version, 3.1.14, and inform about the results.

Hi,

I tried the same with mysql connector/j 3.1.14. It still throws ClassCastException.

Hi Neha and thanks for your report.
According to http://dev.mysql.com/doc/refman/5.0/en/connector-j-reference-type-conversions.html we have a bug.

Verified as described with attached test case on
 - MySQL server 5.0.38BK on WinXP Pro SP2 localhost
 - c/J 3.1.15SVN and JDK 1.5.0_10

Test case

Attachment: TestBug25328.java (text/x-java), 1.94 KiB.

A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/22942

This is fixed in the 5.0 branch. It is not the class of bug that would make it into the "legacy" release of 3.1.

A note has been added to the 5.0.6 changelog.