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

Two failed QueueManagement tests in JBossMessaging test suite on Oracle 11g with JDBC driver 11.2.0.2.0

XMLWordPrintable

    • Documentation (Ref Guide, User Guide, etc.), Release Notes
    • Hide
      Two JBoss Messaging Test Suite tests fail on Oracle 11g R1, R2 and RAC with the JDBC drivers v11.2.0.1.0 and v11.2.0.2.0:

      <itemizedlist>
      <listitem><para><literal>QueueManagementTest.testDestroyDestinationProgrammatically</literal></para></listitem>
      <listitem><para><literal>QueueManagementTest.testDestroyDestinationProgrammaticallyWithParams</literal></para></listitem>
      </itemizedlist>

      These tests use a large value for the <literal>fullSize</literal> queue configuration parameter, which is passed to the <methodname>setFetchSize</methodname> method on the <literal>java.sql.PreparedStatement</literal>. A problem with the JDBC driver means that more than the usual amount of memory is consumed when <function>executeQuery()</function> is called, which results in a <exceptionname>java.lang.OutOfMemoryError</exceptionname>, causing the test to fail.
      Show
      Two JBoss Messaging Test Suite tests fail on Oracle 11g R1, R2 and RAC with the JDBC drivers v11.2.0.1.0 and v11.2.0.2.0: <itemizedlist> <listitem><para><literal>QueueManagementTest.testDestroyDestinationProgrammatically</literal></para></listitem> <listitem><para><literal>QueueManagementTest.testDestroyDestinationProgrammaticallyWithParams</literal></para></listitem> </itemizedlist> These tests use a large value for the <literal>fullSize</literal> queue configuration parameter, which is passed to the <methodname>setFetchSize</methodname> method on the <literal>java.sql.PreparedStatement</literal>. A problem with the JDBC driver means that more than the usual amount of memory is consumed when <function>executeQuery()</function> is called, which results in a <exceptionname>java.lang.OutOfMemoryError</exceptionname>, causing the test to fail.
    • Documented as Known Issue
    • ASSIGNED

      Hi Laura,
      we've found out that there is still an issue in a new version of jdbc driver(version 11.2.0.2.0) for Oracle 11g as decribed in jira https://jira.jboss.org/browse/JBPAPP-4079.

      This Jira added a warning to JBoss Messaging User Guide for EAP 4.3:

      "Configuring large values in destination paging parameters can cause OutOfMemory exceptions when used with JDBC driver version 11.2.0.1.0 and Oracle 11g R1, R2 and RAC. For more information, see the Known Issues section in the JBoss Enterprise Application Platform 5.0.1 Release Notes."

      and a note to Release Notes for EAP 4.3 CP08:

      "JBPAPP-4079: Two JBoss Messaging Test Suite tests fail on Oracle 11g R1, R2 and RAC with the latest JDBC driver, version 11.2.0.1.0:
      QueueManagementTest.testDestroyDestinationProgrammatically
      QueueManagementTest.testDestroyDestinationProgrammaticallyWithParams
      These tests use a large value for the fullSize queue configuration parameter, which is passed to the setFetchSize method on the java.sql.PreparedStatement. A problem with the JDBC driver means that more than the usual amount of memory is consumed when executeQuery() is called, which results in a java.lang.OutOfMemoryError, causing the test to fail."

      1. Could you please add to a warning in the JBM User Guide for EAP 4.3 that this issue is also in new version(it's 11.2.0.2.0) of jdbc driver for Oracle 11g.

      2. And add to the Release Notes for EAP 4.3 CP09 the same comment about this issue as in the Release Notes for EAP 4.3 CP08 and mention that this issue is also in the new jdbc driver 11.2.0.2.0.

      Thank you

              mnovak1@redhat.com Miroslav Novak
              mnovak1@redhat.com Miroslav Novak
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Created:
                Updated:
                Resolved: