您的位置: 首页  >  IT文章  >  Spring閰嶇疆鏁版嵁婧愬嚑绉嶆柟寮

Spring閰嶇疆鏁版嵁婧愬嚑绉嶆柟寮

分类: IT文章 • 2024-10-21 15:06:36
Spring閰嶇疆鏁版嵁婧愬嚑绉嶆柟寮?
閰嶇疆Spring鏁版嵁婧愮殑鍑犵鏂瑰紡

閰嶇疆涓€涓暟鎹簮
     Spring鍦ㄧ涓夋柟渚濊禆鍖呬腑鍖呭惈浜嗕袱涓暟鎹簮鐨勫疄鐜扮被鍖咃紝鍏朵竴鏄疉pache鐨凞BCP锛屽叾浜屾槸 C3P0銆傚彲浠ュ湪Spring閰嶇疆鏂囦欢涓埄鐢ㄨ繖涓よ€呬腑浠讳綍涓€涓厤缃暟鎹簮銆?

DBCP鏁版嵁婧?/strong>
     DBCP绫诲寘浣嶄簬 /lib/jakarta-commons/commons-dbcp.jar锛孌BCP鏄竴涓緷璧?Jakarta commons-pool瀵硅薄姹犳満鍒剁殑鏁版嵁搴撹繛鎺ユ睜锛屾墍浠ュ湪绫昏矾寰勪笅杩樺繀椤诲寘鎷?lib/jakarta- commons/commons-pool.jar銆備笅闈㈡槸浣跨敤DBCP閰嶇疆MySql鏁版嵁婧愮殑閰嶇疆鐗囨柇锛?
<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource"           
        destroy-method="close">           
    <property name="driverClassName" value="com.mysql.jdbc.Driver" />          
    <property name="url" value="jdbc:mysql://localhost:3309/sampledb" />          
    <property name="username" value="root" />          
    <property name="password" value="1234" />          
</bean>

BasicDataSource鎻愪緵浜哻lose()鏂规硶鍏抽棴鏁版嵁婧愶紝鎵€浠ュ繀椤昏瀹歞estroy-method=鈥漜lose鈥濆睘鎬э紝 浠ヤ究Spring瀹瑰櫒鍏抽棴鏃讹紝鏁版嵁婧愯兘澶熸甯稿叧闂€傞櫎浠ヤ笂蹇呴』鐨勬暟鎹簮灞炴€у锛岃繕鏈変竴浜涘父鐢ㄧ殑灞炴€э細
     defaultAutoCommit锛氳缃粠鏁版嵁婧愪腑杩斿洖鐨勮繛鎺ユ槸鍚﹂噰鐢ㄨ嚜鍔ㄦ彁浜ゆ満鍒讹紝榛樿鍊间负 true锛?
     defaultReadOnly锛氳缃暟鎹簮鏄惁浠呰兘鎵ц鍙鎿嶄綔锛?榛樿鍊间负 false锛?
     maxActive锛氭渶澶ц繛鎺ユ暟鎹簱杩炴帴鏁帮紝璁剧疆涓?鏃讹紝琛ㄧず娌℃湁闄愬埗锛?
     maxIdle锛氭渶澶х瓑寰呰繛鎺ヤ腑鐨勬暟閲忥紝璁剧疆涓?鏃讹紝琛ㄧず娌℃湁闄愬埗锛?
     maxWait锛氭渶澶х瓑寰呯鏁帮紝鍗曚綅涓烘绉掞紝 瓒呰繃鏃堕棿浼氭姤鍑洪敊璇俊鎭紱
     validationQuery锛氱敤浜庨獙璇佽繛鎺ユ槸鍚︽垚鍔熺殑鏌ヨSQL璇彞锛孲QL璇彞蹇呴』鑷冲皯瑕佽繑鍥炰竴琛屾暟鎹紝 濡備綘鍙互绠€鍗曞湴璁剧疆涓猴細鈥渟elect count(*) from user鈥濓紱
     removeAbandoned锛氭槸鍚﹁嚜鎴戜腑鏂紝榛樿鏄?false 锛?
     removeAbandonedTimeout锛氬嚑绉掑悗鏁版嵁杩炴帴浼氳嚜鍔ㄦ柇寮€锛屽湪removeAbandoned涓簍rue锛屾彁渚涜鍊硷紱
     logAbandoned锛氭槸鍚﹁褰曚腑鏂簨浠讹紝 榛樿涓?false锛?

