JDBC Adapter debugging

[Former Member]

Hi evrybody!

I can't remember the config setting I have to activate in order to see the actual SQL commands generated by the JDBC adapter... Could you please tell me, how to switch on this setting?

Regards, Joerg

[prateek · Accepted solution]

Try logSQLStatement from SAP note 801367

Also check this out

/people/david.beisert/blog/2005/07/04/tracing-jdbc-statements-through-sqltrace

Regards,

Prateek

[Former Member · Accepted solution]

Hi,

Thank you, but that is not quite what I was looking for. I remember there is some (advanced) setting the JDBC adapter configuration whith which I can turn on the debugging in adapter monitoring. I just don't remember what it is...

Thanks, though!

Regards, Joerg

[prateek · Accepted solution]

<i>to see the actual SQL commands</i>

For this i think logSQLStatement statement is sufficient

Regards,

Prateek

[Former Member · Accepted solution]

Hi,

Advanced Tab Page

Adapter-Specific Message Properties

· To store adapter attributes in the message header of the XI message, select Set Adapter-Specific Message Properties.

· To apply the following attributes in XI message headers, set the corresponding indicators:

Name

Technical Name

JMS Message Correlation ID

DCJMSCorreleationID

JMS Message Delivery Mode

DCJMSDeliveryMode

JMS Message Destination

DCJMSDestination

JMS Message Expiration

DCJMSExpiration

JMS Message ID

DCJMSMessageID

JMS Message Priority

DCJMSPriority

JMS Message Redelivered Flag

DCJMSRedelivered

JMS Message ReplyTo Destination

DCJMSReplyTo

JMS Message Time Stamp

DCJMSTimestamp

JMS Message Type

DCJMSType

Used JMS Message Selector

DCJMSMessageSelector

Used JMS Message Queue

DCJMSMessageQueue

JMS User

DCJMSUser

· If you want to set additional JMS message attributes, select Specify Additional JMS Message Properties (10 Maximum).

· In the table, enter the names of the JMS message properties whose values are to be included in the message header of the XI message.

The technical names of the additional attributes are DCJMSMessageProperty0, DCJMSMessageProperty1, ..., DCJMSMessageProperty9.

You can enter more than 10 properties in the table, but only the first 10 are taken into account.

The attribute namespace for the adapter is http://sap.com/xi/XI/System/JMS.

Adapter Status

Set the adapter to Active to enable messages to be exchanged.

Additional Parameters

To make additional settings or replace the default settings, enter the parameters and values in the table.

You can set the following parameters, for example:

Name

Value

JMSMessageClass

com.ibm.jms.JMSMessage

JMS.Message.method.setStringProperty

java.lang.String XAppId, java.lang.String myapp

You can set additional JMS parameters for all JMS providers.

Or go through

http://help.sap.com/saphelp_nw04/helpdata/en/0f/80243b4a66ae0ce10000000a11402f/frameset.htm

Regards

Hemant

Award points if find helpful

[justin_santhanam · Accepted solution]

Joerg,

See whether its helps u !!!

Parameter name: "logSQLStatement"

Parameter type: boolean

Parameter value: true for any string value, false only for empty string

Parameter value default: false (empty String)

Available with: SP9

Category: 2

Description:

When implementing a scenario with the JDBC receiver adapter, it may be helpful to see which SQL statement is generated by the JDBC adapter from the XI message content for error analysis. Before SP9, this can only be found in the trace of the JDBC adapter if trace level DEBUG is activated. With SP9, the generated SQL statement will be shown in the details page (audit protocol) of the message monitor for each message directly.

Best regards,

raj.

[Former Member · Accepted solution]

Hi everybody,

Sorry - I missed the reference to OSS note for logSQLStatement. That was already what I was looking for.

Thank you,

Joerg

[Former Member]

Dear Joerg,

Go through this blog by Bhavesh

/people/bhavesh.kantilal/blog/2006/07/03/jdbc-receiver-adapter--synchronous-select-150-step-by-step

Go through this link which talks about Document Formats for the Receiver JDBC Adapter

http://help.sap.com/saphelp_nw04/helpdata/en/2e/96fd3f2d14e869e10000000a155106/content.htm

Regards

Srikanth

[Former Member]

Joerg,

I think there are no specific settings. But in mapping you have to have like mentioned in this help:

http://help.sap.com/saphelp_nw04/helpdata/en/2e/96fd3f2d14e869e10000000a155106/content.htm

---Satish