[jboss-jira] [JBoss JIRA] Closed: (JBPORTAL-1159) portal testsuite with derby database

[Prabhat Jha (JIRA)]

     [ http://jira.jboss.com/jira/browse/JBPORTAL-1159?page=all ]

Prabhat Jha closed JBPORTAL-1159.
---------------------------------

    Resolution: Done

Not going to worry about derby database.

> portal testsuite with derby database
> ------------------------------------
>
>                 Key: JBPORTAL-1159
>                 URL: http://jira.jboss.com/jira/browse/JBPORTAL-1159
>             Project: JBoss Portal
>          Issue Type: Bug
>      Security Level: Public(Everyone can see) 
>          Components: Portal CMS
>            Reporter: Prabhat Jha
>         Assigned To: Roy Russo
>
> After sybase problem, we seem to have stumbled across another issue while running portal testsuite against apache derby database. I am going to check in derby database config to regular portal testsuite run so that when the problem is fixed, it's reflected. I do see portal database created on derby side so there should not be any driver/connection issue. I see following error when testsuite tries to create tables on derby:
>  [junit_] 14:54:19,819 INFO  [SchemaExport] exporting generated schema to database
>    [junit_] 14:54:20,041 ERROR [SchemaExport] Unsuccessful: create table jbp_cms_version_node (PK integer not null, NODE_ID varchar(36), NODE_DATA varchar(100000000) for bit data not null, primary key (PK))
>    [junit_] 14:54:20,041 ERROR [SchemaExport] The length, precision, or scale attribute for column, or type mapping 'VARCHAR (100000000) FOR BIT DATA' is not valid.
>    [junit_] 14:54:20,045 ERROR [SchemaExport] Unsuccessful: create table jbp_cms_version_prop (PK integer not null, PROP_ID varchar(255), PROP_DATA varchar(100000000) for bit data not null, primary key (PK)\
> )
>    [junit_] 14:54:20,045 ERROR [SchemaExport] The length, precision, or scale attribute for column, or type mapping 'VARCHAR (100000000) FOR BIT DATA' is not valid.
>    [junit_] 14:54:20,052 ERROR [SchemaExport] Unsuccessful: create table jbp_cms_version_refs (PK integer not null, NODE_ID varchar(36), REFS_DATA varchar(100000000) for bit data not null, primary key (PK))
>    [junit_] 14:54:20,052 ERROR [SchemaExport] The length, precision, or scale attribute for column, or type mapping 'VARCHAR (100000000) FOR BIT DATA' is not valid.
>    [junit_] 14:54:20,164 ERROR [SchemaExport] Unsuccessful: create table jbp_cms_wsp_node (PK integer not null, NODE_ID varchar(36), NODE_DATA varchar(100000000) for bit data not null, primary key (PK))
>    [junit_] 14:54:20,164 ERROR [SchemaExport] The length, precision, or scale attribute for column, or type mapping 'VARCHAR (100000000) FOR BIT DATA' is not valid.
>    [junit_] 14:54:20,172 ERROR [SchemaExport] Unsuccessful: create table jbp_cms_wsp_prop (PK integer not null, PROP_ID varchar(255), PROP_DATA varchar(100000000) for bit data not null, primary key (PK))
>    [junit_] 14:54:20,172 ERROR [SchemaExport] The length, precision, or scale attribute for column, or type mapping 'VARCHAR (100000000) FOR BIT DATA' is not valid.
>    [junit_] 14:54:20,177 ERROR [SchemaExport] Unsuccessful: create table jbp_cms_wsp_refs (PK integer not null, NODE_ID varchar(36), REFS_DATA varchar(100000000) for bit data not null, primary key (PK))
>    [junit_] 14:54:20,177 ERROR [SchemaExport] The length, precision, or scale attribute for column, or type mapping 'VARCHAR (100000000) FOR BIT DATA' is not valid.
>    [junit_] 14:54:20,238 INFO  [SchemaExport] schema export complete
> Looks like 10x10^7 is a big number for derby. Just a note: tck5 tests are run with derby so database should be able to handle regular database needs.

-- 
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