C3P0鏁版嵁婧?/strong>
     C3P0鏄竴涓紑鏀炬簮浠ｇ爜鐨凧DBC鏁版嵁婧愬疄鐜伴」鐩紝瀹冨湪lib鐩綍涓笌Hibernate涓€璧峰彂甯冿紝瀹炵幇浜咼DBC3鍜孞DBC2鎵╁睍瑙勮寖璇存槑鐨?Connection 鍜孲tatement 姹犮€侰3P0绫诲寘浣嶄簬/lib/c3p0/c3p0-0.9.0.4.jar銆備笅闈㈡槸浣跨敤C3P0閰嶇疆涓€涓?oracle鏁版嵁婧愶細
    <bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource"           
            destroy-method="close">          
        <property name="driverClass" value=" oracle.jdbc.driver.OracleDriver "/>          
        <property name="jdbcUrl" value=" jdbc:oracle:thin:@localhost:1521:ora9i"/>
        <property name="user" value="admin"/>          
        <property name="password" value="1234"/>          
    </bean>

ComboPooledDataSource鍜孊asicDataSource涓€鏍锋彁渚涗簡涓€涓敤浜庡叧闂暟鎹簮鐨刢lose()鏂规硶锛岃繖鏍锋垜浠氨鍙互淇濊瘉Spring瀹瑰櫒鍏抽棴鏃舵暟鎹簮鑳藉鎴愬姛閲婃斁銆?
     C3P0鎷ユ湁姣擠BCP鏇翠赴瀵岀殑閰嶇疆灞炴€э紝閫氳繃杩欎簺灞炴€э紝鍙互瀵规暟鎹簮杩涜鍚勭鏈夋晥鐨勬帶鍒讹細
     acquireIncrement锛氬綋杩炴帴姹犱腑鐨勮繛鎺ョ敤瀹屾椂锛孋3P0涓€娆℃€у垱寤烘柊杩炴帴鐨勬暟鐩紱
     acquireRetryAttempts锛氬畾涔夊湪浠庢暟鎹簱鑾峰彇鏂拌繛鎺ュけ璐ュ悗閲嶅灏濊瘯鑾峰彇鐨勬鏁帮紝榛樿涓?0锛?
     acquireRetryDelay锛氫袱娆¤繛鎺ヤ腑闂撮殧鏃堕棿锛屽崟浣嶆绉掞紝榛樿涓?000锛?
     autoCommitOnClose锛氳繛鎺ュ叧闂椂榛樿灏嗘墍鏈夋湭鎻愪氦鐨勬搷浣滃洖婊氥€傞粯璁や负false锛?
     automaticTestTable锛?C3P0灏嗗缓涓€寮犲悕涓篢est鐨勭┖琛紝骞朵娇鐢ㄥ叾鑷甫鐨勬煡璇㈣鍙ヨ繘琛屾祴璇曘€傚鏋滃畾涔変簡杩欎釜鍙傛暟锛岄偅涔堝睘鎬referredTestQuery灏嗚蹇界暐銆備綘涓嶈兘鍦ㄨ繖寮燭est琛ㄤ笂杩涜浠讳綍鎿嶄綔锛屽畠灏嗕腑涓篊3P0娴嬭瘯鎵€鐢紝榛樿涓簄ull锛?
     breakAfterAcquireFailure锛氳幏鍙栬繛鎺ュけ璐ュ皢浼氬紩璧锋墍鏈夌瓑寰呰幏鍙栬繛鎺ョ殑绾跨▼鎶涘嚭寮傚父銆備絾鏄暟鎹簮浠嶆湁鏁堜繚鐣欙紝骞跺湪涓嬫璋?nbsp;   鐢╣etConnection()鐨勬椂鍊欑户缁皾璇曡幏鍙栬繛鎺ャ€傚鏋滆涓簍rue锛岄偅涔堝湪灏濊瘯鑾峰彇杩炴帴澶辫触鍚庤鏁版嵁婧愬皢鐢虫槑宸叉柇寮€骞舵案涔呭叧闂€傞粯璁や负 false锛?
     checkoutTimeout锛氬綋杩炴帴姹犵敤瀹屾椂瀹㈡埛绔皟鐢╣etConnection()鍚庣瓑寰呰幏鍙栨柊杩炴帴鐨勬椂闂达紝瓒呮椂鍚庡皢鎶涘嚭SQLException锛屽璁句负0鍒欐棤闄愭湡绛夊緟銆傚崟浣嶆绉掞紝榛樿涓?锛?
     connectionTesterClassName锛?閫氳繃瀹炵幇ConnectionTester鎴朡ueryConnectionTester鐨勭被鏉ユ祴璇曡繛鎺ワ紝绫诲悕闇€璁剧疆涓哄叏闄愬畾鍚嶃€傞粯璁や负 com.mchange.v2.C3P0.impl.DefaultConnectionTester锛?
     idleConnectionTestPeriod锛氶殧澶氬皯绉掓鏌ユ墍鏈夎繛鎺ユ睜涓殑绌洪棽杩炴帴锛岄粯璁や负0琛ㄧず涓嶆鏌ワ紱
     initialPoolSize锛氬垵濮嬪寲鏃跺垱寤虹殑杩炴帴鏁帮紝搴斿湪minPoolSize涓巑axPoolSize涔嬮棿鍙栧€笺€傞粯璁や负3锛?
     maxIdleTime锛氭渶澶х┖闂叉椂闂达紝瓒呰繃绌洪棽鏃堕棿鐨勮繛鎺ュ皢琚涪寮冦€備负0鎴栬礋鏁板垯姘镐笉涓㈠純銆傞粯璁や负0锛?
     maxPoolSize锛氳繛鎺ユ睜涓繚鐣欑殑鏈€澶ц繛鎺ユ暟銆傞粯璁や负15锛?
     maxStatements锛欽DBC鐨勬爣鍑嗗弬鏁帮紝鐢ㄤ互鎺у埗鏁版嵁婧愬唴鍔犺浇鐨凱reparedStatement鏁伴噺銆備絾鐢变簬棰勭紦瀛樼殑Statement灞炰簬鍗曚釜Connection鑰屼笉鏄暣涓繛鎺ユ睜銆傛墍浠ヨ缃繖涓弬鏁伴渶瑕佽€冭檻鍒板鏂归潰鐨勫洜绱狅紝濡傛灉maxStatements涓?maxStatementsPerConnection鍧囦负0锛屽垯缂撳瓨琚叧闂€傞粯璁や负0锛?
     maxStatementsPerConnection锛氳繛鎺ユ睜鍐呭崟涓繛鎺ユ墍鎷ユ湁鐨勬渶澶х紦瀛楽tatement鏁般€傞粯璁や负0锛?
     numHelperThreads锛欳3P0鏄紓姝ユ搷浣滅殑锛岀紦鎱㈢殑JDBC鎿嶄綔閫氳繃甯姪杩涚▼瀹屾垚銆傛墿灞曡繖浜涙搷浣滃彲浠ユ湁鏁堢殑鎻愬崌鎬ц兘锛岄€氳繃澶氱嚎绋嬪疄鐜板涓搷浣滃悓鏃惰鎵ц銆傞粯璁や负3锛?
     preferredTestQuery锛氬畾涔夋墍鏈夎繛鎺ユ祴璇曢兘鎵ц鐨勬祴璇曡鍙ャ€傚湪浣跨敤杩炴帴娴嬭瘯鐨勬儏鍐典笅杩欎釜鍙傛暟鑳芥樉钁楁彁楂樻祴璇曢€熷害銆傛祴璇曠殑琛ㄥ繀椤诲湪鍒濆鏁版嵁婧愮殑鏃跺€欏氨瀛樺湪銆傞粯璁や负null锛?
     propertyCycle锛?鐢ㄦ埛淇敼绯荤粺閰嶇疆鍙傛暟鎵ц鍓嶆渶澶氱瓑寰呯殑绉掓暟銆傞粯璁や负300锛?
     testConnectionOnCheckout锛氬洜鎬ц兘娑堣€楀ぇ璇峰彧鍦ㄩ渶瑕佺殑鏃跺€欎娇鐢ㄥ畠銆傚鏋滆涓簍rue閭ｄ箞鍦ㄦ瘡涓猚onnection鎻愪氦鐨勬椂鍊欓兘 灏嗘牎楠屽叾鏈夋晥鎬с€傚缓璁娇鐢╥dleConnectionTestPeriod鎴朼utomaticTestTable
