Question
MOving from WebSphere to tomcat for PRPC 7.1.5
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
Hi Murtuza,
In tomcat, JNDI name should be java:comp/env/jdbc/DBName. Update your JNDI name in the database rule as java:comp/env/jdbc/AIWCSRatingDB.
It should be fine.