Postgres has a mapping through the SERIAL datatype. However, I've found its
use to be convoluting during prototyping, etc (it automatically creates a
named sequence that isn't automatically dropped when the table is dropped)
However, it truly is automatic...
Cris
>
> IMO auto-increment (aka generated keys) addition to JDBC
> standard is there to cause confusion :-) ... Driver support
> for it ranges from poor to non-existent. So on the database
> end you can have a number of mechanisms to get a PK generated
> on row insert (triggers being one of them), but propagating
> it to Java layer is another story... AFAIK only SQLServer and
> MySQL proprietary mechanisms have JDBC mapping (if you know
> of others, please post it here) ...
>
This archive was generated by hypermail 2.0.0 : Thu Mar 31 2005 - 21:50:33 EST