Bug 209104 - [patch] Support sensing IDENTITY columns for SQL Server
Summary: [patch] Support sensing IDENTITY columns for SQL Server
Status: CLOSED FIXED
Alias: None
Product: Data Tools
Classification: Tools
Component: Enablement (show other bugs)
Version: unspecified   Edit
Hardware: All All
: P3 enhancement (vote)
Target Milestone: 1.6M5   Edit
Assignee: Brian Fitzpatrick CLA
QA Contact:
URL:
Whiteboard:
Keywords: contributed
Depends on:
Blocks:
 
Reported: 2007-11-07 17:17 EST by Jesper Moller CLA
Modified: 2008-07-01 17:41 EDT (History)
1 user (show)

See Also:


Attachments
Patch for org.eclipse.datatools.enablement.msft.sqlserver (for HEAD) (4.28 KB, patch)
2007-11-07 17:22 EST, Jesper Moller CLA
no flags Details | Diff
Patch for org.eclipse.datatools.enablement.msft.sqlserver.profile (against 1.5.1) (3.97 KB, patch)
2007-11-07 17:46 EST, Jesper Moller CLA
no flags Details | Diff
Binary patched bundle for instant testing (13.26 KB, application/octet-stream)
2007-11-07 17:52 EST, Jesper Moller CLA
no flags Details

Note You need to log in before you can comment on or make changes to this bug.
Description Jesper Moller CLA 2007-11-07 17:17:54 EST
I've created a specialized column loader for SQL Server which will set a IdentitySpecifier on a column which has IDENTITY flavor.
Comment 1 Jesper Moller CLA 2007-11-07 17:22:33 EST
Created attachment 82383 [details]
Patch for org.eclipse.datatools.enablement.msft.sqlserver (for HEAD)

Introduces an extension for creating the specialised ColumnLoader for SQL Server.

I understand this (declarative) way to be the new/preferred way of specialising the schema, as opposed to specializing the domain objects themselves. If I'm mistaken, I'll gladly do it the other way around.

This patch also adds jTDS compatibility for SQL Server 2000, see the second patch in bug 208776.
Comment 2 Jesper Moller CLA 2007-11-07 17:46:57 EST
Created attachment 82386 [details]
Patch for org.eclipse.datatools.enablement.msft.sqlserver.profile (against 1.5.1) 

For those who want to test this against the released version, this is for you.
Comment 3 Jesper Moller CLA 2007-11-07 17:52:45 EST
Created attachment 82387 [details]
Binary patched bundle for instant testing

This bundle for 1.5.1 is patched, with a bumped version qualifier number. Drop it into eclipse/plugins and restart Eclipse.

To test it, create a table with an IDENTITY column (in SQL Server!) and then try to insert a row in the data table editor. This will fail before this patch, but succeed with it.
Comment 4 Jesper Moller CLA 2007-11-08 08:28:08 EST
(In reply to comment #3)

> To test it, create a table with an IDENTITY column (in SQL Server!) and then
> try to insert a row in the data table editor. This will fail before this patch,
> but succeed with it.

By the way, to test this, you will likely run into bug 207331, so apply the patch for that one before you try this one.

I realize that the current patch doesn't capture all information which may be stored in the IdentitySpecifier object, and the information at present can't be regenerated into DDL, but it makes the data table editor a lot more useful. Any comments or review of the patch would be appreciated.
Comment 5 Brian Fitzpatrick CLA 2008-01-21 15:41:02 EST
Delivered to 1.6 head stream for SQL Server profile
Comment 6 Brian Fitzpatrick CLA 2008-07-01 17:41:32 EDT
Closing bugs