Bug 724523 (BRMS-469)

Summary: ModeShape unit tests are failing with DB2 9.7 (DB2 SQL Error: SQLCODE=-302, SQLSTATE=22001, SQLERRMC=null, DRIVER=4.9.78 )
Product: [JBoss] JBoss Enterprise BRMS Platform 5 Reporter: Petr Široký <psiroky>
Component: ModeshapeAssignee: Van Halbert <vhalbert>
Status: CLOSED NEXTRELEASE QA Contact:
Severity: unspecified Docs Contact:
Priority: urgent    
Version: 5.1.0.ER4CC: lcarlon
Target Milestone: ---   
Target Release: BRMS 5.2.0.GA   
Hardware: Unspecified   
OS: Unspecified   
URL: http://jira.jboss.org/jira/browse/BRMS-469
Whiteboard:
Fixed In Version: Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
brms standalone 5.1.0 ER4 DB2 9.7
Last Closed: 2011-07-18 20:21:45 UTC Type: Bug
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:

Description Petr Široký 2010-11-29 12:40:41 UTC 
securitylevel_name: Public

Same as SOA-2570. 

See http://hudson.qa.jboss.com/hudson/view/BRMS/job/brms-modeshape-db/DATABASE=db2-97,jdk=java16_default/3/#showFailuresLink
Comment 1 Petr Široký 2010-11-30 09:31:52 UTC 
Link: Added: This issue is related to MODE-1024
Comment 2 Petr Široký 2010-11-30 09:32:31 UTC 
Link: Removed: This issue is related to MODE-1024
Comment 3 Van Halbert 2010-12-03 15:50:36 UTC 
Link: Added: This issue is a dependency of MODE-1015
Comment 4 Petr Široký 2011-01-06 14:01:02 UTC 
Link: Added: This issue is related to SOA-2570
Comment 5 Anne-Louise Tangring 2011-05-31 19:04:09 UTC 
Triaged by BRMS PM team for 5.2.
Comment 6 Van Halbert 2011-07-18 20:21:45 UTC 
ModeShape committed a fix to 2.5.0 GA:  project comment:

As noted in the accompanying JIRA, the root cause of this issue is that DB2 (and Derby) use a binary data type for JPA LOBs with a maximum size of 255 unless a different size is explicitly provided. Most, if not all, non-trivial uses of ModeShape require a larger value for the two LOB fields in the JPA Simple model.

This patch addresses the problem in several ways. First, it provides larger default values for the two LOB columns (MODE_SIMPLE_NODE.DATA and MODE_LARGE_VALUES.DATA) that ModeShape uses. Second, it adds comments in the model classes for the JPA entities that contain these fields. Third, it adds a detailed note in the JPA Connector of the Reference Guide explaining how to address these issues in a production environment. Fourth, it modifies the DDL generator utility to output a warning when DDL is generated for the DB2 or Derby dialects.