How to get Max id from table of database in java code

Question

I want to write code which give max id from the table but it is throwing error.

code:

Class.forName("oracle.jdbc.driver.OracleDriver");
Connection con = DriverManager.getConnection("XXXXX", "XXXX", "XXX");
Statement st2 = con.createStatement();
ResultSet idMax = st2.executeQuery("select nvl(max(work_id),0) from workdetails");
int id2 = idMax.getInt(0);  // throw error: Invalid column index

System.out.println(id2);

// ****************************
int id2 = idMax.getInt("work_id");
System.out.println(id2);   // throw error: ResultSet.next was not called

giorashc · Accepted Answer · 2012-06-07 10:24:19Z

8

A result set starts at a dummy record and should be advanced to the real first record by calling the next method :

ResultSet idMax = st2.executeQuery("select nvl(max(work_id),0) max_id from workdetails");
int id2 = -1;
if (idMax.next()) {
   id2 = idMax.getInt("max_id");  
}

answered Jun 7, 2012 at 10:24

giorashc

13.7k3 gold badges38 silver badges76 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Rakesh Juyal · Accepted Answer · 2012-06-07 10:30:43Z

2

You missed

idMax.next();

This will set the pointer to the first row. Then only you have to use

idMax.get ( 1 );

So, your code goes like this:

ResultSet idMax = st2.executeQuery("select nvl(max(work_id),0) from workdetails");
int id2 = 0; 
if ( idMax.next() ){
   id2 = idMax.getInt(1);  
}
System.out.println(id2);

answered Jun 7, 2012 at 10:30

Rakesh Juyal

37k74 gold badges179 silver badges218 bronze badges

Collectives™ on Stack Overflow

How to get Max id from table of database in java code

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related