Bookmark Topic Watch Topic
  • New Topic

Some Query related to connection pooling

 
Manish Sridharan
Ranch Hand
Posts: 65
  • 0
  • Mark post as helpful
  • send pies
  • Report post to moderator
i m using mysql driver on tomcat webserver and using JNDI based connectionpooling.
and i made a connection succesfully.

i have made a connection accordingly as given in tomcat documentation on Connection pooling.

i have a number of querys

1. In the initial context , why we write string "java:/comp/env"
what its significance ? Does it point to particular location in the tomcat?

2. I have used org.apache.commons.dbcp.BasicDataSourceFactory . Does this class do the connection pooling? I think its just implementing data source interface. please explain.
i have used a commons-dbcp-1.2.1.jar .
and also i used mysql-connector-java-3.1.10-bin.jar for driver

3. there is MysqlConnectionPoolDataSource.class and MysqlDatasource.class in mysql-connector-java-3.1.10-bin.jar . Can I use this file for connection pooling and datasource connection . If yes then how shd i do it ? please explain.

4. I also want to make a class file for connection pooling instead of relying on tomcat to do the connection pooling for me. can i use these jar files for my own connection pooling? if yes then how should i do it ? please explain.
 
Jeanne Boyarsky
author & internet detective
Marshal
Posts: 33684
316
Eclipse IDE Java VI Editor
  • 0
  • Mark post as helpful
  • send pies
  • Report post to moderator
Please don't post the same question multiple times. Continue discussion in your other thread.
 
It is sorta covered in the JavaRanch Style Guide.
    Bookmark Topic Watch Topic
  • New Topic