Bug 779643 (SOA-2012) - sql-listener not working correctly with transacted="true"
Summary: sql-listener not working correctly with transacted="true"
Keywords:
Status: CLOSED NEXTRELEASE
Alias: SOA-2012
Product: JBoss Enterprise SOA Platform 5
Classification: JBoss
Component: unspecified
Version: 5.0.0 GA
Hardware: Unspecified
OS: Unspecified
high
high
Target Milestone: ---
: 5.0.2
Assignee: Kevin Conner
QA Contact:
URL: http://jira.jboss.org/jira/browse/SOA...
Whiteboard:
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2010-03-24 15:44 UTC by Martin Weiler
Modified: 2010-06-09 06:27 UTC (History)
0 users

Fixed In Version:
Doc Type: Bug Fix
Doc Text:
Clone Of:
Environment:
Last Closed: 2010-05-28 13:05:45 UTC
Type: Bug

Attachments (Terms of Use)
Add an attachment (proposed patch, testcase, etc.)


Links
System ID Private Priority Status Summary Last Updated
Red Hat Bugzilla 779670 0 high CLOSED sql-listener not working correctly with transacted="true" 2021-02-22 00:41:40 UTC
Red Hat Issue Tracker SOA-2012 0 Major Closed sql-listener not working correctly with transacted="true" 2012-10-03 09:00:16 UTC

Internal Links: 779670

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.
Note You need to log in before you can comment on or make changes to this bug.