Hi Brent,
I think your best bet would be to talk to the folks at the JDBC forum on the Microsoft newsgroups. I've had a terrible week with SQL Server too. :)
Sorry I couldn't be of further help,
Abdullah
Brent Ryan wrote:
I'm running SQL Server 2000 8.00.760. The connection reset problem happens for any sql statement, but the ones that I'm testing are:
<select id="getUsers" resultMap="userResult"> select * from BBEXTRACT.USERS </select>
<select id="getRoles" resultMap="roleResult"> select * from BBEXTRACT.ROLES </select>
I never had this problem when connection to a Oracle DB. This only happens when connecting to MS SQL Server.
------------------------------------ Brent Ryan
-----Original Message----- From: Abdullah Kauchali [mailto:[EMAIL PROTECTED] Sent: Thursday, March 17, 2005 11:22 AM To: [email protected] Subject: Re: MS SQL Server 2000 connection reset problem
Brent Ryan wrote:
> * The commiting/rolling back is handled by the datasource > automatically. > > * The max allowable connection is set to 0 * netstat -n on client > and server show 3 connections established. > > If I set this property to 0 then it works, but then this means > there is
> nothing in the pool. Right? <property > name="Pool.MaximumIdleConnections" value="0"/ >
Also, can you post the SQL statement?
Don't miss the 2005 Blackboard Users Conference April 12-14 in Baltimore, MD! Visit http://www.blackboard.com/about/events/BbUC05/index.htm for more information.
This e-mail is intended only for the personal and confidential use of the recipient(s) named above. It may include Blackboard confidential and proprietary information, and is not for redistribution.
