[
http://jira.jboss.com/jira/browse/JBESB-513?page=all ]
Mark Little reassigned JBESB-513:
---------------------------------
Assignee: Kevin Conner (was: Mark Little)
SqlTableGatewayListener keeps the transaction open over successive
polls
------------------------------------------------------------------------
Key: JBESB-513
URL:
http://jira.jboss.com/jira/browse/JBESB-513
Project: JBoss ESB
Issue Type: Bug
Security Level: Public(Everyone can see)
Affects Versions: 4.0
Reporter: Kevin Conner
Assigned To: Kevin Conner
Fix For: 4.2 Milestone Release 2
An examination of the SqlTableGatewayListener shows that the polling loop does not
terminate the current transaction at the end of the loop.
As the isolation layer is currently set to serializable this will result in a full table
lock on the database for the duration of the transaction.
Further, having created a prepared statement to execute the query this does not appear to
be used by the polling loop resulting in the JDBC driver parsing the scan statement for
each invocation.
There is also a possibility of a connection leak if the prepared statement creation fails
in the initialise.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://jira.jboss.com/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira