Knowledge Base

Verifying Database Connectivity

KB1229 - Jul 17, 2018

Type: Problem

Description: How to troubleshoot issues occurring when querying a database with Monitoring Studio's Database Query Analysis feature.

Additional Keywords: Database Query, Matsya

Related Topics


This article explains the procedure to follow if you encounter issues while querying your database using Monitoring Studio's Database Query Analysis feature.


To connect to the database and execute the query, Monitoring Studio v9.4 and higher uses the SEN_MS_matsya-module-jdbc.jar file located in PATROL_HOME\bin. If you are unable to query the database, manually run SEN_MS_matsya-module-jdbc.jar on the PATROL agent as described below:

C:\BMCSOF~1\Patrol3\bin>java -jar SEN_MS_matsya-module-jdbc.jar SEN_MS_matsya-module-jdbc.jar: Error: You must specify a SQL statement to be executed

Usage: java -jar SEN_MS_matsya-module-jdbc.jar <JDBC URL> <-username:<username>> <"SQL statement"> [options...]


  • <JDBC URL> is the JDBC URL to connect to the database (see examples below)
  • <username> is the user login used to connect to the database
  • <"SQL statement"> is the SQL statement to be executed by the database


  • password:<password> to specify the password on the command line (not recommended)
  • driver:<driverClass> to specify the class of the driver to load to perform the JDBC query
  • colsep:<column separator> to specify the char used to separate columns in the result (default: ';')
  • showWarnings:<yes|no> to get the PRINT messages and warnings in the result (default: YES)
  • timeout:<timeout> to specify the timeout in seconds


* Oracle *

Using Database Name

java -jar SEN_MS_matsya-module-jdbc.jar jdbc:oracle:thin:@hostname:1521:databaseName -username:admin "SELECT table_name FROM all_tables"

Using Service Name

java -jar SEN_MS_matsya-module-jdbc.jar jdbc:oracle:thin:@hostname:1521/serviceName -username:admin "SELECT table_name FROM all_tables"


C:\BMCSOF~1\Patrol3\bin>java -jar SEN_MS_matsya-module-jdbc.jar jdbc:oracle:thin:@portal-29:1521:BMCPDS -username:pe "SELECT * from event"
  pe's password:

* Microsoft SQL Server *

java -jar SEN_MS_matsya-module-jdbc.jar jdbc:jtds:sqlserver://hostname/master;instance=instanceName -username:admin "SELECT * FROM sysdatabases"

* PostgreSQL *

java -jar SEN_MS_matsya-module-jdbc.jar jdbc:postgresql://hostname:5432/postgres -username:admin "SELECT datname FROM pg_database;"

* MySQL *

java -jar SEN_MS_matsya-module-jdbc.jar jdbc:mysql://hostname:3306/mysql -username:admin "SELECT user From user;"