JBoss - Oracle and BLOB
jmoliere Sep 12, 2001 5:05 AMHi all,
I'd like to have a valuable answer because I can't spent more time on this problem, so if it is not solved quickly
I fear that Jboss will be changed to a Weblogic server...
Context is :
I'd like to save some cmp fields from entities as BLOBS using the Oracle8 mapping, Oracle 8.1.7.3, inetsoft driver(eval version with no limitation), JBoss 2.4.1 (same results with JBoss 2.2.2).
Creating (or finding beans) induce such result:
I can't figure what's the problem with transactions: I don't have the slightest trace of transactions , nothing declared in my deployment descriptor...
What is the correct way for storing/reading BLOB fields
(deployment descriptor, jaws.xml, home interface & remote interface examples welcomed)
Thanks
Jerome
// your java code here [JAWS] com.inet.ora.SQLException: java.io.IOException: Broken pipe [JAWS] java.io.IOException: Broken pipe [JAWS] at java.net.SocketOutputStream.socketWrite(Native Method) [JAWS] at java.net.SocketOutputStream.write(SocketOutputStream.java:83) [JAWS] at java.io.BufferedOutputStream.flushBuffer(BufferedOutputStream.java:72) [JAWS] at java.io.BufferedOutputStream.flush(BufferedOutputStream.java:130) [JAWS] at com.inet.ora.g.if(Unknown Source) [JAWS] at com.inet.ora.g.int(Unknown Source) [JAWS] at com.inet.ora.g.a(Unknown Source) [JAWS] at com.inet.ora.h.byte(Unknown Source) [JAWS] at com.inet.ora.h.executeUpdate(Unknown Source) [JAWS] at org.jboss.pool.jdbc.PreparedStatementInPool.executeUpdate(PreparedStatementInPool.java:82) [JAWS] at org.jboss.ejb.plugins.jaws.jdbc.JDBCUpdateCommand.executeStatementAndHandleResult(JDBCUpdateCommand.java:49) [JAWS] at org.jboss.ejb.plugins.jaws.jdbc.JDBCCommand.jdbcExecute(JDBCCommand.java:160) [JAWS] at org.jboss.ejb.plugins.jaws.jdbc.JDBCCreateEntityCommand.execute(JDBCCreateEntityCommand.java:135) [JAWS] at org.jboss.ejb.plugins.jaws.JAWSPersistenceManager.createEntity(JAWSPersistenceManager.java:128) [JAWS] at org.jboss.ejb.plugins.CMPPersistenceManager.createEntity(CMPPersistenceManager.java:231) [JAWS] at org.jboss.ejb.EntityContainer.createHome(EntityContainer.java:616) [JAWS] at java.lang.reflect.Method.invoke(Native Method) [JAWS] at org.jboss.ejb.EntityContainer$ContainerInterceptor.invokeHome(EntityContainer.java:843) [JAWS] at org.jboss.ejb.plugins.EntitySynchronizationInterceptor.invokeHome(EntitySynchronizationInterceptor.java:231) [JAWS] at org.jboss.ejb.plugins.EntityInstanceInterceptor.invokeHome(EntityInstanceInterceptor.java:154) [JAWS] at org.jboss.ejb.plugins.EntityLockInterceptor.invokeHome(EntityLockInterceptor.java:108) [JAWS] at org.jboss.ejb.plugins.TxInterceptorCMT.invokeNext(TxInterceptorCMT.java:135) [JAWS] at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:307) [JAWS] at org.jboss.ejb.plugins.TxInterceptorCMT.invokeHome(TxInterceptorCMT.java:86) [JAWS] at org.jboss.ejb.plugins.SecurityInterceptor.invokeHome(SecurityInterceptor.java:103) [JAWS] at org.jboss.ejb.plugins.LogInterceptor.invokeHome(LogInterceptor.java:106) [JAWS] at org.jboss.ejb.EntityContainer.invokeHome(EntityContainer.java:420) [JAWS] at org.jboss.ejb.plugins.jrmp.server.JRMPContainerInvoker.invokeHome(JRMPContainerInvoker.java:437) [JAWS] at org.jboss.ejb.plugins.jrmp.interfaces.HomeProxy.invokeHome(HomeProxy.java:237) [JAWS] at org.jboss.ejb.plugins.jrmp.interfaces.HomeProxy.invoke(HomeProxy.java:182) [JAWS] at $Proxy12.create(Unknown Source) [JAWS] at com.viveo.defmod.plugin.defmodejb.DefmodManagerBean.createDefmodObject(DefmodManagerBean.java:50) [JAWS] at com.viveo.defmod.plugin.defmodejb.DefmodManagerBean.createAddDefmodObject(DefmodManagerBean.java:98) [JAWS] at java.lang.reflect.Method.invoke(Native Method) [JAWS] at org.jboss.ejb.StatelessSessionContainer$ContainerInterceptor.invoke(StatelessSessionContainer.java:543) [JAWS] at org.jboss.ejb.plugins.TxInterceptorBMT.invoke(TxInterceptorBMT.java:276) [JAWS] at org.jboss.ejb.plugins.StatelessSessionInstanceInterceptor.invoke(StatelessSessionInstanceInterceptor.java:87) [JAWS] at org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:128) [JAWS] at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:195) [JAWS] at org.jboss.ejb.StatelessSessionContainer.invoke(StatelessSessionContainer.java:286) [JAWS] at org.jboss.ejb.plugins.jrmp.server.JRMPContainerInvoker.invoke(JRMPContainerInvoker.java:393) [JAWS] at java.lang.reflect.Method.invoke(Native Method) [JAWS] at sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:241) [JAWS] at sun.rmi.transport.Transport$1.run(Transport.java:142) [JAWS] at java.security.AccessController.doPrivileged(Native Method) [JAWS] at sun.rmi.transport.Transport.serviceCall(Transport.java:139) [JAWS] at sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:443) [JAWS] at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.java:643) [JAWS] at java.lang.Thread.run(Thread.java:484) [JAWS] com.inet.ora.SQLException: java.io.IOException: Broken pipe [JAWS] java.io.IOException: Broken pipe [JAWS] at java.net.SocketOutputStream.socketWrite(Native Method) [JAWS] at java.net.SocketOutputStream.write(SocketOutputStream.java:83) [JAWS] at java.io.BufferedOutputStream.flushBuffer(BufferedOutputStream.java:72) [JAWS] at java.io.BufferedOutputStream.flush(BufferedOutputStream.java:130) [JAWS] at com.inet.ora.g.if(Unknown Source) [JAWS] at com.inet.ora.g.int(Unknown Source) [JAWS] at com.inet.ora.g.a(Unknown Source) [JAWS] at com.inet.ora.h.byte(Unknown Source) [JAWS] at com.inet.ora.h.executeUpdate(Unknown Source) [JAWS] at org.jboss.pool.jdbc.PreparedStatementInPool.executeUpdate(PreparedStatementInPool.java:82) [JAWS] at org.jboss.ejb.plugins.jaws.jdbc.JDBCUpdateCommand.executeStatementAndHandleResult(JDBCUpdateCommand.java:49) [JAWS] at org.jboss.ejb.plugins.jaws.jdbc.JDBCCommand.jdbcExecute(JDBCCommand.java:160) [JAWS] at org.jboss.ejb.plugins.jaws.jdbc.JDBCCreateEntityCommand.execute(JDBCCreateEntityCommand.java:135) [JAWS] at org.jboss.ejb.plugins.jaws.JAWSPersistenceManager.createEntity(JAWSPersistenceManager.java:128) [JAWS] at org.jboss.ejb.plugins.CMPPersistenceManager.createEntity(CMPPersistenceManager.java:231) [JAWS] at org.jboss.ejb.EntityContainer.createHome(EntityContainer.java:616) [JAWS] at java.lang.reflect.Method.invoke(Native Method) [JAWS] at org.jboss.ejb.EntityContainer$ContainerInterceptor.invokeHome(EntityContainer.java:843) [JAWS] at org.jboss.ejb.plugins.EntitySynchronizationInterceptor.invokeHome(EntitySynchronizationInterceptor.java:231) [JAWS] at org.jboss.ejb.plugins.EntityInstanceInterceptor.invokeHome(EntityInstanceInterceptor.java:154) [JAWS] at org.jboss.ejb.plugins.EntityLockInterceptor.invokeHome(EntityLockInterceptor.java:108) [JAWS] at org.jboss.ejb.plugins.TxInterceptorCMT.invokeNext(TxInterceptorCMT.java:135) [JAWS] at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:307) [JAWS] at org.jboss.ejb.plugins.TxInterceptorCMT.invokeHome(TxInterceptorCMT.java:86) [JAWS] at org.jboss.ejb.plugins.SecurityInterceptor.invokeHome(SecurityInterceptor.java:103) [JAWS] at org.jboss.ejb.plugins.LogInterceptor.invokeHome(LogInterceptor.java:106) [JAWS] at org.jboss.ejb.EntityContainer.invokeHome(EntityContainer.java:420) [JAWS] at org.jboss.ejb.plugins.jrmp.server.JRMPContainerInvoker.invokeHome(JRMPContainerInvoker.java:437) [JAWS] at org.jboss.ejb.plugins.jrmp.interfaces.HomeProxy.invokeHome(HomeProxy.java:237) [JAWS] at org.jboss.ejb.plugins.jrmp.interfaces.HomeProxy.invoke(HomeProxy.java:182) [JAWS] at $Proxy12.create(Unknown Source) [JAWS] at com.viveo.defmod.plugin.defmodejb.DefmodManagerBean.createDefmodObject(DefmodManagerBean.java:50) [JAWS] at com.viveo.defmod.plugin.defmodejb.DefmodManagerBean.createAddDefmodObject(DefmodManagerBean.java:98) [JAWS] at java.lang.reflect.Method.invoke(Native Method) [JAWS] at org.jboss.ejb.StatelessSessionContainer$ContainerInterceptor.invoke(StatelessSessionContainer.java:543) [JAWS] at org.jboss.ejb.plugins.TxInterceptorBMT.invoke(TxInterceptorBMT.java:276) [JAWS] at org.jboss.ejb.plugins.StatelessSessionInstanceInterceptor.invoke(StatelessSessionInstanceInterceptor.java:87) [JAWS] at org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:128) [JAWS] at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:195) [JAWS] at org.jboss.ejb.StatelessSessionContainer.invoke(StatelessSessionContainer.java:286) [JAWS] at org.jboss.ejb.plugins.jrmp.server.JRMPContainerInvoker.invoke(JRMPContainerInvoker.java:393) [JAWS] at java.lang.reflect.Method.invoke(Native Method) [JAWS] at sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:241) [JAWS] at sun.rmi.transport.Transport$1.run(Transport.java:142) [JAWS] at java.security.AccessController.doPrivileged(Native Method) [JAWS] at sun.rmi.transport.Transport.serviceCall(Transport.java:139) [JAWS] at sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:443) [JAWS] at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.java:643) [JAWS] at java.lang.Thread.run(Thread.java:484) [OracleDB] Pool OracleDB [0/0/Unlimited] destroyed object org.jboss.pool.jdbc.xa.wrapper.XAConnectionImpl@27508a. [Default] java.lang.reflect.UndeclaredThrowableException: [Default] javax.transaction.HeuristicRollbackException [Default] at org.jboss.tm.TxCapsule.checkHeuristics(TxCapsule.java:1323) [Default] [Default] at org.jboss.tm.TxCapsule.commit(TxCapsule.java:357) [Default] [Default] at org.jboss.tm.TransactionImpl.commit(TransactionImpl.java:76) [Default] [Default] at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:364) [Default] [Default] at org.jboss.ejb.plugins.TxInterceptorCMT.invokeHome(TxInterceptorCMT.java:86) [Default] [Default] at org.jboss.ejb.plugins.SecurityInterceptor.invokeHome(SecurityInterceptor.java:103) [Default] [Default] at org.jboss.ejb.plugins.LogInterceptor.invokeHome(LogInterceptor.java:106) [Default] [Default] at org.jboss.ejb.EntityContainer.invokeHome(EntityContainer.java:420) [Default] [Default] at org.jboss.ejb.plugins.jrmp.server.JRMPContainerInvoker.invokeHome(JRMPContainerInvoker.java:437) [Default] [Default] at org.jboss.ejb.plugins.jrmp.interfaces.HomeProxy.invokeHome(HomeProxy.java:237) [Default] [Default] at org.jboss.ejb.plugins.jrmp.interfaces.HomeProxy.invoke(HomeProxy.java:182) [Default] [Default] at $Proxy12.create(Unknown Source) [Default] [Default] at com.viveo.defmod.plugin.defmodejb.DefmodManagerBean.createDefmodObject(DefmodManagerBean.java:50) [Default] [Default] at com.viveo.defmod.plugin.defmodejb.DefmodManagerBean.createAddDefmodObject(DefmodManagerBean.java:98) [Default] [Default] at java.lang.reflect.Method.invoke(Native Method) [Default] [Default] at org.jboss.ejb.StatelessSessionContainer$ContainerInterceptor.invoke(StatelessSessionContainer.java:543) [Default] [Default] at org.jboss.ejb.plugins.TxInterceptorBMT.invoke(TxInterceptorBMT.java:276) [Default] [Default] at org.jboss.ejb.plugins.StatelessSessionInstanceInterceptor.invoke(StatelessSessionInstanceInterceptor.java:87) [Default] [Default] at org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:128) [Default] [Default] at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:195) [Default] [Default] at org.jboss.ejb.StatelessSessionContainer.invoke(StatelessSessionContainer.java:286) [Default] [Default] at org.jboss.ejb.plugins.jrmp.server.JRMPContainerInvoker.invoke(JRMPContainerInvoker.java:393) [Default] [Default] at java.lang.reflect.Method.invoke(Native Method) [Default] [Default] at sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:241) [Default] [Default] at sun.rmi.transport.Transport$1.run(Transport.java:142) [Default] [Default] at java.security.AccessController.doPrivileged(Native Method) [Default] [Default] at sun.rmi.transport.Transport.serviceCall(Transport.java:139) [Default] [Default] at sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:443) [Default] [Default] at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.java:643) [Default] [Default] at java.lang.Thread.run(Thread.java:484) [Default]