File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

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

 
deepti singal
Greenhorn
Posts: 4
  • 0
  • 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
 
Sagar Rohankar
Ranch Hand
Posts: 2906
1
Java Spring Ubuntu
  • 0
  • 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
  • 0
  • 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: 2906
1
Java Spring Ubuntu
  • 0
  • 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
  • 0
  • 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
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Please tell me how to check db config?
 
I agree. Here's the link: http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic