RE : Still socket problems

[KERNEUZET FREDERIC <Fr...@pr-gicm.com>]

Hi Greg,

thanks for your suggestion, i've tried to install Jtds driver but unsuccessfully ... Some doSelect() methods start throwing exceptions (but not all ! Strange ...).

Which pool do you use with your JTDS driver ? And could you give me some examples of your torque configuration file ?


Thanks.
Frederic

-------- Message d'origine--------
De:	Greg Monroe [mailto:Greg.Monroe@DukeCE.com]
Date:	ven. 14/04/2006 15:52
À:	Apache Torque Users List
Cc:	
Objet:	RE: Still socket problems
I use MS SQL with Torque and have load tested some of my webapp to 
the point of 400+ users averaging 30+ page req/sec (with at least 
one query per page) and not had problems.

One thing that I do differently was to use the open source jTDS 
driver instead of MS's.  It's been stable for years, delivered with
a lot of products, passes the J2EE 1.3 cert (which I don't think MS's 
drivers do), and is generally highly recommended by a lot of good 
folks. (And it supports SQL 7.0 for folks stuck with that :)  ).

http://jtds.sourceforge.net/index.html

If this isn't the problem, then come back with some details on
your property settings, etc.

> -----Original Message-----
> From: KERNEUZET FREDERIC [mailto:Frederic.Kerneuzet@pr-gicm.com] 
> 
> i've got problems when i "stress" my webapp : when i reach 28 
> simultaneous users, connections time out because of socket 
> ERROR (10048) => concurrent access on a same socket.
> 
> I'm using an SQL Server with Microsoft driver and SharedPool 
> for my connection ...
> 
> Has someone encountered problems like this ?
> 

Duke CE Privacy Statement
Please be advised that this e-mail and any files transmitted with it are confidential communication or may otherwise be privileged or confidential and are intended solely for the individual or entity to whom they are addressed.  If you are not the intended recipient you may not rely on the contents of this email or any attachments, and we ask that you  please not read, copy or retransmit this communication, but reply to the sender and destroy the email, its contents, and all copies thereof immediately.  Any unauthorized dissemination, distribution or copying of this communication is strictly prohibited.



---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org