Connection poll

[Rajesh Rami Reddy]

Hello Friends,

Could you know any one how to create the Connection Pool in the Apache Tomacat Server 5.5 version.
Please tell me the procedure for creating the Connection Pool.

[Jan Cumps]

Google knows by asking "Connection Pool in the Apache Tomacat Server 5.5"

The Apache Tomcat 5.5 Servlet/JSP Container - JNDI Datasource HOW-TO.

Regards, Jan

[Rajesh Rami Reddy]

I had visit as your suggested URL http://tomcat.apache.org/tomcat-5.5-doc/jndi-datasource-examples-howto.html

I am unable to understand clearly where i will write the Connection pool code. In my project i am using Hibernate, Spring frame works.

In that URL they are giving the procedure for MYSQL,Orcle and Postgre Sql. But there is no procedure for SQQL Server 2000 DataBase.
Can you know what is the procedure.

[Jan Cumps]

Hi Rajesh,

You don't have to write code. Setting up a connection pool in tomcat only needs configuration, as described in the link above.
Doing this for mssqlserver is identical as doing it for Oracle.

[Jan Cumps]

Please do not ask the same question in two posts.