Hi

I note that a call to

Statement.executeUpdate(sql, Statement.RETURN_GENERATED_KEYS)

currently raises an exception with a 'not yet implemented' message. I
imagine this has a lot to do with there being no 'autoinc' type in
firebird? (yes I'm using a trigger and a generator).

Does anyone have a clever and (most importaintly) portable way of
doing the same thing? Although we are currently using Firebird for
development, ultimatly our clients will be making the call as to which
database the app will run on so we need to keep it all as generic as
possible.

Thanks
BP