springboot + druid + oracle
执行查询,数据量小正常,数据量大超时,超时SQL拿出来使用数据库连接工具执行正常
错误堆栈:
error.log:### Cause: java.sql.SQLRecoverableException: IO Error: Socket read timed out
error.log:; IO Error: Socket read timed out; nested exception is java.sql.SQLRecoverableException: IO Error: Socket read timed out
error.log: at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:256)
error.log: at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:73)
error.log: at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:92)
error.log: at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:439)
error.log: at com.sun.proxy.$Proxy198.selectList(Unknown Source)
error.log: at org.mybatis.spring.SqlSessionTemplate.selectList(SqlSessionTemplate.java:224)
error.log: at com.baomidou.mybatisplus.core.override.MybatisMapperMethod.executeForIPage(MybatisMapperMethod.java:121)
error.log: at com.baomidou.mybatisplus.core.override.MybatisMapperMethod.execute(MybatisMapperMethod.java:85)
error.log:
如何解决超时问题?数据库配置中没有指定超时时间