.png?version=1&modificationDate=1662627367996&cacheVersion=1&api=v2&width=226&height=72)
Validation query throwing Oracle exception - 11.x
- Nisha Shantilal
Owned by Nisha Shantilal
Feb 01, 2023
1 min read
Loading data...
Symptoms
One or more SQL Macro returns the following error:
org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (ORA-00923: FROM keyword not found where expected
Cause
Oracle requires a FROM clause in the validation query. For most other databases, it is sufficient to use SELECT 1.
Resolution
Add a valid FROM clause for Oracle queries.
Log a request with our support team.
Confluence®, Jira®, Atlassian Bamboo®, Bitbucket®, Fisheye®, and Atlassian Crucible® are registered trademarks of Atlassian®
Copyright © 2005 - 2024 Appfire | All rights reserved. Appfire™, the 'Apps for makers™' slogan and Bob Swift Atlassian Apps™ are all trademarks of Appfire Technologies, LLC.