[hibernate-issues] [Hibernate-JIRA] Commented: (HHH-6259) failure trying to delete an @Entity with a NULL @Version timestamp using postgresql

[radai (JIRA)]

    [ http://opensource.atlassian.com/projects/hibernate/browse/HHH-6259?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=42409#action_42409 ] 

radai commented on HHH-6259:
----------------------------

this is how i originally found the issue: http://stackoverflow.com/questions/6106410/hibernate-unable-to-delete-entity-with-null-version
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.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira