Breaking News
Home / ServerSide / Cannot create PoolableConnectionFactory (validationQuery didn’t return a row)

Cannot create PoolableConnectionFactory (validationQuery didn’t return a row)

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).

[pb_builder]

Check Also

What webservices standards are supported by Siebel Business Applications?

The following Web services standards are supported by Siebel Business Applications:     * Web Services …

Leave a Reply