to hackateC:\oracle\ora92\bin下面有OraOps9.dll这个DLL文件
可以安装一个oracle for .net的组件,就可以访问oracle了。 你用tnsping看看有反应吗。 同意yes4pierce
已经安转了oracle.dataaccess组件
现在的问题是:我现在可以在web服务器上用toad成功的连接oracle数据库, 但是在运行asp.net程序时仍任报错:无法加载 DLL (OraOps9.dll)。 说明: 执行当前 Web 请求期间,出现未处理的异常。请检查堆栈跟踪信息,以了解有关该错误以及代码中导致错误的出处的详细信息。 ......
上面的问题我以解决了,请教各位大虾,怎么使用TOMCAT自带的数据库连接池???我在jsp中使用TOMCAT自带的数据库连接池出现的错误如下: type Exception report message description The server encountered an internal error () that prevented it from fulfilling this request.exception javax.servlet.ServletException: cannot get Connection pool. org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:848) org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:781) org.apache.jsp.jdbc.OracleDB.testdbpool_jsp._jspService(org.apache.jsp.jdbc.OracleDB.testdbpool_jsp:77) org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97) javax.servlet.http.HttpServlet.service(HttpServlet.java:802) org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:322) org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:291) org.apache.jasper.servlet.JspServlet.service(JspServlet.java:241) javax.servlet.http.HttpServlet.service(HttpServlet.java:802)root cause java.sql.SQLException: cannot get Connection pool. org.apache.jsp.jdbc.OracleDB.testdbpool_jsp._jspService(org.apache.jsp.jdbc.OracleDB.testdbpool_jsp:69) org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97) javax.servlet.http.HttpServlet.service(HttpServlet.java:802) org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:322) org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:291) org.apache.jasper.servlet.JspServlet.service(JspServlet.java:241) javax.servlet.http.HttpServlet.service(HttpServlet.java:802)如何解决呢?谢谢!
你用tnsping看看有反应吗。
同意yes4pierce
但是在运行asp.net程序时仍任报错:无法加载 DLL (OraOps9.dll)。
说明: 执行当前 Web 请求期间,出现未处理的异常。请检查堆栈跟踪信息,以了解有关该错误以及代码中导致错误的出处的详细信息。
......
type Exception report
message
description The server encountered an internal error () that prevented it from fulfilling this request.exception javax.servlet.ServletException: cannot get Connection pool.
org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:848)
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:781)
org.apache.jsp.jdbc.OracleDB.testdbpool_jsp._jspService(org.apache.jsp.jdbc.OracleDB.testdbpool_jsp:77)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:322)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:291)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:241)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)root cause
java.sql.SQLException: cannot get Connection pool.
org.apache.jsp.jdbc.OracleDB.testdbpool_jsp._jspService(org.apache.jsp.jdbc.OracleDB.testdbpool_jsp:69)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:322)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:291)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:241)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)如何解决呢?谢谢!
<%@ page contentType="text/html;charset=GBK"%>
<%@ page import= "java.sql.*"%>
<%@ page import= "javax.naming.*"%>
<%@ page import="javax.sql.*"%>
<html>
<head><title>testdbpool.jsp</title></head>
<body bgcolor="#ffffff">
<h1>test Tomcat connection pool</h1>
<%
//使用Connection Pool要配置服务器 weblogic or resin 服务器的配置见 JSP应用开发详解
//try{
Context initCtx = new InitialContext();
Context envCtx = (Context)initCtx.lookup("java:comp/env");
javax.sql.DataSource ds = (DataSource)envCtx.lookup("OracleDB");
//Context ctx = new InitialContext();
// if (ctx == null)
// throw new Exception("不能获取Context!");
//获取连接池对象
//Object obj = (Object)ctx.lookup("java:comp/env/jdbc/OracleDB");
//类型转换
//javax.sql.DataSource ds = (javax.sql.DataSource)ctx.lookup("java:comp/env/jdbc/OracleDB");
Connection conn = ds.getConnection();
Statement stmt = conn.createStatement();
////String strSql = " insert into Tablea(A_A,B_B) values('00001','holen')";
////stmt.executeUpdate(strSql);
////String strSql = " select A_A,B_B from Tablea ";
String strSql = " select * from TESTTABLE ";
ResultSet rs = stmt.executeQuery(strSql);
//if(rs.next())
while(rs.next()){
out.println(rs.getString(1));
out.println(rs.getString(2));
} rs.close();
stmt.close();
// }
// catch(Exception ex){
// ex.printStackTrace();
// throw new SQLException("cannot get Connection pool.");
// }
%></body>
</html>报错如下:
type Exception reportmessage description The server encountered an internal error () that prevented it from fulfilling this request.exception javax.servlet.ServletException: Name java:comp is not bound in this Context
org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:848)
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:781)
org.apache.jsp.testdbpool_jsp._jspService(org.apache.jsp.testdbpool_jsp:100)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:322)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:291)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:241)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
root cause javax.naming.NameNotFoundException: Name java:comp is not bound in this Context
org.apache.naming.NamingContext.lookup(NamingContext.java:769)
org.apache.naming.NamingContext.lookup(NamingContext.java:152)
javax.naming.InitialContext.lookup(Unknown Source)
org.apache.jsp.testdbpool_jsp._jspService(org.apache.jsp.testdbpool_jsp:58)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:322)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:291)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:241)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)