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
> ********************************