2. Don't understand 18.2.2.Using stored procedures for querying forum.hibernate.orgI have managed to avoid using stored procedures, until now. I find plenty of questions about this but no useful answer. http://docs.jboss.org/hibernate/core/3.6/reference/en-US/html/querysql.html#sp_query raises more questions than it answers. I have to call several Oracle stored procedures that have one OUT parameter and one or more IN parameters. i.e. PROCEDURE IsAnythingAssignedToUser( OUT_READ_PI_VARS OUT SYS_REFCURSOR, IN_READER IN READ_PROCESS_INSTANCE.ASSIGNED_READER%TYPE, IN_WORKFLOW_STATE_ARRAY IN String_Array ); There's ... |
3. problem querying with a stored procedure forum.hibernate.orgHi, With eclipse 3.0.2, hibernate 3.0, sql server 2000, I am having problems using stored procedure for querying via a named query. Basically it complains about invalid mapping, Attribute "callable" is not declared for element "sql-query". here is the stored procedure create procedure spGetEconActual @revisionID int, @quarterID int as begin select quarterID, revisionID into #temp from CCEconActual where revisionID<= @revisionID and ... |
4. stored procedure names query and xdoclet forum.hibernate.org |
5. Stored Procedure for Querying does not work forum.hibernate.orgI am attempting to call an Oracle function (that returns a SYS_REFCURSOR ) using the Halogen framework. The intent is to have the stored procedure return a collection of Halogen Objects. Although I have exactly the same scenario as mentioned in the Chapter 17 of the Halogen progammer's reference, I am still unable to get get the program executed. Everytime we ... |
6. Querying with stored procedure forum.hibernate.org |
7. Can I include stored procedure in Hibernate Query? forum.hibernate.orgHi, All: I create a stored procedure on Sybase ASE, and I want to call it inside a query like this: select * from tableA a, tableB b where a.id=b.id and (exec storeprocedure) My question is: can I write this query using HQL? If not, can I have this query using SQL? Thanks! |
8. Stored procedure queries forum.hibernate.orgHi! I am trying to load collection UserCredential.persons via stored procedure call. I have set hbm.xml, sql query and stored procedure which are attached below. Loading of persons Set is done by Code: Set set = userCredential.getPersons(); But after this I am getting the exception "failed to lazily initialize a collection of role" (see below) when trying to access values in ... |