-
Bug
-
Resolution: Done
-
Major
-
EAP 5.0.0
-
None
-
PostgreSQL, Oracle
testCollectionCUD, testCRUD fail on Oracle
--------------
Hibernate:
insert
into
Party
(givenName, lastName, nationalID, discriminator, id)
values
(?, ?, ?, 'org.hibernate.test.legacy.Person', ?)
Hibernate:
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