tomcat4.03+jdk1.3连接oracle9i的问题(100分)
有解决办法吗?或者给出完整的配置方法。分可以再加。
连接数据库总是出问题,刚开始是找不到驱动。
后来在客户端,找到jdbc驱动。拷到bin目录下以后,却出现异常:
java.sql.SQLException: Io 异常: Connection refused(DESCRIPTION=(TMP=)(VSNNUM=153092352)(ERR=12505)(ERROR_STACK=(ERROR=(CODE=12505)(EMFI=4))))
请问,问题在那里呢?代码如下:
<%@ page language="java" import="java.io.*,java.sql.*,javax.sql.* ,javax.naming.*"%>
<%@ page contentType="text/html;charset=gb2312" %>
<%
String sDBDriver = "oracle.jdbc.driver.OracleDriver";
String sConnStr = "jdbc:oracle:thin:@192.168.0.134:1521:house";
Connection conn = null;
ResultSet rs = null;
Statement stmt = null;
try
{
Class.forName(sDBDriver);
conn = DriverManager.getConnection(sConnStr,"test","test");
stmt = conn.createStatement();
//stmt.executeQuery("create table aaa(aaa int)");
//stmt.executeUpdate("insert into bbb values(456)");
rs = stmt.executeQuery("select * from T_djywsld");
while (rs.next()){
out.println("" + rs.getInt(1) + "");
out.println(":"+"<br>");
//out.println(" + rs.getString('answers') + ");
}
rs.close();
}
catch(Exception e)
{
out.println(e);
}
%>
有解决办法吗?或者给出完整的配置方法。分可以再加。