You are getting the underlying Oracle connection and closing it. At this point, the connection has become unusable because you have directly closed the physical connection and as a result, it is no longer valid.
Close the handle, NOT the actual connection. The example psuedo code illustrates this: | | Connection conn = DataSource.getConnection(); | Connection oracleConn = conn.getUnderlyingConnection(); | | //Do JDBC stuff heere | | //CLOSE THE HANDLE, NOT THE UNDERLYING CONNECTION!!!! | conn.close(); | | conn = DataSource.getConnection(); | oracleConn = conn.getUnderlyingConnection(); | | As far as the 'reboot' thing is concerned, I believe what you mean is that your application has become unusuable. The app server as whole would not be effected by this. View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4030167#4030167 Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4030167 _______________________________________________ jboss-user mailing list [email protected] https://lists.jboss.org/mailman/listinfo/jboss-user
