DB2 Identity column discovery

Thread view:

Wayne Collins - 24 Jan 2005 01:05 GMT

I have a problem with JDBC and DB2 and am wondering if any one can help
with it. The problem is the following - after connecting to a DB2
database we use the getMetaData() method to retrieve a lot of data about
a table, but we have not discovered a way to determine if a particular
column of the data has an attribute like "GENERATED ALWAYS AS IDENTITY".

Anyone have a solution?

Reply to this Message

Lee Fesperman - 24 Jan 2005 08:06 GMT

> I have a problem with JDBC and DB2 and am wondering if any one can help
> with it. The problem is the following - after connecting to a DB2
[quoted text clipped - 3 lines]
>
> Anyone have a solution?

You didn't say, but I assume you're talking about the DatabaseMetaData object. It
doesn't provide that information. ResultSetMetaData, OTOH, does. Look at
isAutoIncrement() in java.sql.ResultSetMetaData.

Signature

Lee Fesperman, FFE Software, Inc. (http://www.firstsql.com)
==============================================================
* The Ultimate DBMS is here!
* FirstSQL/J Object/Relational DBMS (http://www.firstsql.com)

Reply to this Message

Wayne Collins - 26 Jan 2005 02:25 GMT

>>I have a problem with JDBC and DB2 and am wondering if any one can help
>>with it. The problem is the following - after connecting to a DB2
[quoted text clipped - 7 lines]
> doesn't provide that information. ResultSetMetaData, OTOH, does. Look at
> isAutoIncrement() in java.sql.ResultSetMetaData.

Actually I was aware of isAutoIncrement from the ResultSetMetaData
object. But it always returns 'false' even on a column I know to be
GENERATED AS IDENTITY. Don't know what's wrong ... I'll keep tweaking it
to see if I can get it to work....

Reply to this Message

Lee Fesperman - 26 Jan 2005 08:05 GMT

> >>I have a problem with JDBC and DB2 and am wondering if any one can help
> >>with it. The problem is the following - after connecting to a DB2
[quoted text clipped - 12 lines]
> GENERATED AS IDENTITY. Don't know what's wrong ... I'll keep tweaking it
> to see if I can get it to work....

Too bad. java.sql.ResultSetMetaData is an interface, and correct implementation is
entirely up to the JDBC driver.

Signature

Reply to this Message

Bob Kranson - 24 Jan 2005 20:07 GMT

What platform of DB2 and version? I recall some strange works in AS400
using the ALIAS property for table names....

>I have a problem with JDBC and DB2 and am wondering if any one can help
>with it. The problem is the following - after connecting to a DB2 database
[quoted text clipped - 3 lines]
>
> Anyone have a solution?

Reply to this Message

DB2 Identity column discovery

Free Magazines