[jboss-jira] [JBoss JIRA] Created: (JBPORTAL-1107) DB2 / Hibernate mapping / error at starting / JBP_INSTANCE table

DB2 / Hibernate mapping / error at starting / JBP_INSTANCE table ---------------------------------------------------------------- Key: JBPORTAL-1107 URL: http://jira.jboss.com/jira/browse/JBPORTAL-1107 Project: JBoss Portal Issue Type: Bug Security Level: Public (Everyone can see) Components: Portal Core Affects Versions: 2.4 Final Environment: JBP 2.4 on Windows / DB2 8 on Linux RedHat Reporter: Antoine Herzog Assigned To: Julien Viet Priority: Minor When the portal starts, there are some errors with some types used in portal, that don't fit with hibernate + DB2. Error : "ERROR [org.hibernate.util.JDBCExceptionReporter] DB2 SQL error: SQLCODE: -204,..." Error 204 is : "The object identified by _name_ is not found in the database". Some tables cannot be created, because the fields mapping is not correct. A string type (default type) with length 50000000 cannot be created in DB2, hence the whole table is not created. the problem is in : jboss-portal.sar\conf\hibernate_db2\instance\domain.hbm.xml The property definition : length="50000000" (and default type="string") is not working with DB2. type="text" is working (Hibernate put it as a CLOB in the database, which is 2Go caractere field). To check : if this is compatible with other DB mapping. If not, propose a special domain.hbm.xml for DB2 ? or documentation explaination for this special case. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://jira.jboss.com/jira/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira