[hibernate-issues] [Hibernate-JIRA] Commented: (HHH-3240) In Derby field type 'text' is converted to CLOB(255)

[ 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