Support Article

prweb fails to start with "Cannot create JDBC driver"

SA-25521

Summary



Developer reported that. after installing Pega, prweb does not start.


Error Messages



SEVERE: Unable to connect to database. Will only use properties from file.
org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create JDBC driver of class '' for connect URL 'null'


Steps to Reproduce



1) Install PRPC and copy the required archives in tomcat webapps folder.
2) Start up the tomcat and access the PRPC instance.
 


Root Cause



An issue in the custom application code or rules : In user context.xml file there is no context details and user didn't created setenv.bat file in tomcat bin folder.

Resolution



Add the required context details in context.xml like below.
 
<Resource name="jdbc/PegaRULES" auth="Container" type="javax.sql.DataSource" driverClassName="driverClassName" url="jdbc:oracle:thin:@host:port:dbname" username="userName"password="password"maxActive="100"maxIdle="30"maxWait="10000"/>

<Environment name="url/initialization/explicittempdir" value="path" type="java.lang.String" />

After the above change there is no exception in the logs but PRPC is not opening because of less memory resources so create setenv.bat with the below configuration and place in tomcat bin folder.
 
set JAVA_OPTS=-Xms2048m -Xmx4096m -XX:PermSize=64m -XX:MaxPermSize=512m -Djava.awt.headless=true -verbose:gc -XX:+PrintGCDetails -XX:+PrintGCTimeStamps -Xloggc:gc.log
 

 

Published July 12, 2016 - Updated July 29, 2016

Have a question? Get answers now.

Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.