We have created one Datasource in Websphere and configured the database in Pega as "use JDBC connection pool", mentioned the jndi name in the JDBC Datasource settings. The test connectivity is good and we are able to insert the record in the Database.
But while running campaign and saving data through DBTemplate we are facing issue like not able to connect to external database with this configuration.
After changing the Pega database configuration as "How to connect" to JDBC URL and mentioning the JDBC URL, Username and Password in the Pega Database the DBTemplate connection is not coming.
Can anybody suggest if for the 1st scenario do we have to configure anything more to connect DBTemplate with the external database.