当前页面: 开发资料首页 → JSP 专题 → 88分请教高人,连接oracle9数据库报错,windows server2003下,在线等

88分请教高人,连接oracle9数据库报错,windows server2003下,在线等

摘要: 88分请教高人,连接oracle9数据库报错,windows server2003下,在线等

连接oracle的javabean如下:
package name.sahara.sql.oraclexe;
import java.sql.*;
import java.util.*;
import java.sql.Connection;
import oracle.jdbc.pool.OracleDataSource;
/**
* 利用JDBC，使用OracleDateSource方式获取数据库链接。

*/
public class ConnOracleJdbc {
/**
* 构造函数
*
*/
public ConnOracleJdbc(){

}
/**
* 获取数据库链接，不需要返回conn
* @throws SQLException
*/
public void getDBConnection() throws SQLException
{
OracleDataSource ds;
ds = new OracleDataSource();
ds.setURL("jdbc:oracle:thin:sdaubingo/bingo@localhost:1521/graduate");
conn = ds.getConnection();
//return conn;
}
/**
* 获取数据库链接
* @return 数据库链接conn
* @throws SQLException
*/
public Connection getConnection() throws SQLException
{
OracleDataSource ds;
ds = new OracleDataSource();
ds.setURL("jdbc:oracle:thin:sdaubingo/bingo@localhost:1521/graduate");
conn = ds.getConnection();
return conn;
}
/*public static void main(String[] args){
ConnOracleJdbc conn=new ConnOracleJdbc();
try {
System.out.println(conn.getDBConnection());
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}

}*//**
* 运行查询语句并返回查询结果集
* @param SQLQuery
* @return rs
*/
public ResultSet selectQuery(String SQLQuery) {
this.SQLQuery = SQLQuery;
try {
this.getDBConnection();
stmt=this.conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_READ_ONLY);

rs = stmt.executeQuery(SQLQuery);
} catch (Exception e) {
System.out.print("the Exception of selectQuery:");
System.out.println(e.getMessage());
System.out.print("the content of conn:");
System.out.println(conn);
System.out.print("the content of rs"+rs);
}
this.close();
return rs;
}
/**
* 运行插入与更新语句
* @param SQLQuery
*/
public void query(String SQLQuery) {
this.SQLQuery = SQLQuery;
try {this.getDBConnection();
stmt = this.conn.createStatement();
stmt.executeQuery(SQLQuery);
this.close();} catch (Exception e) {
System.out.println("the query exception:"+e.getMessage());
e.printStackTrace();
}
}
/**
* 运行update语句
* @param SQLQuery
*/
public void update(String SQLQuery) {
this.SQLQuery = SQLQuery;
try {this.getDBConnection();
stmt = this.conn.createStatement();
stmt.executeUpdate(SQLQuery);
this.close();
} catch (Exception e) {
System.out.print(e.getMessage());
e.printStackTrace();
}
}
/**
* 关闭数据库链接，包括rs,stmt,conn
*/
public void close(){
if ( rs != null ) {try { rs.close(); } catch ( Exception ex ) {}
rs = null;
} if ( stmt != null ) {
try { stmt.close(); } catch ( Exception ex ) {}
stmt = null;
}if ( conn != null ) {
try { conn.close(); } catch ( Exception ex ) {}
conn = null;
}
}
/**
* 返回数据库链接池
*
*/
public void closeObject(){
try{}
catch(Exception e){}
finally {
close();
}
}
private Connection conn;
private Statement stmt;
private ResultSet rs;
private String SQLQuery;
}

tomcat下报错如下:
java.sql.SQLException: Io 异常: The Network Adapter could not establish the connection
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:255)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:387)
at oracle.jdbc.driver.PhysicalConnection.(PhysicalConnection.java:414)
at oracle.jdbc.driver.T4CConnection.(T4CConnection.java:165)
at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:35)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:801)
at oracle.jdbc.pool.OracleDataSource.getPhysicalConnection(OracleDataSource.java:297)
at oracle.jdbc.pool.OracleDataSource.getConnection(OracleDataSource.java:221)
at oracle.jdbc.pool.OracleDataSource.getConnection(OracleDataSource.java:165)
at name.sahara.sql.oraclexe.ConnOracleJdbc.getConnection(ConnOracleJdbc.java:41)
at cn.edu.sdau.graduate.DegreeInfo.getDegreeInfo(DegreeInfo.java:18)
at org.apache.jsp.register.index_jsp._jspService(index_jsp.java:131)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:324)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:237)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:214)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
at org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:198)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:152)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:118)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:929)
at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:160)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:799)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:705)
at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:577)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:683)
at java.lang.Thread.run(Thread.java:595)


不知道我哪里错了,,对oracle不太了解阿,,有请高人相助...

---

sdaubingo/bingo@localhost

在SQLPLUS里这个能联上数据库么

---

能阿,这应该是一个管理的帐户吧,,除了sysman和system

---

怎么没人顶了?传说中的绝世高手那?

---

好像是你的连接的驱动的问题.怀疑你的 oracle.jdbc.pool.OracleDataSource有问题,或者没有被正确加载

---