[hibernate-issues] [Hibernate-JIRA] Commented: (HHH-3240) In Derby field type 'text' is converted to CLOB(255)
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-3240?page=c...
]
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/o...
). 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....
-
For more information on JIRA, see: http://www.atlassian.com/software/jira