*
The moose likes JDBC and the fly likes Connection poll Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Connection poll " Watch "Connection poll " New topic
Author

Connection poll

Rajesh Rami Reddy
Greenhorn

Joined: Mar 04, 2008
Posts: 5
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
Bartender

Joined: Dec 20, 2006
Posts: 2491
    
    8

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


OCUP UML fundamental and ITIL foundation
youtube channel
Rajesh Rami Reddy
Greenhorn

Joined: Mar 04, 2008
Posts: 5
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
Bartender

Joined: Dec 20, 2006
Posts: 2491
    
    8

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
Bartender

Joined: Dec 20, 2006
Posts: 2491
    
    8

Please do not ask the same question in two posts.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Connection poll
 
Similar Threads
enterprise application with many users
Connection from DataSource
Which one is the best ?
Front Controller pattern and DataSource / Connection sharing
Getting connection from pool?