Resultset « Stored Procedure « JPA Q&A





1. How do I get the resultset of a stored procedure in JPA?    stackoverflow.com

I have SQL Server 2008 and a JPA (EclipseLink) app. I need to be able to read the rows from the stored procedure. The stored procedure does some updating/etc ...

2. MySQLDialect not support resultsets via stored procedures    forum.hibernate.org

public int registerResultSetOutParameter(CallableStatement statement, int col) throws SQLException { return col; } public ResultSet getResultSet(CallableStatement ps) throws SQLException { boolean isResultSet = ps.execute(); while (!isResultSet && ps.getUpdateCount() != -1) { ...

3. MySQL5Dialect ..no support resultsets via Stored procedures    forum.hibernate.org

Hi im new to Hibernate so please bear with me. Im trying retrieve a recordset from a MYSQL stored proceedure and am getting the error telling me that the MySQL5Dialect does not support resultsets via stored proceedures. I have also tried this with the ordinary MySQLDialect and get the same problem. Does anyone have any idea where Im going wrong? Cheers ...

4. Stored procedure must return a resultset?    forum.hibernate.org

5. Problem while getting resultset from stored procedure    forum.hibernate.org

Hello I have written a stored procedure which returns select from multiple tables. How can I return this resultset to java? CREATE PROCEDURE [dbo].[spExtract2] @param1 int, @param2 varchar(255) AS begin declare @t table( expense_id VARCHAR(255), type_name VARCHAR(255), ) SELECT ex.expense_id, ext.type_name FROM Expense ex, Expense_Type ext WHERE .............. return end ---------------------------------------------------------------------------