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