[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=35824#action_35824 ] 

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

Hi Strong Liu,

As far as I know the hibernate TEXT type is mapped to either a SQL TEXT or CLOB type. All drivers I've experienced (like MySQL, Oracle, HSQL, MS SQL Server) are mapped to the TEXT type correctly - only Derby does not, (mapping to LONGVARCHAR instead) and so is inconsistent with the rest.

I fully agree with your statement that "[...] we should deal with all of DB type.", but I cannot understand why the mapping for derby deviates from other mappings. Maybe is it because hibernate says that CLOB shouldn't be used in general? I certainly think that a mapping from hibernate TEXT to SQL CLOB makes more sense.

Will the mapping stay as it is, or do you know of any attempts to change it?

Thanks, Alexandra


Btw. I found nothing about "material_clob". Could you provide further information?

> 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
>            Assignee: Strong Liu
>             Fix For: 3.5.0.Beta-1, 3.5.0-Beta-2, 3.5.0-Beta-3
>
>
> 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