JSP代码如下:
<%@page language="java" contentType="text/html;charset=gb2312"%>
<%@page import="java.sql.*"%>
<html>
<head>
<title>login</title>
</head>
<body>
<%
//定义数据库操作的常量、对象
final String DBDRIVER = "oracle.jdbc.driver.OracleDriver";
final String DBURL = "jdbc:oracle:thin:@localhost:1158:orcl";
final String DBUSER = "scott";
final String DBPASSWORD = "tiger";
Connection conn = null;
%>
<%
try
{
Class.forName(DBDRIVER).newInstance();
conn =DriverManager.getConnection(DBURL,DBUSER,DBPASSWORD);
out.write("连接成功!");
}
catch(Exception e)
{
e.printStackTrace();
out.write("连接失败!");
}
%></body>
</html>网页总是显示:连接失败!
TOMCAT版本为6.0,Oracle版本为11g,端口号1158是Enterprise Manager Console HTTP 端口 (orcl),确认无误;
ojdbc.jar与classes12.jar均放入%tomcat_home%\lib\下敬请高手指导
<%@page language="java" contentType="text/html;charset=gb2312"%>
<%@page import="java.sql.*"%>
<html>
<head>
<title>login</title>
</head>
<body>
<%
//定义数据库操作的常量、对象
final String DBDRIVER = "oracle.jdbc.driver.OracleDriver";
final String DBURL = "jdbc:oracle:thin:@localhost:1158:orcl";
final String DBUSER = "scott";
final String DBPASSWORD = "tiger";
Connection conn = null;
%>
<%
try
{
Class.forName(DBDRIVER).newInstance();
conn =DriverManager.getConnection(DBURL,DBUSER,DBPASSWORD);
out.write("连接成功!");
}
catch(Exception e)
{
e.printStackTrace();
out.write("连接失败!");
}
%></body>
</html>网页总是显示:连接失败!
TOMCAT版本为6.0,Oracle版本为11g,端口号1158是Enterprise Manager Console HTTP 端口 (orcl),确认无误;
ojdbc.jar与classes12.jar均放入%tomcat_home%\lib\下敬请高手指导
java.sql.SQLException:Io异常:Got minus one from a read call at oracle.jdbc.dbaccess.DBError.throwsSqlException(DBError.java:189)
at oracle.jdbc.dbaccess.DBError.throwsSqlException(DBError.java:231)
at oracle.jdbc.dbaccess.DBError.throwsSqlException(DBError.java:345)
等若干信息,最后以at java.lang.Thread.run(Thread.java:619)结束
我将端口号改为1521,将localhost改为192.168.107.189(局域网机器的IP地址)。两者改其一都不可,我查看%oracle_home%\product\11.1.0\db_1\install下的portlist文件,Enterprise Manager Console HTTP 端口 (orcl)为:1158,在此搞不明白为什么改为1521