[jboss-jira] [JBoss JIRA] Commented: (JBPORTAL-1152) testsuite problem with sybase
[ http://jira.jboss.com/jira/browse/JBPORTAL-1152?page=comments#action_1234... ]
Sohil Shah commented on JBPORTAL-1152:
--------------------------------------
Options recommended by Steve:
Since no one still has asked ;) here is what I would recommend. Either:
1) Always map this as a materialized blob. Hibernate unfortunately does not currently
ship with a built in impl for this, but its trivial to implement. Actually, the test
suite does have one:
http://fisheye.jboss.com/browse/Hibernate/trunk/Hibernate3/test/org/hibe
rnate/test/lob/MaterializedBlobType.java?r=10848
2) Make the dialect change I mentioned before. Again, if that works (as I expect it to)
in your tests, then I will incorporate that change back into my code base. I'd go
with the default limit that Ryan pointed out (2048).
However, note that both of these would force changes to the DB schema of current users to
use a BLOB columns here instead of VARBINARY columns.
If that is unacceptable, then you will need to leave these as a type that maps to a
VARBINARY column. Then it is simply a matter of dealing with the size limits. If you
want to leave it at your original size limit, then Sybase users would need to be informed
to change this limit on their database.
testsuite problem with sybase
-----------------------------
Key: JBPORTAL-1152
URL: http://jira.jboss.com/jira/browse/JBPORTAL-1152
Project: JBoss Portal
Issue Type: Task
Security Level: Public(Everyone can see)
Reporter: Prabhat Jha
Assigned To: Roy Russo
During portal testsuite run with sybase database, tables are not getting created
successfully. These are two major errors that I see:
1. ERROR [SchemaExport] Unsuccessful: create table jbp_cms_cmsentry (PK int identity not
null, FSENTRY_NAME varchar(255) null, FSENTRY_PATH varchar(245) not null, FSENTRY_DATA
image nu\ ll, FSENTRY_LASTMOD numeric(19,0) not null, FSENTRY_LENGTH numeric(19,0) not
null, primary key (PK))
[junit_] 17:50:33,387 ERROR [SchemaExport] Identity field 'PK' must be a
numeric with a scale of 0 and not null allowed.
2. ERROR [SchemaExport] Unsuccessful: create table jbp_cms_version_refs (PK int identity
not null, NODE_ID varchar(36) null, REFS_DATA varbinary(100000000) not null, primary key
(PK))
[junit_] 17:50:33,413 ERROR [SchemaExport] Length or precision specification 100000000
is not within the range of 1 to 16384.
Assigning it to Roy since you seem to be the most involved with it. ;-)
--
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