Obtaining auto created id upon finishing insert

[D Rog]

I'm working on a customer service system which return a customer a ticket number after placing a request. A ticket number is an id in request table, like:

table request
id number
request string
subject string
customer_id number

I use insert like:

insert into request (id, request, subject, customer_id) select nextval('ticket_seq'), ?,?,?

I'd like to know ticket id after insertion. Will it be reliable in multi requests environment if I use for getting id under the same transaction the following query:

select max(id) from request

Is there any more elegant way to do that?

[Jeanne Boyarsky]

In JDBC 3, you can use Statement.RETURN_GENERATED_KEYS to have the database return the values. For older versions of JDBC, your solution is best.

[D Rog]

Cool, thanks.