7:31 a.m.
Miloud Haimoune [https://community.jboss.org/people/milhaim] created the discussion
"jbpm 5.3.final postgres issue"
To view the discussion, visit: https://community.jboss.org/message/740678#740678
--------------------------------------------------------------
Hi all,
I'm migrating the code of my application to use jbpm latest release (5.3.final). but
I'm facing this exception when I create a new process instance :
13:01:13,688 WARN [JDBCExceptionReporter] SQL Error: 0, SQLState: 42804
13:01:13,688 ERROR [JDBCExceptionReporter] ERROR: column
"processinstancebytearray" is of type oid but expression is of type bytea
Hint: You will need to rewrite or cast the expression.
Position: 149.
I found a post wich advises to use a recent version of hibernate 3.6.final. but I m using
jboss 5.1 which provides hibenate 3.1 and I don't think it's very wise hibernate
(used by another application).
the some code was working fine with JBPM 5.2.final
if you have any solution ??
many thanks
--------------------------------------------------------------
Reply to this message by going to Community
[https://community.jboss.org/message/740678#740678]
Start a new discussion in jBPM at Community
[https://community.jboss.org/choose-container!input.jspa?contentType=1&...]
4:56 a.m.
New subject: [jBPM] - Re: jbpm 5.3.final postgres issue
hamsterdancer [https://community.jboss.org/people/hamsterdancer] created the discussion
"Re: jbpm 5.3.final postgres issue"
To view the discussion, visit: https://community.jboss.org/message/740940#740940
--------------------------------------------------------------
I'm getting the same Error. Did you find any solution yet?
--------------------------------------------------------------
Reply to this message by going to Community
[https://community.jboss.org/message/740940#740940]
Start a new discussion in jBPM at Community
[https://community.jboss.org/choose-container!input.jspa?contentType=1&...]
9:55 a.m.
New subject: [jBPM] - Re: jbpm 5.3.final postgres issue
Miloud Haimoune [https://community.jboss.org/people/milhaim] created the discussion
"Re: jbpm 5.3.final postgres issue"
To view the discussion, visit: https://community.jboss.org/message/741018#741018
--------------------------------------------------------------
Unfortunately not yet. I'm trying to migrate to jboss 7, to upgrade hibernate version
--------------------------------------------------------------
Reply to this message by going to Community
[https://community.jboss.org/message/741018#741018]
Start a new discussion in jBPM at Community
[https://community.jboss.org/choose-container!input.jspa?contentType=1&...]
8:08 a.m.
New subject: [jBPM] - Re: jbpm 5.3.final postgres issue
Miloud Haimoune [https://community.jboss.org/people/milhaim] created the discussion
"Re: jbpm 5.3.final postgres issue"
To view the discussion, visit: https://community.jboss.org/message/746075#746075
--------------------------------------------------------------
I solved this issue,
in persistence.xml I had :
<mapping-file>META-INF/ProcessInstanceInfo.hbm.xml</mapping-file>
and I added the ProcessInstanceInfo.hbm.xml file in the same place as persistence.xml.
what I did'nt know jbpm-persistence-jpa-5.3.0.Final.jar comes with it's oun
ProcessInstanceInfo.hbm.xml file,
So by changing the name of the file ProcessInstanceInfo.hbm.xml to
(ProcessInstanceInfo_P.hbm.xml) in the folder META-INF of my project
and adding <mapping-file>META-INF/ProcessInstanceInfo_P.hbm.xml</mapping-file>
(remove the old one) in my persistence.xml
and changing in ProcessInstanceInfo_P.hbm.xml file:
<property name="processInstanceByteArray"
type="org.jbpm.persistence.processinstance.BlobUserType"
column="processInstanceByteArray" access="field"
length="2147483647" />
to
<property name="processInstanceByteArray"
type="org.hibernate.type.PrimitiveByteArrayBlobType" access="field"
>
<column name="processInstanceByteArray"
sql-type="oid"/>
</property>
this fix my issue
HTH
--------------------------------------------------------------
Reply to this message by going to Community
[https://community.jboss.org/message/746075#746075]
Start a new discussion in jBPM at Community
[https://community.jboss.org/choose-container!input.jspa?contentType=1&...]
5048
days inactive
5074
days old
3 comments
2 participants
participants (2)
-
hamsterdancer -
Miloud Haimoune