Configuring Driver Class and URL for Database Instance Settings

Previous TopicNext TopicContents

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 tab, expand your configuration.
  3. Expand Database/Instance[n]/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:@xxx:yyyy:zzzz

      Microsoft SQL Server example:

      jdbc:sqlserver://xxx:yyy;database=zzz;

      Where:

      x = IP address or hostname

      y = database listen port

      z = database name or 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 if you use WebLogic, or creating a shared lib reference if you use WebSphere.

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 Database Settings

Configuring Microsoft SharePoint in the Database Instance Settings

Configuring CMIS-Compliant Content Repository in the Database Instance Settings

Configuring the Oracle Database Content Repository

Configuring Session Settings in the Database Instance Settings

Configuring Cost Based Optimization Settings in the Database Instance Settings

Configuring Eventing in the Database Instance Settings

Configuring AIA in the Database Instance Settings

Configuring Fusion Projects Settings in the Database Instance Settings

Configuring BI Publisher in the Primavera P6 Administrator

Configuring P6 to Connect to Oracle BPM



Legal Notices
Copyright © 1999, 2016, Oracle and/or its affiliates. All rights reserved.

Last Published Thursday, February 04, 2016

PDF Library