Bug 780246 (SOA-2642)

Summary: ModeShape needs to support Sybase as a repository
Product: [JBoss] JBoss Enterprise SOA Platform 5 Reporter: Aleksandar Kostadinov <akostadinov>
Component: EAP, EDSAssignee: Van Halbert <vhalbert>
Status: CLOSED WONTFIX QA Contact:
Severity: high Docs Contact:
Priority: high    
Version: 5.1.0.ER4, 5.1.0.ER5CC: akostadinov, rhauch, vhalbert
Target Milestone: ---   
Target Release: FUTURE   
Hardware: Unspecified   
OS: Unspecified   
URL: http://jira.jboss.org/jira/browse/SOA-2642
Whiteboard:
Fixed In Version: Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
linux, sybase 15.x, jdbc4 driver, repository database schema created through the supplied modeshape DDL script
Last Closed: 2011-12-06 22:01:38 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:
Bug Depends On:    
Bug Blocks: 899318    
Attachments:
Description Flags
err.txt
none
modeshape-config.xml none

Description Aleksandar Kostadinov 2010-12-03 17:39:28 UTC
project_key: SOA

On line 26 of index.jsp (see attached to SOA-2640) I'm getting:
java.sql.SQLException: JZNNA: Column does not allow null values / see attached err.txt

This is trying to obtain a Repository through the ServiceLoader. Perhaps DDL needs to be tuned?

Comment 1 Aleksandar Kostadinov 2010-12-03 17:42:15 UTC
Attachment: Added: err.txt


Comment 2 Aleksandar Kostadinov 2010-12-03 19:59:47 UTC
Attachment: Added: modeshape-config.xml


Comment 3 Aleksandar Kostadinov 2010-12-03 20:01:00 UTC
Link: Added: This issue Cloned to SOA-2643


Comment 4 Aleksandar Kostadinov 2010-12-07 19:34:48 UTC
This is still an issue with ER5.

Comment 5 Van Halbert 2010-12-07 21:31:24 UTC
There's a problem with the Sybase jdbc4 driver (jconn4.jar), in that it has issues setting "NULL" for BIT data types used to represent boolean values.

A recommended solution is to go back to the jconn3 driver.

However, that driver has blob / clob issues and these issues we're not fixed until the 3.5.0 release (which we use 3.3.2).

Another suggestion was to use this workaround in the mapping:

change:
type="boolean"
to use:
type="org.hibernate.test.where.NumericTrueFalseType"

I don't know if we want to change the product branch before the project has had this type of change applied.     This needs some serious discussion.

Comment 6 Van Halbert 2010-12-08 14:25:55 UTC
When I referenced the fix in 3.5.0,  I should have clarified that the blob/clob issue was a Hibernate issue (as indicated in MODE-1037).

Comment 7 Randall Hauch 2010-12-08 14:49:08 UTC
As I mentioned on MODE-1037, in order to support running on EAP 5.1, we had to change ModeShape to use an older version of Hibernate. I was told that if any Hibernate issues came up (especially if they were fixed in later releases of Hibernate), that they'd be backported to the version of Hibernate that EAP, SOA-P and BRMS are using. IMO, this is what has to happen here.

Comment 8 Aleksandar Kostadinov 2010-12-08 17:07:20 UTC
It must be considered by the PM team whether we should drop jdbc4 driver support. As far as I understand though going to NumericTrueFalseType would fix the jdbc4 problem. And the backport of hibernate patches would fix the jdbc3 problem. In any case PM need to be involved.

Comment 9 Aleksandar Kostadinov 2010-12-08 17:19:47 UTC
Link: Added: This issue related BRMS-507


Comment 10 Van Halbert 2010-12-08 17:58:34 UTC
Assigning to Ken to get PM team answer.

Comment 12 Van Halbert 2010-12-09 16:27:12 UTC
Link: Added: This issue is a dependency of JBPAPP-5558


Comment 13 Van Halbert 2010-12-09 16:27:13 UTC
This is the jira requesting the Hibernate fix to EAP.

Comment 14 Anne-Louise Tangring 2010-12-14 19:16:57 UTC
Further review has proven that this is not a blocker for SOA 5.1.0. It will be a candidate for SOA 5.1.0

Comment 16 Van Halbert 2011-10-07 20:38:43 UTC
Link: Added: This issue duplicates SOA-2706


Comment 17 JBoss JIRA Server 2014-01-07 17:45:53 UTC
Randall Hauch <rhauch> updated the status of jira MODE-1037 to Closed