File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
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 OCM Java EE 6 Enterprise Architect Exam Guide this week in the OCMJEA 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: 2497
    
    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: 2497
    
    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: 2497
    
    8

Please do not ask the same question in two posts.
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
 
subject: Connection poll