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

    • Bug
    • Resolution: Obsolete
    • Major
    • TBD EAP 5
    • EAP_EWP 5.1.2, EAP_EWP 5.2.0 ER2
    • Hibernate
    • None

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

    • Release Notes
    • Workaround Exists
    • 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
    • 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>
    • Documented as Known Issue
    • NEW

    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)

      Attachments

        Activity

          People

            shaozliu Strong Liu(刘少壮) (Inactive)
            rhn-engineering-jcoleman Julian Coleman
            Russell Dickenson Russell Dickenson (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: