<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<html>
<body link="#355491" alink="#4262a1" vlink="#355491" style="background: #e2e2e2; margin: 0; padding: 20px;">
<div>
<table cellpadding="0" bgcolor="#FFFFFF" border="0" cellspacing="0" style="border: 1px solid #dadada; margin-bottom: 30px; width: 100%; -moz-border-radius: 6px; -webkit-border-radius: 6px;">
<tbody>
<tr>
<td>
<table border="0" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF" style="border: solid 2px #ccc; background: #dadada; width: 100%; -moz-border-radius: 6px; -webkit-border-radius: 6px;">
<tbody>
<tr>
<td bgcolor="#000000" valign="middle" height="58px" style="border-bottom: 1px solid #ccc; padding: 20px; -moz-border-radius-topleft: 3px; -moz-border-radius-topright: 3px; -webkit-border-top-right-radius: 5px; -webkit-border-top-left-radius: 5px;">
<h1 style="color: #333333; font: bold 22px Arial, Helvetica, sans-serif; margin: 0; display: block !important;">
<!-- To have a header image/logo replace the name below with your img tag -->
<!-- Email clients will render the images when the message is read so any image -->
<!-- must be made available on a public server, so that all recipients can load the image. -->
<a href="http://community.jboss.org/index.jspa" style="text-decoration: none; color: #E1E1E1">JBoss Community</a></h1>
</td>
</tr>
<tr>
<td bgcolor="#FFFFFF" style="font: normal 12px Arial, Helvetica, sans-serif; color:#333333; padding: 20px; -moz-border-radius-bottomleft: 4px; -moz-border-radius-bottomright: 4px; -webkit-border-bottom-right-radius: 5px; -webkit-border-bottom-left-radius: 5px;"><h3 style="margin: 10px 0 5px; font-size: 17px; font-weight: normal;">
JBPM4 Migrating from Oracle to Postgres, Transaction Error on JBPM4_LOB
</h3>
<span style="margin-bottom: 10px;">
created by <a href="http://community.jboss.org/people/jeff_maas">Jeff Maas</a> in <i>jBPM</i> - <a href="http://community.jboss.org/message/629406#629406">View the full discussion</a>
</span>
<hr style="margin: 20px 0; border: none; background-color: #dadada; height: 1px;">
<div class="jive-rendered-content"><p>I have inherited an enterprise service bus style application (MULE,JBPM4,Hibernate,Spring) and have been tasked with migrating the application from Oracle to Postgres.  Much of this has gone without a hitch however I have run into a problem that I beleve others have seen before.  Specifically Postgres8.4 does not appear to like auto-commits on OID -> LOB,  which appears to be key with how JBPM4_LOB works.</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>[http-80-2] [org.hibernate.util.JDBCExceptionReporter] Large Objects may not be used in auto-commit mode.</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>Root Exception stack trace:</p><p>org.postgresql.util.PSQLException: Large Objects may not be used in auto-commit mode.</p><p>        at org.postgresql.largeobject.LargeObjectManager.open(LargeObjectManager.java:200)</p><p>        at org.postgresql.largeobject.LargeObjectManager.open(LargeObjectManager.java:172)</p><p>        at org.postgresql.jdbc2.AbstractJdbc2BlobClob.<init>(AbstractJdbc2BlobClob.java:47)</p><p>        at org.postgresql.jdbc2.AbstractJdbc2Blob.<init>(AbstractJdbc2Blob.java:21)</p><p>        at org.postgresql.jdbc3.AbstractJdbc3Blob.<init>(AbstractJdbc3Blob.java:19)</p><p>        at org.postgresql.jdbc4.AbstractJdbc4Blob.<init>(AbstractJdbc4Blob.java:20)</p><p>        at org.postgresql.jdbc4.Jdbc4Blob.<init>(Jdbc4Blob.java:20)</p><p>        at org.postgresql.jdbc4.Jdbc4ResultSet.getBlob(Jdbc4ResultSet.java:52)</p><p>        at org.postgresql.jdbc2.AbstractJdbc2ResultSet.getBlob(AbstractJdbc2ResultSet.java:335)</p><p>        at com.mchange.v2.c3p0.impl.NewProxyResultSet.getBlob(NewProxyResultSet.java:285)</p><p>        at org.hibernate.type.BlobType.get(BlobType.java:80)</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>Admittedly I'm a bit out of my element,  I've tried various forum searched and googles but haven't found a beginners guide to a none beginneres topic.  It would appear I must add a transaction around JBPM4_LOB even though in the context that it is used it is absolutely reaad only.</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>Nowehere else do I use BLOB's and right now I've got the various jbpm4 libraries (maven) on my classpath.  But I'm at a loss on how to deal with this issue surrounding auto-commit.  I've tried various forms of turning auto-commit off at the hibernate level but to no avail.  Previous seraches in the forum suggest others have had this issue but I'm not sure if anyone has recieved an answer.  Any help or sympathy is greatly appreciated.</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>Thanks</p><p>Jeff</p></div>
<div style="background-color: #f4f4f4; padding: 10px; margin-top: 20px;">
<p style="margin: 0;">Reply to this message by <a href="http://community.jboss.org/message/629406#629406">going to Community</a></p>
<p style="margin: 0;">Start a new discussion in jBPM at <a href="http://community.jboss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2034">Community</a></p>
</div></td>
</tr>
</tbody>
</table>
</td>
</tr>
</tbody>
</table>
</div>
</body>
</html>