Sql Result set processing

[Steve Sutton]

I am using an SQL call to db2 to get the count(*) value from a query. I was going to use the getInt method to get the value of the count. I cannot use that method. I get the following error: The method getInt(int) from the type resultset is not static. What method should I use to get the value of the result? Since I am not returning a column value, I am unsure of what to use.

[Bear Bibeault]

We'll need to see your code, particularly in the area around the getInt() call (please be sure to use the UBB code tags).
It looks like you are using getInt() in a static context, and it most certainly is not a static method.
hth,
bear

[Wayne L Johnson]

Make sure you are doing:

   ResultSet rs = stmt.executeQuery("Select count(*) From MyTable");
   if (rs.next()) {
      int count = rs.getInt(1);
   }

and not something like:

   ResultSet rs = stmt.executeQuery("Select count(*) From MyTable");
   if (rs.next()) {
      int count = ResultSet.getInt(1);
   }

[Dirk Schreckmann]

Moving this to the JDBC forum...

[Steve Sutton]

Wayne, Thank you for helping out. I was doing it the way you said not to do it. Changed the code, works great! Thanks again.