[Hibernate-JIRA] Created: (HHH-3317) Entities saved within onPreUpdate() never inserted into db when id generator is sequenze (f.e. oracle)
1:55 p.m.
Entities saved within onPreUpdate() never inserted into db when id generator is sequenze
(f.e. oracle)
------------------------------------------------------------------------------------------------------
Key: HHH-3317
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-3317
Project: Hibernate3
Issue Type: Bug
Components: core
Affects Versions: 3.2.6
Environment: hibernate3.2.6.ga.jar, Oracle 10
Reporter: Martin Backhaus
Priority: Minor
If you save (insert) a entity within the event preUpdate and the id is a oracle-sequenze,
hibernate put the entity to insert in the session-ActionQueue, BUT NEVER INSERTS it. If
you use mysql/hsql... where the id is differently generated, the insert happens
immediately and no put to the ActionQueue occures.
As workaround you can queue the object (to insert) yourself and call save() within the
postUpdate-Event.
I use this events for historizing some stuff.
Inserts within onDelete() works fine.
the ids are annotated as shown here:
@Id
@GeneratedValue(strategy = GenerationType.AUTO)
protected Long id = null;
--
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
4:37 p.m.
New subject: [Hibernate-JIRA] Commented: (HHH-3317) Entities saved within onPreUpdate() never inserted into db when id generator is sequenze (f.e. oracle)
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-3317?page=c...
]
Martin Backhaus commented on HHH-3317:
--------------------------------------
Sorry, i was wrong. Saving within postUpdate() works even not.
Entities saved within onPreUpdate() never inserted into db when id
generator is sequenze (f.e. oracle)
------------------------------------------------------------------------------------------------------
Key: HHH-3317
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-3317
Project: Hibernate3
Issue Type: Bug
Components: core
Affects Versions: 3.2.6
Environment: hibernate3.2.6.ga.jar, Oracle 10
Reporter: Martin Backhaus
Priority: Minor
If you save (insert) a entity within the event preUpdate and the id is a oracle-sequenze,
hibernate put the entity to insert in the session-ActionQueue, BUT NEVER INSERTS it. If
you use mysql/hsql... where the id is differently generated, the insert happens
immediately and no put to the ActionQueue occures.
As workaround you can queue the object (to insert) yourself and call save() within the
postUpdate-Event.
I use this events for historizing some stuff.
Inserts within onDelete() works fine.
the ids are annotated as shown here:
@Id
@GeneratedValue(strategy = GenerationType.AUTO)
protected Long id = null;
--
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:51 p.m.
New subject: [Hibernate-JIRA] Commented: (HHH-3317) Entities saved within onPreUpdate() never inserted into db when id generator is sequenze (f.e. oracle)
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-3317?page=c...
]
Gail Badner commented on HHH-3317:
----------------------------------
When a sequence is used to generate IDs, the entity is not inserted until the session is
flushed.
Have you tried flushing the session using Session.flush()? Also, unless you are using
FlushMode.MANUAL (or the deprecated FlushMode.NEVER), the session will automatically be
flushed when the transaction is committed.
Please close this issue if you find that flushing the session inserts the entity;
otherwise, please attach a test case that reproduces this issue.
Entities saved within onPreUpdate() never inserted into db when id
generator is sequenze (f.e. oracle)
------------------------------------------------------------------------------------------------------
Key: HHH-3317
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-3317
Project: Hibernate3
Issue Type: Bug
Components: core
Affects Versions: 3.2.6
Environment: hibernate3.2.6.ga.jar, Oracle 10
Reporter: Martin Backhaus
Priority: Minor
If you save (insert) a entity within the event preUpdate and the id is a oracle-sequenze,
hibernate put the entity to insert in the session-ActionQueue, BUT NEVER INSERTS it. If
you use mysql/hsql... where the id is differently generated, the insert happens
immediately and no put to the ActionQueue occures.
As workaround you can queue the object (to insert) yourself and call save() within the
postUpdate-Event.
I use this events for historizing some stuff.
Inserts within onDelete() works fine.
the ids are annotated as shown here:
@Id
@GeneratedValue(strategy = GenerationType.AUTO)
protected Long id = null;
--
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:14 a.m.
New subject: [Hibernate-JIRA] Commented: (HHH-3317) Entities saved within onPreUpdate() never inserted into db when id generator is sequenze (f.e. oracle)
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-3317?page=c...
]
Martin Backhaus commented on HHH-3317:
--------------------------------------
The hint - flush() - was good.
Now i've got the right problem. Take a look at the stacktrace:
HibernateListener.onPreUpdate(PreUpdateEvent) line: 119
EntityUpdateAction.preUpdate() line: 221
EntityUpdateAction.execute() line: 65
ActionQueue.execute(Executable) line: 279
ActionQueue.executeActions(List) line: 263
ActionQueue.executeActions() line: 168
DefaultFlushEventListener(AbstractFlushingEventListener).performExecutions(EventSource)
line: 298
DefaultFlushEventListener.onFlush(FlushEvent) line: 27
SessionImpl.flush() line: 1000
The onPreUpdate() is called within flush(). The now inserted entities need an EXTRA
flush().
Don't know if a bug or a feature, but the behavior differs much between oracle and
other DBs (MySQL etc.).
Entities saved within onPreUpdate() never inserted into db when id
generator is sequenze (f.e. oracle)
------------------------------------------------------------------------------------------------------
Key: HHH-3317
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-3317
Project: Hibernate3
Issue Type: Bug
Components: core
Affects Versions: 3.2.6
Environment: hibernate3.2.6.ga.jar, Oracle 10
Reporter: Martin Backhaus
Priority: Minor
If you save (insert) a entity within the event preUpdate and the id is a oracle-sequenze,
hibernate put the entity to insert in the session-ActionQueue, BUT NEVER INSERTS it. If
you use mysql/hsql... where the id is differently generated, the insert happens
immediately and no put to the ActionQueue occures.
As workaround you can queue the object (to insert) yourself and call save() within the
postUpdate-Event.
I use this events for historizing some stuff.
Inserts within onDelete() works fine.
the ids are annotated as shown here:
@Id
@GeneratedValue(strategy = GenerationType.AUTO)
protected Long id = null;
--
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:45 a.m.
New subject: [Hibernate-JIRA] Commented: (HHH-3317) Entities saved within onPreUpdate() never inserted into db when id generator is sequenze (f.e. oracle)
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-3317?page=c...
]
Martin Backhaus commented on HHH-3317:
--------------------------------------
Within onDelete() inserted entities are really inserted without an extra flush(), because
fireDelete() is immediately called (before flush() ).
Why not do so for save()/update() ?
Entities saved within onPreUpdate() never inserted into db when id
generator is sequenze (f.e. oracle)
------------------------------------------------------------------------------------------------------
Key: HHH-3317
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-3317
Project: Hibernate3
Issue Type: Bug
Components: core
Affects Versions: 3.2.6
Environment: hibernate3.2.6.ga.jar, Oracle 10
Reporter: Martin Backhaus
Priority: Minor
If you save (insert) a entity within the event preUpdate and the id is a oracle-sequenze,
hibernate put the entity to insert in the session-ActionQueue, BUT NEVER INSERTS it. If
you use mysql/hsql... where the id is differently generated, the insert happens
immediately and no put to the ActionQueue occures.
As workaround you can queue the object (to insert) yourself and call save() within the
postUpdate-Event.
I use this events for historizing some stuff.
Inserts within onDelete() works fine.
the ids are annotated as shown here:
@Id
@GeneratedValue(strategy = GenerationType.AUTO)
protected Long id = null;
--
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
11:18 a.m.
New subject: [Hibernate-JIRA] Updated: (HHH-3317) Entities saved within onPreUpdate() never inserted into db when id generator is sequenze (f.e. oracle)
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-3317?page=c...
]
Martin Backhaus updated HHH-3317:
---------------------------------
Attachment: HHH_3317_Test.java
HHH_3317.hbm.xml
Here is a Test.
Fails with Oracle.
Entities saved within onPreUpdate() never inserted into db when id
generator is sequenze (f.e. oracle)
------------------------------------------------------------------------------------------------------
Key: HHH-3317
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-3317
Project: Hibernate3
Issue Type: Bug
Components: core
Affects Versions: 3.2.6
Environment: hibernate3.2.6.ga.jar, Oracle 10
Reporter: Martin Backhaus
Priority: Minor
Attachments: HHH_3317.hbm.xml, HHH_3317_Test.java
If you save (insert) a entity within the event preUpdate and the id is a oracle-sequenze,
hibernate put the entity to insert in the session-ActionQueue, BUT NEVER INSERTS it. If
you use mysql/hsql... where the id is differently generated, the insert happens
immediately and no put to the ActionQueue occures.
As workaround you can queue the object (to insert) yourself and call save() within the
postUpdate-Event.
I use this events for historizing some stuff.
Inserts within onDelete() works fine.
the ids are annotated as shown here:
@Id
@GeneratedValue(strategy = GenerationType.AUTO)
protected Long id = null;
--
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:24 p.m.
New subject: [Hibernate-JIRA] Commented: (HHH-3317) Entities saved within onPreUpdate() never inserted into db when id generator is sequenze (f.e. oracle)
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-3317?page=c...
]
Martin Backhaus commented on HHH-3317:
--------------------------------------
Found a potentially answer :
http://opensource.atlassian.com/projects/hibernate/browse/HHH-1241
Will try tomorrow and close if it works.
Entities saved within onPreUpdate() never inserted into db when id
generator is sequenze (f.e. oracle)
------------------------------------------------------------------------------------------------------
Key: HHH-3317
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-3317
Project: Hibernate3
Issue Type: Bug
Components: core
Affects Versions: 3.2.6
Environment: hibernate3.2.6.ga.jar, Oracle 10
Reporter: Martin Backhaus
Priority: Minor
Attachments: HHH_3317.hbm.xml, HHH_3317_Test.java
If you save (insert) a entity within the event preUpdate and the id is a oracle-sequenze,
hibernate put the entity to insert in the session-ActionQueue, BUT NEVER INSERTS it. If
you use mysql/hsql... where the id is differently generated, the insert happens
immediately and no put to the ActionQueue occures.
As workaround you can queue the object (to insert) yourself and call save() within the
postUpdate-Event.
I use this events for historizing some stuff.
Inserts within onDelete() works fine.
the ids are annotated as shown here:
@Id
@GeneratedValue(strategy = GenerationType.AUTO)
protected Long id = null;
--
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:48 a.m.
New subject: [Hibernate-JIRA] Commented: (HHH-3317) Entities saved within onPreUpdate() never inserted into db when id generator is sequenze (f.e. oracle)
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-3317?page=c...
]
Martin Backhaus commented on HHH-3317:
--------------------------------------
I don't want to close this issue.
In my opinion this is a massive bug, because every developer, who trust Hibernate, will
get in trouble with such differences in behavior of the Hibernate-Event-System.
If this behavior is expected (as said in HHH-1241) then should be a Exception thrown, when
inserting an entity within onFlush() - or write a log-message to give the developer a
chance.
Here my workaround for pitiful Oracle-Users :
public boolean onPreUpdate(final PreUpdateEvent arg0)
{
...
saveInSubSession(myEntity, arg0.getSource());
...
}
/**
* WORKAROUND for saving something in Oracle within an event
* @see http://opensource.atlassian.com/projects/hibernate/browse/HHH-3317
*/
private void saveInSubSession(final Object entity, final SessionImplementor si)
{
final Session sessionForSaving =
si.getFactory().openSession(si.getJDBCContext().connection());
sessionForSaving.save(entity);
// If you do something within onFlush() -> be sure to save things which would be
changed
sessionForSaving.flush();
// If you do something within onFlush() -> be sure to revert it at this point
}
Entities saved within onPreUpdate() never inserted into db when id
generator is sequenze (f.e. oracle)
------------------------------------------------------------------------------------------------------
Key: HHH-3317
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-3317
Project: Hibernate3
Issue Type: Bug
Components: core
Affects Versions: 3.2.6
Environment: hibernate3.2.6.ga.jar, Oracle 10
Reporter: Martin Backhaus
Priority: Minor
Attachments: HHH_3317.hbm.xml, HHH_3317_Test.java
If you save (insert) a entity within the event preUpdate and the id is a oracle-sequenze,
hibernate put the entity to insert in the session-ActionQueue, BUT NEVER INSERTS it. If
you use mysql/hsql... where the id is differently generated, the insert happens
immediately and no put to the ActionQueue occures.
As workaround you can queue the object (to insert) yourself and call save() within the
postUpdate-Event.
I use this events for historizing some stuff.
Inserts within onDelete() works fine.
the ids are annotated as shown here:
@Id
@GeneratedValue(strategy = GenerationType.AUTO)
protected Long id = null;
--
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:21 p.m.
New subject: [Hibernate-JIRA] Commented: (HHH-3317) Entities saved within onPreUpdate() never inserted into db when id generator is sequenze (f.e. oracle)
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-3317?page=c...
]
Gail Badner commented on HHH-3317:
----------------------------------
Martin, thanks for your workaround and test case. I'll add them to the unit tests.
Creating a new entity is not supported when the session is being flushed.
As you suggested, I'll look into throwing an exception when this happens. I also plan
to add documentation for how to workaround this issue.
Entities saved within onPreUpdate() never inserted into db when id
generator is sequenze (f.e. oracle)
------------------------------------------------------------------------------------------------------
Key: HHH-3317
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-3317
Project: Hibernate3
Issue Type: Bug
Components: core
Affects Versions: 3.2.6
Environment: hibernate3.2.6.ga.jar, Oracle 10
Reporter: Martin Backhaus
Priority: Minor
Attachments: HHH_3317.hbm.xml, HHH_3317_Test.java
If you save (insert) a entity within the event preUpdate and the id is a oracle-sequenze,
hibernate put the entity to insert in the session-ActionQueue, BUT NEVER INSERTS it. If
you use mysql/hsql... where the id is differently generated, the insert happens
immediately and no put to the ActionQueue occures.
As workaround you can queue the object (to insert) yourself and call save() within the
postUpdate-Event.
I use this events for historizing some stuff.
Inserts within onDelete() works fine.
the ids are annotated as shown here:
@Id
@GeneratedValue(strategy = GenerationType.AUTO)
protected Long id = null;
--
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:40 p.m.
New subject: [Hibernate-JIRA] Commented: (HHH-3317) Entities saved within onPreUpdate() never inserted into db when id generator is sequenze (f.e. oracle)
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-3317?page=c...
]
HG commented on HHH-3317:
-------------------------
I had the same problem and was able to solve it using Listeners. I describe this in my
blog at http://anshuiitk.blogspot.com/2010/11/hibernate-pre-database-opertaion-ev...
. Let me know in case you have any doubts which I can clarify after reading the post.
Entities saved within onPreUpdate() never inserted into db when id
generator is sequenze (f.e. oracle)
------------------------------------------------------------------------------------------------------
Key: HHH-3317
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-3317
Project: Hibernate Core
Issue Type: Bug
Components: core
Affects Versions: 3.2.6
Environment: hibernate3.2.6.ga.jar, Oracle 10
Reporter: Martin Backhaus
Priority: Minor
Attachments: HHH_3317.hbm.xml, HHH_3317_Test.java
If you save (insert) a entity within the event preUpdate and the id is a oracle-sequenze,
hibernate put the entity to insert in the session-ActionQueue, BUT NEVER INSERTS it. If
you use mysql/hsql... where the id is differently generated, the insert happens
immediately and no put to the ActionQueue occures.
As workaround you can queue the object (to insert) yourself and call save() within the
postUpdate-Event.
I use this events for historizing some stuff.
Inserts within onDelete() works fine.
the ids are annotated as shown here:
@Id
@GeneratedValue(strategy = GenerationType.AUTO)
protected Long id = null;
--
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
4:46 p.m.
New subject: [Hibernate-JIRA] (HHH-3317) Entities saved within onPreUpdate() never inserted into db when id generator is sequenze (f.e. oracle)
4175
days inactive
5809
days old
hibernate-issues@lists.jboss.org
10 comments
4 participants
participants (4)
-
Gail Badner (JIRA) -
HG (JIRA)
-
Martin Backhaus (JIRA)
-
Steve Ebersole (JIRA)