Hi All,
I am getting some syntax related issue while executing store procedure.
i.e (15:33:43,053 INFO [stdout] (http-localhost-127.0.0.1-5050-7) query -- SQLQueryImpl({call SquareSP3(:MyFirstParam)})
15:33:43,894 WARN [org.hibernate.util.JDBCExceptionReporter] (http-localhost-127.0.0.1-5050-7) SQL Error: 0, SQLState: null
15:33:43,895 ERROR [org.hibernate.util.JDBCExceptionReporter] (http-localhost-127.0.0.1-5050-7) A result set was generated for update.
15:33:44,175 WARN [org.hibernate.util.JDBCExceptionReporter] (http-localhost-127.0.0.1-5050-7) SQL Error: 102, SQLState: S0001
15:33:44,177 ERROR [org.hibernate.util.JDBCExceptionReporter] (http-localhost-127.0.0.1-5050-7) Incorrect syntax near '{'.
15:33:44,180 ERROR [stderr] (http-localhost-127.0.0.1-5050-7) org.hibernate.exception.SQLGrammarException: could not execute query
15:33:44,182 ERROR [stderr] (http-localhost-127.0.0.1-5050-7) at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:67)
15:33:44,183 ERROR [stderr] (http-localhost-127.0.0.1-5050-7) at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
15:33:44,185 ERROR [stderr] (http-localhost-127.0.0.1-5050-7) at org.hibernate.loader.Loader.doList(Loader.java:2223)
15:33:44,186 ERROR [stderr] (http-localhost-127.0.0.1-5050-7) at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2104)
15:33:44,188 ERROR [stderr] (http-localhost-127.0.0.1-5050-7) at org.hibernate.loader.Loader.list(Loader.java:2099)
15:33:44,190 ERROR [stderr] (http-localhost-127.0.0.1-5050-7) at org.hibernate.loader.custom.CustomLoader.list(CustomLoader.java:289))

I am using jboss server 7.1, sql server 2012, jdk 1.6, and hibernate 3.
I created datasource in jboss server for that I used one jar file i.e sqljdbc4-3.0.jar.


The entry for calling SP in .hbm file

<sql-query name="getDistributionListCriteria">
{call SquareSP3(:keyParam)}
</sql-query>

Note:if I am specifying db connection related details in hibernate configuration file then I am not getting any issue related to store procedure, but if I specify db connection details in jboss using datasource then everything is working fine except store procedure.

Can anybody help on it or guide me what is the actual issue?

Regards,
Jitendra Daswani