SQL Statement on JDBC Adapter

[former_member604483]

Hi all,

how can I see the SQL Statement which is made by the JDBC Adapter.

I have createt the XML Structure, but I want to know how PI (7.11) transformed the XML to SQL.

How can I trace the JDBC Adapter? Which configuration is neccessary? Where can I find the trace?

Thanks very much for your help!

Jürgen

[Former Member]

Hi Jurgan,

If u want check sql statement structure in JDBC reciever adapter u have to add one parameter

logSQLStatement and its value is true in Adavanced mode.It will display the sql statement struture in Auditlog in RWB messages.

Thanks

Ravi

[former_member604483]

Hi all,

thx very much for your help.

I have added the parameter logSQLStatement but I can't find the sql statement.

In the log Configuration Java I set the severity for AuditLog and for JDBC to DEBUG.

Any idea?

Thx!

Jürgen

[Former Member]

Hi,

I believe you are checking in auditlog for channel. Is the channel running in healthy state? and are you able to see it as green in communication channel monitoring.

Regards,

Gautam Purohit

[Former Member]

Please check it in Audit log of message (RWB -> Message monitoring)

[former_member604483]

Hi,

this is my Auditlog

Audit-Protokoll für Message: caded0e4-b287-1def-92a9-907432c01001

Zeitstempel Typ Beschreibung

2010-04-16 13:38:02 Information The message was successfully received by the messaging system. Protocol: XI URL: http://serv3709:52800/MessagingSystem/receive/AFW/XI Credential (User): PIISUSER

2010-04-16 13:38:02 Information Using connection JDBC_http://sap.com/xi/XI/System. Trying to put the message into the request queue.

2010-04-16 13:38:02 Information Message successfully put into the queue.

2010-04-16 13:38:02 Information The message was successfully retrieved from the request queue.

2010-04-16 13:38:02 Information The message status was set to DLNG.

2010-04-16 13:38:02 Information Delivering to channel: test_etl

2010-04-16 13:38:02 Information JDBC Adapter Receiver processing started, required QoS BestEffort

2010-04-16 13:38:02 Information JDBC Adapter Receiver Channel test_etl: processing started; party / service E_DWH.

2010-04-16 13:38:02 Information IS_RUN.MAP_SYS_LADELAUF_START.MAIN

2010-04-16 13:38:02 Information Database request processed successfully.

2010-04-16 13:38:02 Information The message was successfully delivered to the application using connection JDBC_http://sap.com/xi/XI/System.

2010-04-16 13:38:02 Information The message status was set to DLVD.

[justin_santhanam]

Jürgen,

Are you working on PI 7.1 or PI 7.0?

raj.

[former_member604483]

Yes the channel is okay

[former_member604483]

PI 7.1

[justin_santhanam]

Can you check the Exchange Profile parameter value ?

Default - Default.DatabaseSettings - com.sap.aii.util.sql.loglevel

This parameter is used to log sql-accesses performed by the software (0 = no logging, 1 = log structure of SQL statement, 2 = log values, 3 = log stacktrace)

Thanks!

[former_member604483]

Hi Raj

the value was 0. I changed the value to 1.

But I can't see the sql now.

[justin_santhanam]

Shabarish also had the same issue- I don't know if it get solved for him. Can you reply back to his thread and ask if it get resolved?

raj.

[former_member604483]

Done

[madhusudana_reddy2]

Hi,

Goto Advanced Mode--->Additional Parameter

give parameter and value as given below.

logSQLStatement true

thanks,

madhu

[Former Member]

Hi,

Inorder to see the SQL query created by the JDBC adapter.

Goto JDBC Channel Advanced Tab check Advanced Mode.

and add the parameters as logSQLStatement = true. in the table of additional parameters (Table is below Batch Mode Check Box)

Activate the changes.

You will be able to see the query in the channel auditlog.

Regards,

Gautam Purohit

[former_member200962]

Check this parameter in your JDBC channel logSQLStatement ..... this parameter even has reference on SDN....in case you want to know more.

Regards,

Abhishek.