Login Fails due to PoolableConnectionFactory Error

Problem Symptoms

In /m1/voyager/xxxdb/tomcat/logs/catalina.out:

Aug 22, 2014 3:29:27 PM org.apache.catalina.core.StandardWrapperValve invoke SEVERE: Servlet.service() for servlet [AuthenticatePatronService] in context with path [/vxws] threw exception [Servlet execution threw an exception] with root cause

java.lang.IllegalStateException: jdbc/voyager Not declared: javax.naming.NamingException: Cannot create PoolableConnectionFactory (Io exception: The Network Adapter could not establish the connection)

Cause

Incorrect server value in /m1/voyager/xxxdb/tomcat/conf/server.xml

Resolution

1. Edit /m1/voyager/xxxdb/tomcat/conf/server.xml

2. Replace localhost with the database server's hostname in this line: url="jdbc:oracle:thin:@localhost:1521:VGER"

3. Restart Tomcat with the "/m1/voyager/xxxdb/tomcat/tsvrctl restart" command.

• Article last edited: 22-Oct-2014