Log end SQL statement in sql component

[T.K]

Hi

I am using servicemix 7.0.0, camel 2.16.3.

I am using camel SQL Component as below-

<to uri="sql:INSERT INTO transactions(txn_id, sender_org_unit_id, 
                                receiver_org_unit_id, doc_type_id, bp_id, 
route_id, txn_create_datetime, 
                                txn_modified_datetime, doc_id, bp_instance_id, 
technical_status_id,
source_doc, 
                                target_doc) VALUES (:#transactionID, 
:#senderID, :#receiverID,
:#docTypeID, 
                                :#bpID, :#routeID, :#createDateTime, 
:#modifiedDateTime, :#docID,
:#bpInstanceID, 
                                :#statusID, :#sourceDoc, :#targetDoc);" />

I need to log actual INSERT sql statement into servicemix log file which get
triggered after all values has been set.

I change PAX logging threshold to DEBUG, also added 

log4j.logger.org.apache.camel.component.sql=DEBUG
log4j.logger.org.apache.camel.component.sql.appender-ref=out

but no luck.

Rgds
T.K



--
View this message in context: 
http://camel.465427.n5.nabble.com/Log-end-SQL-statement-in-sql-component-tp5798079.html
Sent from the Camel - Users mailing list archive at Nabble.com.