servlet&tomcat连接oracle 时候tomcat 上老提示以下异常: 严重:the web application [/test] registered the JDBC driver [oracle.jdbc.driver.OracleDriver] but faild to unregist it when the web application was stopped.
To prevent amemory leak,the JDBC Driver has ben forcibly unregistered .
java.sql.SQLException: ORA-00942: 表或视图不存在 关于以上两点很疑惑,具体什么原因呢?1。我程序里面都将相关连接关闭了,怎么还提示那什么严重的信息。
2。表是我刚创建的,也提交了。提示不存在。
以下是我的java代码(import 部分省略了),请大家帮我看看哪里出了问题,谢谢啦!public class ShowRs extends HttpServlet {
@Override
protected void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
Connection conn = null ;
Statement stmt = null ;
ResultSet rs = null ;
response.setContentType("text/html") ;
response.setCharacterEncoding("gb2312") ;
PrintWriter out = response.getWriter() ;
out.println("<table border=1>") ;
out.println("<tr><td colspan=2 align='center'>Content</td></tr>") ;
try {
Class.forName("oracle.jdbc.driver.OracleDriver") ;
conn = DriverManager.getConnection("jdbc:oracle:thin:@169.254.66.140:1521:orcl", "scott", "tiger") ;
stmt = conn.createStatement() ;
rs = stmt.executeQuery("select * from article") ;
while(rs.next()){
out.println("<tr>") ;
out.println("<td>"+rs.getString("name")+"</td>") ;
out.println("<td>"+rs.getInt("page")+"</td>") ;
out.println("</tr>") ;
}
out.println("<table>") ;
} catch (ClassNotFoundException e) {
e.printStackTrace();
} catch (SQLException e) {
e.printStackTrace();
} finally{
try{
if(rs != null){
rs.close();
rs = null ;
}
if(stmt != null){
stmt.close() ;
stmt = null ;
}
if(conn != null){
conn.close() ;
conn = null ;
}
out.close() ;
}catch(Exception e){
e.printStackTrace() ;
}
}
}
@Override
protected void doPost(HttpServletRequest req, HttpServletResponse resp)
throws ServletException, IOException {
doGet(req, resp);
}
}
To prevent amemory leak,the JDBC Driver has ben forcibly unregistered .
java.sql.SQLException: ORA-00942: 表或视图不存在 关于以上两点很疑惑,具体什么原因呢?1。我程序里面都将相关连接关闭了,怎么还提示那什么严重的信息。
2。表是我刚创建的,也提交了。提示不存在。
以下是我的java代码(import 部分省略了),请大家帮我看看哪里出了问题,谢谢啦!public class ShowRs extends HttpServlet {
@Override
protected void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
Connection conn = null ;
Statement stmt = null ;
ResultSet rs = null ;
response.setContentType("text/html") ;
response.setCharacterEncoding("gb2312") ;
PrintWriter out = response.getWriter() ;
out.println("<table border=1>") ;
out.println("<tr><td colspan=2 align='center'>Content</td></tr>") ;
try {
Class.forName("oracle.jdbc.driver.OracleDriver") ;
conn = DriverManager.getConnection("jdbc:oracle:thin:@169.254.66.140:1521:orcl", "scott", "tiger") ;
stmt = conn.createStatement() ;
rs = stmt.executeQuery("select * from article") ;
while(rs.next()){
out.println("<tr>") ;
out.println("<td>"+rs.getString("name")+"</td>") ;
out.println("<td>"+rs.getInt("page")+"</td>") ;
out.println("</tr>") ;
}
out.println("<table>") ;
} catch (ClassNotFoundException e) {
e.printStackTrace();
} catch (SQLException e) {
e.printStackTrace();
} finally{
try{
if(rs != null){
rs.close();
rs = null ;
}
if(stmt != null){
stmt.close() ;
stmt = null ;
}
if(conn != null){
conn.close() ;
conn = null ;
}
out.close() ;
}catch(Exception e){
e.printStackTrace() ;
}
}
}
@Override
protected void doPost(HttpServletRequest req, HttpServletResponse resp)
throws ServletException, IOException {
doGet(req, resp);
}
}
解决方案 »
- mybatis3 复合主键查询为null如何解决?
- JNDI查找EJB时遇到的问题
- 用ssh框架怎样连接两个数据库
- asc码 16进制的 02 03 06 xml没办法解析
- Hibernate取数据类型转换不同机器不同结果
- 请问我将ArrayList中数据用<LOGIC:iterate>来显示,为何重复显示最后一条数据。
- 在TOMCAT5.0中beans那个.class文件应保存在哪个目录下?
- 关于Stub的问题
- 倡议: 论坛数据采用xml来标准化, 推行xmlBBS!
- maven框架下使用jibx 绑定模板时候报的异常。求大神解救
- 大学本科计算机科学与技术要学那些课程
- ssh框架下的删除问题
这个出错了,这个地方该怎么写啊??
@Override
public synchronized void close() throws SQLException {
DriverManager.deregisterDriver(DriverManager.getDriver(url));
super.close();
}
}
java.sql.SQLException:ORA-00942:表或视图不存在
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:111)
应该是我这段代码有问题,或者是连接JDBC代码有误,请高手指点下代码该如何写:protected void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
Connection conn = null ;
Statement stmt = null ;
ResultSet rs = null ;
response.setContentType("text/html") ;
response.setCharacterEncoding("gb2312") ;
PrintWriter out = response.getWriter() ;
out.println("<table border=1>") ;
out.println("<tr><td colspan=2 align='center'>Content</td></tr>") ;
try {
Class.forName("oracle.jdbc.driver.OracleDriver") ;
conn = DriverManager.getConnection ("jdbc:oracle:thin:@127.0.0.1:1521:orcl","scott","tiger") ;
stmt = conn.createStatement() ;
rs = stmt.executeQuery("select * from article") ;