Storing massive sized field into Entity Bean

Discussions

EJB programming & troubleshooting: Storing massive sized field into Entity Bean

  1. Storing massive sized field into Entity Bean (1 messages)

    Hi,

    I am trying to store a field into a EMP 2.0 Entity Bean, whose size is in the order of a MB's(20-50 MB).

    When i do that i get the following error


    2003-03-03 14:00:19,671 ERROR [org.jboss.ejb.GlobalTxEntityMap] Store failed on entity: xyz/units
    javax.ejb.EJBException: Store failed; CausedByException is:
    Connection is broken
    at org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreEntityCommand.execute(JDBCStoreEntityCommand.java:94)
    at org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.storeEntity(JDBCStoreManager.java:589)
    at org.jboss.ejb.plugins.CMPPersistenceManager.storeEntity(CMPPersistenceManager.java:458)
    at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.storeEntity(CachedConnectionInterceptor.java:388)
    at org.jboss.ejb.EntityContainer.storeEntity(EntityContainer.java:708)
    at org.jboss.ejb.GlobalTxEntityMap.syncEntities(GlobalTxEntityMap.java:117)
    at org.jboss.ejb.GlobalTxEntityMap$GlobalTxEntityMapCleanup.beforeCompletion(GlobalTxEntityMap.java:185)
    at org.jboss.tm.TxCapsule.doBeforeCompletion(TxCapsule.java:1394)
    at org.jboss.tm.TxCapsule.commit(TxCapsule.java:364)
    at org.jboss.tm.TransactionImpl.commit(TransactionImpl.java:73)
    at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:251)
    at org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:92)
    at org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:130)
    at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:204)
    at org.jboss.ejb.StatelessSessionContainer.invoke(StatelessSessionContainer.java:313)
    at org.jboss.ejb.Container.invoke(Container.java:712)
    at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:517)
    at org.jboss.invocation.jrmp.server.JRMPInvoker.invoke(JRMPInvoker.java:382)
    at sun.reflect.GeneratedMethodAccessor56.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    at java.lang.reflect.Method.invoke(Method.java:324)
    at sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:261)
    at sun.rmi.transport.Transport$1.run(Transport.java:148)
    at java.security.AccessController.doPrivileged(Native Method)
    at sun.rmi.transport.Transport.serviceCall(Transport.java:144)
    at sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:460)
    at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.java:701)
    at java.lang.Thread.run(Thread.java:536)
    java.sql.SQLException: Connection is broken



    I am using JBoss 3.0.6, CMP 2.0

    Can somebody let me know what am i doing wrong ? I am pretty sure it is to do with the xml settings in one of the xml files.

    I have ejb-jar.xml in my .EAR and i am using that only, I dont have a specific jboss.xml or jbossjdbc.xml .. do i have to do any specific changes in those files ? If yes can you guys please point me to a document.

    TIA

    Meka Toka
  2. which DBMS are you using ?

    Have you tried Oracle and Pointbase ?