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("insert into 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(at)phoenixcolor(dot)com
> ********************************