Hi

We have migrated Peag 7.1.5 PRPC from WebSphere to Tomcat, as part of installation we had migrated the DB2 database from source DB to target DB, then we installed Tomcat and configured data source to connect to the Database.

We have a few database configured under Records > SysAdmin > Database, these database have been configured to use JDBC Connection Pool and provided JNDI Name as jdbc/AIWCSRatingDB. When we do test connection for these database we get error

Test Database Connection

Status Value: Unable to obtain DataSource object: code: <none> SQLState: Name [jdbc/AIWCSRatingDB] is not bound in this Context. Unable to find [jdbc]. Message: <none>

Fail

We have checked the context.xml for the above DB and it has been configured correctly as below

<Resource name="jdbc/AIWCSRatingDB"

auth="Container"

type="javax.sql.DataSource"

username="AIWCSDEF"

password="xxxxxxx"

driverClassName="com.microsoft.sqlserver.jdbc.SQLServerDriver"

maxActive="20"

url="jdbc:sqlserver://<SQL-Hostname>:<SQL-Port>;databaseName=AIWCSRATESTST"

SelectMethod="cursor"/>

Can you please let us know what the issue might be and how to resolve ? Is it we need to configure Database configuration differently for tomcat server in the Pega console under Records > SysAdmin > Database