还是不成啊,晕死了。 500 Servlet Exception java.sql.SQLException: No suitable driver at java.sql.DriverManager.getConnection(DriverManager.java:537) at java.sql.DriverManager.getConnection(DriverManager.java:177) at _testoraclejsp__jsp._jspService(/testoraclejsp.jsp:14) at com.caucho.jsp.JavaPage.service(JavaPage.java:75) at com.caucho.jsp.Page.subservice(Page.java:506) at com.caucho.server.http.FilterChainPage.doFilter(FilterChainPage.java:182) at com.caucho.server.http.Invocation.service(Invocation.java:315) at com.caucho.server.http.CacheInvocation.service(CacheInvocation.java:135) at com.caucho.server.http.RunnerRequest.handleRequest(RunnerRequest.java:344) at com.caucho.server.http.RunnerRequest.handleConnection(RunnerRequest.java:274) at com.caucho.server.TcpConnection.run(TcpConnection.java:139) at java.lang.Thread.run(Thread.java:484) -------------------------------------------------------------------------------- Resin 2.1.9 (built Tue Apr 15 14:28:40 PDT 2003)
url="jdbc:oracle:thin:@xxx.xxx.xxx.xxx:1521:myoracle";
是不是这样啊?
同时他这个路径添加到开发工具里,这样不管是开发时还是直接运行都不会有错了
String uid="system";
String pwd=" manager ";更改上面得部分:myoracle实例名,system用户,manager密码另外 etheltim说得也可能是其中一个原因,还有把classes12.jar得路径加入到PATH中
OCI是ORACLE公司提供了访问接口,
而thin是用JAVA写的ORACLE数据库访问接口,
用OCI,必须安装客户端或至少安装所需要的库.OCI是用C实现的.
thin,一个zip文件即可。
500 Servlet Exception
java.sql.SQLException: No suitable driver
at java.sql.DriverManager.getConnection(DriverManager.java:537)
at java.sql.DriverManager.getConnection(DriverManager.java:177)
at _testoraclejsp__jsp._jspService(/testoraclejsp.jsp:14)
at com.caucho.jsp.JavaPage.service(JavaPage.java:75)
at com.caucho.jsp.Page.subservice(Page.java:506)
at com.caucho.server.http.FilterChainPage.doFilter(FilterChainPage.java:182)
at com.caucho.server.http.Invocation.service(Invocation.java:315)
at com.caucho.server.http.CacheInvocation.service(CacheInvocation.java:135)
at com.caucho.server.http.RunnerRequest.handleRequest(RunnerRequest.java:344)
at com.caucho.server.http.RunnerRequest.handleConnection(RunnerRequest.java:274)
at com.caucho.server.TcpConnection.run(TcpConnection.java:139)
at java.lang.Thread.run(Thread.java:484)
--------------------------------------------------------------------------------
Resin 2.1.9 (built Tue Apr 15 14:28:40 PDT 2003)