java - Get current sequence Id to store in other tables -

we have multiple tables , related first table's primary key (example: id). id configured sequence , while inserting data first table using sequence.nextval in insert query. while inserting data other tables, how current sequence value or current id.

we have tried below options:

1. sequence.currval, directly in insert statement 2.select sequence.currval dual

above 2 options throwing error while using getjdbctemplate().update().

could please suggest how current sequence value pass other tables after inserting data first table??

if want insert same id (which comes sequence) different tables, simple form first insert , use in other inserts.

prepearedstatement stmt1 = conn.preparestatement("insert table1 (id) values(yoursequence.nextval)", statemet.return_generated_keys); stmt1.executeupdate(); resultset rs = stmt1.getgeneratedkeys(); rs.next(); long id = rs.getlong(1); prepearedstatement stmt2 = conn.preparestatement("insert table2 (id) values(?)"); stmt2.setlong(1,id); stmt2.executeupdate();