MyBatis
C3P0 Data Source Provider
The org.mybatis.guice.datasource.c3p0.C3p0DataSourceProvider
is the provider that builds the com.mchange.v2.c3p0.ComboPooledDataSource
and helps users to configure it.
for Apache Maven users the C3P0 dependency is not transitive, so they have to take care about including it in their applications.
The table below contains all of the available properties for the Provider; for more details please consult the Official reference.
| Property | Required | Bind to Java Type |
|---|---|---|
| JDBC.driver | true | java.lang.String |
| JDBC.url | true | java.lang.String |
| JDBC.username | true | java.lang.String |
| JDBC.password | true | java.lang.String |
| JDBC.autoCommit | false | boolean |
| JDBC.driverProperties | false | java.util.Properties |
| c3p0.acquireIncrement | false | int |
| c3p0.acquireRetryAttempts | false | int |
| c3p0.acquireRetryDelay | false | int |
| c3p0.automaticTestTable | false | java.lang.String |
| c3p0.breakAfterAcquireFailure | false | boolean |
| c3p0.checkoutTimeout | false | int |
| c3p0.connectionCustomizerClassName | false | java.lang.String |
| c3p0.connectionTesterClassName | false | java.lang.String |
| c3p0.idleConnectionTestPeriod | false | int |
| c3p0.initialPoolSize | false | int |
| c3p0.maxAdministrativeTaskTime | false | int |
| c3p0.maxConnectionAge | false | int |
| c3p0.maxIdleTime | false | int |
| c3p0.maxIdleTimeExcessConnections | false | int |
| c3p0.maxPoolSize | false | int |
| c3p0.maxStatements | false | int |
| c3p0.maxStatementsPerConnection | false | int |
| c3p0.minPoolSize | false | int |
| c3p0.preferredTestQuery | false | java.lang.String |
| c3p0.propertyCycle | false | int |
| c3p0.testConnectionOnCheckin | false | boolean |
| c3p0.testConnectionOnCheckout | false | boolean |
| c3p0.unreturnedConnectionTimeout | false | int |