You are currently reviewing an older revision of this page.

DRAFT KB-XXXX "ORA-00923: FROM keyword not found where expected" error thrown when using Oracle as the database

Symptoms

When using Tomcat as the application server, the application server fails to start with the following error in the logs:

WARNING [localhost-startStop-1] org.apache.naming.NamingContext.lookup Unexpected exception resolving reference java.sql.SQLException: Cannot create PoolableConnectionFactory (ORA-00923: FROM keyword not found where expected ) at org.apache.tomcat.dbcp.dbcp2.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:2385)

Cause

This is caused by the following line in suite.xml reading as follows:

validationQuery="SELECT 1"

Action

Change it to the following:

validationQuery="SELECT 1 FROM dual"

Make sure all other values in suite.xml are formatted as seen in the Configuring Relational Databases documentation.

Affected Versions

This article applies to Appian 18.3 and later using Oracle as the database.

Last reviewed: December 2018