Hi all,

I would like to call stored procedures/function (from Oracle database).
Using entitymanager, I know I can map a native sql query to my entities.
The problem is, I can't map the results of my function to none of my entities, since the refcursor that is returned is too 'complicated' (mixed results from many tables, even from tables accessed via a dblink).

So, I would like to know if it is possible to create an non-managed entity (aka my simple mapping object), to which I can attach a native sql query (and results mapped with @SqlResultSetMapping).

As a hook, I'm getting the delegate hibernate session from my entitymanager :




Hibernate version:
Hibernate EntityManager 3.3.1.GA

Name and version of the database you are using:
Oracle 8.1.7.4 - 10g

Thanks for helping !

Hi,

I am not sure whether I understand your problem correctly.
@SqlResultSetMapping does only apply to mapped entities, but is a custom ResultTransformer exactly what you need?

--Hardy

Hi !
Thanks for your reply.

Yes, the ResultTransformer does the job. But I'm stick to using Transformers.aliasToBean ; with this method, I'm forced to have getter/setter = column_name.

Afaik, using @SqlResultSetMapping to a "not-mapped entity" would be more flexible.

Btw, you're talking about "custom" ResultTransformer ... what do you mean ?


Thanks !

Hi,

Transformers.aliasToBean is a predefined transformer, however you could also implement a completely different transformer by just implementing the ResultTransformer interface.

You could for example use the AliasToBeanConstructorResultTransformer. The name is a little bit misleading. You can easily check out the implementation on the publicly available fisheye instance - http://fisheye.jboss.org/browse/Hibernate/core/trunk/core/src/main/java/org/hibernate/transform/AliasToBeanConstructorResultTransformer.java?r=11588.

Also have a look at the other result transformers:
http://fisheye.jboss.org/browse/Hibernate/core/trunk/core/src/main/java/org/hibernate/transform.

--Hardy