Uploaded image for project: 'Hibernate ORM'
  1. HHH-12757

EntityMapCompositeElementTest fail with oracle

    Details

    • Bug Testcase Reminder (view):

      Bug reports should generally be accompanied by a test case!

    • Last commented by a user?:
      true
    • Sprint:

      Description

      org.hibernate.envers.test.integration.collection.EntityMapCompositeElementTest.initData

      fails with

      Caused by: java.sql.SQLSyntaxErrorException: ORA-01747: invalid user.table.column, table.column, or column specification
      
      	at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:494)
      	at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:446)
      	at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1054)
      	at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:623)
      	at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:252)
      	at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:612)
      	at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:226)
      	at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:59)
      	at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:910)
      	at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1119)
      	at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3780)
      	at oracle.jdbc.driver.T4CPreparedStatement.executeInternal(T4CPreparedStatement.java:1343)
      	at oracle.jdbc.driver.OraclePreparedStatement.executeLargeUpdate(OraclePreparedStatement.java:3865)
      	at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3845)
      	at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1061)
      	at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:175)
      	... 77 more
      Caused by: Error : 1747, Position : 49, Sql = insert into category_item (category_id, item_id, number, text) values (:1 , :2 , :3 , :4 ), OriginalSql = insert into category_item (category_id, item_id, number, text) values (?, ?, ?, ?), Error Msg = ORA-01747: invalid user.table.column, table.column, or column specification
      
      	at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:498)
      	... 92 more
      

      but cause seems to be

      Caused by: java.sql.SQLSyntaxErrorException: ORA-00904: : invalid identifier
      
      	at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:494)
      	at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:446)
      	at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1054)
      	at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:623)
      	at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:252)
      	at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:612)
      	at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:213)
      	at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:37)
      	at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:896)
      	at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1119)
      	at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1737)
      	at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1692)
      	at oracle.jdbc.driver.OracleStatementWrapper.execute(OracleStatementWrapper.java:300)
      	at org.hibernate.tool.schema.internal.exec.GenerationTargetToDatabase.accept(GenerationTargetToDatabase.java:54)
      	... 58 more
      Caused by: Error : 904, Position : 229, Sql = 
          create table category_item_AUD (
             REV number(10,0) not null,
              REVTYPE number(3,0) not null,
              category_id number(19,0) not null,
              item_id number(19,0) not null,
              REVEND number(10,0),
              number number(19,0),
              text varchar2(255 char),
              primary key (REV, REVTYPE, category_id, item_id)
          ), OriginalSql = 
          create table category_item_AUD (
             REV number(10,0) not null,
              REVTYPE number(3,0) not null,
              category_id number(19,0) not null,
              item_id number(19,0) not null,
              REVEND number(10,0),
              number number(19,0),
              text varchar2(255 char),
              primary key (REV, REVTYPE, category_id, item_id)
          ), Error Msg = ORA-00904: : invalid identifier
      
      	at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:498)
      	... 71 more
      

        Attachments

          Activity

            People

            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: