[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-1501?page=c...
]
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....
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira