You are here: Pega Platform database > Database tables and columns > Property optimization > Column Populator database properties

Column Populator database properties

The database properties for the Column Populator are set in the prpcUtils.properties file.

Property

Description

pega.jdbc.driver.jar

The full path to the JDBC driver file for your database:

Oracle : ojdbc#.jar where # indicates the Java version. Note that Java 7 and Java 8 both use the ojdbc7.jar file.

DB/2 UDB: db2jcc.jar (universal driver)

SQL Server: sqljdbc4.jar for Java versions 6, 7, and 8.

PostgreSQL: postgresql-#.jdbc4.jar where # indicates the PostgresSQLversion.

pega.jdbc.driver.class

The class name of the JDBC driver for your database:

Oracle 10g/11g: oracle.jdbc.OracleDriver
IBM DB/2 Type 4: com.ibm.db2.jcc.DB2Driver
SQL Server 2005, 2008: com.microsoft.sqlserver.jdbc.SQLServerDriver

PostgreSQL: org.postgresql.Driver

pega.database.type

The type of database:

Oracle 10g/11g: oracledate
DB/2 UDB: udb
SQL Server 2005, 2008: mssql

PostgreSQL: postgres

pega.jdbc.url

The connection URL for your database, for example:

Oracle : jdbc:oracle:thin:@//serverName:1521/service-name-or-SID

DB/2 UDB: jdbc:db2://serverName:port/dbName

SQL Server 2005, 2008:
jdbc:sqlserver://serverName:1433; databaseName=your-DBname;SelectMethod=cursor; SendStringParametersAsUnicode=false;

Include the SelectMethod and SendStringParametersAsUnicode parameters for SQL Server.

 

PostgreSQL: jdbc:postgresql://localhost:5432/dbName

pega.jdbc.username
pega.jdbc.password

The user name and password to use when connecting to your database.