[hibernate-issues] [Hibernate-JIRA] Resolved: (HHH-6758) Test failure due to Oracle restrictions on Blob comparison and missing equals() and hashcode()

[Gail Badner (JIRA)]

     [ http://opensource.atlassian.com/projects/hibernate/browse/HHH-6758?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Gail Badner resolved HHH-6758.
------------------------------

    Resolution: Fixed

Fixed in master by adding equals() and hashCode() to avoid executing the failing SQL statements.

> Test failure  due to Oracle restrictions on Blob comparison and missing equals() and hashcode()
> -----------------------------------------------------------------------------------------------
>
>                 Key: HHH-6758
>                 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-6758
>             Project: Hibernate Core
>          Issue Type: Bug
>          Components: testsuite
>    Affects Versions: 4.0.0.CR4
>            Reporter: Gail Badner
>            Assignee: Gail Badner
>             Fix For: 4.0.0.next
>
>
> The following test fails because Oracle requires Blob comparisons to be done using dbms_lob.compare():
> org.hibernate.test.annotations.entity.BasicHibernateAnnotationsTest.testSerialized()
> In the following, Forest_near.near is a blob column:
> delete from Forest_near where Forest_id=? and near=?
> When executed, it fails with:  ORA-00932: inconsistent datatypes: expected - got BLOB
> Oracle requires the comparison be done as follows:
> delete from Forest_near where Forest_id=? and dbms_lob.compare( near, ? ) == 0
> This delete statement was being executed for collection elements of an unchanged collection because the Serializable class did not implement equals() or hashCode().
> Adding equals() and hashCode() avoids executing these delete statements.

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira