File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes Data Source in TOMCAT 5.5.4 Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of REST with Spring (video course) this week in the Spring forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Data Source in TOMCAT 5.5.4" Watch "Data Source in TOMCAT 5.5.4" New topic

Data Source in TOMCAT 5.5.4

AnirbanAgartala Bhattacharjee

Joined: Mar 10, 2006
Posts: 4
Does anyone know how to create data source in TOMCAT 5.5.4? I successfully created data sources in earlier versions of TOMCAT. So if anyone has become able to do this, pls do post a response.
Sujith Kanaparthi
Ranch Hand

Joined: Sep 04, 2005
Posts: 45
I'm not sure how you are trying to create the datasource.But you can use org.apache.commons.dbcp and org.apache.commons.pool package classes to create the DataSource in Tomcat(5.5.12) and I myself used them for DataSource creation.Hope you too can implement the same and try it out
connectionPool = new GenericObjectPool(null);
connectionFactory = new DriverManagerConnectionFactory(jdbcConnectionURL,UserID,Password);
poolableConnectionFactory = new PoolableConnectionFactory(connectionFactory,connectionPool,null,null,false,true);
dataSource = new PoolingDataSource(connectionPool);

I agree. Here's the link:
subject: Data Source in TOMCAT 5.5.4
jQuery in Action, 3rd edition