用myeclipse在struts中配置mysql和sqlserver的datasource

myeclipse自動產生的strust-config.xml有幾點要注意：

1.driverClassName不是driverclass;

2.username不是user

3.不要設定loginTimeout.

action調用：DataSource ds=getDataSource(request,"datasource");

注意commons-collections.jar ,commons-pool.jar,commons-dbcp.jar還有資料庫驅動一定要注意拷貝到tomcat/common/lib裡面,

注意 ：通過項目的 構建路徑-->添加外部歸檔-->加入這3個jar包

 

http://jakarta.apache.org/site/downloads/downloads_commons.html

MSSQLServer2000資料來源配置

<data-sources>

<data-source key="datasource" type="org.apache.commons.dbcp.BasicDataSource">

<set-property property="driverClassName" value="com.microsoft.jdbc.sqlserver.SQLServerDriver" />

<set-property property="url" value="jdbc:microsoft:sqlserver://localhost:1433;databaseName=zzb" />

<set-property property="username" value="sa" />

<set-property property="password" value="" />

<set-property property="maxActive" value="10" />

<set-property property="maxWait" value="5000" />

<set-property property="defaultAutoCommit" value="false" />

<set-property property="defaultReadOnly" value="false" />

</data-source>

</data-sources>

MySQL資料來源配置

<data-sources >

<data-source key="datasource" type="org.apache.commons.dbcp.BasicDataSource">

<set-property property="password" value="1234" />

<set-property property="minCount" value="1" />

<set-property property="maxCount" value="10" />

<set-property property="username" value="root" />

<set-property property="driverClassName" value="org.gjt.mm.mysql.Driver" />

<set-property property="description" value="for struts attack aolution" />

<set-property property="url" value="jdbc:mysql://localhost:3306/attack" />

<set-property property="readOnly" value="false" />

<set-property property="autoCommit" value="true" />

</data-source>

</data-sources>

調用的時候在Action裡面getDataSource(request,"datasource");這個datasource就是上面那個key值，２者要對應,OK!!!

注意comm