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

LongInElementsTest fails in Sybase 15.7 due to failing sql that returns empty mesage that cannot be converted by SQLExceptionConveter

    XMLWordPrintable

Details

    • Bug
    • Resolution: Done
    • Major
    • EAP No Release
    • EAP 6.0.0 ER 7
    • Hibernate
    • None
    • Not Required
    • NEW

    Description

      https://hudson.qa.jboss.com/hudson/view/EAP6/view/EAP6-Hibernate/job/eap6-hibernate-core-master-testsuite/database=sybase157,jdk=java16_default,label=hibernate/lastCompletedBuild/testReport/org.hibernate.test.criteria/LongInElementsTest/testLongInElementsByCriteria/

      Failing tests
      org.hibernate.test.criteria.LongInElementsTest.testLongInElementsByHQL
      org.hibernate.test.criteria.LongInElementsTest.testLongInElementsByCriteria

      Stacktrace:
      org.hibernate.exception.GenericJDBCException: Message empty.

      at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:54)
      at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:125)
      at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:110)
      .......................................................................................................................................
      ........................................................................................................................................
      Caused by: java.sql.SQLException: Message empty.

      at com.sybase.jdbc4.jdbc.SybConnection.getAllExceptions(Unknown Source)
      at com.sybase.jdbc4.jdbc.SybStatement.handleSQLE(Unknown Source)

      I think the select query generated by this test on sybase 15.7 is invalid and returns arbit sqlcode(empty message) leading to GenericJDBCException

      Query:

      select this_.id as id1423_0_, this_.name as name1423_0_, this_.isoCode as isoCode1423_0_ from StateProvince this_ where this_.id in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, .........................................................................................................)

      Attachments

        Activity

          People

            brmeyer_jira Brett Meyer (Inactive)
            madhumita12_jira Madhumita Sadhukhan (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: