Hello everybody,
i´d like to use named queries in my project because I have a stored procedure i´d like to call.
Right now my code looks like this:
Code:
Query query = em.createNativeQuery("SELECT stored_procedure(?,?,?) from DUAL");
query.setParameter(1, userId);
query.setParameter(2, value);
query.setParameter(3, date);
String result = (String) query.getSingleResult();
I´d like to call this stored procedure by a named query.
I know that I can define it in a mapping file like this:Code:
<hibernate-mapping >
<sql-query name="test">
<return alias="testString" type="java.lang.String" />
{ SELECT stored_procedure(?,?,?) from DUAL }
</sql-query>
</hibernate-mapping>
But somehow my stored procedure isn´t found - who could help me ?
Login
FAQ
Search