Need Help on JDBC Adapter

[Former Member]

Hi,

This is regarding the scenerio where I have SAP[Proxy]--->XI--

---

>SQL

I have an communication channel in XI which is connected to SQL server using JDBC Adapter in which we have

Transport Protocol : JDBC 2.0

Message Protocpl : XML SQL Format

And also with other parameter values.Now I need to know when XI Call this communication I have one stored procedure at SQL side getting executed which is responsible to enter the records in SQL .

How will be I able to see this SQL message calling the stored procedure of SQL

in SXMB_MONI at XI side.

Thanks

Sudharshan

[agasthuri_doss]

Hi,

This will help you

http://help.sap.com/saphelp_nw04/helpdata/en/64/ce4e886334ec4ea7c2712e11cc567c/frameset.htm

Regards

Agasthuri Doss

[justin_santhanam]

Sudharshan,

Try logSQLStatement from SAP note 801367

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

Best regards,

raj.

[Former Member]

Hey

can you please explain your requirement a bit more,do you some issue with monitoring or something else?

anyways have a look at the following scenario

/people/siva.maranani/blog/2005/05/21/jdbc-stored-procedures

Thanx

Ahmad