java 连接 oracle 10_java-连接到oracle 10g数据库时,获得IOException“...

连接到Oracle 10g数据库时获取IOException:-

Exception in thread "main" java.sql.SQLException: Io exception: Got minus one from a read call

at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:145)

at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:190)

at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:363)

at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:401)

at oracle.jdbc.driver.PhysicalConnection.(PhysicalConnection.java:441)

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:839)

at java.sql.DriverManager.getConnection(DriverManager.java:582)

at java.sql.DriverManager.getConnection(DriverManager.java:185)

at com.myapp.struts.DBConnection.getDBConnection(DBConnection.java:21)

at com.myapp.struts.DBConnection.main(DBConnection.java:31)

Java结果:1

我的班级代码如下:

package com.myapp.struts;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.ResultSet;

import java.sql.Statement;

public class DBConnection {

Connection connection = null;

public Connection getDBConnection()throws Exception{

Class.forName("oracle.jdbc.driver.OracleDriver");

System.out.println("OUTPUUT ********driver registered");

connection = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:XE","system","system");

System.out.println("OUTPUUT ********connection established");

return connection;

}

public static void main(String args[])throws Exception{

DBConnection db = new DBConnection();

ResultSet result = null;

String query = "SELECT * FROM admin;";

Connection con = null;

con = db.getDBConnection();

System.out.println("OUTPUUT ********111111111");

Statement st =con.createStatement();

result = (ResultSet) st.executeQuery(query);

while(result.next()){

System.out.println("OUTPUUT ********");

System.out.println(result.getInt(1));

System.out.println(result.getString(2));

System.out.println(result.getString(3));

System.out.println(result.getString(4));

}

con.close();

}

}

还有另一件事,我正在使用netbeans ide并开发一个struts项目.

从最近两天开始努力解决此问题,但尚未找到解决方案.

请帮忙????

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值