Please let me know what changes are needed



Hibernate version:

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN" "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd" >
<hibernate-mapping>

<sql-query name="selectAllRegions_p" callable="true">
<return alias="st" class="src.main.java.State">
<return-property name="stateid" column="REGIONID" />
<return-property name="stateabbr" column="REGIONCODE" />
<return-property name="statename" column="NAME" />
<return-property name="countryID" column="COUNTRYID" />
</return>
{ ? = call getAllRegions() }
</sql-query>

</hibernate-mapping>

Mapping documents:

Code between sessionFactory.openSession() and session.close():

Query query = session.getNamedQuery("selectAllRegions_p");
List result = query.list();

Full stack trace of any exception that occurs:

Exception in thread "main" org.hibernate.exception.SQLGrammarException: could not execute query
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:67)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at org.hibernate.loader.Loader.doList(Loader.java:2148)
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2029)
at org.hibernate.loader.Loader.list(Loader.java:2024)
at org.hibernate.loader.custom.CustomLoader.list(CustomLoader.java:111)
at org.hibernate.impl.SessionImpl.listCustomQuery(SessionImpl.java:1655)
at org.hibernate.impl.AbstractSessionImpl.list(AbstractSessionImpl.java:142)
at org.hibernate.impl.SQLQueryImpl.list(SQLQueryImpl.java:164)
at src.main.java.TestHibernateApp.listEvents(TestHibernateApp.java:36)
at src.main.java.TestHibernateApp.main(TestHibernateApp.java:13)
Caused by: java.sql.SQLException: Parameter #1 has not been set.
at net.sourceforge.jtds.jdbc.TdsCore.executeSQL(TdsCore.java:1005)
at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL(JtdsStatement.java:478)
at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.execute(JtdsPreparedStatement.java:478)
at org.hibernate.dialect.SybaseDialect.getResultSet(SybaseDialect.java:149)
at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:146)
at org.hibernate.loader.Loader.getResultSet(Loader.java:1666)
at org.hibernate.loader.Loader.doQuery(Loader.java:662)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:224)
at org.hibernate.loader.Loader.doList(Loader.java:2145)
... 8 more
Hibernate: { ? = call getAllRegions() }

Name and version of the database you are using:

sql server2005

The generated SQL (show_sql=true):

Debug level Hibernate log excerpt:

Hello Friend:

If you see in detail ur exception trace, you will found the follow line:

Caused by: java.sql.SQLException: Parameter #1 has not been set.

Cos your Store Procedure is write:
? = call getAllRegions() , where the character "?" means implicitly a parameter, so u have tu set a parameter there to excecute.

I think u use Oracle DB, u can search in the hibernate forum all topics associed to Store Procedure of your data base.


Requests for comments

Thank you,

I removed the " ? =" from my code and i was able to retrieve the data.

Question
"? = call getAllRegions() " is this to register the return type of the procedure call to a variable ?

do we have to do some setXX method to get it into a variable.