[OS-JIRA] Created: (CAY-55) Postgres Exception when using Boolean and BIT column

From: jir..bjectstyle.org
Date: Mon Dec 08 2003 - 19:42:17 EST

  • Next message: Henry A: "Re: Winding down.."

    Message:

      A new issue has been created in JIRA.

    ---------------------------------------------------------------------
    View the issue:

      http://objectstyle.org/jira/secure/ViewIssue.jspa?key=CAY-55

    Here is an overview of the issue:
    ---------------------------------------------------------------------
            Key: CAY-55
        Summary: Postgres Exception when using Boolean and BIT column
           Type: Bug

         Status: Assigned
       Priority: Minor

        Project: Cayenne
     Components:
                 Cayenne Core Library
       Fix Fors:
                 1.0 [STABLE]
       Versions:
                 1.0 [STABLE]
                 1.1 [DEV]

       Assignee: Andrus Adamchik
       Reporter: Andrus Adamchik

        Created: Mon, 8 Dec 2003 7:41 PM
        Updated: Mon, 8 Dec 2003 7:41 PM

    Description:
    Postgres seems to unable to handle Boolean values mapped to BIT columns. Here is a typical exception thrown:

    Caused by: java.sql.SQLException: ERROR: Unable to identify an operator '=' for types 'bit' and 'boolean'
    You will have to retype this query using an explicit cast

    at org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:131)
    at org.postgresql.jdbc1.AbstractJdbc1Connection.ExecSQL(AbstractJdbc1Connection.java:505)
    at org.postgresql.jdbc1.AbstractJdbc1Statement.execute(AbstractJdbc1Statement.java:320)
    at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:48)
    at org.postgresql.jdbc1.AbstractJdbc1Statement.executeQuery(AbstractJdbc1Statement.java:153)
    at org.objectstyle.cayenne.access.DataNode.runSelect(DataNode.java:391)
    at org.objectstyle.cayenne.access.DataNode.performQueries(DataNode.java:292)
    ... 28 more

    ---------------------------------------------------------------------
    JIRA INFORMATION:
    This message is automatically generated by JIRA.

    If you think it was sent incorrectly contact one of the administrators:
       http://objectstyle.org/jira/secure/Administrators.jspa

    If you want more information on JIRA, or have a bug to report see:
       http://www.atlassian.com/software/jira



    This archive was generated by hypermail 2.0.0 : Mon Dec 08 2003 - 19:42:18 EST