请高手帮忙,关于连接池的问题。 兄弟,见意你先用程序连接数据库,就是普通的方法,,如果通过。说明驱动程序可以用,再在连接池里面试。。上面的错误,应该是驱动程序的问题,检查一下classpath之类的环境变量是否设置正确 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 我用的测试代码如下:<%@ page contentType="text/html;charset=gb2312"%> <%@ page import="java.sql.*"%> <%@ page import="javax.sql.*"%> <html> <body> <%try{ Class.forName("oracle.jdbc.driver.OracleDriver");}catch(ClassNotFoundException e){ System.out.println(e);}//Class.forName("oracle.jdbc.driver.OracleDriver").newInstance(); String url="jdbc:oracle:thin:@132.147.160.190:1521:oracle"; //orcl为你的数据库的SID String user="wk_cor"; String password="wk_cor"; Connection conn= DriverManager.getConnection(url,user,password);Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE); String sql="select eh0100,eh0103 from eh001"; ResultSet rs=stmt.executeQuery(sql); while(rs.next()) {%> 您的第一个字段内容为:<%=rs.getString(1)%> 您的第二个字段内容为:<%=rs.getString(2)%> <%}%> <%out.print("数据库操作成功,恭喜你");%> <%rs.close(); stmt.close(); conn.close(); %> </body> </html> 运行异常为:javax.servlet.ServletException: Io ??: Connection refused(DESCRIPTION=(TMP=)(VSNNUM=135294976)(ERR=12505)(ERROR_STACK=(ERROR=(CODE=12505)(EMFI=4)))) org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:867) org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:800) org.apache.jsp.testoracle_jsp._jspService(testoracle_jsp.java:91) org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:133) javax.servlet.http.HttpServlet.service(HttpServlet.java:856) org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:311) org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:301) org.apache.jasper.servlet.JspServlet.service(JspServlet.java:248) javax.servlet.http.HttpServlet.service(HttpServlet.java:856)附我的classpath:CLASSPATH=.;C:\j2sdk1.4.0-rc\lib\tools.jar;C:\j2sdkee1.3.1\lib\j2ee.jar;D:\sql2000jdbc\lib\msbase.jar;D:\sql2000jdbc\lib\mssqlserver.jar;D:\sql2000jdbc\lib\msutil.jar;C:\j2sdk1.4.0-rc\jre\lib\rt.jar;.;C:\j2sdkee1.3.1\lib\j2ee.jar;D:\j2eetutorial\examples\src\ejb\converter\ConverterApp.ear;D:\j2eetutorial\examples\src\ejb\converter\ConverterAppClient.jar;D:\jakarta-tomcat-5.0.16\common\lib\classes12.jar;谁能告诉我怎么错啦,救命呀 java 问题,如下所示,代码什么意思啊? 有关用servlet+JSP做跟C++通讯接收端的问题 中小企业园区网规划与设计 quartz在程序启动时就执行而且就执行一次 大家帮我看看 关于java.util.Timer 为什么我的滚动条颜色不改变? 高分求教“如何动态设置jsp的字符集?” 把我代码拷到你们机上运行一下好吗?我真的不知道错在哪里? 如何在js中对excel word等格式的文件进行读写操作? tomcat5.0.16下开发servlet的问题? JSP+MYSQL中用到的问题关于事务
<%@ page contentType="text/html;charset=gb2312"%>
<%@ page import="java.sql.*"%>
<%@ page import="javax.sql.*"%>
<html>
<body>
<%
try
{
Class.forName("oracle.jdbc.driver.OracleDriver");
}
catch(ClassNotFoundException e)
{
System.out.println(e);
}
//Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();
String url="jdbc:oracle:thin:@132.147.160.190:1521:oracle";
//orcl为你的数据库的SID
String user="wk_cor";
String password="wk_cor";
Connection conn= DriverManager.getConnection(url,user,password);Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
String sql="select eh0100,eh0103 from eh001";
ResultSet rs=stmt.executeQuery(sql);
while(rs.next()) {%>
您的第一个字段内容为:<%=rs.getString(1)%>
您的第二个字段内容为:<%=rs.getString(2)%>
<%}
%>
<%out.print("数据库操作成功,恭喜你");%>
<%rs.close();
stmt.close();
conn.close();
%>
</body>
</html>
运行异常为:javax.servlet.ServletException: Io ??: Connection refused(DESCRIPTION=(TMP=)(VSNNUM=135294976)(ERR=12505)(ERROR_STACK=(ERROR=(CODE=12505)(EMFI=4))))
org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:867)
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:800)
org.apache.jsp.testoracle_jsp._jspService(testoracle_jsp.java:91)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:133)
javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:311)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:301)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:248)
javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
附我的classpath:
CLASSPATH=.;C:\j2sdk1.4.0-rc\lib\tools.jar;C:\j2sdkee1.3.1\lib\j2ee.jar;D:\sql20
00jdbc\lib\msbase.jar;D:\sql2000jdbc\lib\mssqlserver.jar;D:\sql2000jdbc\lib\msut
il.jar;C:\j2sdk1.4.0-rc\jre\lib\rt.jar;.;C:\j2sdkee1.3.1\lib\j2ee.jar;D:\j2eetut
orial\examples\src\ejb\converter\ConverterApp.ear;D:\j2eetutorial\examples\src\e
jb\converter\ConverterAppClient.jar;D:\jakarta-tomcat-5.0.16\common\lib\classes1
2.jar;谁能告诉我怎么错啦,救命呀