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

[Julien Viet (JIRA)]

    [ http://jira.jboss.com/jira/browse/JBPORTAL-1107?page=comments#action_12346612 ] 
            
Julien Viet commented on JBPORTAL-1107:
---------------------------------------

I think we should wait until we have more databases in our QA labs in order to be able to test any change against all that databases.

> 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
>   Original Estimate: 1 day
>  Remaining Estimate: 1 day
>
> 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