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

    • Icon: Bug Bug
    • Resolution: Obsolete
    • Icon: Major Major
    • TBD EAP 5
    • EAP_EWP 5.1.0_CR3, EAP_EWP 5.1.1 ER2, EAP_EWP 5.1.1 ER3
    • Messaging
    • None
    • Release Notes
    • 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.
    • 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>.
    • Documented as Known Issue
    • NEW

      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.

              jaredmorgs_jira Jared Morgan (Inactive)
              mnovak1@redhat.com Miroslav Novak
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Created:
                Updated:
                Resolved: