Spring Boot 连接数据库异常
在搭建新项目时 , 连接数据库出现下面异常:
Druid-ConnectionPool-Create-819680566 [ERROR] com.alibaba.druid.pool.DruidDataSource Line:2469 create connection SQLException, url: jdbc:oracle:thin:@127.0.0.1:1521:odsdb, errorCode 923, state 42000
java.sql.SQLException: ORA-00923: 未找到要求的 FROM 关键字at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:745)at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:207)at oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:801)at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1039)at oracle.jdbc.driver.T4CStatement.executeMaybeDescribe(T4CStatement.java:841)at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1126)at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1274)at com.alibaba.druid.pool.vendor.OracleValidConnectionChecker.isValidConnection(OracleValidConnectionChecker.java:84)at com.alibaba.druid.pool.DruidAbstractDataSource.validateConnection(DruidAbstractDataSource.java:1307)at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1588)at com.alibaba.druid.pool.DruidDataSource$CreateConnectionThread.run(DruidDataSource.java:2466)
解决方案 :
- 检查SQL 是否正确
- 查看配置文件 validationQuery 配置是否正确
validationQuery：Druid用来测试连接是否可用的SQL语句,默认值每种数据库都不相同：
Mysql:SELECT 1;
SQLSERVER:SELECT 1;
ORACLE:SELECT ‘x’ FROM DUAL;
PostGresql:SELECT ‘x’;
validationQuery什么时候会起作用？
当Druid遇到testWhileIdle，testOnBorrow，testOnReturn时，就会验证连接的有效性，验证规则如下：
如果有相关数据库的ValidConnectionChecker，则使用ValidConnectionChecker验证（Druid提供常用数据库的ValidConnectionChecker，包括MSSQLValidConnectionChecker，MySqlValidConnectionChecker，OracleValidConnectionChecker，PGValidConnectionChecker）；
个人错误信息总结,仅供参考.