[OS-JIRA] Created: (CAY-269) DB2 throws when there are line breaks in SQLTemplate

From: jir..bjectstyle.org
Date: Sun Feb 06 2005 - 23:26:57 EST

  • Next message: Andrus Adamchik: "Cayenne 1.2 M2 is out"

    Message:

      A new issue has been created in JIRA.

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

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

    Here is an overview of the issue:
    ---------------------------------------------------------------------
            Key: CAY-269
        Summary: DB2 throws when there are line breaks in SQLTemplate
           Type: Bug

         Status: Assigned
       Priority: Minor

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

       Assignee: Andrus Adamchik
       Reporter: Andrus Adamchik

        Created: Sun, 6 Feb 2005 11:25 PM
        Updated: Sun, 6 Feb 2005 11:25 PM
    Environment: DB2 linux/ Cayenne client is on Mac OS

    Description:
    This happened when testing DB2 - test data is loaded from the XML file and some queries were entered as multiline CDATA... DB2 was unhappy:

    com.ibm.db2.jcc.b.SQLException: An error occurred during implicit system action type "2". Information returned for the error includes SQLCODE "-7", SQLSTATE "42601" and message tokens "|IST_NAME) values (1,". at com.ibm.db2.jcc.b.ce.d(ce.java:975) at com.ibm.db2.jcc.a.bd.k(bd.java:312) at com.ibm.db2.jcc.a.bd.a(bd.java:61) at com.ibm.db2.jcc.a.r.a(r.java:64) at com.ibm.db2.jcc.a.bq.c(bq.java:217) at com.ibm.db2.jcc.b.cf.C(cf.java:1109) at com.ibm.db2.jcc.b.cf.a(cf.java:1505) at com.ibm.db2.jcc.b.cf.executeUpdate(cf.java:322) at org.objectstyle.cayenne.access.jdbc.SQLTemplateAction.performAction(SQLTemplateAction.java:144) at org.objectstyle.cayenne.access.DataNode.performQueries(DataNode.java:309)

    I guess we need a specialized translator...

    ---------------------------------------------------------------------
    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 : Sun Feb 06 2005 - 23:27:00 EST