Installing JDBC Driver - discovery - 23.1

Spectrum Discovery Guide

Product type
Software
Portfolio
Verify
Product family
Spectrum
Product
Spectrum > Discovery
Version
23.1
Language
English
Product name
Spectrum Discovery
Title
Spectrum Discovery Guide
Topic type
How Do I
Overview
Reference
First publish date
2007
ft:lastEdition
2024-02-07
ft:lastPublication
2024-02-07T17:21:58.768552

Use these steps to download the JDBC driver, install it, and create connection to the model store.

  1. On the Spectrum Technology Platform welcome page, click Platform Client Tools. In the options on the right pane, expand the Driver cascading menu, and click the Download Jar button for JDBC Driver.
  2. Save the modelstore-jdbc.jar file in the default browser directory.
    Note: You do not need to restart the server.

Once the JDBC driver is installed, use these details to connect to the Spectrum server using a simple code or any application:

  1. Spectrum user name
  2. Password to authenticate the Spectrum user name
  3. JDBC Driver Class Name = com.pb.spectrum.modelstore.driver.modelstoreDriver
  4. Connection String Template = jdbc:spectrum://${host}:${port}/${modelstore}.
    Fill in the server IP or machine name in place of {host}, the port for Spectrum Discovery in {port}, and the name of the model store you wish to access in {modelstore}.
    Note: Default for {port} is 32750.
  5. To access model store in the SSL mode, set the property sslEnabled to true.
    Note: If this property is not defined or is set to false, the driver will connect in non-SSL mode.
    1. For a one-way SSL connection, define these properties:
      • trustStore: Location of a truststore containing server public key. The private key will be in server’s keystore.
      • trustStorePassword: Truststore password encrypted using Spectrum's password-utility that was shipped along.
        Note: For details on how to use the password utility, see Generate encryption strings.
    2. For a two-way SSL connection, specify these two additional properties.
      • keystore: Location of keystore containing client’s private key. The public key needs to be added to server’s truststore.
      • keystorePassword: Keystore password encrypted using Spectrum's password-utility that was shipped along.
        Note: For details on how to use the password utility, see Generate encryption strings.
  6. Configure these optional properties:
    1. keyStoreType: Type of keystore. For example, JKS and PKCS12.
    2. trustAllHosts: Set this as true to allow client to trust all server certificates. Default is false.
    3. checkExpired: Set this as false to ignore checking if the server certificates have expired. Defaults is true.

You can now connect to any desired model store.