[jboss-jira] [JBoss JIRA] Commented: (JBPORTAL-2154) test portal with DB2

[Prabhat Jha (JIRA)]

    [ https://jira.jboss.org/jira/browse/JBPORTAL-2154?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12429708#action_12429708 ] 

Prabhat Jha commented on JBPORTAL-2154:
---------------------------------------

Looks like DB2 and Sybase are cousins...evil cousins. :-( 

I have setup a build with DB2 version 9.1 in hudson. It's at http://hudson.qa.jboss.com/hudson/view/JBoss%20Portal/job/portal-db2 and the latest build http://hudson.qa.jboss.com/hudson/view/JBoss%20Portal/job/portal-db2/7/console shows error as:

[SchemaExport] Unsuccessful: create table jbp_cms_version_node (PK integer generated by default as identity, NODE_ID varchar(36), NODE_DATA varchar(100000000) for bit data not null, primary key (PK))
[junit_] 12:10:41,066 ERROR [SchemaExport] DB2 SQL error: SQLCODE: -604, SQLSTATE: 42611, SQLERRMC: varchar(100000000)

As per DB2 doc, SQLCODE = -604, ERROR: A DATA TYPE DEFINITION SPECIFIES AN INVALID LENGTH, PRECISION, OR SCALE ATTRIBUTE which is similar to blob issue we had in Sybase.



> test portal with DB2
> --------------------
>
>                 Key: JBPORTAL-2154
>                 URL: https://jira.jboss.org/jira/browse/JBPORTAL-2154
>             Project: JBoss Portal
>          Issue Type: Task
>      Security Level: Public(Everyone can see) 
>            Reporter: Prabhat Jha
>            Assignee: Prabhat Jha
>             Fix For: 2.6.7 Final, 2.7.0 Final
>
>


-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira