spring配置ibatis的jdbc方式和proxool、c3p0连接池方式
<!--<rdf:RDF xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#"xmlns:dc="http://purl.org/dc/elements/1.1/"xmlns:trackback="http://madskills.com/public/xml/rss/module/trackback/"><rdf:Descriptionrdf:about="http://www.blogjava.net/landor2004/archive/2009/07/01/284978.html"dc:identifier="http://www.blogjava.net/landor2004/archive/2009/07/01/284978.html"dc:title="spring配置ibatis的jdbc方式和proxool、c3p0连接池方式"trackback:ping="http://www.blogjava.net/landor2004/services/trackbacks/284978.aspx" /></rdf:RDF>-->
</sqlMapConfig>2 用proxool连接池方式，只有datasource发生变化，其他的无变动
? 需要加入proxool.jar
<!--<br /><br />Code highlighting produced by Actipro CodeHighlighter (freeware)<br />http://www.CodeHighlighter.com/<br /><br />-->????<bean?id="dataSource"?class="org.logicalcobwebs.proxool.ProxoolDataSource"?destroy-method="close">
????????<property?name="alias"?value="test"></property>
????????<property?name="delegateProperties">
????????????<value>user=${jdbc.username},password=${jdbc.password}</value>
????????</property>
????????<property?name="user"?value="${jdbc.username}"/>
????????<property?name="password"?value="${jdbc.password}"/>
????????<property?name="driver"?value="${jdbc.driverClassName}"/>
????????<property?name="driverUrl"?value="${jdbc.url}"/>
????????<property?name="houseKeepingTestSql"?value="select?CURRENT_DATE"></property>
??????? <!--此处继续增加proxool属性，详细见proxool文档-->
????</bean>此处说明一下：属性中的user和password不起任何作用，需要用delegateProperties方式写一下，否则会报错误，如下
??? org.springframework.transaction.CannotCreateTransactionException: Could not open JDBC Connection for transaction; nested exception is com.microsoft.sqlserver.jdbc.SQLServerException: Login failed for user ''. The user is not associated with a trusted SQL Server connection.
但是user和password还不能被去掉。
除了上面的用delegateProperties之外，还可以将用户名和密码直接写在url后面。
proxool属性的说明，在这里写的比较详细
http://www.cnblogs.com/wllyy189/archive/2008/10/15/1311560.html
3 c3p0方式
? 需要加入c3p0.jar
<!--<br /><br />Code highlighting produced by Actipro CodeHighlighter (freeware)<br />http://www.CodeHighlighter.com/<br /><br />-->????<bean?id="dataSource"?class="com.mchange.v2.c3p0.ComboPooledDataSource"?destroy-method="close">
????????<property?name="driverClass">
????????????????<value>${jdbc.driverClassName}</value>
????????????</property>
????????????<property?name="jdbcUrl">
????????????????<value>${jdbc.url}</value>
????????????</property>
????????????<property?name="user">
????????????????<value>${jdbc.username}</value>
????????????</property>
????????????<property?name="password">
????????????????<value>${jdbc.password}</value>
????????????</property>
??????????? <!--此处继续增加c3p0属性-->
????</bean>关于c3p0的属性说明请参见：
http://www.blogjava.net/Alpha/archive/2009/03/29/262789.html