[jboss-jira] [JBoss JIRA] Closed: (JBPORTAL-1159) portal testsuite with 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.