How to execute SQL commands from java application servers

[former_member585196]

HI ,

We have doing application DB performance testing and got one requirement to test some querys from NW java application servers.

We are checking what are different ways to execute sql commands from NW java application server directly.

Please suggest

Thanks, Subhash .G

[oppancs · Accepted solution]

Dear Subhash,

I deem you are looking for an option to execute SQL queries using Open SQL/JDBC in the Persistence Layer. Please check the followings:

Regarding 7.0X systems:

https://help.sap.com/doc/saphelp_nw70ehp1/7.01.16/en-US/57/1177611c11cd418564cdbc1488ce33/frameset.h...

https://help.sap.com/saphelp_nw70/helpdata/en/ba/e7a1c1bc208c4bbb41b0bd20b066db/frameset.htm

Regarding 7.1 or higher systems:

https://help.sap.com/saphelp_nw73ehp1/helpdata/de/4a/9eac69f2d9388fe10000000a42189c/frameset.htm

https://help.sap.com/saphelp_nw73ehp1/helpdata/de/4a/9fe706952b6c3de10000000a42189c/frameset.htm

Here in these SAP Help pages you can find other type db query options as well based on your requirements.

Best Regards,
Barnabás

[hemanth2]

Hi Subhash,

Hope you are doing good.

To me it looks like you need some functionality similar to /nST05 or DBACOCKPIT commands on an ABAP stack where the Basis Admin you can write the statement on the server itself and it gets executed in the backend DB. Unfortunately there is no such option on the Java stack.

You need to get in touch with a developer and execute persistence layer traces as Barnabas mentioned earlier.

Hope this helps.

_ _ _ _ _ _ _ __ _ _

Kind Regards, Hemanth Kumar | SAP Product Support