这是我连接数据库的语句
host.spring.jpa.database = oracle
host.spring.datasource.url = jdbc:oracle:thin:@localhost:1521:ORCL
host.spring.datasource.username =c##host
host.spring.datasource.password =LIANGwei011
host.spring.datasource.driverClassName=oracle.jdbc.driver.OracleDriver
host.spring.jpa.properties.hibernate.dialect= org.hibernate.dialect.OracleDialect
host.spring.datasource.validationQuery=select * from dual
错误如下
java.sql.SQLSyntaxErrorException: ORA-00923: 未找到要求的 FROM 关键字
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:450) ~[ojdbc7-12.1.0.2.jar:12.1.0.1.0]
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:399) ~[ojdbc7-12.1.0.2.jar:12.1.0.1.0]
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1017) ~[ojdbc7-12.1.0.2.jar:12.1.0.1.0]
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:655) ~[ojdbc7-12.1.0.2.jar:12.1.0.1.0]
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:249) ~[ojdbc7-12.1.0.2.jar:12.1.0.1.0]
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:566) ~[ojdbc7-12.1.0.2.jar:12.1.0.1.0]
at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:202) ~[ojdbc7-12.1.0.2.jar:12.1.0.1.0]
at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:45) ~[ojdbc7-12.1.0.2.jar:12.1.0.1.0]
at oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:766) ~[ojdbc7-12.1.0.2.jar:12.1.0.1.0]
at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:897) ~[ojdbc7-12.1.0.2.jar:12.1.0.1.0]
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1026) ~[ojdbc7-12.1.0.2.jar:12.1.0.1.0]
at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1244) ~[ojdbc7-12.1.0.2.jar:12.1.0.1.0]
at oracle.jdbc.driver.OracleStatementWrapper.executeQuery(OracleStatementWrapper.java:420) ~[ojdbc7-12.1.0.2.jar:12.1.0.1.0]
at com.alibaba.druid.pool.vendor.OracleValidConnectionChecker.isValidConnection(OracleValidConnectionChecker.java:84) ~[druid-1.1.10.jar:1.1.10]
at com.alibaba.druid.pool.DruidAbstractDataSource.validateConnection(DruidAbstractDataSource.java:1346) ~[druid-1.1.10.jar:1.1.10]
at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1633) ~[druid-1.1.10.jar:1.1.10]
at com.alibaba.druid.pool.DruidDataSource$CreateConnectionThread.run(DruidDataSource.java:2468) [druid-1.1.10.jar:1.1.10]
错误信息： ORA-00923: 未找到要求的 FROM 关键字
检查你的sql，是不是少写了from，又或者写错了。