I created a sequence for id and I need max id from the table. So, I am using autoGeneratedKeys() but its not working

Asked Jun 27 '18 at 11:32

Active Jun 27 '18 at 16:07

Viewed 43 times

I created a sequence for id and I need max id from the table. So, I am using autoGeneratedKeys(), but it's not working.

public int createDataDAOImplentation(UserData c){
    int i=0; String sql="";
    try
    {
        ds.setPs("insert into contact(id,firstName,lastName,email,dob,gender)values(contact_seq.nextval,?,?,?,?,?)");
        ds.getPs().setString(1, c.getFirstname());
        ds.getPs().setString(2, c.getLastName());
        ds.getPs().setString(3, c.getEmail());
        ds.getPs().setint(4, c.getDob());
        ds.getPs().setLong(5, c.getGender());
        ds.getPs().executeQuery();
        ResultSet rs = ds.getPs().getGeneratedKeys();
        System.out.println("iam");
        if(rs.next()){
            i = rs.getInt(1);
            System.out.println("in"0);
        }
        ds.getCon().commit();
        ds.getCon().close();
    }
    catch(SQLException ex)
}

edited Jun 27 '18 at 16:07

koPytok

3,453
1
14
29

asked Jun 27 '18 at 11:32

shark

1

You should show your code. – Jure Jun 27 '18 at 11:35
1

please share your code – gaurav singh Jun 27 '18 at 11:35
@Jure -yes I have shared – shark Jun 27 '18 at 11:44
@gaurav singh yes i did – shark Jun 27 '18 at 11:46
1

Code should be inside the question as "Code Sample". – Jure Jun 27 '18 at 11:52
https://stackoverflow.com/questions/4496336/nextval-jdbc-insert-problem – gaurav singh Jun 27 '18 at 12:00
@gaurav singh yes I am inserting correctly but I need the id which we inserted – shark Jun 27 '18 at 12:22
The insertion doesn't generate an ID. What generates an ID is the query to the sequence. So, execute the query to get the next sequence number first. Then pass the value you get as aparameter to a second query, inserting the data. – JB Nizet Jun 27 '18 at 16:16

I created a sequence for id and I need max id from the table. So, I am using autoGeneratedKeys() but its not working

0 Answers0