[Hibernate-JIRA] Created: (HHH-6259) failure trying to delete an @Entity with a NULL @Version timestamp using postgresql
2:31 a.m.
failure trying to delete an @Entity with a NULL @Version timestamp using postgresql
-----------------------------------------------------------------------------------
Key: HHH-6259
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-6259
Project: Hibernate Core
Issue Type: Bug
Components: core
Affects Versions: 3.6.1
Environment: jboss 6, hibernate 3.6.1, postgresql 9.0, JDBC4 driver, windows 7
x64
Reporter: radai
given an @Entity with a Timestamp @Version property that happens to be NULL, hibernate
fails to delete the entity, assuming the entity is dirty.
the root cause for this is the PreparedStatement hibernate generates. the sql string looks
something along the lines of:
"delete from [table] where [idField]=? and [timestampField]=?"
hibernate then sets the 1st arg to the entity's id (non null) and then calls setNull()
to set the 2nd parameter to null (the timestamp property for the entity is null). the
postgres JDBC driver doesnt return any error, but executing the statement returns 0 rows,
which in turn causes hibernate to assume the entity has been changed in the meantime and
throw an exception.
apparently the postgresql jdbc4 driver expects "[timestampField] is null" in the
sql string and nothing else.
im not sure if its hibernate or the postgresql driver at fault here, but the overall
combnation of the two definitely does not work.
--
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
2:48 a.m.
New subject: [Hibernate-JIRA] Commented: (HHH-6259) failure trying to delete an @Entity with a NULL @Version timestamp using postgresql
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-6259?page=c...
]
radai commented on HHH-6259:
----------------------------
this is how i originally found the issue:
http://stackoverflow.com/questions/6106410/hibernate-unable-to-delete-ent...
there's a lot more info there.
failure trying to delete an @Entity with a NULL @Version timestamp
using postgresql
-----------------------------------------------------------------------------------
Key: HHH-6259
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-6259
Project: Hibernate Core
Issue Type: Bug
Components: core
Affects Versions: 3.6.1
Environment: jboss 6, hibernate 3.6.1, postgresql 9.0, JDBC4 driver, windows 7
x64
Reporter: radai
given an @Entity with a Timestamp @Version property that happens to be NULL, hibernate
fails to delete the entity, assuming the entity is dirty.
the root cause for this is the PreparedStatement hibernate generates. the sql string
looks something along the lines of:
"delete from [table] where [idField]=? and [timestampField]=?"
hibernate then sets the 1st arg to the entity's id (non null) and then calls
setNull() to set the 2nd parameter to null (the timestamp property for the entity is
null). the postgres JDBC driver doesnt return any error, but executing the statement
returns 0 rows, which in turn causes hibernate to assume the entity has been changed in
the meantime and throw an exception.
apparently the postgresql jdbc4 driver expects "[timestampField] is null" in
the sql string and nothing else.
im not sure if its hibernate or the postgresql driver at fault here, but the overall
combnation of the two definitely does not work.
--
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:42 p.m.
New subject: [Hibernate-JIRA] Commented: (HHH-6259) failure trying to delete an @Entity with a NULL @Version timestamp using postgresql
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-6259?page=c...
]
reda abdi commented on HHH-6259:
--------------------------------
Hi,
I don't think it is related to postgresql as I have the same issue with MySql version:
5.0.51a-24+lenny5
Here is the stack trace:
{code}
ERROR org.hibernate.event.def.AbstractFlushingEventListener - Could not synchronize
database state with session
org.hibernate.StaleObjectStateException: Row was updated or deleted by another transaction
(or unsaved-value mapping was incorrect): [com.myapp.model.MyBean#2]
at
org.hibernate.persister.entity.AbstractEntityPersister.check(AbstractEntityPersister.java:1934)
at
org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:2578)
at
org.hibernate.persister.entity.AbstractEntityPersister.updateOrInsert(AbstractEntityPersister.java:2478)
at
org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:2805)
at org.hibernate.action.EntityUpdateAction.execute(EntityUpdateAction.java:114)
at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:268)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:260)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:180)
at
org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:321)
at
org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:51)
at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1206)
at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:375)
at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:137)
at
org.springframework.orm.hibernate3.HibernateTransactionManager.doCommit(HibernateTransactionManager.java:656)
at
org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:754)
at
org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:723)
at
org.springframework.transaction.interceptor.TransactionAspectSupport.commitTransactionAfterReturning(TransactionAspectSupport.java:393)
at
org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:120)
at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
at
org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor.intercept(Cglib2AopProxy.java:621)
at
com.myapp.service.MyBeanService$$EnhancerByCGLIB$$ad87b6b7.saveMyBean(<generated>)
at com.myapp.controller.rest.MyController.putClientId(MyController.java:98)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at
org.springframework.web.bind.annotation.support.HandlerMethodInvoker.invokeHandlerMethod(HandlerMethodInvoker.java:176)
at
org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter.invokeHandlerMethod(AnnotationMethodHandlerAdapter.java:426)
at
org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter.handle(AnnotationMethodHandlerAdapter.java:414)
at
org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:790)
at
org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:719)
at
org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:644)
at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:560)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at
org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88)
at
org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:852)
at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
at java.lang.Thread.run(Thread.java:662)
{code}
I can't delete nor update the entity.
Thanks
failure trying to delete an @Entity with a NULL @Version timestamp
using postgresql
-----------------------------------------------------------------------------------
Key: HHH-6259
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-6259
Project: Hibernate Core
Issue Type: Bug
Components: core
Affects Versions: 3.6.1
Environment: jboss 6, hibernate 3.6.1, postgresql 9.0, JDBC4 driver, windows 7
x64
Reporter: radai
given an @Entity with a Timestamp @Version property that happens to be NULL, hibernate
fails to delete the entity, assuming the entity is dirty.
the root cause for this is the PreparedStatement hibernate generates. the sql string
looks something along the lines of:
"delete from [table] where [idField]=? and [timestampField]=?"
hibernate then sets the 1st arg to the entity's id (non null) and then calls
setNull() to set the 2nd parameter to null (the timestamp property for the entity is
null). the postgres JDBC driver doesnt return any error, but executing the statement
returns 0 rows, which in turn causes hibernate to assume the entity has been changed in
the meantime and throw an exception.
apparently the postgresql jdbc4 driver expects "[timestampField] is null" in
the sql string and nothing else.
im not sure if its hibernate or the postgresql driver at fault here, but the overall
combnation of the two definitely does not work.
--
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
4775
days inactive
4788
days old
hibernate-issues@lists.jboss.org
2 comments
2 participants
participants (2)
-
radai (JIRA) -
reda abdi (JIRA)