Win a copy of Svelte and Sapper in Action this week in the JavaScript forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Ron McLeod
  • Paul Clapham
  • Bear Bibeault
  • Junilu Lacar
Sheriffs:
  • Jeanne Boyarsky
  • Tim Cooke
  • Henry Wong
Saloon Keepers:
  • Tim Moores
  • Stephan van Hulst
  • Tim Holloway
  • salvin francis
  • Frits Walraven
Bartenders:
  • Scott Selikoff
  • Piet Souris
  • Carey Brown

"java.sql.exception:[microsoft][sqlserver 2000 driver forJDBC] connection reset"

 
Greenhorn
Posts: 4
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi Everyone,

I got this error

java.sql.SQLEXCEPTION :[microsoft][sqlserver 2000 driver forJDBC] connection reset"

while executing

"$pstmt executeQuery "SELECT InstallReqID FROM STAutorequest where ID='$iReqID'"

(procedure "GetInstallID" line4)

invoked from within

"GetInstallID $iReqID"

(procedure "CreateEmailReport" line26)

invoked from within

please reply asap

Thanks
 
Ranch Hand
Posts: 2908
1
Spring Java Ubuntu
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Can you paste connection details here, like db url and other extra param you are using for creating connection object.
 
deepti singal
Greenhorn
Posts: 4
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi Sagar,

Thanku for replying.This exception started coming up when we changed "SQL Enterprise Manager to MS SQL 2005 " otherwise things were working fine earlier

Please tell me is there any limit on the no of connections that are supported by MS SQL 2005? and how can i see the active connections (any query to extract this info?)

Do help me if you have some solution

Thanks in advance
 
Sagar Rohankar
Ranch Hand
Posts: 2908
1
Spring Java Ubuntu
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator

deepti singal wrote:This exception started coming up when we changed "SQL Enterprise Manager to MS SQL 2005 " otherwise things were working fine earlier


Pardon my little knowledge of SQl Server, but try updating/changing JDBC driver for MS SQL 2005.

Please tell me is there any limit on the no of connections that are supported by MS SQL 2005? and how can i see the active connections (any query to extract this info?)


The concurrent connection limit is something configure in db server, please check db config. For seeing active connections, you have to query db for that, and I don't how to that, googling will help.
 
deepti singal
Greenhorn
Posts: 4
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I don't think it is driver issue because this exception comes up in 2 out of 10.due to this our work is hampered

Do you need more information ?
 
deepti singal
Greenhorn
Posts: 4
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Please tell me how to check db config?
 
Consider Paul's rocket mass heater.
    Bookmark Topic Watch Topic
  • New Topic