Friday, 15 January 2010

java - Is there something like preparedStatement.setDefault()? -



java - Is there something like preparedStatement.setDefault()? -

if have statement like:

insert foo (id, name, description, etc_a, etc_b) values (?, ?, ?, ?, ?);

it's passed preparedstatement. want specify id, , want utilize database's default id, next unused id value.

is there way can tell preparedstatement (ps) utilize default 1 of values without having sec ps default in place of first ??

i'm using postgresql.

unfortunately pgjdbc doesn't want. have utilize literal default keyword. there's no way parameter.

the team work for developing enhancement prepare that'll create pgjdbc release soon. you'll able utilize setobject(...) special placeholder instance indicate want default.

java sql postgresql jdbc

No comments:

Post a Comment