Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

JDBC connection issues

 
vijay kumar
Ranch Hand
Posts: 58
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 1078
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Code?
 
Jeanne Boyarsky
author & internet detective
Marshal
Posts: 35279
384
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
vijay kumar
Ranch Hand
Posts: 58
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 381
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 58
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic