Bug 808529

Summary: org.jboss.soa.esb.listeners.gateway.SqlTableGatewayListener class needs to log DEBUG statements
Product: [JBoss] JBoss Enterprise SOA Platform 5 Reporter: Taneem Ibrahim <tibrahim>
Component: JBossESBAssignee: Kevin Conner <kevin.conner>
Status: VERIFIED --- QA Contact: Jiri Pechanec <jpechane>
Severity: medium Docs Contact:
Priority: medium    
Version: 5.3.0 GACC: jpechane, kejohnso, ldimaggi, rwagner, soa-p-jira, tcunning
Target Milestone: ER4   
Target Release: 5.3.0 GA   
Hardware: All   
OS: All   
Whiteboard:
Fixed In Version: Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 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 Taneem Ibrahim 2012-03-30 15:48:16 UTC 
Description of problem:

SqlTableGatewayListener class in general has virtually not enough debug statements for trouble shooting when a problem arises. Recently we ran into an issue with the SQL that was built by SqlTableGatewayListener. Since there was no debug logging on the sql that got built, we had to use byteman scripts to figure out the SQL. 

The following three methods should at least log the SQL that it built before returning from the method.

protected String scanStatement();
protected String updateStatement();
protected String deleteStatement();

Version-Release number of selected component (if applicable):
JBossESB 4.10

How reproducible:
Does not apply.

Steps to Reproduce:
Does not apply.
Comment 1 Rick Wagner 2012-03-30 15:51:45 UTC 
GSS prioritizes this 'medium'.  This should be a very fast / low risk change, it would be nice to have it in SOA-P 5.3 if possible.
Comment 2 JBoss JIRA Server 2012-05-30 19:26:13 UTC 
Tom Cunningham <tcunning> updated the status of jira JBESB-3803 to Resolved
Comment 3 JBoss JIRA Server 2012-05-30 19:26:30 UTC 
Tom Cunningham <tcunning> updated the status of jira JBESB-3803 to Closed
Comment 4 JBoss JIRA Server 2012-05-30 19:26:30 UTC 
Tom Cunningham <tcunning> made a comment on jira JBESB-3803

Added debug statements to scan/update/deleteStatement.
Comment 5 Suz 2012-06-13 02:55:57 UTC 
I have set the technical note field to negative as this appears to have been detected and fixed in the same version, so users will not have seen it.
Comment 6 Jiri Pechanec 2012-06-27 07:39:05 UTC 
Verified in ER4