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.
2011/9/29 Jeff Maas <do-not-re...@jboss.com> > ** > JBoss Community <http://community.jboss.org/index.jspa> JBPM4 > Migrating from Oracle to Postgres, Transaction Error on JBPM4_LOB created > by Jeff Maas <http://community.jboss.org/people/jeff_maas> in *jBPM* - View > the full discussion <http://community.jboss.org/message/629406#629406> > ------------------------------ > > 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. > > > > [http-80-2] [org.hibernate.util.JDBCExceptionReporter] Large Objects may > not be used in auto-commit mode. > > > > Root Exception stack trace: > > org.postgresql.util.PSQLException: Large Objects may not be used in > auto-commit mode. > > at > org.postgresql.largeobject.LargeObjectManager.open(LargeObjectManager.java:200) > > at > org.postgresql.largeobject.LargeObjectManager.open(LargeObjectManager.java:172) > > at > org.postgresql.jdbc2.AbstractJdbc2BlobClob.<init>(AbstractJdbc2BlobClob.java:47) > > at > org.postgresql.jdbc2.AbstractJdbc2Blob.<init>(AbstractJdbc2Blob.java:21) > > at > org.postgresql.jdbc3.AbstractJdbc3Blob.<init>(AbstractJdbc3Blob.java:19) > > at > org.postgresql.jdbc4.AbstractJdbc4Blob.<init>(AbstractJdbc4Blob.java:20) > > at org.postgresql.jdbc4.Jdbc4Blob.<init>(Jdbc4Blob.java:20) > > at > org.postgresql.jdbc4.Jdbc4ResultSet.getBlob(Jdbc4ResultSet.java:52) > > at > org.postgresql.jdbc2.AbstractJdbc2ResultSet.getBlob(AbstractJdbc2ResultSet.java:335) > > at > com.mchange.v2.c3p0.impl.NewProxyResultSet.getBlob(NewProxyResultSet.java:285) > > at org.hibernate.type.BlobType.get(BlobType.java:80) > > > > 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. > > > > 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. > > > > > > Thanks > > Jeff > > Reply to this message by going to > Community<http://community.jboss.org/message/629406#629406> > > Start a new discussion in jBPM at > Community<http://community.jboss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2034> > > _______________________________________________ > jboss-user mailing list > jboss-user@lists.jboss.org > https://lists.jboss.org/mailman/listinfo/jboss-user > >
_______________________________________________ jboss-user mailing list jboss-user@lists.jboss.org https://lists.jboss.org/mailman/listinfo/jboss-user
