How to use "c3p0" to configure the connection between Oracle and MySQL

This article describes two sample codes for configuring the connection between Oracle and MySQL using "c3p0 ".
You can make corresponding modifications based on your actual situation.

1. Connect to the Oracle database

 

<bean id=”dataSource” class=”com.mchange.v2.c3p0.ComboPooledDataSource” destroy-method=”close” abstract=”false” singleton=”true” lazy-init=”default” autowire=”default” dependency-check=”default”> <property name=”driverClass”> <value>oracle.jdbc.driver.OracleDriver</value> </property> <property name=”jdbcUrl”> <value>jdbc:oracle:thin:@192.168.0.1:1521:orcl</value> </property> <property name=”user”> <value>username</value> </property> <property name=”password”> <value>password</value> </property> <property name=”minPoolSize”> <value>10</value> </property> <property name=”maxPoolSize”> <value>20</value> </property> <property name=”initialPoolSize”> <value>10</value> </property> </bean> <bean id=”sessionFactory” class=”org.springframework.orm. hibernate3.LocalSessionFactoryBean”> <property name=”dataSource”> <ref bean=”dataSource”></ref> </property> <property name=”hibernateProperties”> <props> <prop key=”hibernate.dialect”> org.hibernate.dialect.OracleDialect </prop> <prop key=”hibernate.show_sql”> false </prop> <prop key=”hibernate.generate_statistics”>true</prop> <prop key=”hibernate.cache.use_query_cache”> true </prop> <prop key=”hibernate.cache.use_second_level_cache”> true </prop> <prop key=”hibernate.cache.provider_class”> net.sf.ehcache.hibernate.EhCacheProvider </prop> <prop key=”hibernate.connection.provider_class”> org.hibernate.connection.C3P0ConnectionProvider </prop> <prop key=”hibernate.query.substitutions”> true 1, false 0, yes ''Y'', no ''N'' </prop> <prop key=”hibernate.bytecode.use_reflection_optimizer”> true </prop> <prop key=”hibernate.use_outer_join”>true</prop> <prop key=”hibernate.prepare_sql”>true</prop> <prop key=”hibernate.query.factory_class”> org.hibernate.hql.ast.ASTQueryTranslatorFactory </prop> </props> </property> <property name=”mappingResources”> <list> <value>xxx/xx/xx.hbm.xml</value> <value>xxx/xx/xx.hbm.xml</value> </list> </property> </bean>

2. Connect to the MySQL database

<bean id=”dataSource” class=”com.mchange.v2.c3p0.ComboPooledDataSource” destroy-method=”close” abstract=”false” singleton=”true” lazy-init=”default” autowire=”default” dependency-check=”default”> <property name=”driverClass”> <value>com.mysql.jdbc.Driver</value> </property> <property name=”jdbcUrl”> <value>jdbc:mysql://192.168.0.1/databasename? useUnicode=true&amp; characterEncoding=utf-8&amp;autoReconnect=true</value> </property> <property name=”user”> <value>username</value> </property> <property name=”password”> <value>password</value> </property> <property name=”minPoolSize”> <value>10</value> </property> <property name=”maxPoolSize”> <value>20</value> </property> <property name=”initialPoolSize”> <value>10</value> </property> </bean> <bean id=”sessionFactory” class=”org.springframework.orm.hibernate3.LocalSessionFactoryBean”> <property name=”dataSource”> <ref bean=”dataSource”></ref> </property> <property name=”hibernateProperties”> <props> <prop key=”hibernate.dialect”> org.hibernate.dialect.MySQLDialect </prop> <prop key=”hibernate.show_sql”> false </prop> <prop key=”hibernate.generate_statistics”>true</prop> <prop key=”hibernate.cache.use_query_cache”> true </prop> <prop key=”hibernate.cache.use_second_level_cache”> true </prop> <prop key=”hibernate.cache.provider_class”> net.sf.ehcache.hibernate.EhCacheProvider </prop> <prop key=”hibernate.connection.provider_class”> org.hibernate.connection.C3P0ConnectionProvider </prop> <prop key=”hibernate.query.substitutions”> true 1, false 0, yes ''Y'', no ''N'' </prop> <prop key=”hibernate.bytecode.use_reflection_optimizer”> true </prop> <prop key=”hibernate.use_outer_join”>true</prop> <prop key=”hibernate.prepare_sql”>true</prop> <prop key=”hibernate.query.factory_class”> org.hibernate.hql.ast.ASTQueryTranslatorFactory </prop> </props> </property> <property name=”mappingResources”> <list> <value>xxx/xx/xx.hbm.xml</value> <value>xxx/xx/xx.hbm.xml</value> </list> </property> </bean>