Issue:

java.lang.RuntimeException: org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (validationQuery didn't return a row)
     at com.infuze.service.linkedin.workflow.RegisterUserWorkflow.executeProcess(RegisterUserWorkflow.java:84)
     at com.infuze.service.workflow.WorkflowExecutor.execute(WorkflowExecutor.java:24)
     at com.infuze.service.linkedin.xml.LinkedInJobAlertXmlService.register(LinkedInJobAlertXmlService.java:48)
     at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
     at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
     at java.lang.reflect.Method.invoke(Method.java:597)
     at com.livrona.xhttpi.XHttpInvoker.execute(Unknown Source)
     at com.infuze.server.service.XmlServiceActionHandler.execute(XmlServiceActionHandler.java:28)
     at com.livrona.haxe.server.RequestHandler.executeRequest(RequestHandler.java:149)
     at com.livrona.haxe.server.RequestHandler.run(RequestHandler.java:77)
Caused by: org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (validationQuery didn't return a row)
     at org.apache.commons.dbcp.BasicDataSource.createPoolableConnectionFactory

(BasicDataSource.java:1549)
     at org.apache.commons.dbcp.BasicDataSource.createDataSource

(BasicDataSource.java:1388)
     at org.apache.commons.dbcp.BasicDataSource.getConnection
     at com.infuze.service.linkedin.dao.JobChangeServiceDao.addUser
     at com.infuze.service.linkedin.workflow.RegisterUserWorkflow.executeProcess
     ... 10 more
Caused by: java.sql.SQLException: validationQuery didn't return a row
     at org.apache.commons.dbcp.PoolableConnectionFactory.validateConnection

(PoolableConnectionFactory.java:660)
     at org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory

(BasicDataSource.java:1558)
     at org.apache.commons.dbcp.BasicDataSource.createPoolableConnectionFactory

(BasicDataSource.java:1545

Possible Solutions

Check the db pool validation query, most likely that is not correct. Verify that the sql works by running it against the db. Maybe the table does not exits or if it does exits, it may not have any data(rows) (if yes that add at least one row and try again).