报错信息:(试过换路径不管是tomcat 的目录还是项目的WEB-INF\lib 目录都运行不出来)
errordata
java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver
at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1358)
at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1204)
at java.lang.ClassLoader.loadClassInternal(Unknown Source)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Unknown Source)
at dao.StudentDao.initConnection(StudentDao.java:29)
at dao.StudentDao.queryStuByName(StudentDao.java:44)
at prj2_1.QueryAction.execute(QueryAction.java:37)
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:431)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:236)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)
at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:432)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:710)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:230)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:104)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:261)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:581)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
at java.lang.Thread.run(Unknown Source)
java.lang.NullPointerException
at dao.StudentDao.queryStuByName(StudentDao.java:45)
at prj2_1.QueryAction.execute(QueryAction.java:37)
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:431)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:236)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)
at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:432)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:710)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:230)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:104)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:261)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:581)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
at java.lang.Thread.run(Unknown Source)
加载的包:下面test项目是可以成功连接数据库的

连接代码:
try{
/*
Class.forName("oracle.jdbc.driver.OracleDriver");
conn = DriverManager.getConnection("jdbc:oracle:" + "thin:@127.0.0.1:1521:XE","osky","osky123");
System.out.println("连接成功!");
*/
System.out.println("开始尝试连接数据库!BBBB");
Class.forName("oracle.jdbc.driver.OracleDriver");// 加载Oracle驱动程序
System.out.println("开始尝试连接数据库!BBBB");
System.out.println("开始尝试连接数据库!");
String url = "jdbc:oracle:" + "thin:@127.0.0.1:1521:XE";// 127.0.0.1是本机地址,XE是精简版Oracle的默认数据库名
String user = "osky";// 用户名,系统默认的账户名
String password = "osky123";// 你安装时选设置的密码
conn = DriverManager.getConnection(url, user, password);// 获取连接
System.out.println("连接成功!");
}catch(Exception ex){ System.out.println("errordata");ex.printStackTrace();}
}
相关解决方案
- 求教,SSH + ORACLE 日期处理有关问题
- 请问registered the JDBC driver [com.mysql.jdbc.Driver] but failed to unregister
- hibernate 连接 oracle session 有关问题
- 小白Could not execute JDBC batch update解决办法
- eclipse+tomcat6.0+oracle 10g配置数据库连接池的异常
- java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] 找不到资料 '(未知的)'
- !使用JDNI时,报 Cannot create JDBC driver of class '' for connect URL 'null'
- java 生成 word 封存到 oracle 数据库
- JDBC 控制台输入数据 直接插入到数据库
- jdbc 联接oracle
- java.lang.UnsupportedOperationException: The user must supply a JDBC connection,该怎么处理
- [Microsoft][SQLServer 2000 Driver for JDBC]No ResultSet set was produced.多谢
- oracle 最大连市接数 为什么main方法无限拿连接
- oracle 分页排序,ssi,该怎么处理
- oracle 最近的时间(而不是前一天的时间) 跪求sql语句 。解决方法
- 办公自动化系统——议程管理(用jsp+servlet+js+html+jdbc)怎样实现
- JDBC 连接sql server 2005老是失败怎么处理?恳请高手帮忙。
- JDBC-ODBC连接数据库,读写数据库速度超慢,该怎么处理
- Could not load JDBC driver class 咋回事
- java.sql.SQLException: No suitable driver found for jdbc:oracle:thin:192.168解决思路
- JDBC SQLSERVER2000驱动,该如何解决
- com.microsoft.sqlserver.jdbc.SQLServerException: 列名 n_id 无效。解决方案
- java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver,该怎么处理
- com.microsoft.sqlserver.jdbc.SQLServerException: 该联接已关闭
- Jsp + Oracle 怎么取回id,报错getInt not implemented for class oracle.jdbc.driver.T4CRo
- oracle 调用java程序,该如何处理
- oracle,该怎么解决
- java.sql.SQLException: No suitable driver found for jdbc:mysql://localhost:3306,该怎么处理
- 在 Hibernate3 查询不到 Oracle 11g 里的记录
- JDBC MYSQL 驱动加载失败 JSP DAO ECLIPSE,该怎么解决