Sequences & generators

Thread view:

Andre Rothe - 27 Jun 2009 10:59 GMT

Hi,

Is there a way to get information about sequences/generators from the
java.sql.DatabaseMetaData? Some RDBMS use auto-increment columns, which
I can see in getColumns(), but if I use sequences, I have to use
RDBMS-specific code to get information about?

Thanks for all ideas
Andre

Reply to this Message

Thomas Kellerer - 27 Jun 2009 11:13 GMT

Andre Rothe wrote on 27.06.2009 11:59:

> but if I use sequences, I have to use
> RDBMS-specific code to get information about?

Yes, with the exception of Postgres which returns sequences in getTables() as well.

Thomas

Reply to this Message

Free Magazines

Get these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...