I have an existing table that I need to get the last record number and increment it. I've read that I need to create a sequence first, but I'm not sure how to go about doing that with an existing table. Here is the code I have so far:
try {
s = conn.createStatement();
log.info("Got Connection");
empID = s.executeQuery("SELECT nextval(emp_uid) FROM employee"); <--- this is not working
log.info("Got Employee ID ");
empID.next();
int newID = empID.getInt(1);
log.info("New ID = " + newID);
rows = s.executeUpdate("INSERT INTO employee(emp_uid,first_name, last_name, emp_nbr, emp_type_code, emp_status_code, emp_work_center) " +
"VALUES ('"+newID+"','"+firstName+"','"+lastName+"','"+empNumber+"','"+empType+"','"+empStatus+"','"+workStation+ "')");
} catch (SQLException se) {
log.info("We got an exception while executing our query:" +
"that probably means our SQL is invalid. " +
se);
System.exit(1);
}
Here's the log:
INFO: We got an exception while executing our query:that probably means our SQL is invalidorg.postgresql.util.PSQLException: ERROR: could not open relation with OID 5
What am I missing?
Thank You
Chris