How to connect to a stored Procedure in db2 using Spring and Hibernate Combination

["Nutulapati, Krishna" <KN...@ussco.com>]

Hello All, Can any of suggest me, how I can call a stored Procedure
using spring and hibernate.The entire Request is getting processed using
Spring and Hibernate. Currently the session configuration is as follows
in web.xml.
 <filter>
          <filter-name>sessionFilter</filter-name>
 
<filter-class>com.ussco.persistence.hibernate3.dao.support.OpenSessionIn
ViewFlushFilter</filter-class>
          <init-param>
          		<param-name>sessionFactoryBeanName</param-name>
 
<param-value>nedExtraSessionFactory</param-value>
          </init-param>
          <init-param>
           <param-name>singleSession</param-name> 
           <param-value>false</param-value> 
          </init-param>
          
      </filter>

     <filter-mapping>
          <filter-name>sessionFilter</filter-name>
          <url-pattern>/*</url-pattern>
     </filter-mapping>
	DataSource Info is defined as follows
<bean id="projectDataSource"
		class="org.springframework.jndi.JndiObjectFactoryBean">
		<property name="jndiName" value="jdbc/projectapp/db2"/>
	</bean>
</beans>

Please suggest me the right approach.
Your response is appreciated. 
Thanks
Krishna

Re: How to connect to a stored Procedure in db2 using Spring and Hibernate Combination

[Martyn Hiemstra <m....@minihouse.com>]

Goto the Spring/Hibernate forum and ask your question there.. Please 
next time use some common sense and realize that you don't ask Spring 
and Hibernate questions in a myfaces mailing list.

Martyn Hiemstra
>
> Hello All, Can any of suggest me, how I can call a stored Procedure 
> using spring and hibernate.The entire Request is getting processed 
> using Spring and Hibernate. Currently the session configuration is as 
> follows in web.xml.
>
>  <filter>
>           <filter-name>sessionFilter</filter-name>
>           
> <filter-class>com.ussco.persistence.hibernate3.dao.support.OpenSessionInViewFlushFilter</filter-class> 
>
>           <init-param>
>                         <param-name>sessionFactoryBeanName</param-name>
>                         <param-value>nedExtraSessionFactory</param-value>
>           </init-param>
>           <init-param>
>            <param-name>singleSession</param-name>
>            <param-value>false</param-value>
>           </init-param>
>          
>       </filter>
>
>      <filter-mapping>
>           <filter-name>sessionFilter</filter-name>
>           <url-pattern>/*</url-pattern>
>      </filter-mapping>
>         DataSource Info is defined as follows
> <bean id="projectDataSource"
>                 class="org.springframework.jndi.JndiObjectFactoryBean">
>                 <property name="jndiName" value="jdbc/projectapp/db2"/>
>         </bean>
> </beans>
>
> Please suggest me the right approach.
> Your response is appreciated.
> Thanks
> Krishna
>