[hibernate-issues] [Hibernate-JIRA] Commented: (HHH-5206) mapping TextType with outer join on oracle causes "Stream has already been closed" error

[Gail Badner (JIRA)]

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

Gail Badner commented on HHH-5206:
----------------------------------

Since this is a known issue, it sounds like "materialized_clob" should be used instead of "text" for Oracle.

> mapping TextType with outer join on oracle causes "Stream has already been closed" error
> ----------------------------------------------------------------------------------------
>
>                 Key: HHH-5206
>                 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-5206
>             Project: Hibernate Core
>          Issue Type: Bug
>          Components: build
>    Affects Versions: 3.5.0-Final, 3.5.1
>            Reporter: Strong Liu
>            Assignee: Gail Badner
>
> org.hibernate.test.onetoone.formula.OneToOneFormulaTest.testOneToOneFormula() fails on oracle
> {quote}
> http://www.jroller.com/agrebnev/entry/hibernate_dbms_portability_tips_tricks
>  Instead BLOB I use "long raw". It is a VARBINARY hibernate type. Here I faced with another Oracle problem "java.sql.SQLException: Stream has already been closed" accessing long raw. The problem is that "The Oracle JDBC driver automatically closes any pending inputstreams whenever another database access is made". It means you should get binary data from result set before all other types. In terms of Hibernate the mapping of binary field should be last. And please keep in your mind that you should disable outer join fetching with class which contains this field.
> {quote}

-- 
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