附件的代码为原orale数据库的代码。而我修改为:
<data-sources>
<data-source type="org.apache.commons.dbcp.BasicDataSource" key="oracleDB1">
<set-property property="driverClass" value="com.microsoft.jdbc.sqlserver.SQLServerDriver" />
<set-property property="url" value="jdbc:microsoft:sqlserver://127.0.0.1:1433;DataBaseName=BookStore;SelectMethod=cursor" />
<set-property property="maxActive" value="10" />
<set-property property="description" value="sql server 2000" />
<set-property property="username" value="sa" />
<set-property property="password" value="" />
<set-property property="autoCommit" value="true" />
</data-source>
</data-sources>
原来的是:
<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>