How do I connect to a Pro/5 database

View some of the Frequently Asked Questions to our support staff. Included are some tips and tricks making this forum ideal for users getting started with GoAnywhere Director. Note: Users can reply to existing topics but only our support staff can add new topics to this forum.

How do I connect to a Pro/5 database

Postby Support_Duane » Mon Mar 09, 2009 11:34 am

  • 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.
Once the resource is setup, create projects using the resource to read/write data to the database.

Driver Class
The BBj JDBC Driverimplementation of the Java.SQL.Driver interface is as follows:
com.basis.jdbc.BasisDriver
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.

Connection URL
To make a connection to the JDBC driver, use a connect string in the following format:
jdbc:basis:<server>:<port>?database=<database_name>&user=<user_name>&pwd=<password>
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:
jdbc:basis:myserver?database=ChileCompany&user=admin&pwd=admin123

Note that if the port is omitted, the default port of 2001 is used.

Example
...
// Load the Driver implementation into memory
Class.forName("com.basis.jdbc.BasisDriver");
// Establish a connection to the ChileCompany database
Connection con =
DriverManager.getConnection("jdbc:basis:myserver?database=ChileCompany",
"admin",
"admin123");
...

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_Duane
Support Specialist
 
Posts: 65
Joined: Thu Mar 05, 2009 3:49 pm

Return to Knowledge Center

Who is online

Users browsing this forum: No registered users and 1 guest