绛夋柟娉曟潵鎻愬崌杩炴帴娴嬭瘯鐨勬€ц兘銆傞粯璁や负false锛?
     testConnectionOnCheckin锛氬鏋滆涓簍rue閭ｄ箞鍦ㄥ彇寰楄繛鎺ョ殑鍚屾椂灏嗘牎楠岃繛鎺ョ殑鏈夋晥鎬с€傞粯璁や负false銆?
璇婚厤缃枃浠剁殑鏂瑰紡寮曠敤灞炴€э細
<bean id="propertyConfigurer"         
class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">   
    <property name="location" value="/WEB-INF/jdbc.properties"/>          
</bean>          
<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource"           
        destroy-method="close">          
    <property name="driverClassName" value="${jdbc.driverClassName}" />          
    <property name="url" value="${jdbc.url}" />          
    <property name="username" value="${jdbc.username}" />          
    <property name="password" value="${jdbc.password}" />          
</bean>

鍦╦dbc.properties灞炴€ф枃浠朵腑瀹氫箟灞炴€у€硷細
     jdbc.driverClassName= com.mysql.jdbc.Driver
     jdbc.url= jdbc:mysql://localhost:3309/sampledb
     jdbc.username=root
     jdbc.password=1234

     鎻愮ず 缁忓父鏈夊紑鍙戣€呭湪${xxx}鐨勫墠鍚庝笉灏忓績閿叆涓€浜涚┖鏍硷紝杩欎簺绌烘牸瀛楃灏嗗拰鍙橀噺鍚堝苟鍚庝綔涓哄睘鎬х殑鍊笺€傚锛氱殑灞炴€ч厤缃」锛屽湪鍓嶅悗閮芥湁绌烘牸锛岃瑙ｆ瀽鍚庯紝username鐨勫€间负鈥?1234 鈥濓紝杩欏皢閫犳垚鏈€缁堢殑閿欒锛屽洜姝ら渶瑕佺壒鍒皬蹇冦€?

