[hibernate-issues] [Hibernate-JIRA] Commented: (HHH-2969) DB2Dialect Clob SchemaExport uses default length even if no length set
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-2969?page=c...
]
Philippe Mouawad commented on HHH-2969:
---------------------------------------
Hello M. Badner,
What is the intent of your comment ?
I read the link, it does not mention the length, it rather speaks about sizing the page
size depending on LOB length to minimize the lost space.
What is the exact link that says:
"When integer is not specified, the default length is 1M."
Philippe.
DB2Dialect Clob SchemaExport uses default length even if no length
set
----------------------------------------------------------------------
Key: HHH-2969
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2969
Project: Hibernate3
Issue Type: Bug
Components: core
Affects Versions: 3.2.5
Environment: Hibernate 3.2.5, DB2 8, DB2 9
Reporter: Philippe Mouawad
Attachments: db2-clob-schemaExport-patch.txt
I have this property in my mapping:
<property
name="argumentsValues"
column="cte_arguments_values"
type="text"
not-null="true"
/>
Notice no length is set.
Hibernate schema Export generates:
cte_arguments_names clob(255) not null,
Same problem occurs for Clob and Blob.
This is due to the following lines in org.hibernate.dialect.DB2Dialect:
registerColumnType( Types.BLOB, "blob($l)" );
registerColumnType( Types.CLOB, "clob($l)" );
Attached is the patch.
There would be another solution to test that Column has no length set.
Philippe.
www.ubik-ingenierie.com
--
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