[jboss-user] [jBPM] - Drools 5.x + jBPM 5.x + Hibernate 3.6.x + Postgres 9.x

Krešimir Popović [http://community.jboss.org/people/kresimir_popovic] created the discussion "Drools 5.x + jBPM 5.x + Hibernate 3.6.x + Postgres 9.x" To view the discussion, visit: http://community.jboss.org/message/600522#600522 -------------------------------------------------------------- Hello, has anyone knows if jBPM was tested with Hibernate 3.6.x (part of JBoss 6.x) ? I just want to know if JBPM 5.x tested with hibernate 3.6.x ? Hibernate team has done some changes since hibernate 3.5.x regarding bytea / oid data type handling. http://programmingbulls.com/postgresql-bytea-vs-oid-large-object http://programmingbulls.com/postgresql-bytea-vs-oid-large-object http://stackoverflow.com/questions/3677380/proper-hibernate-annotation-fo... http://stackoverflow.com/questions/3677380/proper-hibernate-annotation-fo... http://opensource.atlassian.com/projects/hibernate/browse/HHH-4876 http://opensource.atlassian.com/projects/hibernate/browse/HHH-4876 This is the error I get when I execute Mina task client method: getTasksAssignedAsPotentialOwner 15:16:19,690 INFO  [hr.bpmsolutions.printinghouse.services.actions.humantask.HumanTaskAction] tmp:0 15:16:19,690 INFO  [hr.bpmsolutions.printinghouse.services.actions.humantask.HumanTaskAction] tasksAssignedAsPotentialOw ner - END 15:16:19,694 INFO  [STDOUT] Hibernate: 15:16:19,695 INFO  [STDOUT]     insert 15:16:19,695 INFO  [STDOUT]     into 15:16:19,695 INFO  [STDOUT]         SessionInfo 15:16:19,695 INFO  [STDOUT]         (lastModificationDate, rulesByteArray, startDate, OPTLOCK, id) 15:16:19,696 INFO  [STDOUT]     values 15:16:19,696 INFO  [STDOUT]         (?, ?, ?, ?, ?) 15:16:19,708 WARN  [org.hibernate.util.JDBCExceptionReporter] SQL Error: 0, SQLState: 42804 *15:16:19,709 ERROR [org.hibernate.util.JDBCExceptionReporter] ERROR: column "rulesbytearray" is of type oid but expressi* *on is of type bytea* *  Hint: You will need to rewrite or cast the expression.*   Position: 100 15:16:19,711 ERROR [org.hibernate.event.def.AbstractFlushingEventListener] Could not synchronize database state with ses sion: org.hibernate.exception.SQLGrammarException: could not insert: [org.drools.persistence.info.SessionInfo]         at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:92) [:3.6.0.Final] I get also the same thing for processinstanceinfo -->  COLUMN processinstancebytearray Problematic Enttity classes: org.drools.persistence.processinstance.ProcessInstanceInfo org.drools.persistence.processinstance.SessionInfo Maybe what is needed to do is to use annotation @Type(type="org.hibernate.type.PrimitiveByteArrayBlobType") for *processinstancebytearray* and *rulesbytearray entity fields?* Best Regards, Krešimir -------------------------------------------------------------- Reply to this message by going to Community [http://community.jboss.org/message/600522#600522] Start a new discussion in jBPM at Community [http://community.jboss.org/choose-container!input.jspa?contentType=1&...]