If your process is the only one inserting records, another approach would be to find the previous maximum for the session (SELECT max(id)...), and within your process increment it and include it in the insert statement instead of having the db autoassign.