[hibernate-issues] [Hibernate-JIRA] Commented: (HHH-4268) StringClobType doesn't work with Sybase ASA

[Gail Badner (JIRA)]

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

Gail Badner commented on HHH-4268:
----------------------------------

Using TextType in the trunk version should work because it calls st.setNull(index, Types.LONGVARCHAR). 
 
In the Branch_3_2 (3.2.x) and Branch_3_3 (3.3.x), TextType calls st.setNull(index, Types.CLOB), so those versions won't work.

> StringClobType doesn't work with Sybase ASA
> -------------------------------------------
>
>                 Key: HHH-4268
>                 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-4268
>             Project: Hibernate Core
>          Issue Type: Bug
>          Components: annotations
>         Environment: Database: Adaptive Server Anywhere, version: 9.0.1.1753 
> JDBC: jConnect (TM) for JDBC(TM)/6.05(Build 26023)
>            Reporter: Paul Middelkoop
>
> Sybase ASA doesn't support the CLOB datatype. However StringClobType works fine except when inserting a null value in the PreparedStatement. I fixed this by changing st.setNull(index, Types.CLOB) to st.setString(index, null). Maybe this can be added to the next release?

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