Details
-
Bug
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Fixed
-
6.2.0
Description
tested successfully with 2.5.12, this only occurs on 6.x version
After execution of a stored procedure using binary protocol that contains OUT parameters, command is successful, but connection is stalled : any another command send won't have any response.
example to reproduced :
try (Connection c = DriverManager.getConnection("jdbc:mariadb://localhost:4006/testj?user=boby&password=heyPassword")) { |
Statement stmt = c.createStatement();
|
stmt.execute("DROP PROCEDURE IF EXISTS basic_proc"); |
stmt.execute("CREATE PROCEDURE basic_proc (INOUT t2 INT) BEGIN \n" |
+ "set t2 = t2 + 1;\n" |
+ "END"); |
|
c.createStatement().execute("SELECT 1"); |
|
try (CallableStatement prep = c.prepareCall("{call basic_proc(?)}")) { |
prep.setInt(1, 2); |
prep.executeQuery();
|
c.createStatement().execute("SELECT 1"); |
}
|
}
|