how to invoke Result Set method in java?

Question

ResultSet data_result = dao.getDetails();

Method resultset_method;

resultset_method = data_result.getClass().getMethod("getInt", Integer.class);

it is giving error:

java.lang.NoSuchMethodException: org.apache.commons.dbcp.DelegatingResultSet.getInt(java.lang.Integer)

Why not calling the `getInt` method directly on the `ResultSet` object? — Dimitri, Sep 08 '17 at 15:12

score 0 · Accepted Answer · answered Sep 08 '17 at 14:59

0

The ResultSet's getInt method has two overloads, one that takes an int for the index and one that takes a String for a column name. You're attempting to retrieve a getInt() method, which indeed does not exist.

You need to supply the types that the method takes - eg, if you were going by name,

resultset_method = data_result.getClass().getMethod("getInt", String.class);

answered Sep 08 '17 at 14:59

Evan Knowles

7,426
2
37
71

still it is not working:: java.lang.NoSuchMethodException:org.apache.commons.dbcp.DelegatingResultSet.getInt() – MaheshPVM Sep 08 '17 at 15:03
1

Same error? Can you update your answer including your new code? – Evan Knowles Sep 08 '17 at 15:04
resultset_method = data_result.getClass().getMethod("getInt", Integer.class); and the error is java.lang.NoSuchMethodException: org.apache.commons.dbcp.DelegatingResultSet.getInt(java.lang.Integer) – MaheshPVM Sep 08 '17 at 15:09
@MaheshPVM No, edit the question. – Dave Newton Sep 08 '17 at 15:11
Guess you have to use `Integer.TYPE` , not `Integer.class`. – Gyro Gearless Sep 08 '17 at 15:20
Yes !! it is working Thanks to Evan Knowles and Gyro Gearless – MaheshPVM Sep 08 '17 at 15:28

how to invoke Result Set method in java?

1 Answers1