This week's book giveaway is in the Servlets forum.
We're giving away four copies of Murach's Java Servlets and JSP and have Joel Murach on-line!
See this thread for details.
The moose likes JDBC and the fly likes Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark ""java.sql.exception:[microsoft][sqlserver 2000 driver forJDBC] connection reset"" Watch ""java.sql.exception:[microsoft][sqlserver 2000 driver forJDBC] connection reset"" New topic
Author

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

deepti singal
Greenhorn

Joined: Jan 10, 2013
Posts: 4
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

Joined: Feb 19, 2008
Posts: 2902
    
    1

Can you paste connection details here, like db url and other extra param you are using for creating connection object.


[LEARNING bLOG] | [Freelance Web Designer] | [and "Rohan" is part of my surname]
deepti singal
Greenhorn

Joined: Jan 10, 2013
Posts: 4
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

Joined: Feb 19, 2008
Posts: 2902
    
    1

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

Joined: Jan 10, 2013
Posts: 4
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

Joined: Jan 10, 2013
Posts: 4
Please tell me how to check db config?
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: "java.sql.exception:[microsoft][sqlserver 2000 driver forJDBC] connection reset"
 
Similar Threads
How to convert Blob Type back to File
Getting Exception as Could not find stored procedure 'sp_getNextMainGroup'
Problem in making connection
"Could not find stored procedure" Error
visual J++ and retreiving rows from sql server