<Context path="/doors" reloadable="true" docBase="d:/work/workspace/doors" workDir="d:/work/workspace/doors/work" >
<Resource name="jdbc/doorsDB" type="javax.sql.DataSource"
factory="org.apache.tomcat.dbcp.dbcp.BasicDataSourceFactory"
driverClassName="com.microsoft.sqlserver.jdbc.SQLServerDriver"
maxIdle="2" maxWait="5000" validationQuery="select 1"
username="doors_user" password="pwd" url="jdbc:sqlserver://localhost:1433;DatabaseName=doors"
maxActive="4"/>
1) issue, con pool
Cannot create JDBC driver of class 'com.microsoft.sqlserver.jdbc.SQLServerDriver' for connect URL
'jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=doors'
2) issue, direct connect
No suitable driver found for jdbc:microsoft:sqlserver://localhost:1433
use this url to solve, ok: String url = "jdbc:sqlserver://localhost:1037;DatabaseName=doors";
a)可能不同版本的jdbc,类的名字不一样, 如:com.microsoft.sqlserver.jdbc.SQLServerDriver 对比有的资料写 com.microsoft.jdbc.sqlserver.SQLServerDriver, 不知道是否笔误。
b)还有如果数据库安装在本地,如SQLEXPRESS,可用不是用1433端口,如我这里查到1037
c)还有有的资料写url中间多一个microsoft=jdbc:microsoft:sqlserver://localhost:1037,我这里去掉了才成功。