Curious if anyone is having an issue like this...
Its pretty basic stuff... Struts app, Spring for IoC / DAO support and Hibernate for persistence.

Getting "Communication link failures?"

Any advice would be appreciated..

Versions:
Database product name : DB2/LINUX
Database product version : 08.01.0000
JDBC driver name : IBM DB2 JDBC 2.0 Type 2
JDBC driver version : 08.01.0000

Websphere 5.1.1

Gory Details:

Hibernate: select this.APPLICANT_OID as APPLICAN1_0_, this.LOCK_SEQ_NO as LOCK_SEQ2_0_ < blah blah > from GASPERMIT.APPLICANT this where this.LST_NM like ?
[5/27/04 20:39:13:822 CDT] 41ab015 StaleConnecti A CONM7007I: Mapping the following SQLException, with ErrorCode -99,999 and SQLState 40003, to a StaleConnectionException: COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver] CLI0108E Communication link failure. SQLSTATE=40003
at COM.ibm.db2.jdbc.app.SQLExceptionGenerator.throw_SQLException(SQLExceptionGenerator.java:281)
at COM.ibm.db2.jdbc.app.SQLExceptionGenerator.throw_SQLException(SQLExceptionGenerator.java:218)
at COM.ibm.db2.jdbc.app.SQLExceptionGenerator.check_return_code(SQLExceptionGenerator.java:448)
at COM.ibm.db2.jdbc.app.DB2PreparedStatement.execute2(DB2PreparedStatement.java:2177)
at COM.ibm.db2.jdbc.app.DB2PreparedStatement.executeQuery(DB2PreparedStatement.java:1672)
at com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.executeQuery(WSJdbcPreparedStatement.java:426)
at net.sf.hibernate.impl.BatcherImpl.getResultSet(BatcherImpl.java:83)
at net.sf.hibernate.loader.Loader.getResultSet(Loader.java:794)
at net.sf.hibernate.loader.Loader.doQuery(Loader.java:188)
at net.sf.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:132)
at net.sf.hibernate.loader.Loader.doList(Loader.java:949)
at net.sf.hibernate.loader.CriteriaLoader.list(CriteriaLoader.java:109)
at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:3440)
at net.sf.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:177)
at com.ibm.permit.dao.hibernate.HibernateApplicantDao.findByCriteria(Unknown Source)
at com.ibm.permit.service.GasPermitServiceImpl.searchApplicant(Unknown Source)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:79)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:41)
at java.lang.reflect.Method.invoke(Method.java:386)
at org.springframework.aop.framework.AopProxyUtils.invokeJoinpointUsingReflection(AopProxyUtils.java:59)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:138)
at $Proxy0.searchApplicant(Unknown Source)
at com.ibm.permit.web.actions.SearchApplicantAction.executeAction(Unknown Source)
at com.ibm.permit.web.actions.PermitBaseAction.execute(Unknown Source)
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)
at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:525)

You don't use WAS datasources ?

Yes I am using a Datasource configured through Websphere.
I have the "datasource" and "sessionFactory" all configured through Spring.

This information below was just what WS blurts out in the log..thought might be useful..
Versions:
Database product name : DB2/LINUX
Database product version : 08.01.0000
JDBC driver name : IBM DB2 JDBC 2.0 Type 2
JDBC driver version : 08.01.0000

However I am looking up the connections thru a datasource.


Another odd sidenote... It only seems to happen on the first operation against the DB.... rebooted and tried in W2K... doesnt seem to occur there. Very Odd.

Try to set some DS params like :
- check connection after release
- check connection before retrieve etc