• 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 Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

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

 
Greenhorn
Posts: 4
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Please tell me how to check db config?
 
Did you ever grow anything in the garden of your mind? - Fred Rogers. Tiny ad:
a bit of art, as a gift, that will fit in a stocking
https://gardener-gift.com
reply
    Bookmark Topic Watch Topic
  • New Topic