• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

Query regarding Connection pooling

 
Ranch Hand
Posts: 65
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Firstly, I have lot of Queries. so any one can answer any query will be helpful. I think java ranch is best forum to get answer related java queries. So I call upon all java geeks to clarify my doubts regarding this.

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.
--------------------------------------------------------------------------------
 
author & internet detective
Posts: 41860
908
Eclipse IDE VI Editor Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Gaurav,
Welcome to JavaRanch!

1. java:/comp/env states that you are using a reference. This is like a level of indirection. It's not a particular location though.

2. No. There is a SharedPoolDataSourceFactory that does connection pooling.

3. I'm not sure whether Mysql gives you connection pooling by default. (I think it doesn't though.) What does the documentation say?

4. It's usually best to let the server do connection pooling since it can do a good job. Second best is DBCP. You don't want to write your own though. It's complicated, hard to get right and it's already been done well.
 
incandescent light gives off an efficient form of heat. You must be THIS smart to ride this ride. Tiny ad:
a bit of art, as a gift, the permaculture playing cards
https://gardener-gift.com
reply
    Bookmark Topic Watch Topic
  • New Topic