Tomcat下conf/server.xml 配置如下
将sqlserver的驱动包括jtds的驱动全部拷贝到Tomcat的lib下:
<Context path="" docBase="" debug="0">
<Resource name="jdbc/dbpool" auth="Container" type="javax.sql.DataSource" maxActive="100" maxIdle="30" maxWait="10000" username="" password="" driverClassName="oracle.jdbc.driver.OracleDriver" url="jdbc:oracle:thin:@IP:1521:orcl" />
<Resource name="jdbc/dbpooltwo" auth="Container" type="javax.sql.DataSource" maxActive="100" maxIdle="30" maxWait="10000" username="sa" password="" driverClassName="net.sourceforge.jtds.jdbc.Driver" url="jdbc:jtds:sqlserver://IP:1433;databaseName=XX" />
</Context>
将sqlserver的驱动包括jtds的驱动全部拷贝到Tomcat的lib下:
sqljdbc.jar
msbase.jar
mssqlserver.jar
msutil.jar
jtds-x.x.jar