Page 1 of 1

How do I add a new JDBC driver to GoAnywhere?

Posted: Fri Mar 06, 2009 9:04 am
by Support_Ron
While database drivers for most popular databases are shipped with GoAnywhere, occasionally you may want to connect to a database for which no pre-installed driver exists. To install a driver for a database:
  • Obtain the JDBC driver from your database vendor or driver vendor
  • Stop the GoAnywhere Service/Subsystem
  • Copy the driver files (typically shipped as one or more JAR files) to the system where GoAnywhere is installed. The location to copy is GA_INSTALL_DIR/WebRoot/WEB-INF/lib.
    If that location does not exist, use GA_INSTALL_DIR/userdata/lib
  • Restart GoAnywhere Service/Subsystem
  • Log in to GoAnywhere
  • Click on Resources
  • Click on the Database Servers in the list on the left side
  • Click on Add Database Resource
  • In the JDBC Driver field, type in the driver's class name.
    Example: com.basis.jdbc.BasisDriver
    Please refer to the JDBC driver's documentation to find the driver class.
  • In the JDBC URL field, type in the URL for that JDBC driver.
    Example:
    jdbc:basis:<server>:<port>?database=<database_name>.
    The URL format is driver dependent, so please refer to the driver's documentation to get the correct syntax or use the JDBC URL Wizard helper tool.
  • Enter the database User Name and Password for logging into the database
  • Click on Test button to see if the database connection goes through.
Click on the Save and Close Resource button to save the Resource definition. You should now be able to use this Resource in SQL Task to execute queries against the database.