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

[Prabhat Jha (JIRA)]

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