[hibernate-issues] [Hibernate-JIRA] Updated: (HHH-1501) insert long string (more than 32700) fails on derby
Strong Liu (JIRA)
noreply at atlassian.com
Sat Dec 5 08:13:12 EST 2009
[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-1501?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Strong Liu updated HHH-1501:
----------------------------
Description:
http://issues.apache.org/jira/browse/DERBY-102
VARCHAR maximum length 32 672
LONG VARCHAR maximum length 32 700
CLOB maximum length 2 147 483 647
BLOB maximum length 2 147 483 647
this issue can be reproduced by org.hibernate.test.lob.TextTest (in 3.5 beta1,2) with change org.hibernate.test.lob.LongStringTest.LONG_STRING_SIZE > 32700
was:
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).
Affects Version/s: (was: 3.1.2)
3.5.0-Beta-2
Summary: insert long string (more than 32700) fails on derby (was: Derby 10 varchar limit is 32672)
> insert long string (more than 32700) fails on derby
> ---------------------------------------------------
>
> Key: HHH-1501
> URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-1501
> Project: Hibernate Core
> Issue Type: Bug
> Components: core
> Affects Versions: 3.5.0-Beta-2
> Environment: Derby 10
> Reporter: Sergey Vladimirov
> Priority: Trivial
>
> http://issues.apache.org/jira/browse/DERBY-102
> VARCHAR maximum length 32 672
> LONG VARCHAR maximum length 32 700
> CLOB maximum length 2 147 483 647
> BLOB maximum length 2 147 483 647
> this issue can be reproduced by org.hibernate.test.lob.TextTest (in 3.5 beta1,2) with change org.hibernate.test.lob.LongStringTest.LONG_STRING_SIZE > 32700
--
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
More information about the hibernate-issues
mailing list