0 Replies Latest reply on Sep 12, 2001 5:05 AM by Jerome Moliere

    JBoss - Oracle and BLOB

    Jerome Moliere Newbie

      Hi 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]