Posted: 17 Jan 2018 16:19 EST Last activity: 6 Feb 2018 15:09 EST
External Datasource definition PRPC 7.2.1 and Tomcat
We are migrating from WAS to Tomcat.
In WAS, we define external datasources within the WAS console and we have corresponding definitions within PRPC making use of the "use jdbc Connection Pool" as the means to connect. This works great.
In Tomcat, we have left the PRPC definitions as is. I have also defined the external db in the conf/context.xml file. I have also added a "resource-ref" definition to the web.xml file for prweb. However, I get the following message when clicking "Test Connection" in the PRPC database definition:
Status Value: Unable to obtain DataSource object: code: <none> SQLState: Name [jdbc/EstateSettlement] is not bound in this Context. Unable to find [jdbc]. Message: <none> DatabaseException caused by prior exception: javax.naming.NameNotFoundException: Name [jdbc/EstateSettlement] is not bound in this Context. Unable to find [jdbc].
Thoughts on what I am doing wrong? Below are the entries in context.xml and web.xml:
Thanks Sriva. I did open an SR on this topic and was provided with information that the Database definition within PRPC differs between WAS and Tomcat. In WAS, we used jdbc/EstateSettlement. In Tomcat, we need to use java:comp/env/jdbc/EstateSettlement in order to get it to work.