[jboss-user] [JCA/JBoss] - OracleConnection underlyingConn after Close(); do not work

[Oleg1962]

Good afternoon! 

Prompt please, why after conn.close (); and the subsequent conn = getConnection (); I receive an error

ERROR [STDERR] java.sql.SQLException: closed connection
ERROR [STDERR] 	at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)

ERROR [STDERR] 	at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)

ERROR [STDERR] 	at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:269)

ERROR [STDERR] 	at oracle.jdbc.driver.OracleConnection.privatePrepareStatement(OracleConnection.java:895)

ERROR [STDERR] 	at oracle.jdbc.driver.OracleConnection.prepareStatement(OracleConnection.java:802)

ERROR [STDERR] 	at com.titan.processpayment.ProcessPaymentBean.SelectJGeom(ProcessPaymentBean.java:64)

ERROR [STDERR] 	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

ERROR [STDERR] 	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

 Also I can work further only after reboot JBoss


  | public class ProcessPaymentBean implements javax.ejb.SessionBean
  | ............................
  |  conn = getConnection ();
  |  pstmt = conn.prepareStatement("select MKT_ID, NAME, SHAPE from MDSYS.cola_markets");
  |  rs = pstmt.executeQuery();
  |  pstmt2 = conn.prepareStatement("insert into MDSYS.cola_markets2 (MKT_ID, NAME, SHAPE) values (?, ?, ?)");
  |   
  |  while (rs.next()) {
  |    state = rs.getString(1);
  |    stateAbrv = rs.getString(2);
  |    st = (STRUCT) rs.getObject("SHAPE");
  |    geom = JGeometry.load(st);
  |    pstmt2.setString(1, state);
  |    pstmt2.setString(2, stateAbrv);
  |    st2 = JGeometry.store(geom, conn);
  |    pstmt2.setObject(3, st2);
  |    pstmt2.executeUpdate();
  |  } 
  | .....
  | conn.close();
  | .....
  | conn = getConnection ();
  | //I receive the message on an error
  | //Also I can work further only after reboot JBoss
  | 
  | 
  | private Connection getConnection() throws SQLException {
  |   //http://forums.oracle.com/forums/thread.jspa?threadID=279238
  |   try {
  |     DataSource myJBossDatasource = (DataSource) context.lookup("java:OracleDS");
  |     java.sql.Connection conn = myJBossDatasource.getConnection();
  |        WrappedConnection wrappedConn = (WrappedConnection)conn;
  |        java.sql.Connection underlyingConn = wrappedConn.getUnderlyingConnection();
  |    oracle.jdbc.driver.OracleConnection oracleConn =
  |        (oracle.jdbc.driver.OracleConnection)underlyingConn;
  |    return oracleConn;
  |   }
  |   catch (SQLException ex) {
  |     throw new EJBException(ex);
  |   }
  | }
  | 
  | 


  |   <enterprise-beans>
  |     <session>
  |       <description>A service that handles monetary payments</description>
  |       <display-name>ProcessPaymentEJB</display-name>
  |       <ejb-name>ProcessPaymentEJB</ejb-name>
  |       <home>com.titan.processpayment.ProcessPaymentHomeRemote</home>
  |       <remote>com.titan.processpayment.ProcessPaymentRemote</remote>
  |       <ejb-class>com.titan.processpayment.ProcessPaymentBean</ejb-class>
  |       <session-type>Stateless</session-type>
  |       <transaction-type>Container</transaction-type>
  |       <env-entry>
  |         <env-entry-name>minCheckNumber</env-entry-name>
  |         <env-entry-type>java.lang.Integer</env-entry-type>
  |         <env-entry-value>2000</env-entry-value>
  |       </env-entry>
  |       <resource-ref>
  |         <description>DataSource for the Titan database</description>
  |         <res-ref-name>jdbc/titanDB</res-ref-name>
  |         <res-type>javax.sql.DataSource</res-type>
  |         <res-auth>Container</res-auth>
  |       </resource-ref>
  |     </session>
  |   </enterprise-beans>
  | 

For earlier it is grateful for the help

View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4030161#4030161

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4030161