Re: [JBoss-user] Connection is broken

[zyb2]

when I restarted jboss and run my ejb and client again ,I got a "table INFO 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, Branc hQual=] errorCode=XA_UNKNOWN(0) [GetDBConnection] javax.transaction.xa.XAException: Rollback failed: Connection is broken [GetDBConnection]       at org.jboss.pool.jdbc.xa.wrapper.XAResourceImpl.rollbac k(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 also tested my pool with  the oracle.jdbc.driver.OracleDriver and it passed.