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

    • Bug
    • Resolution: Obsolete
    • 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

    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.

      Attachments

        Activity

          People

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

            Dates

              Created:
              Updated:
              Resolved: