1.JNDI数据源局部配置(解决Cannot create JDBC driver of class '' for connect URL 'null')
复制项目coscoins放在D:\MWNEW\apache-tomcat-7.0.82\webapps路径下。
解决:在\apache-tomcat-7.0.82\conf\Catalina\localhost下增加文件coscoins.xml,注意
path="/coscoins" docBase="D:\MWNEW\apache-tomcat-7.0.82\webapps\coscoins"
<?xml version="1.0" encoding="UTF-8"?>
<Context path="/coscoins" docBase="D:\MWNEW\apache-tomcat-7.0.82\webapps\coscoins" reloadable="true" debug="0" crossContext="true" >
<Resource
name="jdbc/sql2005ins"
type="javax.sql.DataSource"
password="****"
driverClassName="com.microsoft.sqlserver.jdbc.SQLServerDriver"
maxIdle="20"
maxWait="5000"
username="sa"
url="jdbc:sqlserver://172.25.6.65:1433;DatabaseName=COSCOINS2020"
/>
</Context>
2.org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot load JDBC driver class 'com.microsoft.sqlserver.jdbc.SQLServerDriver
解决:复制sqljdbc4.jar放在\apache-tomcat-7.0.82\webapps\coscoins\WEB-INF\lib