java.sql.SQLException: Exhausted Resultset

Phi · *nix forums beginner Joined: 20 Mar 2005 Posts: 2

Hi all,
This is the code which i use to test connecting to Oracle db.
But it says "Exhausted Resultset"

System.out.println("Connecting...");
Connection conn = DriverManager.getConnection
("jdbc:oracle:oci:@" + database, user, password);

Statement stmt = conn.createStatement();

ResultSet rset = stmt.executeQuery ("SELECT id,name FROM pmain");

System.out.println(rset.findColumn("Name"));
rset.next();
System.out.println(rset.getString(1));
// close the result set, the statement and connect
rset.close();
stmt.close();
conn.close();
System.out.println("Your JDBC installation is correct.");

pmain has two rows.

ID NAME
---------- ---------------------------------------------------------------------
1 Phi
2 Tram
Please give a look and help me to fix this funny bug.
Cheer,
Phi.

Faroch Hordil · *nix forums beginner Joined: 11 Mar 2005 Posts: 6

You are using the Oracle driver. Have you registered it?

If not, put this before your attempt at getting a connection objekt

DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());

Fred

"Phi" <nnphi2304@gmail.com> wrote in message
news:a8dcada7.0503192013.775ffe67@posting.google.com...

Malcolm Dew-Jones · *nix forums Guru Joined: 04 Mar 2005 Posts: 418

Phi (nnphi2304@gmail.com) wrote:
: Hi all,
: This is the code which i use to test connecting to Oracle db.
: But it says "Exhausted Resultset"

i'm thinking the connection involves a long round trip, and has to compete
with a lot of other traffic on the route

--

This space not for rent.

Rauf Sarwar · *nix forums Guru Joined: 03 May 2005 Posts: 353

Your code is not very well written. Please read java docs and learn the
functions in a given class. My comments are embedded.

Phi wrote:

Google