on 11-07-2006 8:03 PM
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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.