Uploaded image for project: 'MariaDB MaxScale'
  1. MariaDB MaxScale
  2. MXS-3929

connection stalled after executing a stored procedure with OUT parameter

    XMLWordPrintable

Details

    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");
                  }
              }
      

      Attachments

        Activity

          People

            markus makela markus makela
            diego dupin Diego Dupin
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.