鑾峰彇JNDI鏁版嵁婧?/strong>
     濡傛灉搴旂敤閰嶇疆鍦ㄩ珮鎬ц兘鐨勫簲鐢ㄦ湇鍔″櫒锛堝WebLogic鎴朩ebsphere绛夛級涓婏紝鎴戜滑鍙兘鏇村笇鏈涗娇鐢ㄥ簲鐢ㄦ湇鍔″櫒鏈韩鎻愪緵鐨勬暟鎹簮銆傚簲鐢ㄦ湇鍔″櫒鐨勬暟鎹簮 浣跨敤JNDI寮€鏀捐皟鐢ㄨ€呬娇鐢紝Spring涓烘涓撻棬鎻愪緵寮曠敤JNDI璧勬簮鐨凧ndiObjectFactoryBean绫汇€備笅闈㈡槸涓€涓畝鍗曠殑閰嶇疆锛?
<bean id="dataSource" class="org.springframework.jndi.JndiObjectFactoryBean">          
    <property name="jndiName" value="java:comp/env/jdbc/bbt"/>          
</bean>


閫氳繃jndiName鎸囧畾寮曠敤鐨凧NDI鏁版嵁婧愬悕绉般€?
     Spring 2.0涓鸿幏鍙朖2EE璧勬簮鎻愪緵浜嗕竴涓猨ee鍛藉悕绌洪棿锛岄€氳繃jee鍛藉悕绌洪棿锛屽彲浠ユ湁鏁堝湴绠€鍖朖2EE璧勬簮鐨勫紩鐢ㄣ€備笅闈㈡槸浣跨敤jee鍛藉悕绌洪棿寮曠敤JNDI鏁版嵁婧愮殑閰嶇疆锛?
