1.

How To Configure Liferay To Use A Jndi Jdbc Datasource Instead Of Internal C3p0 Connection Pool?

Answer»

We need to do the entry of perticular resource with some certain parameter LIKE name, factory, driverclassname, URL of database, uaername and password.

Below is the entry of resource where JDBC DATASOURCE is configured.

name="jdbc/LiferayPool"
factory="org.apache.tomcat.jdbc.pool.DataSourceFactory"
driverClassName="com.mysql.jdbc.Driver"
url="jdbc:mysql:///?autoReconnect=true&useUnicode=true&characterEncoding=UTF-8&useFastDateParsing=false&noAccessToProcedureBodies=true"
username="liferay"
password="0bknSWE2zzl"
initialSize="10"
maxActive="200"
minIdle="0"
/>

Below is the entry of resource where c3p0.ComboPooledDataSource is configured.

<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:///?useUnicode=true&characterEncoding=UTF-8&useFastDateParsing=false&noAccessToProcedureBodies=true"
user="liferay"
password="0bknSWE2zzl"
minPoolSize="10"
maxPoolSize="100"
/>

We need to do the entry of perticular resource with some certain parameter like name, factory, driverclassname, url of database, uaername and password.

Below is the entry of resource where JDBC datasource is configured.

name="jdbc/LiferayPool"
factory="org.apache.tomcat.jdbc.pool.DataSourceFactory"
driverClassName="com.mysql.jdbc.Driver"
url="jdbc:mysql:///?autoReconnect=true&useUnicode=true&characterEncoding=UTF-8&useFastDateParsing=false&noAccessToProcedureBodies=true"
username="liferay"
password="0bknSWE2zzl"
initialSize="10"
maxActive="200"
minIdle="0"
/>

Below is the entry of resource where c3p0.ComboPooledDataSource is configured.

<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:///?useUnicode=true&characterEncoding=UTF-8&useFastDateParsing=false&noAccessToProcedureBodies=true"
user="liferay"
password="0bknSWE2zzl"
minPoolSize="10"
maxPoolSize="100"
/>



Discussion

No Comment Found