Skip to content

Instantly share code, notes, and snippets.

@cmaggiulli
Created July 22, 2018 22:24
Show Gist options
  • Save cmaggiulli/b50da3a02513f15c4c58aa8649cf9aed to your computer and use it in GitHub Desktop.
Save cmaggiulli/b50da3a02513f15c4c58aa8649cf9aed to your computer and use it in GitHub Desktop.
c3p0 JDNI configuration for liferay 6.2
jdbc.default.liferay.pool.provider=c3po
jdbc.default.acquireIncrement=5
jdbc.default.acquireRetryAttempts=3
jdbc.default.acquireRetryDelay=1000
jdbc.default.connectionCustomizerClassName=com.liferay.portal.dao.jdbc.pool.c3p0.PortalConnectionCustomizer
jdbc.default.idleConnectionTestPeriod=60
jdbc.default.initialPoolSize=34
jdbc.default.maxIdleTime=233
jdbc.default.maxPoolSize=377
jdbc.default.minPoolSize=10
jdbc.default.numHelperThreads=10
jdbc.default.timeBetweenEvictionRunsMillis=34000
<Resource
name="jdbc/LiferayPool"
auth="Container"
type="com.mchange.v2.c3p0.ComboPooledDataSource"
factory="org.apache.naming.factory.BeanFactory"
driverClass="com.mysql.jdbc.Driver"
jdbcUrl="jdbc:mysql://address/database?autoReconnect=true&amp;useUnicode=true&amp;characterEncoding=UTF-8&amp;useFastDateParsing=false&amp;allowMultiQueries=true"
user=""
password=""
minPoolSize="10"
maxPoolSize="377"
maxIdleTime="233"
preferredTestQuery="select 1"
idleConnectionTestPeriod="60"
numHelperThreads="10"
maxStatementsPerConnection="100"
/>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment