帆软-SqlServer-Tomcat整合

Tomcat下conf/server.xml 配置如下

<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