Re: jdbc how to get SERIAL

Explictly get the value.

For example:
ResultSet rs = st.executeQuery("select nextval('my_col_name_seq'));st.next(); int id =
st.getInt(1);st.executeUpdate("insertinto mytable values(id = "+id+" , myvalu =
 
'blah');");

John Thorhauer wrote:
> 
> How do I get the id column of a row via jdbc if the column is a SERIAL
> column.  I want to get the id of the row after I insert new data via
> jdbc execute command.
> 
> Thanks,
> John Thorhauer
> 
> --
> ********************************
> ** John Thorhauer
> ** jthorhauer@phoenixcolor.com
> ********************************