8:34 a.m.
Session.replicate failure with identity column
----------------------------------------------
Key: HHH-2716
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2716
Project: Hibernate3
Issue Type: Bug
Components: core
Affects Versions: 3.2.2
Environment: Java 1.5, MySQL 5.0.27 and Hibernate Annotations 3.2.1.GA
Reporter: Yves Martin
I'm trying to use replicate:
http://www.hibernate.org/hib_docs/reference/en/html/objectstate.html#obje...
The column "@version" is replicated properly (same value in second db) but the
column "@Id @GeneratedValue" contains a new value from the db2 sequence.
In fact the insert statement generated by the replicate method does not include the
"id" column.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://opensource.atlassian.com/projects/hibernate/secure/Administrators....
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
8:42 a.m.
New subject: [Hibernate-JIRA] Commented: (HHH-2716) Session.replicate failure with identity column
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-2716?page=c...
]
Yves Martin commented on HHH-2716:
----------------------------------
Sorry. "from the db2 sequence" => "from the sequence from the second
database"
Session.replicate failure with identity column
----------------------------------------------
Key: HHH-2716
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2716
Project: Hibernate3
Issue Type: Bug
Components: core
Affects Versions: 3.2.2
Environment: Java 1.5, MySQL 5.0.27 and Hibernate Annotations 3.2.1.GA
Reporter: Yves Martin
I'm trying to use replicate:
http://www.hibernate.org/hib_docs/reference/en/html/objectstate.html#obje...
The column "@version" is replicated properly (same value in second db) but the
column "@Id @GeneratedValue" contains a new value from the db2 sequence.
In fact the insert statement generated by the replicate method does not include the
"id" column.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://opensource.atlassian.com/projects/hibernate/secure/Administrators....
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
9:38 a.m.
New subject: [Hibernate-JIRA] Commented: (HHH-2716) Session.replicate failure with identity column
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-2716?page=c...
]
Yves Martin commented on HHH-2716:
----------------------------------
I have located where this issue may be fixed
org/hibernate/event/def/DefaultReplicateEventListener.java
final boolean regenerate = persister.isIdentifierAssignedByInsert(); // prefer
re-generation of identity!
final EntityKey key = regenerate ? null : new EntityKey( id, persister,
source.getEntityMode() );
According to discussions in http://forum.hibernate.org/viewtopic.php?p=2358517#2358517 and
in devel mailing list
http://www.mail-archive.com/hibernate-devel@lists.sourceforge.net/msg0523...
I understand why regeneration is forced in case of Hibernate is not responsible for the
identifier generation.
My proposal is "simple": add a "Dialect.supportsInsertIdentityValue"
boolean
and decide to "regenerate" or not according to this flag and
persister.isIdentifierAssignedByInsert() value.
Session.replicate failure with identity column
----------------------------------------------
Key: HHH-2716
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2716
Project: Hibernate3
Issue Type: Bug
Components: core
Affects Versions: 3.2.2
Environment: Java 1.5, MySQL 5.0.27 and Hibernate Annotations 3.2.1.GA
Reporter: Yves Martin
I'm trying to use replicate:
http://www.hibernate.org/hib_docs/reference/en/html/objectstate.html#obje...
The column "@version" is replicated properly (same value in second db) but the
column "@Id @GeneratedValue" contains a new value from the db2 sequence.
In fact the insert statement generated by the replicate method does not include the
"id" column.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://opensource.atlassian.com/projects/hibernate/secure/Administrators....
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
7:43 a.m.
New subject: [Hibernate-JIRA] Commented: (HHH-2716) Session.replicate failure with identity column
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-2716?page=c...
]
Max Bowsher commented on HHH-2716:
----------------------------------
The javadoc for replicate says "Persist the state of the given detached instance,
reusing the current identifier value.". IIUC, the specification of the identifier
value is the only reason for using replicate rather than persist or save.
The current behaviour violates the documented API. It could lead to an application working
entirely correctly with a pre-insert native id generator, and then developing a bug when
switched to a dialect using a post-insert native id generator.
I suggest that the correct behaviour for replicate is to always try to insert the given
identifier, and if the database is unable to do that, throw an exception.
Session.replicate failure with identity column
----------------------------------------------
Key: HHH-2716
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2716
Project: Hibernate3
Issue Type: Bug
Components: core
Affects Versions: 3.2.2
Environment: Java 1.5, MySQL 5.0.27 and Hibernate Annotations 3.2.1.GA
Reporter: Yves Martin
I'm trying to use replicate:
http://www.hibernate.org/hib_docs/reference/en/html/objectstate.html#obje...
The column "@version" is replicated properly (same value in second db) but the
column "@Id @GeneratedValue" contains a new value from the db2 sequence.
In fact the insert statement generated by the replicate method does not include the
"id" column.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://opensource.atlassian.com/projects/hibernate/secure/Administrators....
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
10:52 a.m.
New subject: [Hibernate-JIRA] Commented: (HHH-2716) Session.replicate failure with identity column
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-2716?page=c...
]
Yves Martin commented on HHH-2716:
----------------------------------
I agree with you.
Session.replicate failure with identity column
----------------------------------------------
Key: HHH-2716
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2716
Project: Hibernate3
Issue Type: Bug
Components: core
Affects Versions: 3.2.2
Environment: Java 1.5, MySQL 5.0.27 and Hibernate Annotations 3.2.1.GA
Reporter: Yves Martin
I'm trying to use replicate:
http://www.hibernate.org/hib_docs/reference/en/html/objectstate.html#obje...
The column "@version" is replicated properly (same value in second db) but the
column "@Id @GeneratedValue" contains a new value from the db2 sequence.
In fact the insert statement generated by the replicate method does not include the
"id" column.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://opensource.atlassian.com/projects/hibernate/secure/Administrators....
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
9:11 a.m.
New subject: [Hibernate-JIRA] Commented: (HHH-2716) Session.replicate failure with identity column
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-2716?page=c...
]
Nektarios Ioannides commented on HHH-2716:
------------------------------------------
Just letting the world know, I am faced with the same problem. replicate() has no apparent
difference from save() at the moment.
Session.replicate failure with identity column
----------------------------------------------
Key: HHH-2716
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2716
Project: Hibernate3
Issue Type: Bug
Components: core
Affects Versions: 3.2.2
Environment: Java 1.5, MySQL 5.0.27 and Hibernate Annotations 3.2.1.GA
Reporter: Yves Martin
I'm trying to use replicate:
http://www.hibernate.org/hib_docs/reference/en/html/objectstate.html#obje...
The column "@version" is replicated properly (same value in second db) but the
column "@Id @GeneratedValue" contains a new value from the db2 sequence.
In fact the insert statement generated by the replicate method does not include the
"id" column.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://opensource.atlassian.com/projects/hibernate/secure/Administrators....
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
6:47 a.m.
New subject: [Hibernate-JIRA] Commented: (HHH-2716) Session.replicate failure with identity column
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-2716?page=c...
]
Josef Andersson commented on HHH-2716:
--------------------------------------
Agree, this should be fixed. For example, it should be possible to do copy of generated
ids to. MS SQL server has IDENTITY INSERT OFF and so on , which could be used. This could
be a great feature.
Session.replicate failure with identity column
----------------------------------------------
Key: HHH-2716
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2716
Project: Hibernate Core
Issue Type: Bug
Components: core
Affects Versions: 3.2.2
Environment: Java 1.5, MySQL 5.0.27 and Hibernate Annotations 3.2.1.GA
Reporter: Yves Martin
I'm trying to use replicate:
http://www.hibernate.org/hib_docs/reference/en/html/objectstate.html#obje...
The column "@version" is replicated properly (same value in second db) but the
column "@Id @GeneratedValue" contains a new value from the db2 sequence.
In fact the insert statement generated by the replicate method does not include the
"id" column.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://opensource.atlassian.com/projects/hibernate/secure/Administrators....
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
12:30 p.m.
New subject: [Hibernate-JIRA] Commented: (HHH-2716) Session.replicate failure with identity column
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-2716?page=c...
]
sp commented on HHH-2716:
-------------------------
I have the same issue. I have entities using auto generated ids and I need to replicate
them to multiple database without altering the already generated ids. MySQL support
inserting values with defined id for auto increment columns so it would make sense to at
least have the option in the hibernate dilect. Can we have some feedback for this issue,
it have been opened a while ago and I would like to know if there have any plan to fix it
or if I have to find another solution.
Session.replicate failure with identity column
----------------------------------------------
Key: HHH-2716
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2716
Project: Hibernate Core
Issue Type: Bug
Components: core
Affects Versions: 3.2.2
Environment: Java 1.5, MySQL 5.0.27 and Hibernate Annotations 3.2.1.GA
Reporter: Yves Martin
I'm trying to use replicate:
http://www.hibernate.org/hib_docs/reference/en/html/objectstate.html#obje...
The column "@version" is replicated properly (same value in second db) but the
column "@Id @GeneratedValue" contains a new value from the db2 sequence.
In fact the insert statement generated by the replicate method does not include the
"id" column.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://opensource.atlassian.com/projects/hibernate/secure/Administrators....
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
5:16 p.m.
New subject: [Hibernate-JIRA] Commented: (HHH-2716) Session.replicate failure with identity column
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-2716?page=c...
]
Hans Loeblich commented on HHH-2716:
------------------------------------
I too was bitten by this bug. I ended up having to implement my own id generator class,
basically a hybrid of org.hibernate.id.enhanced.SequenceStyleGenerator and
org.hibernate.id.Assigned. If an id is not assigned, then it generates one. This was
really suboptimal since I now have to create sequence tables for every table that I need
to replicate across databases. Replicate does not work as advertised, and it really cost
me a lot of time figuring out a workaround.
Session.replicate failure with identity column
----------------------------------------------
Key: HHH-2716
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2716
Project: Hibernate Core
Issue Type: Bug
Components: core
Affects Versions: 3.2.2
Environment: Java 1.5, MySQL 5.0.27 and Hibernate Annotations 3.2.1.GA
Reporter: Yves Martin
I'm trying to use replicate:
http://www.hibernate.org/hib_docs/reference/en/html/objectstate.html#obje...
The column "@version" is replicated properly (same value in second db) but the
column "@Id @GeneratedValue" contains a new value from the db2 sequence.
In fact the insert statement generated by the replicate method does not include the
"id" column.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://opensource.atlassian.com/projects/hibernate/secure/Administrators....
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
5059
days inactive
6291
days old
hibernate-issues@lists.jboss.org
8 comments
6 participants
participants (6)
-
Hans Loeblich (JIRA) -
Josef Andersson (JIRA)
-
Max Bowsher (JIRA)
-
Nektarios Ioannides (JIRA)
-
sp (JIRA)
-
Yves Martin (JIRA)