[jira] Closed: (CAY-1022) MySQL 5 data type tinyint(1) not interpreted as java.lang.Boolean

From: Andrus Adamchik (JIRA) ("Andrus)
Date: Thu May 08 2008 - 12:56:52 EDT

  • Next message: Dave Dombrosky (JIRA): "[jira] Commented: (CAY-1052) Invalid cast on NUMERICs with scale of 0 using Postgres JDBC 8.2+"

         [ https://issues.apache.org/cayenne/browse/CAY-1022?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

    Andrus Adamchik closed CAY-1022.
    --------------------------------

        Resolution: Won't Fix

    I don't think we can do anything about that. The driver returns this as a BIT... ResultSetMeatadata.getColumns() returns the following (i tried drivers between 3.x to 5.1.x)

             rs.getInt("DATA_TYPE"); // returns -7 which is Types.BIT
             rs.getString("TYPE_NAME"); // returns "BIT"

    So I guess you may log a bug with MySQL

    > MySQL 5 data type tinyint(1) not interpreted as java.lang.Boolean
    > -----------------------------------------------------------------
    >
    > Key: CAY-1022
    > URL: https://issues.apache.org/cayenne/browse/CAY-1022
    > Project: Cayenne
    > Issue Type: Bug
    > Components: Cayenne Core Library
    > Affects Versions: 3.0
    > Environment: Cayenne 3.0M3, Modeler-win, Mysql 5
    > Reporter: Borut Bolčina
    > Assignee: Andrus Adamchik
    >
    > If data type is defined as tinyint(1), the class for this attribute should be Boolean, but is insted Byte. Byte is ok if there is no length defined in parenthesis.
    > http://dev.mysql.com/doc/refman/5.0/en/connector-j-reference-type-conversions.html 

    -- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

    This archive was generated by hypermail 2.0.0 : Thu May 08 2008 - 12:57:27 EDT