Not able to test connection with SQL server database
SummaryThe 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.
with JNDI Name: java:comp/env/eis/PRAdapterConnectionFactory, java.lang.ClassCastException: java.net.URL incompatible with javax.resource.cci.ConnectionFactory
java.lang.ClassCastException: java.net.URL incompatible with javax.resource.cci.ConnectionFactory
Steps to Reproduce
- Map a table using External Database class mapping.
- Execute SQL-save on the particualr external table class property.
Root CauseA defect or configuration issue in the operating environment
ResolutionHere’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