Connect with JDBC

PulseUno uses a JDBC driver to connect to the database. This topic describes the format of the JDBC URL for Oracle, PostgreSQL, and Microsoft SQL Server databases.

JDBC URL for Oracle

We recommend using database service names when connecting with JDBC. The common convention is for the net service name defined in tnsnames.ora to have the same value as the database service name.

If you have named it differently, connect to an Oracle database using SQL*Plus as the system user and run the following SQL query to discover it:

Copy code 
SELECT SYS_CONTEXT('USERENV', 'SERVICE_NAME') AS database_service_name FROM DUAL;

To set the JDBC URL for the Oracle database:

  1. Open the startup.properties file in the <pulse_data>\conf directory on the PulseUno server.

    Default locations:

    Windows C:\ProgramData\OpenText\PulseUno\pulse_data\conf
    Linux /opt/opentext/pulseuno/data/pulse_data/conf

  2. Set the database.jdbcurl property to the following URL:

    jdbc:oracle:thin:@//<database-server-hostname>:<port>/<database-service-name>

    The default port is 1521, for example:

    Copy code 
    database.jdbcurl=jdbc:oracle:thin:@//dbserver.example.org:1521/dim14

Back to top

JDBC URL for PostgreSQL

For the PostgreSQL database, the port parameter in the JDBC URL is optional, and the default port is 5432.

To set the JDBC URL for the PostgreSQL database:

  1. Open the startup.properties file in the <pulse_data>\conf directory on the PulseUno server.

    Default locations:

    Windows C:\ProgramData\OpenText\PulseUno\pulse_data\conf
    Linux /opt/opentext/pulseuno/data/pulse_data/conf

  2. Set the database.jdbcurl property to the following URL:

    jdbc:postgresql://<database-server-hostname>:<optional-port-number>/<database-name>

    For example:

    Copy code 
    database.jdbcurl=jdbc:postgresql://dbserver.example.org:5432/dim14

Back to top

JDBC URL for MS SQL Server

To connect to MS SQL Server, first ensure that TCP is enabled on a fixed TCP port in SQL Server Configuration Manager.

To set the JDBC URL for MS SQL Server:

  1. Open the startup.properties file in the <pulse_data>\conf directory on the PulseUno server.

    Default locations:

    Windows C:\ProgramData\OpenText\PulseUno\pulse_data\conf
    Linux /opt/opentext/pulseuno/data/pulse_data/conf

  2. Set the database.jdbcurl property to the following URL:

    jdbc:sqlserver://<database-server-hostname>:<optional-port>;databaseName=<database-name>

    The port parameter is optional, and the default port is 1433.

    For example:

    Copy code 
    database.jdbcurl=jdbc:sqlserver://dbserver.example.org:1433;databaseName=dim14

Back to top

See also: