I dont have an answer to you but do you use XA? what is the type of datasource configured for Oracle db? if its an xa datasource then you got yourself a clue where to search.<br><br><div class="gmail_quote">2011/9/29 Jeff Maas <span dir="ltr"><<a href="mailto:do-not-reply@jboss.com">do-not-reply@jboss.com</a>></span><br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;"><u></u>
<div 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%">
<tbody>
<tr>
<td>
<table border="0" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF" style="border:solid 2px #ccc;background:#dadada;width:100%">
<tbody>
<tr>
<td bgcolor="#000000" valign="middle" height="58px" style="border-bottom:1px solid #ccc;padding:20px">
<h1 style="color:#333333;font:bold 22px Arial, Helvetica, sans-serif;margin:0;display:block !important">
<a href="http://community.jboss.org/index.jspa" style="text-decoration:none;color:#E1E1E1" target="_blank">JBoss Community</a></h1>
</td>
</tr>
<tr>
<td bgcolor="#FFFFFF" style="font:normal 12px Arial, Helvetica, sans-serif;color:#333333;padding:20px"><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" target="_blank">Jeff Maas</a> in <i>jBPM</i> - <a href="http://community.jboss.org/message/629406#629406" target="_blank">View the full discussion</a>
</span>
<hr style="margin:20px 0;border:none;background-color:#dadada;min-height:1px">
<div><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;min-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;min-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;min-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;min-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;min-height:8pt;padding:0px">�</p><p style="min-height:8pt;min-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" target="_blank">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" target="_blank">Community</a></p>
</div></td>
</tr>
</tbody>
</table>
</td>
</tr>
</tbody>
</table>
</div>
</div>
<br>_______________________________________________<br>
jboss-user mailing list<br>
<a href="mailto:jboss-user@lists.jboss.org">jboss-user@lists.jboss.org</a><br>
<a href="https://lists.jboss.org/mailman/listinfo/jboss-user" target="_blank">https://lists.jboss.org/mailman/listinfo/jboss-user</a><br>
<br></blockquote></div><br>