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 Email Updates:
Status: Closed Impact on me:
None 
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