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

org.hibernate.test.legacy.CustomSQLTest fails

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Done
    • Icon: Major Major
    • EAP 5.0.1.CR1
    • EAP 5.0.0
    • Hibernate
    • None
    • PostgreSQL, Oracle

      testCollectionCUD, testCRUD fail on Oracle
      --------------
      Hibernate:
      insert
      into
      Party
      (givenName, lastName, nationalID, discriminator, id)
      values
      (?, ?, ?, 'org.hibernate.test.legacy.Person', ?)
      Hibernate:

      { call createJoinTable(?, ?, ?) }
      05:32:21,929 WARN JDBCExceptionReporter:100 - SQL Error: 6550, SQLState: 65000
      05:32:21,931 ERROR JDBCExceptionReporter:101 - ORA-06550: line 1, column 7:
      PLS-00201: identifier 'CREATEJOINTABLE' must be declared
      ORA-06550: line 1, column 7:
      PL/SQL: Statement ignored

      05:32:21,931 ERROR AbstractFlushingEventListener:324 - Could not synchronize database state with session
      org.hibernate.exception.SQLGrammarException: could not insert: [org.hibernate.test.legacy.Person]
      at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:90)
      at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
      ***************************************
      testInsert fails on PostgreSQL because of
      <sql-insert>insert into Role (name, id) values (?, upper) /** i did this*/</sql-insert>
      but id is Long type

      testCollectionCUD, testCRUD fail on PostgreSQL because of
      Hibernate:
      insert
      into
      Party
      (givenName, lastName, nationalID, discriminator, id)
      values
      (?, ?, ?, 'org.hibernate.test.legacy.Person', ?)
      Hibernate:
      { call createJoinTable(?, ?, ?) }

      05:35:15,511 WARN JDBCExceptionReporter:100 - SQL Error: 0, SQLState: 42883
      05:35:15,511 ERROR JDBCExceptionReporter:101 - ERROR: function createjointable(character varying, character varying, character varying) does not exist

            shaozliu Strong Liu(刘少壮) (Inactive)
            shaozliu Strong Liu(刘少壮) (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated:
              Resolved: