Re: [Oracle] How to check for empty ResultSet?
From: Kevin C. (nomail_at_fake.com)
Date: 03/14/04
- Next message: Igor N. Kolomiyets: "Re: [Oracle] How to check for empty ResultSet?"
- Previous message: Silvio Bierman: "Re: Regarding retrievel of data"
- In reply to: Igor N. Kolomiyets: "Re: [Oracle] How to check for empty ResultSet?"
- Next in thread: Igor N. Kolomiyets: "Re: [Oracle] How to check for empty ResultSet?"
- Reply: Igor N. Kolomiyets: "Re: [Oracle] How to check for empty ResultSet?"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Date: Sun, 14 Mar 2004 00:11:20 GMT
"Igor N. Kolomiyets" <list@inksystems.net> wrote in message
news:c2vftc$hg7$1@kermit.esat.net...
> Result Set will return false if there is no records in it. If it throws
> such an exception it is something wrong with the way the result set was
> opened.
> What driver do you use? Can you provide your code from the point where
> you are creating the statement used top open the ResultSet?
DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
Connection con = DriverManager.getConnection("jdbc:oracle:oci8:@mydb",
"scott", "tiger");
try
{
Statement statement = con.createStatement(ResultSet.TYPE_FORWARD_ONLY,
ResultSet.CONCUR_UPDATABLE);
String query; // query string built elsewhere
ResultSet rs = statement.executeQuery(query);
while (rs.next()) // breaks to exception handler if rs is empty
{ ... }
}
catch (SQLException e)
{ System.out.println(e.getMessage()); }
- Next message: Igor N. Kolomiyets: "Re: [Oracle] How to check for empty ResultSet?"
- Previous message: Silvio Bierman: "Re: Regarding retrievel of data"
- In reply to: Igor N. Kolomiyets: "Re: [Oracle] How to check for empty ResultSet?"
- Next in thread: Igor N. Kolomiyets: "Re: [Oracle] How to check for empty ResultSet?"
- Reply: Igor N. Kolomiyets: "Re: [Oracle] How to check for empty ResultSet?"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Relevant Pages
|
