Bug #20485 Updatable result sets don't support the BIT type

• Submitted: 15 Jun 2006 19:36
• Modified: 26 Jul 2006 18:17
• Reporter: Mark Matthews
• Status: Closed
• Category: Connector / J
• Severity: S3 (Non-critical)
• Version: 3.1.13
• OS: N/A
• Assigned to: Mark Matthews
• CPU Architecture: Any

[15 Jun 2006 19:36] Mark Matthews

Description:
From a comment on BUG#14609

I am having a different problem like this. I have FC5 supporting x86_64 OS with
MySQL 5.0.18 with connector/J 3.1.13.  When I am running Reliable File Transfer
I am getting a issue like

faultDetail:
        {http://xml.apache.org/axis/}stackTrace:java.rmi.RemoteException: Error
in start; nested exception is:
        org.globus.transfer.reliable.service.database.RftDBException: Error
retrieving data from database for id:
 "24" [Caused by: Unknown type '16 in column 7 of 20 in binary-encoded
result set.]

In this case, how one can handle the situation. I think there may be some issue
with the Connector.

How to repeat:
Create an updatable result set that has a BIT column in it with a server-side prepared statement.

[15 Jun 2006 19:46] Bugs System

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/7721