You are currently reviewing an older revision of this page.
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)
This is caused by the following line in suite.xml reading as follows:
validationQuery="SELECT 1"
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.
This article applies to Appian 18.3 and later using Oracle as the database.
Last reviewed: December 2018