[hibernate-issues] [Hibernate-JIRA] Commented: (HHH-3240) In Derby field type 'text' is converted to CLOB(255)

[Alexandra Wamb (JIRA)]

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

Alexandra Wamb commented on HHH-3240:
-------------------------------------

I still don't get why TEXT is mapped to LONGVARCHAR. The derby reference in regard to LONGVARCHAR says that it is restricted to 32,700 characters (http://db.apache.org/derby/docs/10.5/ref/rrefsqlj15147.html).
To my knowledge TEXT in the domain of SQL allows two giga of characters. And this is exactly the amount of characters that CLOB in derby offers (http://db.apache.org/derby/docs/10.5/ref/rrefclob.html).

So is there any reason why TEXT is mapped to LONGVARCHAR and not CLOB?
Thanks



> In Derby field type 'text' is converted to CLOB(255)
> ----------------------------------------------------
>
>                 Key: HHH-3240
>                 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-3240
>             Project: Hibernate Core
>          Issue Type: Bug
>          Components: core
>    Affects Versions: 3.1
>         Environment: Hibernate 3.1, Derby 10.3.2.1
>            Reporter: Aleksander Rozman
>             Fix For: 3.5.0.Beta-1, 3.5.0-Beta-2, 3.5
>
>
> When using type 'text' this is incorectly converted to CLOB(255). Derby has several long var char types which could be used instead, but instead it's defaulted to clob(255). 
> I have taken a look at source from 3.1 and 3.2.6 (latest) and this code is still the same... I think that just little fix in DerbyDialect would be enough... I would try this myself but I am currently lacking time and resources.
> I hope this will be taken care of as soon as it gets...

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