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:
- Open the Primavera P6 Administrator.
- In the Configurations drop-down list, select your configuration.
- In the sidebar select Database.
- Select your Instance from the drop-down list.
- Expand Driver Class & URL.
- 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
- 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\libfile.
- In the Java Class field, enter the database driver class used for communicating with the database. Your options are: