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


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.



Release
Yes/No
8.3.x(tick)



  1. Retrieve the latest version of 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 you would like to test the connectivity for :     
  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 :   
  8. You need to make sure to match the encryption parameters (Properties) as the customer server configuration for the Oracle server 
  9. If the above steps do not solve your issue please contact CAST Technical Support