[infinispan-issues] [JBoss JIRA] (ISPN-2397) Allow proper config of PooledConnectionFactory

[Bert Jacobs (JIRA)]

    [ https://issues.jboss.org/browse/ISPN-2397?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12777114#comment-12777114 ] 

Bert Jacobs commented on ISPN-2397:
-----------------------------------

The description here is somewhat vague, but I agree with the reporter that there's currently no "proper" way to configure the pool.

I'm using JBoss AS 5 (or rather the EAP version matching it) but I can't use its managed data sources until ISPN-604 gets fixed. Therefore I switched to the PooledConnectionFactory, but I don't like to throw a C3P0 config into the common Class path lest I upset some other application. It would be better IMHO if the Infinispan config held the C3P0 configuration, or at least a reference to a config file similar to the way JGroups gets configured (classpath or file system reference).

C3P0 itself doesn't support any datasource-specific config files (except for a shared config file with config names in it, but that's another ugly thing in a container), but I think Infinispan could inject the settings using the `setProperties(...)` method it is using now when it creates the `ComboPooledDataSource` instance.
                
> Allow proper config of PooledConnectionFactory
> ----------------------------------------------
>
>                 Key: ISPN-2397
>                 URL: https://issues.jboss.org/browse/ISPN-2397
>             Project: Infinispan
>          Issue Type: Feature Request
>          Components: Loaders and Stores
>    Affects Versions: 5.1.0.FINAL
>            Reporter: Thomas Kratz
>            Assignee: Mircea Markus
>            Priority: Trivial
>
> mysql needs testConnection on checkout settings as those connection die after a certain time.
> Currently it is not possible to set this on the c3p0 config.

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira