cancel
Showing results for 
Search instead for 
Did you mean: 

Could I see the actual SQL command for JDBC ?

Former Member
0 Kudos

If I use XML SQL in JDBC adapter, is it possible to see the actual SQL command in runtime? I think it's useful for trouble shooting.

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi,

Maybe you can look at it in adapter monitor in Runtime Workbench or old monitor for adapters: <host>:<port>/MessagingSystem/monitor/monitor.jsp

Regards,

Wojciech

Answers (3)

Answers (3)

Former Member
0 Kudos

I reference note 801367, it works.

But I think it's not the actual SQL, because the SQL command doesn't show the quotation marks.

This is the SQL command from the monitor:

UPDATE table_name SET field1=sysdate WHERE (key1=key_value)

And I add "hasQuot" tag and set to "No" (ref: /people/alessandro.berta/blog/2005/10/04/datetime-datatypes-and-oracle-database) and the result is different. But the SQL in workbench is still the same.

ps: the test database is Oracle and I use sysdate to test.

Former Member
0 Kudos

Hi-

Yes, you can. Set the following advanced parameter in your JDBC channel to true:

logSQLStatement

The SQL statement(s) will then show up in the details page (audit protocol) of the message monitor for each message.

Please see note 801367 for details.

Thanks,

J Wolff

moorthy
Active Contributor
0 Kudos

Hi,

One option is to check in the Message Monitoring->Message Display tool->Audit log

also this blog may help u-

/people/prasad.illapani/blog/2006/10/25/how-to-check-jdbc-sql-query-syntax-and-verify-the-query-results-inside-a-user-defined-function-of-the-lookup-api

Regards,

Moorthy