Issue Details (XML | Word | Printable)

Key: JDBC-322
Type: Improvement Improvement
Status: Closed Closed
Resolution: Fixed
Priority: Major Major
Assignee: Mark Rotteveel
Reporter: Mark Rotteveel
Votes: 0
Watchers: 0

If you were logged in you would be able to see more operations.
Jaybird JDBC Driver

Add metadata information for FB 3 IDENTITY columns

Created: 05/Aug/13 02:07 PM   Updated: 07/May/17 12:32 PM
Component/s: JDBC driver
Affects Version/s: None
Fix Version/s: Jaybird 3.0.0

 Description  « Hide
Add metadata information for FB 3 IDENTITY columns

 All   Comments   Change History   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
Mark Rotteveel added a comment - 15/Jul/16 02:31 PM - edited
For identity columns, getColumns "IS_AUTOINCREMENT" and "IS_GENERATEDCOLUMN" will now report YES if the column is an identity column.

Also added Jaybird-specific columns:

JB_IS_IDENTITY with possible values YES and NO
JB_IDENTITY_TYPE with possible values ALWAYS (although not yet supported by Firebird), BY DEFAULT and null (which either means 'not an identity column, or identity type is unknown).