Re: [JBoss-user] Connection is broken
when I restarted jboss and run my ejb and client again ,I got a "tableINFO not found" exception.My sql string just like this:"select * from info". when I changed to "select infosequence.nextval from dual" .I got a "table dual not found" exception. I changed to use "select * from scott.info" ,but it's no use. ? - Original Message - From: zyb2 To: [EMAIL PROTECTED] Sent: Friday, December 07, 2001 4:33 PM Subject: [JBoss-user] Connection is broken [Default] Error:Connection is broken[GetDBConnection] XAException: tx=XidImpl [FormatId=257, GlobalId=zyb//10, BranchQual=] errorCode=XA_UNKNOWN(0)[GetDBConnection] javax.transaction.xa.XAException: Rollback failed: Connectionis broken[GetDBConnection] at org.jboss.pool.jdbc.xa.wrapper.XAResourceImpl.rollback(XAResourceImpl.java:219) // public java.sql.Connection GetConnection() throws RemoteException{java.sql.Connection con;try {con = ds.getConnection("scott","tiger");Statement stmt = con.createStatement ();ResultSet rset = stmt.executeQuery ("select id from scott.info");while (rset.next ()) {String roomid= rset.getString("ID");System.out.println("bbs: " + roomid);}return con;} catch( Exception ex ) {System.out.println("Error:" + ex.getMessage());throw new RemoteException( ex.getMessage() );}}/ I use a pool named OraclePool ,which was tested successfuly! I alsotested my pool with the oracle.jdbc.driver.OracleDriver and it passed.
[JBoss-user] Connection is broken
[Default] Error:Connection is broken[GetDBConnection] XAException: tx=XidImpl [FormatId=257, GlobalId=zyb//10, BranchQual=] errorCode=XA_UNKNOWN(0)[GetDBConnection] javax.transaction.xa.XAException: Rollback failed: Connectionis broken[GetDBConnection] at org.jboss.pool.jdbc.xa.wrapper.XAResourceImpl.rollback(XAResourceImpl.java:219) // public java.sql.Connection GetConnection() throws RemoteException{java.sql.Connection con;try {con = ds.getConnection("scott","tiger");Statement stmt = con.createStatement ();ResultSet rset = stmt.executeQuery ("select id from scott.info");while (rset.next ()) {String roomid= rset.getString("ID");System.out.println("bbs: " + roomid);}return con;} catch( Exception ex ) {System.out.println("Error:" + ex.getMessage());throw new RemoteException( ex.getMessage() );}}/ I use a pool named OraclePool ,which was tested successfuly! I alsotested my pool with the oracle.jdbc.driver.OracleDriver and it passed.
[JBoss-user] Connection is broken
--already posted on the forum but no answer and i don't know what to do-- Hi all ! I'm trying to use JBoss and hsql with heavy data (succession of 3D blocks which could have 1000*1000*200 points with properties associated with...). So i have object with big persitent attributes (to try to limit db access) To initialize my data, i build arrays client side and i try to update the corresponding entity bean (with a set method). With 10*10*3 blocks, all is ok. With 50*50*10 blocks, all goes wrong. If someone could help me ... The exception is: -Client side- [java] java.lang.reflect.UndeclaredThrowableException: javax.transaction.RollbackException: Unable to commit, tx=XidImpl [FormatId=257, GlobalId=grsun51//11, BranchQual=] status=STATUS_ROLLEDBACK [java] at sun.rmi.transport.StreamRemoteCall.exceptionReceivedFromServer(StreamRemoteCall.java:245) [java] at sun.rmi.transport.StreamRemoteCall.executeCall(StreamRemoteCall.java:220) [java] at sun.rmi.server.UnicastRef.invoke(UnicastRef.java:122) [java] at org.jboss.ejb.plugins.jrmp.server.JRMPContainerInvoker_Stub.invoke(Unknown Source) [java] at org.jboss.ejb.plugins.jrmp.interfaces.EntityProxy.invoke(EntityProxy.java:182) [java] at $Proxy4.setPoints(Unknown Source) [java] at com.geomath.t3d.TestClient.buildBlock4D(TestClient.java:308) [java] at com.geomath.t3d.TestClient.main(TestClient.java:497) --Server side-- [PointsBean] java.rmi.ServerException: Store failed; nested exception is: [PointsBean] java.sql.SQLException: Connection is broken [PointsBean] java.sql.SQLException: Connection is broken [PointsBean] at org.hsql.Trace.getError(Trace.java:124) [PointsBean] at org.hsql.Trace.getError(Trace.java:115) [PointsBean] at org.hsql.Trace.error(Trace.java:130) [PointsBean] at org.hsql.jdbcConnection.executeHSQL(jdbcConnection.java:642) [PointsBean] at org.hsql.jdbcConnection.execute(jdbcConnection.java:540) [PointsBean] at org.hsql.jdbcStatement.fetchResult(jdbcStatement.java:499) [PointsBean] at org.hsql.jdbcStatement.executeUpdate(jdbcStatement.java:52) [PointsBean] at org.hsql.jdbcPreparedStatement.executeUpdate(jdbcPreparedStatement.java:114) [PointsBean] at org.opentools.minerva.jdbc.PreparedStatementInPool.executeUpdate(PreparedStatementInPool.java:82) [PointsBean] at org.jboss.ejb.plugins.jaws.jdbc.JDBCUpdateCommand.executeStatementAndHandleResult(JDBCUpdateCommand.java:49) [PointsBean] at org.jboss.ejb.plugins.jaws.jdbc.JDBCCommand.jdbcExecute(JDBCCommand.java:160) [PointsBean] at org.jboss.ejb.plugins.jaws.jdbc.JDBCStoreEntityCommand.execute(JDBCStoreEntityCommand.java:97) [PointsBean] at org.jboss.ejb.plugins.jaws.JAWSPersistenceManager.storeEntity(JAWSPersistenceManager.java:156) [PointsBean] at org.jboss.ejb.plugins.CMPPersistenceManager.storeEntity(CMPPersistenceManager.java:401) [PointsBean] at org.jboss.ejb.plugins.EntitySynchronizationInterceptor$InstanceSynchronization.beforeCompletion(EntitySynchronizationInterceptor.java:342) [PointsBean] at org.jboss.tm.TxCapsule.doBeforeCompletion(TxCapsule.java:1228) [PointsBean] at org.jboss.tm.TxCapsule.commit(TxCapsule.java:322) [PointsBean] at org.jboss.tm.TransactionImpl.commit(TransactionImpl.java:76) [PointsBean] at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:318) [PointsBean] at org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:99) [PointsBean] at org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:190) [PointsBean] at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:195) [PointsBean] at org.jboss.ejb.EntityContainer.invoke(EntityContainer.java:323) [PointsBean] at org.jboss.ejb.plugins.jrmp.server.JRMPContainerInvoker.invoke(JRMPContainerInvoker.java:392) [PointsBean] at java.lang.reflect.Method.invoke(Native Method) [PointsBean] at sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:241) [PointsBean] at sun.rmi.transport.Transport$1.run(Transport.java:142) [PointsBean] at java.security.AccessController.doPrivileged(Native Method) [PointsBean] at sun.rmi.transport.Transport.serviceCall(Transport.java:139) [PointsBean] at sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:443) [PointsBean] at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.java:643) [PointsBean] at java.lang.Thread.run(Thread.java:484) ___ JBoss-user mailing list [EMAIL PROTECTED] http://lists.sourceforge.net/lists/listinfo/jboss-user
Re: [JBoss-user] Connection is broken
Hi, I think maybe you are pushing hypersonic to hard. Try another DB, like postgresql. Burkhard - Original Message - From: Nicolas Ocquidant [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, July 20, 2001 2:29 PM Subject: [JBoss-user] Connection is broken --already posted on the forum but no answer and i don't know what to do-- Hi all ! I'm trying to use JBoss and hsql with heavy data (succession of 3D blocks which could have 1000*1000*200 points with properties associated with...). So i have object with big persitent attributes (to try to limit db access) To initialize my data, i build arrays client side and i try to update the corresponding entity bean (with a set method). With 10*10*3 blocks, all is ok. With 50*50*10 blocks, all goes wrong. If someone could help me ... The exception is: -Client side- [java] java.lang.reflect.UndeclaredThrowableException: javax.transaction.RollbackException: Unable to commit, tx=XidImpl [FormatId=257, GlobalId=grsun51//11, BranchQual=] status=STATUS_ROLLEDBACK [java] at sun.rmi.transport.StreamRemoteCall.exceptionReceivedFromServer(StreamRemoteC all.java:245) [java] at sun.rmi.transport.StreamRemoteCall.executeCall(StreamRemoteCall.java:220) [java] at sun.rmi.server.UnicastRef.invoke(UnicastRef.java:122) [java] at org.jboss.ejb.plugins.jrmp.server.JRMPContainerInvoker_Stub.invoke(Unknown Source) [java] at org.jboss.ejb.plugins.jrmp.interfaces.EntityProxy.invoke(EntityProxy.java:18 2) [java] at $Proxy4.setPoints(Unknown Source) [java] at com.geomath.t3d.TestClient.buildBlock4D(TestClient.java:308) [java] at com.geomath.t3d.TestClient.main(TestClient.java:497) --Server side-- [PointsBean] java.rmi.ServerException: Store failed; nested exception is: [PointsBean] java.sql.SQLException: Connection is broken [PointsBean] java.sql.SQLException: Connection is broken [PointsBean] at org.hsql.Trace.getError(Trace.java:124) [PointsBean] at org.hsql.Trace.getError(Trace.java:115) [PointsBean] at org.hsql.Trace.error(Trace.java:130) [PointsBean] at org.hsql.jdbcConnection.executeHSQL(jdbcConnection.java:642) [PointsBean] at org.hsql.jdbcConnection.execute(jdbcConnection.java:540) [PointsBean] at org.hsql.jdbcStatement.fetchResult(jdbcStatement.java:499) [PointsBean] at org.hsql.jdbcStatement.executeUpdate(jdbcStatement.java:52) [PointsBean] at org.hsql.jdbcPreparedStatement.executeUpdate(jdbcPreparedStatement.java:114) [PointsBean] at org.opentools.minerva.jdbc.PreparedStatementInPool.executeUpdate(PreparedSta tementInPool.java:82) [PointsBean] at org.jboss.ejb.plugins.jaws.jdbc.JDBCUpdateCommand.executeStatementAndHandleR esult(JDBCUpdateCommand.java:49) [PointsBean] at org.jboss.ejb.plugins.jaws.jdbc.JDBCCommand.jdbcExecute(JDBCCommand.java:160 ) [PointsBean] at org.jboss.ejb.plugins.jaws.jdbc.JDBCStoreEntityCommand.execute(JDBCStoreEnti tyCommand.java:97) [PointsBean] at org.jboss.ejb.plugins.jaws.JAWSPersistenceManager.storeEntity(JAWSPersistenc eManager.java:156) [PointsBean] at org.jboss.ejb.plugins.CMPPersistenceManager.storeEntity(CMPPersistenceManage r.java:401) [PointsBean] at org.jboss.ejb.plugins.EntitySynchronizationInterceptor$InstanceSynchronizati on.beforeCompletion(EntitySynchronizationInterceptor.java:342) [PointsBean] at org.jboss.tm.TxCapsule.doBeforeCompletion(TxCapsule.java:1228) [PointsBean] at org.jboss.tm.TxCapsule.commit(TxCapsule.java:322) [PointsBean] at org.jboss.tm.TransactionImpl.commit(TransactionImpl.java:76) [PointsBean] at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT. java:318) [PointsBean] at org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:99) [PointsBean] at org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:19 0) [PointsBean] at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:195) [PointsBean] at org.jboss.ejb.EntityContainer.invoke(EntityContainer.java:323) [PointsBean] at org.jboss.ejb.plugins.jrmp.server.JRMPContainerInvoker.invoke(JRMPContainerI nvoker.java:392) [PointsBean] at java.lang.reflect.Method.invoke(Native Method) [PointsBean] at sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:241) [PointsBean] at sun.rmi.transport.Transport$1.run(Transport.java:142) [PointsBean] at java.security.AccessController.doPrivileged(Native Method) [PointsBean] at sun.rmi.transport.Transport.serviceCall(Transport.java:139) [PointsBean] at sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:443) [PointsBean] at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.java:6 43) [PointsBean] at java.lang.Thread.run(Thread.java:484) ___ JBoss-user mailing list [EMAIL PROTECTED] http://lists.sourceforge.net/lists/listinfo/jboss-user ___ JBoss-user mailing list [EMAIL PROTECTED] http