[hibernate-issues] [Hibernate-JIRA] Commented: (HHH-1501) Derby 10 varchar limit is 32672

[Brian J. Sayatovic (JIRA)]

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

Brian J. Sayatovic commented on HHH-1501:
-----------------------------------------

I've been trying to get XWiki (v1.0b6), which uses Hibernate, to run against Derby.  However, the table creation is failing when large text columns are involved:

21:12:38,687 [http-80-Processor25] ERROR hbm2ddl.SchemaExport            - Unsuccessful: create table XWIKI.xwikiattachment_archive (XWA_ID bigint not null, XWA_ARCHIVE varchar(4000000) for bit data, primary key (XWA_ID)) 
21:12:38,687 [http-80-Processor25] ERROR hbm2ddl.SchemaExport            - The length, precision, or scale attribute for column, or type mapping 'VARCHAR (4000000) FOR BIT DATA' is not valid.  

I believe this is caused by the very issue covered in this issue.

I mention this because the priority of this issue is 'trivial', so if evidence of an actual problem created by this bug can help raise this priroity, I've just offered one.

Mind you, I'm a HIbernate/Derby/XWiki novice, so I may be misunderstanding the problem.

> Derby 10 varchar limit  is 32672
> --------------------------------
>
>                 Key: HHH-1501
>                 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-1501
>             Project: Hibernate3
>          Issue Type: Bug
>          Components: core
>    Affects Versions: 3.1.2
>         Environment: Derby 10
>            Reporter: Sergey Vladimirov
>            Priority: Trivial
>
> Derby 10 varchar limit  is 32672.
> One need to change DB2Dialect and DerbyDialect to create clob columns, if size of text > 32k:
>         registerColumnType(Types.CHAR, 254, "char(1)");
>         registerColumnType(Types.VARCHAR, 32672, "varchar($l)");
>         registerColumnType(Types.VARCHAR, Integer.MAX_VALUE, "clob($l)");
> (BTW, char limit is 254).

-- 
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