Configuring Driver Class and URL for Database Instance Settings

The Driver Class and URL settings are where you configure the Java class and database URL that will connect to P6 EPPM.

To set your Driver Class and URL settings:

  1. Open the Primavera P6 Administrator.
  2. In the Configurations drop-down list, select your configuration.
  3. In the sidebar select Database.
  4. Select your Instance from the drop-down list.
  5. Expand Driver Class & URL.
    1. In the Java Class field, enter the database driver class used for communicating with the database. Your options are:
      • oracle.jdbc.driver.OracleDriver
      • com.microsoft.sqlserver.jdbc.SQLServerDriver
    2. In the URL field, enter the database URL used to establish a connection to the P6 EPPM database.

      Oracle example:

      jdbc:oracle:thin:@<Host_Name>:<Database_Port>:<Database_Name>

      Microsoft SQL Server example:

      jdbc:sqlserver://<Host_Name>:<Database_Port>;database=<Database_SID>;

      Notes:

      • If you upgrade your database and this database connection gets disconnected, you can right-click on the Driver Class & URL node to reconfigure your database connection. When you right-click on the node, click Configure and the Configure URL dialog box will appear.
      • You can also define a custom Oracle/MSSQL driver class from the Configure URL dialog box. The jar file for your custom driver class should exist in the application server classpath. Oracle recommends copying the driver jar file to the <WebLogic_Home>\user_projects\domains\your_domain\lib file.

Related Topics

About Database Instance Settings

Configuring User Security for Database Instance Settings

Configuring Connection Pool for Database Instance Settings

Configuring Oracle WebCenter Content Core Capabilities (WCCC) in the Database Instance Settings

Configuring the Oracle Database Content Repository

Configuring CMIS-Compliant Content Repository in the Database Instance Settings

Configuring Session Settings in the Database Instance Settings

Configuring Cost Based Optimization Settings in the Database Instance Settings

Configuring Oracle Analytics Server in the Primavera P6 Administrator

Configuring P6 to Connect to Oracle BPM

Configuring Import/Export Options (Scheduled Service)



Legal Notices | Your Privacy Rights
Copyright © 1999, 2023

Last Published Thursday, January 12, 2023