日期:2014-05-18  浏览次数:20647 次

急:::tomcat5.0+sql2000数据库连接池配置
请问怎么配制tomcat5.0   sql2000数据库连接池配置?
在我的web文件夹下struts-config.xml里原来是使用oracel数据库的连接池,我现在使用的是sql   2000,改怎么修改呢?

<data-sources>
<data-source   key= "oracleDB1 "   type= "org.apache.commons.dbcp.BasicDataSource ">
<set-property   property= "driverClassName "
value= "oracle.jdbc.driver.OracleDriver "   />
<set-property   property= "url "
value= "jdbc:oracle:thin:@127.0.0.1:1521:ZGYDB "   />
<set-property   property= "maxActive "
value= "5 "/>
<set-property   property= "username "
value= "jenny "/>
<set-property   property= "password "
value= "888888 "/>
<set-property   property= "autoCommit "
value= "true "/>
</data-source>
</data-sources>

恳请大家帮我看看怎么处理
谢谢

------解决方案--------------------
lz把DatabaseName改成自己的数据库名称。


<data-sources>
<data-source key= "SQLServerDB ">
<set-property property= "password " value= " " />
<set-property property= "minCount " value= "1 " />
<set-property property= "maxCount " value= "3 " />
<set-property property= "user " value= "sa " />
<set-property property= "driverClass " value= "com.microsoft.jdbc.sqlserver.SQLServerDriver " />
<set-property property= "url " value= "jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=police " />
<set-property property= "readOnly " value= "false " />
<set-property property= "autoCommit " value= "true " />
<set-property property= "loginTimeout " value= "3 " />
</data-source>
</data-sources>