[hibernate-issues] [Hibernate-JIRA] Commented: (HHH-2969) DB2Dialect Clob SchemaExport uses default length even if no length set

[Gail Badner (JIRA)]

    [ http://opensource.atlassian.com/projects/hibernate/browse/HHH-2969?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_28958 ] 

Gail Badner commented on HHH-2969:
----------------------------------

For CLOBs and BLOBs, the DB2 9.1 reference at http://publib.boulder.ibm.com/infocenter/dzichelp/v2r2/index.jsp?topic=/com.ibm.db29.doc.admin/db2z_lobpagesize.htm says, "When integer is not specified, the default length is 1M."

> 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.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira