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

[Emmanuel Bernard (JIRA)]

    [ http://opensource.atlassian.com/projects/hibernate/browse/ANN-692?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_29452 ] 

Emmanuel Bernard commented on ANN-692:
--------------------------------------

But it will break with every other database...

> StringClobType doesn't work with Sybase ASA
> -------------------------------------------
>
>                 Key: ANN-692
>                 URL: http://opensource.atlassian.com/projects/hibernate/browse/ANN-692
>             Project: Hibernate Annotations
>          Issue Type: Bug
>    Affects Versions: 3.3.0.ga
>         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