Details
-
Task
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
None
-
None
-
Sprint connector/j 2.1.0
Description
Driver failover handling is based on 08xxx sql state that indicate a connection exception.
A "KILL CONNECTION" command will return a 70100 that is not automatically handled by failover.
70xxx sql state familly stand for interrupted exception.
specifically 70100 sql state can be issue with different kind of error :
- ER_STATEMENT_TIMEOUT (error 1969)
- ER_QUERY_INTERRUPTED (error 1317)
- ER_CONNECTION_KILLED (error 1927)
The 70100 sql state with error code 1927 (= KILL CONNECTION) must be handled by driver to reconnect automatically WITHOUT relaunching query