[hibernate-issues] [Hibernate-JIRA] Commented: (HHH-3240) In Derby field type 'text' is converted to CLOB(255)
Steve Ebersole (JIRA)
noreply at atlassian.com
Wed May 5 10:39:06 EDT 2010
[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-3240?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=36916#action_36916 ]
Steve Ebersole commented on HHH-3240:
-------------------------------------
The limit comes from a number of places. First there is the column length, if any, defined in the metadata. If none is defined then a default length is used ( http://fisheye.jboss.org/browse/Hibernate/core/trunk/core/src/main/java/org/hibernate/mapping/Column.java?r=17821#l37 ). Lastly, it is up to the dialect how and if it wants to utilize that length via calls to Dialect.registerColumnType. The DB2Dialect, for example, says registerColumnType( Types.CLOB, "clob($l)" ); which says to create columns of type CLOB sized to whatever the given length ($1) is. Thats the part you do not want.
You would want to create a custom dialect that says:
registerColumnType( Types.CLOB, "clob" );
provided Derby allows unsized clob types.
> 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
More information about the hibernate-issues
mailing list