[jboss-user] [Datasource Configuration] - Use c3p0 with JBOSS AS 7.1.1
Álvaro López López
do-not-reply at jboss.com
Fri Jun 28 04:51:53 EDT 2013
Álvaro López López [https://community.jboss.org/people/allopez] created the discussion
"Use c3p0 with JBOSS AS 7.1.1"
To view the discussion, visit: https://community.jboss.org/message/825446#825446
--------------------------------------------------------------
Hello everyone,
I read in c3p0´s manual: http://www.mchange.com/projects/c3p0/#jboss-specific http://www.mchange.com/projects/c3p0/#jboss-specific that it is possible to use c3p0 library inside JBOSS as an MBean.
Once configured correctly, I would like to reference the new C3P0PooledDataSource in my Java WAR through its JNDI name. As I am using Spring
it would be something similar to:
[src/webapp/WEB-INF/applicationContext.xml]
*<jee:jndi-lookup id="dataSource" jndi-name="java:PooledDS" />*
However, I don´t know how to configure this library properly. I tried to place *c3p0-0.9.2.1.jar* and *c3p0-service.xml* in the folders commented in the manual
but I had no luck :( . So:
* *Is it possible to use c3p0 connection pool inside JBOSS AS 7.1.1? How should I configure it?*
I started to "play" with c3p0 because of its large number of configuration properties, but I don´t know if c3p0 is better than embedded JBOSS pooling capabilities.
* *Does c3p0 library deserve to be used instead of JBOSS embedded connection pool (i.e. configuring the datasource with the admin console/web) ?*
I am currently developing a project which uses a MySql database.
I appreciate any comments to these matters.*
*
--------------------------------------------------------------
Reply to this message by going to Community
[https://community.jboss.org/message/825446#825446]
Start a new discussion in Datasource Configuration at Community
[https://community.jboss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2077]
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jboss.org/pipermail/jboss-user/attachments/20130628/a6384b5a/attachment-0001.html
More information about the jboss-user
mailing list