Connection pooling.

[engasi]

Our website is JSP-based. We use JRun 3.0 and the JDBC Driver is Merant DirectData from company DataDirect Technologies. Database is SQL Server 2000. The current site is slow. We thought it is probably because we didn't use connection pooling. My question is what procudure shall we go through to apply connection pooling? Where shall we start, JSP coding, Servlets under ..\WEB-INF\lib and ..\WEB-INFclass, or JRun 3.0 itself?

 

[iSeriesCodePoet]

I don't know that much, but anywhere in your programs that you are connecting to a data base you should have a connection pool setup. iSeriesCodePoet
IBM iSeries (AS/400) Programmer

 

[Rayz66]

Some stuff on connection pooling can be found at:

thread269-458379

But as iSeriesCodePoet said, anywhere that you use a getConnection() will have to be replaced with a call to retrieve the connection from the pool.

Your driver may come with its own connection pool system, or you can wrap one of these around the driver if it doesn't.

http://jakarta.apache.org/commons/dbcp.html

http://proxool.sourceforge.net

 

[engasi]

Are those two free (

http://jakarta.apache.org/commons/dbcp.html

&

http://proxool.sourceforge.net).

How about their performance? Can increase the site speed alot? Thanks.