'Re: [jboss-user] [jBPM] - JBPM4 Migrating from Oracle to Postgres,'

[prev in list] [next in list] [prev in thread] [next in thread] 

List: jboss-user
Subject: Re: [jboss-user] [jBPM] - JBPM4 Migrating from Oracle to Postgres,
From: Alexander Lvov <alexanderlvov1 () gmail ! com>
Date: 2011-09-29 19:04:12
Message-ID: CACpw7FKpDkxVedpMsGxtqP5o5ZG5eXjFk9tUk_dRs6Yqb34Hbg () mail ! gmail ! com
[Download RAW message or body]

[Attachment #2 (multipart/alternative)]

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-reply@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
> 
> 

[Attachment #5 (text/html)]

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. <div class="gmail_quote">2011/9/29 Jeff Maas &lt;<a \
href="mailto:do-not-reply@jboss.com">do-not-reply@jboss.com</a>&gt; \
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc \
solid;padding-left:1ex;">

<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>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 -&gt; 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.&lt;init&gt;(AbstractJdbc2BlobClob.java:47) \
at org.postgresql.jdbc2.AbstractJdbc2Blob.&lt;init&gt;(AbstractJdbc2Blob.java:21) \
 at org.postgresql.jdbc3.AbstractJdbc3Blob.&lt;init&gt;(AbstractJdbc3Blob.java:19) \
at org.postgresql.jdbc4.AbstractJdbc4Blob.&lt;init&gt;(AbstractJdbc4Blob.java:20) \
at org.postgresql.jdbc4.Jdbc4Blob.&lt;init&gt;(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&#39;m a bit \
out of my element, I&#39;ve tried various forum searched and googles but haven&#39;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&#39;s and right now I&#39;ve got the various jbpm4 \
libraries (maven) on my classpath. But I&#39;m at a loss on how to deal with this \
issue surrounding auto-commit. I&#39;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&#39;m not sure if anyone has recieved an answer. \
Any help or sympathy is greatly appreciated. ThanksJeff</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&amp;containerType=14&amp;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>

_______________________________________________
jboss-user mailing list
jboss-user@lists.jboss.org
https://lists.jboss.org/mailman/listinfo/jboss-user

[prev in list] [next in list] [prev in thread] [next in thread] 