object « Stored Procedure « JPA Q&A





1. Return partial object from stored procedure    forum.hibernate.org

I have a stored procedure that returns a partial set of fields of an entity - is it possible to map these results to a full entity ? I am aware this object if partial and it cannot be persisted but these results are for UI rendering (the entities can be serialized to XML ). I've read some mentions on this ...

2. Passing Blob object to oracle stored procedure    forum.hibernate.org

Hi, My requirement is to pass an blob object to an oracle procedure. I am able to save & retrieve a blob object using hibernate in a table when the blob is inside a Entity. However when i try to pass a blob to a procedure i get the exception "java.lang.ClassCastException: org.hibernate.lob.SerializableBlob incompatible with oracle.sql.BLOB" My code consist of: session.doWork(new Work() ...

3. create an object form an Oracle stored proc.    forum.hibernate.org

Hi I am a hibernate newbie. I am creating a "Customer" object from an oracle stored procedure and then want to use that object to save on a SQL server database. The problem I am having is when I call the Stored procedure Hibernate keeps wanting to create a customer table on Oracle even though i don't want it to be ...

4. save(object) Not using stored procedure    forum.hibernate.org

Hibernate version:3.2.1.ga Mapping documents: Code: ...

5. Problem using Stored Procedure returning nested object!    forum.hibernate.org

Our problem is that we want to use a stored procedure to collect and return a more complex structure. For example, it should be possible to return a list of orders where each row in the list inlcudes a number of order rows. We have tested this with an Oracle Stored Procedure Code: PROCEDURE test ...