| 
					
						 I recently used Websphere 5.1 and Hibernate 3 for develope DAO class
 
 Everythings is ok on windows but when I porting the same application on zlinux, the first time that the apllication call DAO class the result  is ok but the second time that I try to call the same method with the same parameter Websphere display the error message that I attached below 
 
 I don't know to solve the problem, any suggestion ...
 Many thanks in advince
 
 
 
 -> hibernate.cfg.xml
 <?xml version="1.0" encoding="utf-8"?>
 <!DOCTYPE hibernate-configuration PUBLIC
 "-//Hibernate/Hibernate Configuration DTD 3.0//EN"
 "http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">
 <hibernate-configuration>
     <session-factory>
     
 	<property name="hibernate.connection.datasource">jdbc/WINDB</property>	
 		
 	<!-- Transaction API Configurazione WebSphere in locale e in test -->
 	<property name="transaction.factory_class">
 		org.hibernate.transaction.JTATransactionFactory</property>
 	<property name="transaction.manager_lookup_class">
 		org.hibernate.transaction.WebSphereTransactionManagerLookup</property> 
 		
 		<property name="hibernate.dialect">org.hibernate.dialect.DB2Dialect</property>
         <property name="hibernate.show_sql">true</property>
         <mapping resource="it/seceti/icbp/hibernate/vo/Nrbtutcx.hbm.xml" />
     </session-factory>
 </hibernate-configuration>
 
 -> DAO method
 	public Nrbtutcx getNrbtutcx(String utnt_cod_sia) {
 		logger.debug("Inizio");
 		logger.debug("utnt_cod_sia -> " + utnt_cod_sia);
 		logger.debug("dim utnt_cod_sia -> " + utnt_cod_sia.length());	
 		Session session = HibernateUtil.getSession_A();
 		try {
 			Query q = session.createQuery(
 			"from Nrbtutcx " +
 			"where " +
 			"utntCodSia = :utntCodSia  ");
 			q.setString("utntCodSia", utnt_cod_sia);
 			Nrbtutcx nrbtutcx = (Nrbtutcx) q.uniqueResult();			
 			logger.debug("Fine");
 			return nrbtutcx;
 		} catch (HibernateException e) {
 			logger.debug("Eccezione " + e);
 			throw e;
 		} finally {
 			logger.debug("Chiusura sessione ");
 			session.close();
 			
 		}
 	}
 
 
 -> error message
 [5/16/08 11:42:03:535 GMT] 201a4f84 AbstractExcep W org.apache.struts.chain.commands.AbstractExceptionHandler  Unhandled exception
 [5/16/08 11:42:03:544 GMT] 201a4f84 AbstractExcep W org.apache.struts.chain.commands.AbstractExceptionHandler  TRAS0014I: The following exception was logged org.hibernate.exception.GenericJDBCException: could not execute query
 	at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:103)
 	at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:91)
 	at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
 	at org.hibernate.loader.Loader.doList(Loader.java:2216)
 	at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2104)
 	at org.hibernate.loader.Loader.list(Loader.java:2099)
 	at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:378)
 	at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:338)
 	at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:172)
 	at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1121)
 	at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)
 	at org.hibernate.impl.AbstractQueryImpl.uniqueResult(AbstractQueryImpl.java:811)
 	at it.teti.ifff.hibernate.persistence.NrbtutcxHibernateDao.getNrbtutcx(NrbtutcxHibernateDao.java:179)
 	at it.teti.ifff.hibernate.service.NrbtutcxDaoService.getNrbtutcx(NrbtutcxDaoService.java:31)
 	at it.teti.ifff.struts.action.ProdottiAction.initAllProdottiByCodsocieta(ProdottiAction.java:60)
 	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
 	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java(Compiled Code))
 	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java(Compiled Code))
 	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java(Compiled Code))
 	at java.lang.reflect.Method.invoke(Method.java(Compiled Code))
 	at org.apache.struts.actions.DispatchAction.dispatchMethod(DispatchAction.java:269)
 	at org.apache.struts.actions.DispatchAction.execute(DispatchAction.java:170)
 	at org.apache.struts.chain.commands.servlet.ExecuteAction.execute(ExecuteAction.java:58)
 	at org.apache.struts.chain.commands.AbstractExecuteAction.execute(AbstractExecuteAction.java:67)
 	at org.apache.struts.chain.commands.ActionCommandBase.execute(ActionCommandBase.java:51)
 	at org.apache.commons.chain.impl.ChainBase.execute(ChainBase.java:190)
 	at org.apache.commons.chain.generic.LookupCommand.execute(LookupCommand.java:304)
 	at org.apache.commons.chain.impl.ChainBase.execute(ChainBase.java:190)
 	at org.apache.struts.chain.ComposableRequestProcessor.process(ComposableRequestProcessor.java:283)
 	at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1913)
 	at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:449)
 	at javax.servlet.http.HttpServlet.service(HttpServlet.java:740)
 	at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
 	at com.ibm.ws.webcontainer.servlet.StrictServletInstance.doService(StrictServletInstance.java:110)
 	at com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet._service(StrictLifecycleServlet.java:174)
 	at com.ibm.ws.webcontainer.servlet.IdleServletState.service(StrictLifecycleServlet.java:313)
 	at com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet.service(StrictLifecycleServlet.java:116)
 	at com.ibm.ws.webcontainer.servlet.ServletInstance.service(ServletInstance.java:283)
 	at com.ibm.ws.webcontainer.servlet.ValidServletReferenceState.dispatch(ValidServletReferenceState.java:42)
 	at com.ibm.ws.webcontainer.servlet.ServletInstanceReference.dispatch(ServletInstanceReference.java:40)
 	at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.handleWebAppDispatch(WebAppRequestDispatcher.java:1171)
 	at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.dispatch(WebAppRequestDispatcher.java:676)
 	at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.forward(WebAppRequestDispatcher.java:203)
 	at com.ibm.ws.webcontainer.srt.WebAppInvoker.doForward(WebAppInvoker.java:125)
 	at com.ibm.ws.webcontainer.srt.WebAppInvoker.handleInvocationHook(WebAppInvoker.java:300)
 	at com.ibm.ws.webcontainer.cache.invocation.CachedInvocation.handleInvocation(CachedInvocation.java:71)
 	at com.ibm.ws.webcontainer.srp.ServletRequestProcessor.dispatchByURI(ServletRequestProcessor.java:246)
 	at com.ibm.ws.webcontainer.oselistener.OSEListenerDispatcher.service(OSEListener.java:334)
 	at com.ibm.ws.webcontainer.http.HttpConnection.handleRequest(HttpConnection.java:56)
 	at com.ibm.ws.http.HttpConnection.readAndHandleRequest(HttpConnection.java:652)
 	at com.ibm.ws.http.HttpConnection.run(HttpConnection.java:448)
 	at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:936)
 Caused by: com.ibm.db2.jcc.b.SqlException: Invalid argument: parameter index 1 is out of range.
 	at com.ibm.db2.jcc.b.tf.e(tf.java:3172)
 	at com.ibm.db2.jcc.b.tf.d(tf.java:3165)
 	at com.ibm.db2.jcc.b.tf.b(tf.java:918)
 	at com.ibm.db2.jcc.b.tf.setString(tf.java:910)
 	at com.ibm.ws.rsadapter.spi.InternalGenericDataStoreHelper.psSetString(InternalGenericDataStoreHelper.java:347)
 	at com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.setString(WSJdbcPreparedStatement.java:1192)
 	at org.hibernate.type.StringType.set(StringType.java:26)
 	at org.hibernate.type.NullableType.nullSafeSet(NullableType.java:136)
 	at org.hibernate.type.NullableType.nullSafeSet(NullableType.java:116)
 	at org.hibernate.param.NamedParameterSpecification.bind(NamedParameterSpecification.java:38)
 	at org.hibernate.loader.hql.QueryLoader.bindParameterValues(QueryLoader.java:491)
 	at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1563)
 	at org.hibernate.loader.Loader.doQuery(Loader.java:673)
 	at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:236)
 	at org.hibernate.loader.Loader.doList(Loader.java:2213)
 	... 48 more 
					
  
						
					 |