[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-3240?page=c... ] Aleksander Rozman commented on HHH-3240: ---------------------------------------- Hi ! Will try to do this over weekend. Problem is not so urgent anymore since I decided to use another database... But the fact is... Text type is mapped into Types.CLOB, and definition in Derby (actually D2) is registerColumnType( Types.CLOB, "clob($l)" ); Now we must only find who decides that text size should be 255.... I have posted same problem on Derby JIRA and they are blaming Hibernate... I imagine same will happen here. Link is https://issues.apache.org/jira/browse/DERBY-3621?page=com.atlassian.jira.... I made "hack" in code in which I set clob like this registerColumnType( Types.CLOB, "clob(255K)" ); but as I said this is only hack... I hope I will have time to create you test case, although I am very busy... Simple how-to is to change column type to "text" and create database and it will happen (I use new SchemaExport(m_cfg).create(true, true) to create db, m_cfg is configuration). You should see in create script that type is now clob(255). Try writing string larger than 255 into it and my exception will follow. Please look JIRA on Derby I have posted more info there that should help. Andy -- 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

[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-3240?page=c... ] strong liu commented on HHH-3240: --------------------------------- Text type is mapped into Types.LONGVARCHAR in 3.5-beta1 -- 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

[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-3240?page=c... ] Strong Liu updated HHH-3240: ---------------------------- Priority: Major (was: Blocker) apparently, this is not a blocker -- 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

[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-3240?page=c... ] Alexandra Wamb commented on HHH-3240: ------------------------------------- I still don't get why TEXT is mapped to LONGVARCHAR. The derby reference in regard to LONGVARCHAR says that it is restricted to 32,700 characters (http://db.apache.org/derby/docs/10.5/ref/rrefsqlj15147.html). To my knowledge TEXT in the domain of SQL allows two giga of characters. And this is exactly the amount of characters that CLOB in derby offers (http://db.apache.org/derby/docs/10.5/ref/rrefclob.html). So is there any reason why TEXT is mapped to LONGVARCHAR and not CLOB? Thanks -- 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

[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-3240?page=c... ] Strong Liu commented on HHH-3240: --------------------------------- java type hibernate type sql type string text longvarchar string material_clob clob --------------------------------- so, if you want to map string property to clob, you can just use material_clob the 'text' is a hibernate type, it used to bind a java type to sql type, maybe it more senseble on derby to bind text to clob, but, here, we should deal with all of DB type :) -- 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

[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-3240?page=c... ] Alexandra Wamb commented on HHH-3240: ------------------------------------- Hi Strong Liu, As far as I know the hibernate TEXT type is mapped to either a SQL TEXT or CLOB type. All drivers I've experienced (like MySQL, Oracle, HSQL, MS SQL Server) are mapped to the TEXT type correctly - only Derby does not, (mapping to LONGVARCHAR instead) and so is inconsistent with the rest. I fully agree with your statement that "[...] we should deal with all of DB type.", but I cannot understand why the mapping for derby deviates from other mappings. Maybe is it because hibernate says that CLOB shouldn't be used in general? I certainly think that a mapping from hibernate TEXT to SQL CLOB makes more sense. Will the mapping stay as it is, or do you know of any attempts to change it? Thanks, Alexandra Btw. I found nothing about "material_clob". Could you provide further information? -- 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

[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-3240?page=c... ] Strong Liu commented on HHH-3240: --------------------------------- Hi Alexandra, I will give more time on derby dialect once i finish the current "higher priority task", sorry about that, but as you may know, looks like there are not so much people uses derby in their production environment :) and for the new two material_clob/blob/text/image, one of our team member is writing documents about these types, it will be in 3.5.GA (hopely :) -- 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

[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-3240?page=c... ] Alexandra Wamb commented on HHH-3240: ------------------------------------- Thanks for the quick response Strong. Does that mean that you guys are working on mapping TEXT to CLOB? Thanks again! -- 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

[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-3240?page=c... ] Alexandra Wamb commented on HHH-3240: ------------------------------------- Dear Strong, I'm not exactly sure what you want me to do with the java code. However, when I just run the SQL command against derby, 'LONG STR' has a column size of 32700 only. Thank you, Alexandra -- 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

[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-3240?page=c... ] Strong Liu commented on HHH-3240: --------------------------------- yes -- 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

[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-3240?page=c... ] Strong Liu commented on HHH-3240: --------------------------------- no, Gail, IMO, it is not duplicated by HHH-1501 -- 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

[ https://hibernate.onjira.com/browse/HHH-3240?page=com.atlassian.jira.plug... ] ian mockford commented on HHH-3240: ----------------------------------- I don't think this issue is resolved. A similar issue with Derby but with BLOB not CLOB was fixed in HHH-2614 (Blob Length Set to 255 By Default With Derby DB). The suggestion by [~steve]: {quote}You would want to create a custom dialect that says: registerColumnType( Types.CLOB, "clob" ); {quote} seems to work, and looking at the changes in HHH-2614 it seems that a similar change should be made to fix this issue. (For info, a simple way of testing this is to use the @Lob annotation on a String column when using JPA backed by Hibernate & Derby) (Hibernate 4.0.1; Derby 10.8.2.2) -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira