论坛徽章:: 0

电梯直达

1楼 [收藏(0)] [报告]

发表于 2004-07-08 15:37 |只看该作者 |倒序浏览

各位高手：
我用tomcat 连接数据库出现问题，请帮忙解决，谢谢！
我的jsp源码是：
<%@ page contentType="text/html;charset=gb2312"%>;
<%@ page import="java.sql.*"%>;
<%@ page import="javax.sql.*"%>;
<html>;
<body>;
<%Class.forName("com.informix.jdbc.IfxDriver"

;
String url =
"jdbc:informix-sqli://12.12.12.87:6666/ebank:INFORMIXSERVER=qyyh;user=ebank;password=ebankpwd";

Connection conn= DriverManager.getConnection(url);
Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
String sql="select * from test";
ResultSet rs=stmt.executeQuery(sql);
while(rs.next()) {%>;
您的第一个字段内容为：<%=rs.getString(1)%>;
您的第二个字段内容为：<%=rs.getString(2)%>;
<%}%>;
<%out.print("数据库操作成功，恭喜你"

;%>;
<%rs.close();
stmt.close();
conn.close();
%>;
</body>;
</html>;

出现的错误信息是：
HTTP Status 500 -

--------------------------------------------------------------------------------

type Exception report

message

description The server encountered an internal error () that prevented it from fulfilling this request.

exception

javax.servlet.ServletException: Attempt to connect to database server (Java socket exception encountered:Connection refused: connect) failed.
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:673)
org.apache.jsp.movies.informixconnect_jsp._jspService(informixconnect_jsp.java:77)
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:285)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:232)
javax.servlet.http.HttpServlet.service(HttpServlet.java:856)

root cause

java.sql.SQLException: Attempt to connect to database server (Java socket exception encountered:Connection refused: connect) failed.
com.informix.jdbc.IfxSqliConnect.(IfxSqliConnect.java)
sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
java.lang.reflect.Constructor.newInstance(Constructor.java:274)
com.informix.jdbc.IfxDriver.connect(IfxDriver.java)
java.sql.DriverManager.getConnection(DriverManager.java:512)
java.sql.DriverManager.getConnection(DriverManager.java:193)
org.apache.jsp.movies.informixconnect_jsp._jspService(informixconnect_jsp.java:51)
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:285)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:232)
javax.servlet.http.HttpServlet.service(HttpServlet.java:856)

note The full stack trace of the root cause is available in the Tomcat logs.

文库|博客

返回列表

Chinaunix › 论坛 › 程序设计 › Java › 请教关于informix 连接

请教关于informix 连接 [复制链接]

浏览过的版块