[jboss-jira] [JBoss JIRA] Commented: (JBPORTAL-1152) testsuite problem with sybase

[Sohil Shah (JIRA)]

    [ http://jira.jboss.com/jira/browse/JBPORTAL-1152?page=comments#action_12348371 ] 
            
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