Re: [jboss-user] [jBPM] - JBPM4 Migrating from Oracle to Postgres, Transaction Error on JBPM4_LOB
by Alexander Lvov
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(a)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&cont...>
>
> _______________________________________________
> jboss-user mailing list
> jboss-user(a)lists.jboss.org
> https://lists.jboss.org/mailman/listinfo/jboss-user
>
>
14 years, 6 months
[jBPM] - Re: jBPM 5.1 with SQL Server
by Hugo Boss
Hugo Boss [http://community.jboss.org/people/adfasdfasdfhjasdfhasddfhasdfaj] created the discussion
"Re: jBPM 5.1 with SQL Server"
To view the discussion, visit: http://community.jboss.org/message/629412#629412
--------------------------------------------------------------
I have the same problem... i'm using hsqldb and this driver org.hsqldb.jdbcDriver
Please post your solution, if you find one. Thank you.
[CODE]
Caused by: org.springframework.beans.BeanInstantiationException: Could not instantiate bean class [com.plixia.domain.businessprocess.ProcessSessionFactory]: Constructor threw exception; nested exception is bitronix.tm.resource.ResourceConfigurationException: cannot create JDBC datasource named jdbc/jbpmDataSource
at org.springframework.beans.BeanUtils.instantiateClass(BeanUtils.java:141)
at org.springframework.beans.factory.support.SimpleInstantiationStrategy.instantiate(SimpleInstantiationStrategy.java:71)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.instantiateBean(AbstractAutowireCapableBeanFactory.java:948)
... 56 more
Caused by: bitronix.tm.resource.ResourceConfigurationException: cannot create JDBC datasource named jdbc/jbpmDataSource
at bitronix.tm.resource.jdbc.PoolingDataSource.init(PoolingDataSource.java:76)
at com.plixia.domain.businessprocess.ProcessSessionFactory.initEnvironment(ProcessSessionFactory.java:74)
at com.plixia.domain.businessprocess.ProcessSessionFactory.<init>(ProcessSessionFactory.java:57)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
at org.springframework.beans.BeanUtils.instantiateClass(BeanUtils.java:126)
... 58 more
Caused by: bitronix.tm.utils.PropertyException: no writeable property 'URL' in class 'org.hsqldb.jdbcDriver'
at bitronix.tm.utils.PropertyUtils.getSetter(PropertyUtils.java:318)
at bitronix.tm.utils.PropertyUtils.setDirectProperty(PropertyUtils.java:217)
at bitronix.tm.utils.PropertyUtils.setProperty(PropertyUtils.java:83)
at bitronix.tm.resource.common.XAPool.createXAFactory(XAPool.java:314)
at bitronix.tm.resource.common.XAPool.<init>(XAPool.java:63)
at bitronix.tm.resource.jdbc.PoolingDataSource.buildXAPool(PoolingDataSource.java:85)
at bitronix.tm.resource.jdbc.PoolingDataSource.init(PoolingDataSource.java:72)
... 65 more
[/CODE]
--------------------------------------------------------------
Reply to this message by going to Community
[http://community.jboss.org/message/629412#629412]
Start a new discussion in jBPM at Community
[http://community.jboss.org/choose-container!input.jspa?contentType=1&cont...]
14 years, 6 months
[JBoss Tools] - JBoss AS7 webapp development
by Konrad Wolski
Konrad Wolski [http://community.jboss.org/people/konwol] created the discussion
"JBoss AS7 webapp development"
To view the discussion, visit: http://community.jboss.org/message/628012#628012
--------------------------------------------------------------
Hi,
Our team wants to switch to JBoss 7 as a development platform on a regular day to day basis. Currenly we use Tomcat 7. We want to use JBoss Tools and have tested current development version.
Is there an article explaining how incremental publishing works ?
We want to achive same setup as with Tomcat 7 wtp server adapter, that is:
1) automatic redeployment of application when a dynamic resource changes (like a Java class)
2) no redeployment when a static resource changes (only refresh)
>From what we see in default configuration (exploded webapp) static resources are refreshed but dynamic resources do not trigger automatic redeployment. Is there something we are missing or the community server adapter doesn't support this feature ?
I am aware that scanning of exploded application can be enabled but we want to avoid it so static resource changes do not trigger full redeployment.
---
Second concern is that we are building our projects using maven multimodule functionality. When the tools are switched to deploy archives (war is the target here) automatic redeployment doesn't happen when a dependency in WEB-INF/lib changes. We created two simple projects:
a) one named 'dep1' (Java Project)
b) second named 'webapp' (Dynamic Web Project) with the 'dep1' set in "Deployment assembly" project properties
The dependency is placed in WEB-INF/lib/dep1.jar. When we recompile a class that is in "webapp" project the whole application gets redeployed (cool), but when a class from 'dep1' is recompiled the application isn't redeployed. We are yet again forced to do manual deployment like in the first problem.
In a way those two are problems are connected. We don't use any JBoss 7 specific functionallity yet. These are simple web applications (no ear, osgi, etc).
Thanks,
Konrad
--------------------------------------------------------------
Reply to this message by going to Community
[http://community.jboss.org/message/628012#628012]
Start a new discussion in JBoss Tools at Community
[http://community.jboss.org/choose-container!input.jspa?contentType=1&cont...]
14 years, 6 months