我运行怎么不行啊,出来如下东西,还请斑竹帮帮忙,帮我看看,谢谢啦!
java.lang.ClassNotFoundException: com.microsoft.sqlserver.jdbc.SQLServerDriver
at java.net.URLClassLoader$1.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at java.lang.ClassLoader.loadClassInternal(Unknown Source)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Unknown Source)
at cn.edu.jfcs.app.test.main(test.java:15)
java.lang.ClassNotFoundException: com.microsoft.sqlserver.jdbc.SQLServerDriver
at java.net.URLClassLoader$1.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at java.lang.ClassLoader.loadClassInternal(Unknown Source)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Unknown Source)
at cn.edu.jfcs.app.test.main(test.java:15)
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.getInstancePort(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)这个是什么错误啊!
org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFact
ory (到主机 的 TCP/IP 连接失败。 java.net.ConnectException: Connection refused:
connect)
at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSou
rce.java:855)
at org.apache.commons.dbcp.BasicDataSource.setLogWriter(BasicDataSource.
java:598)
at org.apache.struts.action.ActionServlet.initModuleDataSources(ActionSe
rvlet.java:808)
at org.apache.struts.action.ActionServlet.init(ActionServlet.java:335)
at javax.servlet.GenericServlet.init(GenericServlet.java:82)
at com.caucho.server.http.Application.createServlet(Application.java:310
9)
at com.caucho.server.http.Application.loadServlet(Application.java:3060) at com.caucho.server.http.Application.initServlets(Application.java:1921
)
at com.caucho.server.http.Application.init(Application.java:1847)
at com.caucho.server.http.VirtualHost.init(VirtualHost.java:728)
at com.caucho.server.http.ServletServer.initHosts(ServletServer.java:874
)
at com.caucho.server.http.ServletServer.initInternal(ServletServer.java:
719)
at com.caucho.server.http.ServletServer.init(ServletServer.java:530)
at com.caucho.server.http.ResinServer.init(ResinServer.java:393)
at com.caucho.server.http.ResinServer.main(ResinServer.java:1154)
at com.caucho.server.http.HttpServer.main(HttpServer.java:103)
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: 到主机 的 TCP/IP 连
接失败。 java.net.ConnectException: Connection refused: connect
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(U
nknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(Unknown Sour
ce)
at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(Unknown Source)
at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(Driv
erConnectionFactory.java:37)
at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(Poolable
ConnectionFactory.java:290)
at org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(Bas
icDataSource.java:877)
at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSou
rce.java:851)
... 15 more
struts.config的数据源配置:
<data-source key="java:comp/localhost" type="org.apache.commons.dbcp.BasicDataSource">
<set-property property="driverClassName" value="com.microsoft.sqlserver.jdbc.SQLServerDriver"/>
<set-property property="url" value="jdbc:sqlserver://localhost:1433;DatabaseName=Company"/>
<set-property property="username" value="sa"/>
<set-property property="password" value="kaka"/>
<set-property property="maxActive" value="5"/>
<set-property property="maxIdle" value="3"/>
<set-property property="maxWait" value="100"/>
<set-property property="defaultAutoCommit" value="true"/>
<set-property property="defaultReadOnly" value="false"/>
</data-source>请各位帮忙看看是什么错误呢?? 设置SQLEXPRESS服务器: 的设置都按照楼主的样子设置了!
try { Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
} catch (Exception ex) {
System.out.println ("无法加载驱动程序:" + ex.getMessage());
return;结果报错了:
无法加载驱动程序:com.microsoft.sqlserver.jdbc.SQLServerDriver
我的驱动包是sp3,sqlserver是sp4,驱动包是在项目右键buildpath ->libraries中增加的