How to resolve an Oracle validation query throwing exception - 10.x


One or more SQL Macro returns the following error:

Cannot create PoolableConnectionFactory (ORA-00923: FROM keyword not found where expected


Oracle requires a FROM clause in the validation query. For most other databases, it is sufficient to use SELECT 1


Add a valid FROM clause for Oracle queries. 

Find answers from the community.

Ask a question to the community.

Log a request with our support team.

Confluence®, Jira®, Atlassian Bamboo®, Bitbucket®, Fisheye®, and Atlassian Crucible® are registered trademarks of Atlassian®
Copyright © 2005 - 2022 Appfire | All rights reserved. Appfire™, the 'Apps for makers™' slogan and Bob Swift Atlassian Apps™ are all trademarks of Appfire Technologies, LLC.