Support Article

Not able to test connection with SQL server database



The user has to connect to an external database, and is presently on Oracle DB and wanted to connect to SQL DB. The user imported the jar file at Server side and peformed the required settings but after that user is observing timeout exceptions in WAS logs. If the jar file is removed, the user is seeing classnotfound exception.

Error Messages

with JNDI Name: java:comp/env/eis/PRAdapterConnectionFactory, java.lang.ClassCastException: incompatible with javax.resource.cci.ConnectionFactory
java.lang.ClassCastException: incompatible with javax.resource.cci.ConnectionFactory

Steps to Reproduce

  1. Map a table using External Database class mapping.
  2. Execute SQL-save on the particualr external table class property.

Root Cause

A defect or configuration issue in the operating environment 


Here’s the explanation for the reported behavior: 

 Kindly mention the below configuration in the prconfig.xml file and try to save the configuration.
<env name="database/databases/PegaRULES/dataSource" value="‘jdbc/DBName"/>

Published November 15, 2016 - Updated December 3, 2016

Have a question? Get answers now.

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