Bug 724523 (BRMS-469) - ModeShape unit tests are failing with DB2 9.7 (DB2 SQL Error: SQLCODE=-302, SQLSTATE=22001, SQLERRMC=null, DRIVER=4.9.78 )
Summary: ModeShape unit tests are failing with DB2 9.7 (DB2 SQL Error: SQLCODE=-302, S...
Keywords:
Status: CLOSED NEXTRELEASE
Alias: BRMS-469
Product: JBoss Enterprise BRMS Platform 5
Classification: JBoss
Component: Modeshape
Version: 5.1.0.ER4
Hardware: Unspecified
OS: Unspecified
urgent
unspecified
Target Milestone: ---
: BRMS 5.2.0.GA
Assignee: Van Halbert
QA Contact:
URL: http://jira.jboss.org/jira/browse/BRM...
Whiteboard:
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2010-11-29 12:40 UTC by Petr Široký
Modified: 2011-08-19 04:18 UTC (History)
1 user (show)

Fixed In Version:
Doc Type: Bug Fix
Doc Text:
Clone Of:
Environment:
brms standalone 5.1.0 ER4 DB2 9.7
Last Closed: 2011-07-18 20:21:45 UTC
Type: Bug


Attachments (Terms of Use)


Links
System ID Private Priority Status Summary Last Updated
Red Hat Bugzilla 780191 0 urgent CLOSED ModeShape unit tests are failing with DB2 9.7 2021-02-22 00:41:40 UTC
Red Hat Issue Tracker BRMS-469 0 Critical Closed ModeShape unit tests are failing with DB2 9.7 (DB2 SQL Error: SQLCODE=-302, SQLSTATE=22001, SQLERRMC=null, DRIVER=4.9.78... 2012-11-13 14:25:41 UTC

Internal Links: 780191

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.



Note You need to log in before you can comment on or make changes to this bug.