It seems you are using the same connection to
create two statements. I would craete two separate
connections. When you close the statement, that,
usually, closes the connection and the result set
associated with the statement. So, always, close
everything ONLY once you are done...
Also, a couple of suggestions. IF you are
definetely using weblogic for your deployment
environment, I would suggest using the WebLogic's SQL
Server driver instead of JDBC-ODBC bridge: MUCH more
stable. Also, instead of creating the connection
right away, use weblogic connection pool and a
datasource...