wood burning stoves 2.0*
The moose likes JDBC and the fly likes JDBC connection issues Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "JDBC connection issues" Watch "JDBC connection issues" New topic
Author

JDBC connection issues

vijay kumar
Ranch Hand

Joined: Nov 05, 2005
Posts: 58
i'm getting the following error while trying to connect to SQLServer2000 from java .
Connection is busy with the results of other hstmt.

I tried with both ODBC driver and Microsoft's jdbc driver for sqlserver.

Can any one help me resolve this issue
Ken Blair
Ranch Hand

Joined: Jul 15, 2003
Posts: 1078
Code?
Jeanne Boyarsky
internet detective
Marshal

Joined: May 26, 2003
Posts: 30123
    
150

Ram,
Welcome to JavaRanch!

Double check you are closing the statement before starting a new one. Also, post the code as Ken suggested so we can give you more specific advice.


[Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Blogging on Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, OCAJP, OCPJP beta, TOGAF part 1 and part 2
vijay kumar
Ranch Hand

Joined: Nov 05, 2005
Posts: 58
i have made some changes and it's working with TYPE4 driver
and not with Type1

Why this is not working with Type1.

does Type 1 not support multiple active resultsets?
Maximilian Xavier Stocker
Ranch Hand

Joined: Sep 20, 2005
Posts: 381
Originally posted by Ram kumar:
i have made some changes and it's working with TYPE4 driver
and not with Type1

Why this is not working with Type1.

does Type 1 not support multiple active resultsets?


No. But technically the type 4 should not either and you just lucked out there.
[ November 10, 2005: Message edited by: Maximilian Stocker ]
vijay kumar
Ranch Hand

Joined: Nov 05, 2005
Posts: 58
for oracle database with Type I driver also working fine
MicroSoft is telling that odbc driver dont support multiple active statments of SQL server only.
 
 
subject: JDBC connection issues
 
Similar Threads
Oracle JDBC-OCI driver with Hibernate
How to connect to Pradox v4 through Java
connection object
JDBC Drivers
Configuring JDBC Connectionpool in Weblogic7.0 with Oracle thin driver