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

NamedNativeQueryTest fails on sybase databases

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Done
    • Icon: Major Major
    • EAP_EWP 5.3.0.ER3
    • Hibernate
    • None
    • EAP 5.3.0.ER3
      hibernate annotations 3.4.0.GA_CP06
      sybase

    • NEW

      org.hibernate.test.jpa.ql.NamedNativeQueryTest.testInsertSingleValue
      org.hibernate.test.jpa.ql.NamedNativeQueryTest.testInsertMultipleValues
      Stacktrace:

      org.hibernate.exception.GenericJDBCException: could not execute native bulk manipulation query
      	at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:126)
      	at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:114)
      	at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
      	at org.hibernate.engine.query.NativeSQLQueryPlan.performExecuteUpdate(NativeSQLQueryPlan.java:198)
      	at org.hibernate.impl.SessionImpl.executeNativeUpdate(SessionImpl.java:1234)
      	at org.hibernate.impl.SQLQueryImpl.executeUpdate(SQLQueryImpl.java:357)
      	at org.hibernate.test.jpa.ql.NamedNativeQueryTest.testInsertMultipleValues(NamedNativeQueryTest.java:165)
      	at org.hibernate.test.annotations.HibernateTestCase.runTest(HibernateTestCase.java:93)
      	at org.hibernate.test.annotations.HibernateTestCase.runBare(HibernateTestCase.java:81)
      Caused by: java.sql.SQLException: Explicit value specified for identity field in table 'destination_entity' when 'SET IDENTITY_INSERT' is OFF.
      
      	at com.sybase.jdbc4.jdbc.SybConnection.getAllExceptions(Unknown Source)
      	at com.sybase.jdbc4.jdbc.SybStatement.handleSQLE(Unknown Source)
      	at com.sybase.jdbc4.jdbc.SybStatement.nextResult(Unknown Source)
      	at com.sybase.jdbc4.jdbc.SybStatement.nextResult(Unknown Source)
      	at com.sybase.jdbc4.jdbc.SybStatement.updateLoop(Unknown Source)
      	at com.sybase.jdbc4.jdbc.SybStatement.executeUpdate(Unknown Source)
      	at com.sybase.jdbc4.jdbc.SybPreparedStatement.executeUpdate(Unknown Source)
      	at org.hibernate.engine.query.NativeSQLQueryPlan.performExecuteUpdate(NativeSQLQueryPlan.java:189)
      

              brmeyer_jira Brett Meyer (Inactive)
              msimka@redhat.com Martin Simka
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Created:
                Updated:
                Resolved: