0001702: @GeneratedValue with MS SQLServer is not working

Viewing Issue Simple Details [ Jump to Notes ]

[ View Advanced ] [ Issue History ] [ Print ]

Category

Severity

Reproducibility

Date Submitted

Last Update

0001702

[Resin]

major

always

04-23-07 19:12

05-01-07 09:08

Reporter

westrupp

View Status

public

Assigned To

westrupp

Priority

high

Resolution

fixed

Status

closed

Product Version

3.1.0

Summary

0001702: @GeneratedValue with MS SQLServer is not working

Description

Even setting the IDENTITY_INSERT to ON:

SET IDENTITY_INSERT ON;

the following exception is thrown:

javax.persistence.EntityExistsException: Trying to persist an entity of
class 'test.TestBean' with PK
'0' that already exists. Entity state 'TRANSIENT'

A possible workaround would be to use a trigger to set the new id value.

Additional Information

Attached Files

Relationships

Notes
(0001881) westrupp 04-30-07 12:06	jpa/0g80 (resin db equivalent) jpa/0g81 (mysql equivalent)

Issue History
Date Modified	Username	Field	Change
04-23-07 19:12	westrupp	New Issue
04-30-07 12:03	westrupp	Status	new => assigned
04-30-07 12:03	westrupp	Assigned To	=> westrupp
04-30-07 12:06	westrupp	Status	assigned => resolved
04-30-07 12:06	westrupp	Fixed in Version	=> 3.1.1
04-30-07 12:06	westrupp	Resolution	open => fixed
04-30-07 12:06	westrupp	Note Added: 0001881
05-01-07 09:08	ferg	Status	resolved => closed

Mantis 1.0.0rc3[^]

29 total queries executed.
26 unique queries executed.