I have this in my mapping:
Code:
<sql-query name="sprocName" callable="true">
<return-scalar column="userId" type="integer"/>
<![CDATA[
{ call sprocName(
:param1,
:param2,
:param3,
:param4,
:param5,
:param6
)}
]]>
</sql-query>
My java code is as below
Code:
Query query = HibernateUtil.getNamedQuery(
"com.voyager.vip.dao.LicenseSystemUserDao.consumeStaffLicense");
query.setInteger("param1", param1);
query.setInteger("param3", param2);
query.setDate("param3", param3);
query.setInteger("param4", param4);
query.setInteger("param5", param5);
query.setInteger("param6", param6);
Integer r = (Integer)query.uniqueResult();
In end of my sproc I execute this sproc this:
Code:
.
.
.
.
set @sql = 'select UserId from Table where UserId=12354'
exec sp_executesql @sql
print @sql
when I execute the code, I can see in the log that the call is made by Hibernate to the sproc but I get a NullPointerException
Code:
java.lang.NullPointerException
at org.hibernate.loader.Loader.doQuery(Loader.java:720)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:259)
at org.hibernate.loader.Loader.doList(Loader.java:2228)
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2125)
at org.hibernate.loader.Loader.list(Loader.java:2120)
at org.hibernate.loader.custom.CustomLoader.list(CustomLoader.java:312)
at org.hibernate.impl.SessionImpl.listCustomQuery(SessionImpl.java:1722)
at org.hibernate.impl.AbstractSessionImpl.list(AbstractSessionImpl.java:165)
at org.hibernate.impl.SQLQueryImpl.list(SQLQueryImpl.java:175)
at org.hibernate.impl.AbstractQueryImpl.uniqueResult(AbstractQueryImpl.java:835)
Could someone please help, guide me in some direction. Thanks.
Login
FAQ
Search