Validation Query Throwing Exception

Validation Query Throwing Exception

Symptoms

One or more SQL Macro returns the following error:

org.apache.tomcat.dbcp.dbcp.SQLNestedException:
Cannot create PoolableConnectionFactory (Syntax error: Encountered

Cause

The validation query is either not supported or you are using incorrect syntax.

Resolution

Remove the validation query or ensure it is correct for your database

Need support? Create a request with our support team.

Copyright © 2005 - 2025 Appfire | All rights reserved.