Hello everyone,
I am currently a bit frustrated about stored procedures and hibernate. In Chapter 16, SPs are introduced as being addressed like named queries being callable. So I create created such a named query.
Code:
<sql-query name="roles" callable="true">
<return alias="roles" class="RoleType">
<return-property name="roleTypeId" column="rollen" />
<return-property name="roleDescription" column="rcU88AASHR" />
</return>
{ ? = call myMethod(:user,:res,:id) }
</sql-query>
Now my question would be, how I should call this method.
I found two ways in the web. CallableStatement which is not the one
I want because then I could leave out the named query, right? It's from java.sql.*
The other one would be this one:
Code:
Query lQ = lSession.getNamedQuery("roles").setParameter("user", "username")
.setParameter("res", "Test")
.setParameter("id", 1);
int i = lQ.executeUpdate();
But this way I receive a:
Code:
java.lang.IllegalArgumentException: callable not yet supported for native queries
at org.hibernate.engine.query.NativeSQLQueryPlan.performExecuteUpdate(NativeSQLQueryPlan.java:147)
at org.hibernate.impl.SessionImpl.executeNativeUpdate(SessionImpl.java:1163)
at org.hibernate.impl.SQLQueryImpl.executeUpdate(SQLQueryImpl.java:334)
at com.mycompany.cama.HibernateTest.testConnection(HibernateTest.java:61)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:64)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:615)
at junit.framework.TestCase.runTest(TestCase.java:154)
at junit.framework.TestCase.runBare(TestCase.java:127)
at junit.framework.TestResult$1.protect(TestResult.java:106)
at junit.framework.TestResult.runProtected(TestResult.java:124)
at junit.framework.TestResult.run(TestResult.java:109)
at junit.framework.TestCase.run(TestCase.java:118)
at junit.framework.TestSuite.runTest(TestSuite.java:208)
at junit.framework.TestSuite.run(TestSuite.java:203)
at org.eclipse.jdt.internal.junit.runner.junit3.JUnit3TestReference.run(JUnit3TestReference.java:128)
at org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:38)
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:460)
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:673)
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:386)
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:196)
Can please anyone give me a hint how I can successfully call this procedure and receive the RoleType instances?
Thank you
Hibernate version:3.2.5
Login
FAQ
Search
