Sample Header Ad - 728x90

Can a MySql stored procedure return multiple resultsets each containing different columns?

3 votes
0 answers
1052 views
I have made a stored procedure that returns multiple resultsets from multiple tables. Therefore each resultset is made out of different columns. These resultsets are retrieved by an ProcedureOutputs object from the Hibernate framework. The first resultset is retrieved with no problems, however Hibernate tries to map the resultsets after that using the column set from the first resultset. This results in the error 2020-04-26 21:28:55.112 ERROR 22164 --- [nio-8080-exec-1] o.h.engine.jdbc.spi.SqlExceptionHelper : Column 'firstColumnFromFirstResultSet' not found. firstColumnFromFirstResultSet is an example here. My question is: Is there any way to let Hibernate know that each resultset is unique and that it shouldn't try to map the second resultset based on the columns of the first resultset? Thank you
Asked by Maurice (147 rep)
Apr 26, 2020, 08:08 PM