- Download the JDBC driver from http://www.basis.com
- Copy the BBjJDBC.jar to the system where GoAnywhere is installed. The location to copy is GA_INSTALL_DIR/WebRoot/WEB-INF/lib.
- Restart GoAnywhere Service/Subsystem
- Log in to GoAnywhere
- Add/Edit a Database Resource
- In the JDBC Driver field, type com.basis.jdbc.BasisDriver
- In the JDBC URL field, type jdbc:basis:<server>:<port>?database=<database_name>. Substitute <server> with the host name or IP address of the Pro/5 database server. Substitute <port> with the port number on which the Pro/5 database server is listening. Substitute <database_name> with the database that you would like to connect.
- Enter the database login in the User Name and Password fields.
- Click on Test button to see if the database connection goes through.
The BBj JDBC Driverimplementation of the Java.SQL.Driver interface is as follows:
In order to have access to the com.basis.jdbc.BasisDriver class, the CLASSPATH environment variable must include the location of the BBjJDBC.jar file. This file is located in the <bbj install>/lib directory.
To make a connection to the JDBC driver, use a connect string in the following format:
The important properties that can be specified are as follows:
- database=<database_name> Database on the BBj SQL server to open. The database name must be provided
- user=<user_name> Specify a BBj SQL user to open the database.
- pwd=<password> Specify a BBj SQL password for the provided user to authenticate with.
- ssl=<true or false> BBj 4.0 and higher, indicate whether the BBj SQL server is running using SSL. If this property is set to "true", the server must be using SSL in order to connect. Alternately, if this property is set to "false", the client will be unable to connect to a server that is using SSL. This is to ensure that the user knows whether or not the connection to the BBj SQL server is secure.
- keystore=<keystore> BBj 4.0 and higher, this is entirely optional. If a user wants to specify their own SSL keys and authentication connecting to the BBj SQL server this property indicates where the keystore is to be found. If this parameter is not specified, the default keystore is used.
- keypass=<keystore pwd> BBj 4.0 and higher, this is entirely optional. If a user has specified their own keystore, they must provide the appropriate keystore password. If this parameter is not specified, the keystore password for the default keystore is used.
For example, to connect to the sample Chile Company database that is installed with the BASIS DBMS located on a machine called "myserver," use the following connect string:
Note that if the port is omitted, the default port of 2001 is used.
// Load the Driver implementation into memory
// Establish a connection to the ChileCompany database
Connection con =
For information about using a JDBC driver in a third party JDBC application, refer to the third party documentation.
For additional information on the JDBC API and how it works, visit the Sun Java Web site at http://java.sun.com.
- Support Specialist
- Posts: 66
- Joined: Thu Mar 05, 2009 3:49 pm
Who is online
Users browsing this forum: No registered users and 0 guests