Creating or changing a JDBC driver definition

In some cases, you might want to create a different JDBC driver connection, or change the existing driving connection. You can create or update a JDBC driver definition in your client environment.

About this task

The Big SQL service does not include a client such as IBM Data Studio. But since that client uses JDBC drivers to create connections, you can create a connection to your Big SQL service. The references in this topic to certain menu and interface options are meant as guides. The exact menu or interface might be different depending on the application that you use.

Procedure

  1. From a JDBC client application, such as IBM Data Studio, click Window > Preferences.
  2. Click Data Management > Connectivity > Driver Definitions. If the driver definition that you need is not in the list, such as IBM Big SQL JDBC Driver v3.0.0 Default, click Add.
  3. In the Specify a Driver Template and Definition Name window, specify a driver name, and display the JAR files and the properties.
    1. On the Name/Type page, select the name of the Big SQL driver template with which you want to work. If you are working with Big SQL, then select IBM Big SQL JDBC Driver v3.0.0.
    2. Type a unique name in the Driver name field, or accept the default name, which is the template name when you click on one of the Available driver templates:
    3. On the JAR List page, you can see the list of JAR files that are required by the Big SQL JDBC driver.
    4. On the Properties page, you can see the properties of the driver. The values of each of the properties can be edited. For example, if you are working with Big SQL, then on the Properties page, make sure the value of the Connection URL parameter is jdbc:db2://<localhost>:32051/bigsql. The value for <localhost> can be the actual server name of your cluster. Change the Database Name value to bigsql.
  4. Click OK to create the driver.