[hibernate-issues] [Hibernate-JIRA] Commented: (HHH-1501) insert long string (more than 32700) fails on derby

[Gail Badner (JIRA)]

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

Gail Badner commented on HHH-1501:
----------------------------------

Please try using 3.5.1 and map your property as a materialized_clob like:

<property name="longString" column="LONG_STR" type="materialized_clob" length="MAX_LENGTH"/>

Replace MAX_LENGTH with the actual maximum length for the string.

The Hibernate type, "materialized_clob", is new for 3.5 (HHH-3892/HHH-4405) and has not been documented yet. Documentation will added for HHH-4878. (That's on my TODO list...)

If "materialized_clob" doesn't work, then please attach a test case that reproduces your issue.

You may be able to update a test in https://anonsvn.jboss.org/repos/hibernate/core/trunk/testsuite/src/test/java/org/hibernate/test/lob/ to reproduce your issue.

If you need to change the Derby dialect to get this to work, please attach a patched version of the Derby dialect as well.

Thanks,
Gail

> insert long string (more than 32700) fails on derby
> ---------------------------------------------------
>
>                 Key: HHH-1501
>                 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-1501
>             Project: Hibernate Core
>          Issue Type: Bug
>          Components: core
>    Affects Versions: 3.5.0-Beta-2
>         Environment: Derby 10
>            Reporter: Sergey Vladimirov
>            Priority: Trivial
>
> http://issues.apache.org/jira/browse/DERBY-102
> VARCHAR maximum length 32 672
> LONG VARCHAR maximum length 32 700
> CLOB maximum length 2 147 483 647
> BLOB maximum length 2 147 483 647
> this issue can be reproduced by org.hibernate.test.lob.TextTest (in 3.5 beta1,2) with change org.hibernate.test.lob.LongStringTest.LONG_STRING_SIZE > 32700

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