Logo 
Search:

Java Answers

Ask Question   UnAnswered
Home » Forum » Java       RSS Feeds
  Question Asked By: Nicole Hughes   on Feb 20 In Java Category.

  
Question Answered By: Isaac Evans   on Feb 20

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...

Share: 

 
 
Didn't find what you were looking for? Find more on prob in using SQL Server through JDBC Or get search suggestion and latest updates.


Tagged: