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#...
Reply to the post :
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&a...