How do I add a new JDBC driver to GoAnywhere?
Posted: Fri Mar 06, 2009 9:04 am
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.