RE: Connection pooling with sql server

[Turner, John]

Not sure what you mean by jdbc driver from datadirect but if you mean the
free JDBC driver from Microsoft, we were never able to get it to support
pooling after several weeks of trying.

We ended up purchasing a license to a third-party driver.  Benefits were
actual pooling, and on top of that, support for CachedRowSet which was a key
feature we needed for our apps.

John

 -Original Message-
 From: Ashruf Hussain [mailto:[EMAIL PROTECTED]]
 Sent: Sunday, December 15, 2002 9:44 PM
 To: [EMAIL PROTECTED]
 Subject: Connection pooling with sql server
 
 
 Hi all,
 
 I am new user of tomcat 4.1, using jdbc driver from 
 datadirect to connect to
 sqlserver database. 
 I am able to get normal individual connections without pooling. 
 Now, I want to get connections from connection pool. 
 I tried with all my efforts (followed pooling documentation) to get
 connection pooling done with sql server, but tomcat hangs up 
 at start up.
 
 Anybody who has done it all, pls help.
 
 Thanks in advance,
 
 Ashruf
 
 ---
 Regards, 
 Mohammed Ashruf Hussain
 Software Engineer.
 Virtusa, Corp. (formerly erunway)
 Work 040 23414200 ext(303)
 www.virtusa.com 
 
 
 
 --
 To unsubscribe, e-mail:   
 mailto:[EMAIL PROTECTED]
 For additional commands, e-mail: 
 mailto:[EMAIL PROTECTED]
 

--
To unsubscribe, e-mail:   mailto:[EMAIL PROTECTED]
For additional commands, e-mail: mailto:[EMAIL PROTECTED]

Re: Connection pooling with sql server

[Peng Tuck Kwok]

I've never managed to get tomcat to hang on a mis-configured db-pool, 
just got it to throw exceptions. Post your server.xml and web.xml and 
let the mailling list have a look. Your jsp or servlet if you are using 
any would be helpful.

Ashruf Hussain wrote:
Hi all,

I am new user of tomcat 4.1, using jdbc driver from datadirect to connect to
sqlserver database. 
I am able to get normal individual connections without pooling. 
Now, I want to get connections from connection pool. 
I tried with all my efforts (followed pooling documentation) to get
connection pooling done with sql server, but tomcat hangs up at start up.

Anybody who has done it all, pls help.

Thanks in advance,

Ashruf

---
Regards, 
Mohammed Ashruf Hussain
Software Engineer.
Virtusa, Corp. (formerly erunway)
Work 040 23414200 ext(303)
www.virtusa.com 



--
To unsubscribe, e-mail:   mailto:[EMAIL PROTECTED]
For additional commands, e-mail: mailto:[EMAIL PROTECTED]





--
To unsubscribe, e-mail:   mailto:[EMAIL PROTECTED]
For additional commands, e-mail: mailto:[EMAIL PROTECTED]