1. é¦å
æ¯jdbc.propertieså±æ§æ件çç¼åï¼ä¾¿äºæ°æ®åºç§»æ¤ï¼
datasource.driverClassName=oracle.jdbc.driver.OracleDriver
datasource.url=jdbc:oracle:thin:@10.6.1.11:1521:student
datasource.username=zs
datasource.password=zs
datasource.defaultAutoCommit=true
hibernate.dialect=org.hibernate.dialect.Oracle9Dialect
以ä¸æ¯c3p0çåæ°é
ç½®ï¼
#å½è¿æ¥æ± ä¸çè¿æ¥èå°½çæ¶åc3p0ä¸æ¬¡åæ¶è·åçè¿æ¥æ°ãDefault: 3
c3p0.acquireIncrement=5
#åå§åæ¶è·åä¸ä¸ªè¿æ¥ï¼åå¼åºå¨minPoolSizeä¸maxPoolSizeä¹é´ãDefault: 3
c3p0.initialPoolSize=10
#æ¯60ç§æ£æ¥ææè¿æ¥æ± ä¸ç空é²è¿æ¥ãDefault: 0
c3p0.idleConnectionTestPeriod=600
#-è¿æ¥æ± ä¸ä¿ççæå°è¿æ¥æ°ã
c3p0.minPoolSize=5
#è¿æ¥æ± ä¸ä¿ççæ大è¿æ¥æ°ãDefault: 15
c3p0.maxPoolSize=50
#JDBCçæ ååæ°ï¼ç¨ä»¥æ§å¶æ°æ®æºå
å è½½çPreparedStatementsæ°éãä½ç±äºé¢ç¼åçstatements
#å±äºå个connectionèä¸æ¯æ´ä¸ªè¿æ¥æ± ãæ以设置è¿ä¸ªåæ°éè¦èèå°å¤æ¹é¢çå ç´ ã
#å¦æmaxStatementsä¸maxStatementsPerConnectionå为0ï¼åç¼å被å
³éãDefault: 0
c3p0.maxStatements=100
#c3p0æ¯å¼æ¥æä½çï¼ç¼æ
¢çJDBCæä½éè¿å¸®å©è¿ç¨å®æãæ©å±è¿äºæä½å¯ä»¥ææçæåæ§è½
#éè¿å¤çº¿ç¨å®ç°å¤ä¸ªæä½åæ¶è¢«æ§è¡ãDefault: 3
c3p0.numHelperThreads=10
#æ大空é²æ¶é´,60ç§å
æªä½¿ç¨åè¿æ¥è¢«ä¸¢å¼ãè¥ä¸º0åæ°¸ä¸ä¸¢å¼ãDefault: 0
c3p0.maxIdleTime=600
#hibernate.dialect=org.hibernate.dialect.SQLServerDialect
hibernate.jdbc.batch_size=25
hibernate.jdbc.fetch_size=50
hibernate.show_sql=true
hibernate.connection.release_mode=after_transaction
2. å
¶æ¬¡æ¯springé
ç½®æ件çæ°æ®æºé
ç½®ï¼
<bean id="propertyConfigurer" class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">
<property name="location">
<value>/WEB-INF/classes/conf/jdbc/jdbc.properties</value>
</property>
</bean>
<bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource" destroy-method="close" dependency-check="none">
<property name="driverClass">
<value>${datasource.driverClassName}</value>
</property>
<property name="jdbcUrl">
<value>${datasource.url}</value>
</property>
<property name="user">
<value>${datasource.username}</value>
</property>
<property name="password">
<value>${datasource.password}</value>
</property>
<!-- å½è¿æ¥æ± ä¸è¿æ¥èå°½çæ¶åc3p0ä¸æ¬¡åæ¶è·åçè¿æ¥æ° -->
<property name="acquireIncrement">
<value>${c3p0.acquireIncrement}</value>
</property>
<!--åå§åæ¶è·åä¸ä¸ªè¿æ¥ï¼åå¼åºå¨minPoolSizeä¸maxPoolSizeä¹é´ãDefault: 3 -->
<property name="initialPoolSize">
<value>${c3p0.initialPoolSize}</value>
</property>
<!-- æå°è¿æ¥æ° -->
<property name="minPoolSize">
<value>${c3p0.minPoolSize}</value>
</property>
<!-- æ大è¿æ¥æ° -->
<property name="maxPoolSize">
<value>${c3p0.minPoolSize}</value>
</property>
<!--æ大空é²æ¶é´,60ç§å
æªä½¿ç¨åè¿æ¥è¢«ä¸¢å¼ãè¥ä¸º0åæ°¸ä¸ä¸¢å¼ãDefault: 0 -->
<property name="maxIdleTime">
<value>${c3p0.maxPoolSize}</value>
</property>
<!--æ¯60ç§æ£æ¥ææè¿æ¥æ± ä¸ç空é²è¿æ¥ãDefault: 0 -->
<property name="idleConnectionTestPeriod">
<value>${c3p0.idleConnectionTestPeriod}</value>
</property>
<!--JDBCçæ ååæ°ï¼ç¨ä»¥æ§å¶æ°æ®æºå
å è½½çPreparedStatementsæ°éãä½ç±äºé¢ç¼åçstatementså±äºå个connectionèä¸æ¯æ´ä¸ªè¿æ¥æ± ã
æ以设置è¿ä¸ªåæ°éè¦èèå°å¤æ¹é¢çå ç´ ãå¦æmaxStatementsä¸maxStatementsPerConnectionå为0ï¼åç¼å被å
³éãDefault: 0-->
<property name="maxStatements">
<value>${c3p0.maxStatements}</value>
</property>
<!--c3p0æ¯å¼æ¥æä½çï¼ç¼æ
¢çJDBCæä½éè¿å¸®å©è¿ç¨å®æãæ©å±è¿äºæä½å¯ä»¥ææçæåæ§è½éè¿å¤çº¿ç¨å®ç°å¤ä¸ªæä½åæ¶è¢«æ§è¡ãDefault: 3-->
<property name="numHelperThreads">
<value>${c3p0.numHelperThreads}</value>
</property>
</bean>
3. æéè¦çæ¯è¿æ¥oracleæ°æ®åºç驱å¨jaråc3p0çjarå
c3p0-0.9.1.jar è¿æ¯c3p0çjarå
classes12.jar(1.51MB) è¿æ¥oracleæ°æ®åºç驱å¨ï¼è¿ä¸ªé©±å¨ååéè¦ã
温馨提示:答案为网友推荐,仅供参考