struts <data-sources> 的配置确实是让人恶心,但是要是配好了用起来还挺方便。配置时候特别要注意的就是大小写和对于不同数据库的property不同的区别。一字之差就会耽误你很多时间。开始可能会出现很多包找不到的现象,只要根据报错提示一步步添加所需要的包就ok了。我配过了oracle的数据源和mysql的数据源,sql server的配置我没记下来,算了,姑且先记下前面提到的两个吧。
oracle
<data-sources >
<data-source type="oracle.jdbc.pool.OracleConnectionPoolDataSource">
<set-property property="password" value="system" />
<set-property property="user" value="system" />
<set-property property="driverClass" value="oracle.jdbc.driver.OracleDriver" />
<set-property property="description" value="oracleDB" />
<set-property property="URL" value="jdbc:oracle:thin:@127.0.0.1:1521:FOXDATA" />
<set-property property="readOnly" value="false" />
<set-property property="autoCommit" value="false" />
</data-source>
</data-sources>
<data-source type="oracle.jdbc.pool.OracleConnectionPoolDataSource">
<set-property property="password" value="system" />
<set-property property="user" value="system" />
<set-property property="driverClass" value="oracle.jdbc.driver.OracleDriver" />
<set-property property="description" value="oracleDB" />
<set-property property="URL" value="jdbc:oracle:thin:@127.0.0.1:1521:FOXDATA" />
<set-property property="readOnly" value="false" />
<set-property property="autoCommit" value="false" />
</data-source>
</data-sources>
mysql(commons-pool-1.2.jar,commons-dbcp-1.2.1.jar,mysql.jar)
<data-source type="org.apache.commons.dbcp.BasicDataSource">
<set-property property="password" value="123456" />
<set-property property="username" value="information" />
<set-property property="driverClassName" value="com.mysql.jdbc.Driver" />
<set-property property="description" value="informationDB" />
<set-property property="url" value="jdbc:mysql://localhost:3306/information" />
<set-property property="readOnly" value="false" />
<set-property property="autoCommit" value="false" />
</data-source>
<set-property property="password" value="123456" />
<set-property property="username" value="information" />
<set-property property="driverClassName" value="com.mysql.jdbc.Driver" />
<set-property property="description" value="informationDB" />
<set-property property="url" value="jdbc:mysql://localhost:3306/information" />
<set-property property="readOnly" value="false" />
<set-property property="autoCommit" value="false" />
</data-source>