Description

This lesson describes how to test the connection of your source and destination JDBC property files to their respective databases.


Overview

To make sure that you have defined the JDBC properties correctly so that the DMCLT can connect to the source and destination databases, you can use the GenRocket command line option to test a JDBC connection.  


Testing the JDBC Connection

To test the JDBC source connection, run the following GenRocket command:

  • genrocket -tjdbc source.config.properties.gref


To test the JDBC destination connection, run the same GenRocket command:

  • genrocket -tjdbc dest.config.properties


When the connection succeeds, the following message will be displayed:

  • Connection to the database was successful!

If the connection does not succeed, a GenRocket exception will be thrown. For example, if the name of the database is not found because the name was spelled 'junk' instead of 'alpha', the following GenRocket exception would be thrown: 

  • Exception in thread "main" com.genRocket.GenRocketException: Unkown database 'junk'

   

Move onto the next lesson >