<beans xmlns=http://www.springframework.org/schema/beans        
xmlns:xsi=http://www.w3.org/2001/XMLSchema-instance        
xmlns:jee=http://www.springframework.org/schema/jee        
xsi:schemaLocation="http://www.springframework.org/schema/beans         
http://www.springframework.org/schema/beans/spring-beans-2.0.xsd         
http://www.springframework.org/schema/jee        
http://www.springframework.org/schema/jee/spring-jee-2.0.xsd">          
    <jee:jndi-lookup id="dataSource" jndi-name=" java:comp/env/jdbc/bbt"/>          
</beans>


Spring鐨勬暟鎹簮瀹炵幇绫?/strong>
     Spring鏈韩涔熸彁渚涗簡涓€涓畝鍗曠殑鏁版嵁婧愬疄鐜扮被DriverManagerDataSource 锛屽畠浣嶄簬org.springframework.jdbc.datasource鍖呬腑銆傝繖涓被瀹炵幇浜唈avax.sql.DataSource鎺ュ彛锛屼絾 瀹冨苟娌℃湁鎻愪緵姹犲寲杩炴帴鐨勬満鍒讹紝姣忔璋冪敤getConnection()鑾峰彇鏂拌繛鎺ユ椂锛屽彧鏄畝鍗曞湴鍒涘缓涓€涓柊鐨勮繛鎺ャ€傚洜姝わ紝杩欎釜鏁版嵁婧愮被姣旇緝閫傚悎鍦ㄥ崟鍏冩祴璇曟垨绠€鍗曠殑鐙珛搴旂敤涓娇鐢紝鍥犱负瀹冧笉闇€瑕侀澶栫殑渚濊禆绫汇€?
      涓嬮潰锛屾垜浠潵鐪嬩竴涓婦riverManagerDataSource鐨勭畝鍗曚娇鐢細褰撶劧锛屾垜浠篃鍙互閫氳繃閰嶇疆鐨勬柟寮忕洿鎺ヤ娇鐢―riverManagerDataSource銆?
DriverManagerDataSource ds = new DriverManagerDataSource ();          
ds.setDriverClassName("com.mysql.jdbc.Driver");          
ds.setUrl("jdbc:mysql://localhost:3309/sampledb");          
ds.setUsername("root");          
ds.setPassword("1234");          
Connection actualCon = ds.getConnection();


灏忕粨
     涓嶇閲囩敤浣曠鎸佷箙鍖栨妧鏈紝閮介渶瑕佸畾涔夋暟鎹簮銆係pring闄勫甫浜嗕袱涓暟鎹簮鐨勫疄鐜扮被鍖咃紝浣犲彲浠ヨ嚜琛岄€夋嫨杩涜瀹氫箟銆傚湪瀹為檯閮ㄧ讲鏃讹紝鎴戜滑鍙兘浼氱洿鎺ラ噰鐢ㄥ簲鐢ㄦ湇鍔″櫒鏈韩鎻愪緵鐨勬暟鎹簮锛岃繖鏃讹紝鍒欏彲浠ラ€氳繃JndiObjectFactoryBean鎴杍ee鍛藉悕绌洪棿寮曠敤JNDI涓殑鏁版嵁婧愩€?

DBCP涓嶤3PO閰嶇疆鐨勫尯鍒細
C3PO 锛?
    <bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource" destroy-method="close">      
        <property name="driverClass">      
            <value>oracle.jdbc.driver.OracleDrivervalue>      
        </property>      
        <property name="jdbcUrl">                 
            <value>jdbc:oracle:thin:@10.10.10.6:1521:DataBaseNamevalue>      
        </property>      
        <property name="user">      
            <value>testAdminvalue>      
        </property>      
        <property name="password">      
            <value>123456value>      
        </property>      
    </bean>

DBCP锛?
    <bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">      
        <property name="driverClassName">      
            <value>oracle.jdbc.driver.OracleDrivervalue>      
        </property>      
        <property name="url">                 
            <value>jdbc:oracle:thin:@10.10.10.6:1521:DataBaseNamevalue>      
         </property>      
        <property name="username">      
            <value>testAdminvalue>      
        </property>      
        <property name="password">      
            <value>123456value>      
        </property>      
    </bean>

杞嚜锛歨ttp://blog.****.net/zcywell/article/details/7175478

相关推荐