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

Sybase database - Limited number of params of PreparedStatement

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Out of Date
    • Affects Version/s: EAP_EWP 5.1.0_CR3, EAP_EWP 5.1.1 ER2, EAP_EWP 5.1.1 ER3
    • Fix Version/s: TBD EAP 5
    • Component/s: Messaging
    • Labels:
      None
    • Affects:
      Release Notes
    • Workaround Description:
      Hide

      The workaround for this issue is to set variable MaxParams in the sybase-persistence-service.xml configuration file to a smaller value than 481.

      Show
      The workaround for this issue is to set variable MaxParams in the sybase-persistence-service.xml configuration file to a smaller value than 481.
    • Release Notes Text:
      Hide
      When using Sybase database with the JDBC driver Sybase jConnect JDBC driver v7 (Build 26502), a <varname>MaxParams</varname> attribute in the <filename>sybase-persistence-service.xml</filename> configuration file cannot be set higher than <literal>481</literal> due to a limitation of the <classname>PreparedStatement</classname> class in this driver. Unexpected failures can occur when the <varname>MaxParams</varname> attribute is set to a value higher than <literal>481</literal>. To avoid this issue, set <varname>MaxParams</varname> to a smaller value than <literal>481</literal>.
      Show
      When using Sybase database with the JDBC driver Sybase jConnect JDBC driver v7 (Build 26502), a <varname>MaxParams</varname> attribute in the <filename>sybase-persistence-service.xml</filename> configuration file cannot be set higher than <literal>481</literal> due to a limitation of the <classname>PreparedStatement</classname> class in this driver. Unexpected failures can occur when the <varname>MaxParams</varname> attribute is set to a value higher than <literal>481</literal>. To avoid this issue, set <varname>MaxParams</varname> to a smaller value than <literal>481</literal>.
    • Release Notes Docs Status:
      Documented as Known Issue
    • Docs QE Status:
      NEW

      Description

      There is an issue when using Sybase database with Sybase jConnect JDBC driver v7 (Build 26502). The PreparedStatement class is not able to handle more then 481 parameters in a prepared statement.

        Gliffy Diagrams

          Attachments

            Activity

              People

              • Assignee:
                jaredmorgs Jared Morgan
                Reporter:
                mnovak Miroslav Novak
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: