Question

4
Replies
179
Views
vinodm61 Member since 2017 2 posts
Toronto-Dominion Bank
Posted: March 11, 2019
Last activity: March 12, 2019
Closed

BIX 7.2.1 SQLState 08001, Error code 0: java.sql.SQLException: No suitable driver found for

Hi,

We are facing an issue in PAT BIX server, when ever we tried to run a BIX script it is throwing below error and we are not able to connect to database to run the BIX rule.

java] com.pega.pegarules.pub.database.ConnectionException: Database-GeneralProblem encountered when getting connection for database pegarules008001No suitable driver found for jdbc:oracle:thin:@

[java] From: (unknown)
[java] Caused by SQL Problems.
[java] Problem #1, SQLState 08001, Error code 0: java.sql.SQLException: No suitable driver found for jdbc:oracle:thin:@
[java] at com.pega.pegarules.data.internal.access.ExceptionInformation.createExceptionDueToDBFailure(ExceptionInformation.java:157)
[java] at com.pega.pegarules.data.internal.access.ConnectionManagerImpl.getConnection(ConnectionManagerImpl.java:1308)
[java] at com.pega.pegarules.data.internal.access.ConnectionManagerImpl.getConnection(ConnectionManagerImpl.java:937)
[java] at com.pega.pegarules.data.internal.access.ConnectionManagerImpl.rebuildDBNameDefinitions(ConnectionManagerImpl.java:2206)
[java] at com.pega.pegarules.data.internal.access.ConnectionManagerImpl.<init>(ConnectionManagerImpl.java:593)
[java] at com.pega.pegarules.data.internal.access.ConnectionManagerImpl.getInstance(ConnectionManagerImpl.java:713)
[java] at com.pega.pegarules.data.internal.access.ExtractImpl.<init>(ExtractImpl.java:411)
[java] at com.pega.pegarules.data.internal.access.ExtractImpl.main(ExtractImpl.java:755)
[java] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
[java] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
[java] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
[java] at java.lang.reflect.Method.invoke(Method.java:606)
[java] at com.pega.pegarules.internal.bootstrap.PRBootstrap.invokeMethod(PRBootstrap.java:312)
[java] at com.pega.pegarules.internal.bootstrap.PRBootstrap.invokeMethodPropagatingThrowable(PRBootstrap.java:353)
[java] at com.pega.pegarules.internal.bootstrap.PRBootstrap.invokeMethod(PRBootstrap.java:402)
[java] at com.pega.pegarules.pub.PegaRULES.main(PegaRULES.java:88)
[java] Caused by: java.sql.SQLException: No suitable driver found for jdbc:oracle:thin:@//
[java] at java.sql.DriverManager.getConnection(DriverManager.java:596)
[java] at java.sql.DriverManager.getConnection(DriverManager.java:215)
[java] at com.pega.pegarules.data.internal.access.ConnectionManagerImpl.getConnection(ConnectionManagerImpl.java:1104)
[java] ... 14 more
We have given correct jdbc connection(removed from above error log). Below are Few observations 1. we are setting a oracle_HOME path in one of the script. it is not present in dev environment.
2. Ojdbc7.jar file was present in the directory mentioned to include. Along with below files jar file there are lot of jar files which were imported from legacy version (5.5). Currently we are using 7.2.1 version(BIX - 07-10-25).
ojdbc7.jar
jsr94-1.0.jar
prbootstrap.jar
prdbcp.jar
prbootstrap-api.jar
Thanks in Advance,
Vinod.
Low-Code App Development Reporting Low-Code App Development Installation and Deployment
Moderation Team has archived post
Share this page LinkedIn