Orcle的c3p0配置

 

applicationContext.xml

<!-- 数据库连接池 -->

<bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource">
<property name="driverClass" value="${jdbc.driver}" />
<property name="jdbcUrl" value="${jdbc.url}" />
<property name="user" value="${jdbc.user}" />
<property name="password" value="${jdbc.password}" />
</bean>

 

 

config.properties (url的数据在电脑的D:\instantclient_12_1---->tnsnames.ora)

 

# oracle jdbc properties
jdbc.url = jdbc:oracle:thin:@192.168.80.10:1521:orcl        //jdbc:连接的数据库:瘦连接:@Orcel装的位置的ip:端口号:SERVICE_NAME = orcl
jdbc.driver= oracle.jdbc.driver.OracleDriver
jdbc.user = bos
jdbc.password = bos