Page tree
Skip to end of metadata
Go to start of metadata
Purpose

This page provides information about how to run the JDBC tester to check whether the jdbc connection is working.

When to use the tool

We can use this tool when a connection to a database server is failing either in CAST MS when attempting to connect to a management database or Delivery Manager Tool when extracting a database.

Applicable in CAST Version
Release
Yes/No
8.2.x(tick)
8.1.x(tick)
8.0.x(tick)
7.3.x(tick)
Notes/comments
  1. Retrieve the JDBC Tester Tool in : \\Productfs01\Engbuild\ExtraBuilds\Tools\CAST-JDBCTester

  2. Execute the jdbc tester by executing the CAST-JDBCTesterGUI.jar. It will open the JDBC Tester GUI as shown below :
  3. Select the advanced mode : click View and select Advanced mode as shown below :


  4. Select the JDBC Driver :
    1. Either you select the oracle.jdbc.Oracledriver if you are facing issue to connect to oracle server.
    2. or you select com.microsoft.sqlserver.jdbc.SQLServerDriver if you are facing issues to connect to SQL Server database server.
  5. Once you have selected the JDBC driver, fill the credential : the Server URL, the user name and the password as shown below:


  6. In the advanced tab, put a query to be run by the jdbc connector as shown below :


  7. Then, click Run and check the connection log file as shown below :
Related Pages


  • No labels