Bug 779643 (SOA-2012)

Summary:	sql-listener not working correctly with transacted="true"
Product:	[JBoss] JBoss Enterprise SOA Platform 5	Reporter:	Martin Weiler <mweiler>
Component:	unspecified	Assignee:	Kevin Conner <kevin.conner>
Status:	CLOSED NEXTRELEASE	QA Contact:
Severity:	high	Docs Contact:
Priority:	high
Version:	5.0.0 GA
Target Milestone:	---
Target Release:	5.0.2
Hardware:	Unspecified
OS:	Unspecified
URL:	http://jira.jboss.org/jira/browse/SOA-2012
Whiteboard:
Fixed In Version:		Doc Type:	Bug Fix
Doc Text:		Story Points:	---
Clone Of:		Environment:
Last Closed:	2010-05-28 13:05: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 Martin Weiler 2010-03-24 15:44:58 UTC

Date of First Response: 2010-04-28 07:39:56
Help Desk Ticket Reference: https://enterprise.redhat.com/issue-tracker/659163
project_key: SOA

A customer has configured the sql-listener with transacted="true", and claims that the connections are not released after a db shutdown period. If transacted="true" is removed, the service recovers properly once the db is back up and running.

Comment 1 John Graham 2010-04-12 17:08:42 UTC

Link: Added: This issue related SOA-2035

Comment 2 John Graham 2010-04-12 17:09:04 UTC

Link: Added: This issue is related to SOA-2035

Comment 3 Kevin Conner 2010-04-16 07:38:24 UTC

Link: Removed: This issue related SOA-2035

Comment 4 Kevin Conner 2010-04-16 08:06:36 UTC

Link: Added: This issue depends JBESB-3282

Comment 5 Tom Fennelly 2010-04-28 11:39:56 UTC

This is fixed on the 4.7 CP branch (JBESB-3282).

Comment 6 Marek Baluch 2010-05-28 13:05:45 UTC

Verified on 5.0.2 CR1.

Comment 7 Dana Mison 2010-06-09 06:27:21 UTC

Added to the SOA 5.0.2 release notes as resolved: 

JBESB-3282
SqlTableGatewayListener did not correctly support transacted mode.  This would result in a number of
problems if it was configured with transacted="true" including:

* commits and rollbacks not being handled correctly.
* connections were not being released when creation of prepared statements failed 
* connections are not released after a database shutdown period.  

This has been fixed and SqlTableGatewayListener now behaves as expected in both
transacted and un-transacted modes.  However the <local-tx-datasource> configuration 
must have a <check-valid-connection-sql> configuration or the unused connections will 
not be cleaned out.