DX Application Performance Management

Expand all | Collapse all

java SQL statement

Jump to Best Answer
  • 1.  java SQL statement

    Posted 01-26-2015 05:02 PM

    Need help SQL syntax for JAVA programming for Introscope. I can run the following statement successfully:

         select * from metric_data

    but if I add a where clause, I can't run it successful, even with the following:

         select * from metric_data where agent='.*'


    Any guidance to syntax is appreciated.


  • 2.  Re: java SQL statement

    Posted 01-26-2015 05:11 PM



    Are you looking to tie Introscope to the API Gateway product or are you looking for Introscope support?

  • 3.  Re: java SQL statement

    Posted 01-26-2015 05:15 PM

    Thank you Stephen for your quick view.

    I am looking for pulling Introscope data through JAVA. Or if there’s another simpler method to pull Introscope data in CSV format or any other readable format programmatically.



  • 4.  Re: java SQL statement

    Posted 01-26-2015 05:22 PM



    We will need to move this to the Introscope team community part as this community area is for API Management.

  • 5.  Re: java SQL statement

    Posted 01-26-2015 05:24 PM

    Pardon my ignorance. Yes, please move it but please let me know the URL for it to follow up.




  • 6.  Re: java SQL statement

    Posted 01-26-2015 05:27 PM



    The communities.ca.com site is for all CA product so we are just aligning it within the community site to the right product group.

  • 7.  Re: java SQL statement
    Best Answer

    Posted 01-26-2015 09:59 PM

    Dear Jalal,

    Please look at below posts that should help you



    Also pls refer to APM Configuration Guide for information on JDBC API and it's usage as well as APM API Reference for other ways for e.g using Webservice API to query for APM data.



    Kulbir Nijjer

    CA Support.

  • 8.  Re: java SQL statement

    Posted 01-27-2015 11:20 AM

    Thank you Kulbir!

    The articles are very helpful. I found my mistake in the syntax (RegEx).