【YashanDB知识库】YashanDB JDBC查询时抛出YAS-02094

本文内容来自YashanDB官网，原文内容请见https://yashandb.com/newsinfo/7849025.html?templateId=1718516

YashanDB JDBC查询时抛出YAS-02094 current session has been killed or canceled异常
首页 ꁇ YashanDB JDBC查询时抛出YAS-02094 current session has been killed or canceled异常
业务在执行SQL语句时抛出了YAS-02094 current session has been killed or canceled异常，堆栈如下：

Caused by: java.sql.SQLTimeoutException: [line: 0 column: 0] YAS-02094 current session has been killed or canceled

    at com.yashandb.jdbc.exception.SQLExceptionType$9.a(Unknown Source)

    at com.yashandb.jdbc.exception.SQLExceptionType.newSQLException(Unknown Source)

    at com.yashandb.jdbc.exception.SQLError.createSQLException(Unknown Source)

    at com.yashandb.jdbc.exception.SQLError.createSQLException(Unknown Source)

    at com.yashandb.protocol.NativeProtocol.checkServerError(Unknown Source)

    at com.yashandb.protocol.NativeProtocol.receivePacket(Unknown Source)

    at com.yashandb.protocol.NativeProtocol.sendCommand(Unknown Source)

    at com.yashandb.SessionImpl.a(Unknown Source)

    at com.yashandb.SessionImpl.a(Unknown Source)

    at com.yashandb.SessionImpl.a(Unknown Source)

    at com.yashandb.SessionImpl.b(Unknown Source)

    at com.yashandb.SessionImpl.a(Unknown Source)

    at com.yashandb.SessionImpl.a(Unknown Source)

    at com.yashandb.SessionImpl.execute(Unknown Source)

    at com.yashandb.jdbc.PreparedStatementImpl.b(Unknown Source)

    at com.yashandb.jdbc.PreparedStatementImpl.executeQuery(Unknown Source)

问题原因：SQL语句的执行时间超过了PreparedStatement对象setQueryTimeout指定的时间(单位：秒)，或者中间件类似参数(例如druid的query-timeout，单位：秒)指定的时间

解决办法：优化SQL语句减少执行时间或者调大对应的参数设置