Using jdbctemplate call db2 stored procedures without the result set, but in the toad called directl-CodePudding

calls after an error
2020-06-30 16:26:02.541 ERROR 15308 --- [nio-8081-exec-4] o.a.c.c.C.[.[.[.[dispatcherServlet] : Servlet.service() for servlet [dispatcherServlet] in context with path [/ddmobile] threw exception [Request processing failed; nested exception is org.springframework.jdbc.UncategorizedSQLException: PreparedStatementCallback; uncategorized SQLException for SQL [{call query_classitem (?)}]; SQL state [null]; error code [-4476]; [jcc][10100][10910][4.25.13] 调用了 java.sql.PreparedStatement.executeQuery(),但是未返回任何结果集,

in eclipse error screenshot

change directly on the toad called stored procedures can return result sets

in Java using the same method calls another stored procedure can return to normal result sets, not don't understand why the stored procedure, doubt is written by the stored procedure has a problem, the following stored procedure code

CodePudding user response:

There is an error? 4476

CodePudding user response:

reference 1st floor lhdz_bj response:

is it an error? 4476

. This is called the PreparedStatement executeQuery (), but no results returned an error, I stored procedure on the toad direct execution is the result set, but in Java using JdbcTemplate call does not return a result set, this is my problem now

Java code is as follows:

CodePudding user response:

Should still this process has a problem, toad calls will be output as a result, shows that the result set no output to the variables, procedures for process result sets should be through the variable,