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

[Antoine Herzog (JIRA)]

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