Using Struts 1.3 , Hibernate 3 and Tomcat 5.5v

I have a stored procedure that gives values from multiple tables.

Java Class to get the data -->
List list = null;
try
{
Session session = HibernateUtils.currentSession();
Query query = session.getNamedQuery("SalesForecastSalesRepSummarySp");
query.setParameter("para1", marketID );
query.setParameter("para2", statusID );
query.setParameter("para3",quarterID);
query.setParameter("para4", month );
query.setParameter("para5",year );
query.setParameter("para6",customer );
query.setParameter("para7",loggedInUserID);

list = query.list();

HibernateUtils.closeSession();

}
catch (Exception e) {
System.out.println(e);
}
return list;



POJO (SalesForecast.java)
______________________

public class SalesForecast implements java.io.Serializable{

private Short managerId;
private Short saleaRepId;
private Short totalPrice;
private BigDecimal forecast;
private BigDecimal pending;
private BigDecimal booked;
private BigDecimal lost;

public SalesForecast()
{
super();
}
public SalesForecast(Short managerId
, Short saleaRepId
, Short totalPrice
, BigDecimal forecast
, BigDecimal pending
, BigDecimal booked
,BigDecimal lost)
{
super();
this.managerId = managerId;
this.saleaRepId = saleaRepId;
this.totalPrice = totalPrice;
this.forecast = forecast;
this.pending = pending;
this.booked = booked;
this.lost=lost;
}

public Short getManagerId() {
return managerId;
}
public void setManagerId(Short managerId) {
this.managerId = managerId;
}


public Short getSaleaRepId() {
return saleaRepId;
}

public void setSaleaRepId(Short saleaRepId) {
this.saleaRepId = saleaRepId;
}



public Short getTotalPrice() {
return totalPrice;
}

public void setTotalPrice(Short totalPrice) {
this.totalPrice = totalPrice;
}

public BigDecimal getForecast() {
return forecast;
}
public void setForecast(BigDecimal forecast) {
this.forecast = forecast;
}
public BigDecimal getPending() {
return pending;
}
public void setPending(BigDecimal pending) {
this.pending = pending;
}
public BigDecimal getBooked() {
return booked;
}
public void setBooked(BigDecimal booked) {
this.booked = booked;
}

public BigDecimal getLost() {
return lost;
}

public void setLost(BigDecimal lost) {
this.lost = lost;
}

}



SalesForecast.hbm.xml
___________________
<hibernate-mapping>

<sql-query name="dbo.SalesForecastSalesRepSummarySp" callable="true">
<return alias="SalesForecastSalesRepSummarySp" class="com.cynosure.sf.domain.SalesForecast">
<return-property name="managerId" column="ManagerId"/>
<return-property name="saleaRepId" column="SaleaRepId"/>
<return-property name="totalPrice" column="TotalPrice"/>
<return-property name="forecast" column="Forecast"/>
<return-property name="pending" column="Pending"/>
<return-property name="booked" column="Booked"/>
<return-property name="lost" column="Lost"/>

</return>
{ ? = call SalesForecastSalesRepSummarySp(:para1, :para2, :para3, :para4, :para5, :para6, :para7) }

</sql-query>
</hibernate-mapping>

ERRORS-->

javax.servlet.ServletException: Filter execution threw an exception


root cause

java.lang.ExceptionInInitializerError
com.cynosure.sf.utils.HibernateUtils.<clinit>(HibernateUtils.java:22)
com.cynosure.sf.service.impl.SecurityServiceImpl.authenticateUser(SecurityServiceImpl.java:28)
com.cynosure.sf.security.SecurityFilterRealm.booleanAuthenticate(SecurityFilterRealm.java:14)
org.securityfilter.realm.SimpleSecurityRealmBase.authenticate(SimpleSecurityRealmBase.java:107)
org.securityfilter.authenticator.FormAuthenticator.processLogin(FormAuthenticator.java:178)
org.securityfilter.filter.SecurityFilter.doFilter(SecurityFilter.java:138)


root cause

org.hibernate.HibernateException: Errors in named queries: dbo.SalesForecastSalesRepSummarySp
org.hibernate.impl.SessionFactoryImpl.<init>(SessionFactoryImpl.java:407)
org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1341)
com.cynosure.sf.utils.HibernateUtils.<clinit>(HibernateUtils.java:18)
com.cynosure.sf.service.impl.SecurityServiceImpl.authenticateUser(SecurityServiceImpl.java:28)
com.cynosure.sf.security.SecurityFilterRealm.booleanAuthenticate(SecurityFilterRealm.java:14)
org.securityfilter.realm.SimpleSecurityRealmBase.authenticate(SimpleSecurityRealmBase.java:107)
org.securityfilter.authenticator.FormAuthenticator.processLogin(FormAuthenticator.java:178)
org.securityfilter.filter.SecurityFilter.doFilter(SecurityFilter.java:138)


note The full stack trace of the root cause is available in the Apache Tomcat/5.5.27 logs.


I have been trying to resolve it for a while. But cannot find way out. Any help will be appreciated. Thanks in Advance.