webMethods

HI experts,

Could someone please guide , is there a option to fetch all the JDBC connection details. I am working for some DB related activity, so i need to collect all the DB user details. But its taking too much of time to open the every connection and collecting the details

Best Regards
K M, Varun

Hi Varun,

please check the IS Built-In-Services Reference for your IS version for the ART-Folder.
This one contains services to list all connections and then to get their details (except password for security reasons).

Regards,
Holger

Hi ,

Thanks for the response. What should be the input for that service , I have tried with the adapter name , but the result is null. Also i tried with the String as input , same result as Null .
Please assist me .

https://higherlogicdownload.s3.amazonaws.com/IMWUC/webMethods/Files3/5e79269ad370b28043989e19359aa39774c9e8e9_2_888x750.jpeg 1.5x, https://higherlogicdownload.s3.amazonaws.com/IMWUC/webMethods/Files3/5e79269ad370b28043989e19359aa39774c9e8e9_2_1184x1000.jpeg 2x" data-dominant-color="F0F2F5">

image1588×1340 113 KB

If you are on 10.7 or newer version of IS, please have a look @ REST Admin API. You can get underlying Swagger doc by invoking http://localhost:5555/admin/swagger/integrationServer. Please have a look @ /admin/jdbc/pool/ resource.

Use the service “pub.art:listRegisteredAdapters” to list all the available adapter types.
That way you can copy/paste the one you want.
regards,
John.

But it wont list the JDBC adapter connections … it fetched juts type of connections like JDBC and SAP

https://higherlogicdownload.s3.amazonaws.com/IMWUC/webMethods/Files3/bcaa7acaf2ccedd36a36be7f0aad78c7b04eb5e6_2_1035x174.jpeg 1.5x, https://higherlogicdownload.s3.amazonaws.com/IMWUC/webMethods/Files3/bcaa7acaf2ccedd36a36be7f0aad78c7b04eb5e6_2_1380x232.jpeg 2x" data-dominant-color="DEE5F1">

image2174×368 112 KB

Best Regards
K M, Varun

Note that your listAdapterServices’ input is “adapterTypeName”, which is the type of the adapter - SAP or JDBC, etc. Each type has a specific keyword, which is what John pointed you to.

You take the output of listRegisteredAdapters (which provides you the keywords of the types that are available on your IS, viz., “WmSAP” or “JDBCAdapter”) and use in the listAdapterServices service as input. You will now get the list of all adapters for that type, i.e., SAP or JDBC.

KM