Message:
A new issue has been created in JIRA.
---------------------------------------------------------------------
View the issue:
http://objectstyle.org/jira/secure/ViewIssue.jspa?key=CAY-243
Here is an overview of the issue:
---------------------------------------------------------------------
Key: CAY-243
Summary: Allow Cayenne PK generator to work over SQLServer identity columns
Type: Improvement
Status: Assigned
Priority: Major
Project: Cayenne
Components:
Cayenne Core Library
Fix Fors:
1.2 [DEV]
Versions:
1.2 [DEV]
Assignee: Andrus Adamchik
Reporter: Andrus Adamchik
Created: Sun, 21 Nov 2004 3:33 PM
Updated: Sun, 21 Nov 2004 3:33 PM
Environment: SQLServer DB
Description:
Background:
Currently Cayenne can't insert records to SQLServer tables with PK columns defined as identity, as SQLServer throws an exception on insert. We will support direct work with identity columns soon, however it should be nice to allow current Cayenne PK generator to be used too...
SQLServer actually allows inserts to identity columns, to the workaround is to run this SQL before any insert queries - "SET IDENTITY_INSERT table_name ON". SQLServerAdapter must support this option.
---------------------------------------------------------------------
JIRA INFORMATION:
This message is automatically generated by JIRA.
If you think it was sent incorrectly contact one of the administrators:
http://objectstyle.org/jira/secure/Administrators.jspa
If you want more information on JIRA, or have a bug to report see:
http://www.atlassian.com/software/jira
This archive was generated by hypermail 2.0.0 : Sun Nov 21 2004 - 15:34:48 EST