Question
Pegasystems Inc.
JP
Last activity: 28 Apr 2017 4:26 EDT
How to customize jndi name "jdbc/PegaRULES" on WebSphere
On Tomcat it is easy to customize jndi name of pega rules data source by modifying contex.xml and prconfig.xml as below.
Contex.xml
<Resource name="jdbc/PegaRULES_DEV"
auth="Container"
type="javax.sql.DataSource"
maxActive="100"
maxIdle="30"
maxWait="10000"
driverClassName="org.postgresql.Driver"
url="jdbc:postgresql://localhost:5432/postgres"
username="postgres"
password="postgres"/>
prconfig.xml
<env name="database/databases/PegaRULES/dataSource" value="java:comp/env/jdbc/PegaRULES_DEV"/>
<env name="database/databases/PegaDATA/dataSource" value="java:comp/env/jdbc/PegaRULES_DEV"/>
However, the similar approach doesn't work on Webshpere 8.5.5, any ideas? We have restarted Websphere after adding new data source with jndi name "jdbc/PegaRULES_DEV".
ERROR - Unable to obtain DataSource for java:comp/env/jdbc/PegaRULES_DEV; javax.naming.NameNotFoundExceptionHowever, the similar approach doesn't work on Webshpere 8.5.5, any ideas? We have restarted Websphere after adding new data source with jndi name "jdbc/PegaRULES_DEV"
| Caused by: com.pega.pegarules.pub.database.BadDatabaseDefinitionException: Database-BadDBDef-Missing | PegaRULES |
From: (unknown)
On Tomcat it is easy to customize jndi name of pega rules data source by modifying contex.xml and prconfig.xml as below.
Contex.xml
<Resource name="jdbc/PegaRULES_DEV"
auth="Container"
type="javax.sql.DataSource"
maxActive="100"
maxIdle="30"
maxWait="10000"
driverClassName="org.postgresql.Driver"
url="jdbc:postgresql://localhost:5432/postgres"
username="postgres"
password="postgres"/>
prconfig.xml
<env name="database/databases/PegaRULES/dataSource" value="java:comp/env/jdbc/PegaRULES_DEV"/>
<env name="database/databases/PegaDATA/dataSource" value="java:comp/env/jdbc/PegaRULES_DEV"/>
However, the similar approach doesn't work on Webshpere 8.5.5, any ideas? We have restarted Websphere after adding new data source with jndi name "jdbc/PegaRULES_DEV".
ERROR - Unable to obtain DataSource for java:comp/env/jdbc/PegaRULES_DEV; javax.naming.NameNotFoundExceptionHowever, the similar approach doesn't work on Webshpere 8.5.5, any ideas? We have restarted Websphere after adding new data source with jndi name "jdbc/PegaRULES_DEV"
| Caused by: com.pega.pegarules.pub.database.BadDatabaseDefinitionException: Database-BadDBDef-Missing | PegaRULES |
From: (unknown)
| at com.pega.pegarules.data.internal.access.DatabaseConfigurationMap.getDBConfig(DatabaseConfigurationMap.java:144) | |
| at com.pega.pegarules.data.internal.access.ConnectionManagerImpl.getDBConfig(ConnectionManagerImpl.java:2776) | |
| at com.pega.pegarules.data.internal.access.ConnectionManagerImpl.getConnection(ConnectionManagerImpl.java:1213) | |
| at com.pega.pegarules.data.internal.access.ConnectionManagerImpl.getConnection(ConnectionManagerImpl.java:1170) | |
| at com.pega.pegarules.data.internal.access.ConnectionManagerImpl.<init>(ConnectionManagerImpl.java:544) | |
| at com.pega.pegarules.data.internal.PRDataProviderImpl.getConnectionManager(PRDataProviderImpl.java:610) | |
| at com.pega.pegarules.data.internal.PRDataProviderImpl.isMultiTenantEnvironment(PRDataProviderImpl.java:1165) | |
| ... 28 more |
Pegasystems Inc.
IN
Hi,
Please check the Configuring the application server >> Creating binding identifiers section in 'PRPC-WebSphere' installation guide.
I believe, look-up should be in "prconfig/XXXXX" format.
Thanks,
Venkat
PEG
GB
It's possible that you're venturing into the unknown (certainly this isn't something that I've done before).
But I do also notice references to jdbc/PegaRULES in prpc_j2ee14_ws.ear/prbeans.war/META-INF/ejc-jar.xml
PEG
GB
Are you failing at a particular point?
I'd managed to log into mine after changing the datasource to jdbc/PegaRULES_DEV
Before deployment I'd create the above data source in Websphere.
Then modified the prpc_j2ee41_ws.ear file, changing the references to this data source in
/APP-INF/lib/prresources.jar/prbootstrap.properties
/APP-INF/lib/prresources.jar/prconfig.xml
/prweb.war/WEB-INF/ibm-web-bnd.xmi
/prweb.war/WEB-INF/web.xml
/prbeans.war/META-INF/ejb-jar.xml
Then during the deployment of the ear (Detailed deployment) when reaching the Map Resources step ensure that the relevant entries are pointing to jdbc/PegaRULES_DEV