Uploaded image for project: 'JBoss Enterprise Application Platform 4 and 5'
  1. JBoss Enterprise Application Platform 4 and 5
  2. JBPAPP-9059

Consistent test failures on DB2 due to processingError

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Reopened (View Workflow)
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: EAP_EWP 5.1.2, EAP_EWP 5.2.0 ER2
    • Fix Version/s: TBD EAP 5
    • Component/s: Hibernate
    • Labels:
      None
    • Environment:

      SOA-P 5.3.0 ER2 (based on EAP 5.1.2 GA)

    • Affects:
      Release Notes
    • Workaround:
      Workaround Exists
    • Workaround Description:
      Hide

      there are couples workaround exist:

      • Setting deferPrepares=false
      • Using type org.hibernate.type.NumericBooleanType
      Show
      there are couples workaround exist: Setting deferPrepares=false Using type org.hibernate.type.NumericBooleanType
    • Release Notes Text:
      Hide
      When using Hibernate with IBM DB2-97 a SqlSyntaxErrorException may occur when deploying jbossesb.esb. The error occurs because of a mismatch between the Hibernate data type and the DB2 data type to which it is mapped. There are two possible workarounds available for this issue:
      <itemizedlist>
      <listitem>
      <para>
      Add <programlisting><![CDATA[<connection-property name="deferPrepares">false</connection-property>]]></programlisting> to <filename>"/jboss-as/server/db2-97/deploy/jbossesb-registry.sar/juddi-ds.xml" </filename>. Note that according to <ulink type="http" url="http://publib.boulder.ibm.com/infocenter/db2luw/v8/index.jsp?topic=/com.ibm.db2.udb.doc/ad/c0010273.htm">http://publib.boulder.ibm.com/infocenter/db2luw/v8/index.jsp?topic=/com.ibm.db2.udb.doc/ad/c0010273.htm&lt;/ulink&gt;, this workaround may affect performance;
      </para>
      </listitem>
      <listitem>
      <para>
      Use org.hibernate.type.NumericBooleanType type instead of BooleanType.
      </para>
      </listitem>
      </itemizedlist>
      Show
      When using Hibernate with IBM DB2-97 a SqlSyntaxErrorException may occur when deploying jbossesb.esb. The error occurs because of a mismatch between the Hibernate data type and the DB2 data type to which it is mapped. There are two possible workarounds available for this issue: <itemizedlist> <listitem> <para> Add <programlisting><![CDATA[<connection-property name="deferPrepares">false</connection-property>]]></programlisting> to <filename>"/jboss-as/server/db2-97/deploy/jbossesb-registry.sar/juddi-ds.xml" </filename>. Note that according to <ulink type="http" url=" http://publib.boulder.ibm.com/infocenter/db2luw/v8/index.jsp?topic=/com.ibm.db2.udb.doc/ad/c0010273.htm "> http://publib.boulder.ibm.com/infocenter/db2luw/v8/index.jsp?topic=/com.ibm.db2.udb.doc/ad/c0010273.htm&lt;/ulink&gt;, this workaround may affect performance; </para> </listitem> <listitem> <para> Use org.hibernate.type.NumericBooleanType type instead of BooleanType. </para> </listitem> </itemizedlist>
    • Release Notes Docs Status:
      Documented as Known Issue
    • Docs QE Status:
      NEW
    • Bugzilla References:
    • Bugzilla Update:
      Perform

      Description

      From: https://bugzilla.redhat.com/show_bug.cgi?id=810481

      SOA-P 5.3.0 DR3 throws com.ibm.db2.jcc.am.SqlSyntaxErrorException while
      deploying jbossesb.esb.

      This problem occurs only with IBM DB2-97.
      See log in the Bugzilla bug attachment.

      Exception details:
      com.ibm.db2.jcc.am.SqlSyntaxErrorException: DB2 SQL Error: SQLCODE=-401,
      SQLSTATE=42818, SQLERRMC==, DRIVER=4.12.55
      at com.ibm.db2.jcc.am.hd.a(hd.java:676)
      at com.ibm.db2.jcc.am.hd.a(hd.java:60)
      at com.ibm.db2.jcc.am.hd.a(hd.java:127)
      at com.ibm.db2.jcc.am.mn.c(mn.java:2621)
      at com.ibm.db2.jcc.am.mn.d(mn.java:2609)
      at com.ibm.db2.jcc.am.mn.a(mn.java:2085)
      at com.ibm.db2.jcc.am.nn.a(nn.java:7054)
      at com.ibm.db2.jcc.t4.cb.g(cb.java:141)
      at com.ibm.db2.jcc.t4.cb.a(cb.java:41)
      at com.ibm.db2.jcc.t4.q.a(q.java:32)
      at com.ibm.db2.jcc.t4.rb.i(rb.java:135)
      at com.ibm.db2.jcc.am.mn.ib(mn.java:2055)
      at com.ibm.db2.jcc.am.nn.rc(nn.java:3219)
      at com.ibm.db2.jcc.am.nn.b(nn.java:4002)
      at com.ibm.db2.jcc.am.nn.ec(nn.java:728)
      at com.ibm.db2.jcc.am.nn.executeQuery(nn.java:698)
      at
      org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeQuery(WrappedPreparedStatement.java:342)
      at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:208)
      at org.hibernate.loader.Loader.getResultSet(Loader.java:1997)

        Gliffy Diagrams

          Attachments

            Issue Links

            cloned from

            Bug - A problem which impairs or prevents the functions of the product. JBPAPP6-813 Consistent test failures on DB2 due to processingError

            • Major - A request that should be considered seriously but is not a show stopper.
            • Closed
            is related to

            Bug - A problem which impairs or prevents the functions of the product. JBPAPP6-813 Consistent test failures on DB2 due to processingError

            • Major - A request that should be considered seriously but is not a show stopper.
            • Closed

              Activity

                People

                • Assignee:
                  stliu Strong Liu
                  Reporter:
                  jcoleman Julian Coleman
                  Writer:
                  Russell Dickenson
                • Votes:
                  0 Vote for this issue
                  Watchers:
                  4 Start watching this issue

                  Dates

                  • Created:
                    Updated: