java.sql.SQLException: Descriptor index not valid.

[varadh...@lycos.com]

Hi,

I have one EJB CMP and thas was working fine. I have added one timestamp column in database for that I modified the CMP as well with the addtion of the new timestamp field.

After added this new field,
I got the home interface from JNDI and created the remote interface, then trying to set some values in the remote interface, I am getting the following exception.

could you please help me solve this issue?

Error:
---------
java.rmi.RemoteException: ; nested exception is:
java.sql.SQLException: Descriptor index not valid.
at com.ibm.ejs.container.RemoteExceptionMappingStrategy.mapEJBException(RemoteExceptionMappingStrategy.java:411)
at com.ibm.ejs.container.RemoteExceptionMappingStrategy.mapException(RemoteExceptionMappingStrategy.java:113)
at com.ibm.ejs.container.RemoteExceptionMappingStrategy.setUncheckedException(RemoteExceptionMappingStrategy.java:203)
at com.ibm.ejs.container.EJSDeployedSupport.setUncheckedException(EJSDeployedSupport.java:296)
at com.ibm.ejs.container.EJSContainer.preInvoke_internal(EJSContainer.java(Compiled Code))
at com.ibm.ejs.container.EJSContainer.preInvoke(EJSContainer.java(Inlined Compiled Code))
at com.ibm.ejs.container.EJSContainer.preInvoke(EJSContainer.java(Compiled Code))
at mhcs.physicianlink.cmp.EJSRemoteCMPReqSched_619f0d7c.setPatientMRN(EJSRemoteCMPReqSched_619f0d7c.java:831)
at mhcs.physicianlink.cmp._EJSRemoteCMPReqSched_619f0d7c_Tie._set_patientMRN(_EJSRemoteCMPReqSched_619f0d7c_Tie.java:302)
at mhcs.physicianlink.cmp._EJSRemoteCMPReqSched_619f0d7c_Tie._invoke(_EJSRemoteCMPReqSched_619f0d7c_Tie.java:197)
at com.ibm.CORBA.iiop.ServerDelegate.dispatchInvokeHandler(ServerDelegate.java(Compiled Code))
at com.ibm.CORBA.iiop.ServerDelegate.dispatch(ServerDelegate.java(Compiled Code))
at com.ibm.rmi.iiop.ORB.process(ORB.java(Compiled Code))
at com.ibm.CORBA.iiop.ORB.process(ORB.java(Compiled Code))
at com.ibm.rmi.iiop.Connection.doWork(Connection.java(Compiled Code))
at com.ibm.rmi.iiop.WorkUnitImpl.doWork(WorkUnitImpl.java(Compiled Code))
at com.ibm.ejs.oa.pool.PooledThread.run(ThreadPool.java(Compiled Code))
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java(Compiled Code))
Caused by: java.sql.SQLException: Descriptor index not valid.
at com.ibm.as400.access.JDError.throwSQLException(JDError.java:382)
at com.ibm.as400.access.JDError.throwSQLException(JDError.java(Inlined Compiled Code))
at com.ibm.as400.access.AS400JDBCResultSet.getValue(AS400JDBCResultSet.java(Compiled Code))
at com.ibm.as400.access.AS400JDBCResultSet.internalGetTimestamp(AS400JDBCResultSet.java:3433)
at com.ibm.as400.access.AS400JDBCResultSet.getTimestamp(AS400JDBCResultSet.java:3399)
at com.ibm.ws.rsadapter.cci.WSRdbResultSetImpl.getTimestamp(WSRdbResultSetImpl.java:2503)
at com.ibm.ws.ejbpersistence.dataaccess.RawBeanData.getTimestamp(Unknown Source)
at mhcs.physicianlink.cmp.websphere_deploy.DB2UDBAS400_V5_1.ReqSchedBeanExtractor_619f0d7c.extractData(ReqSchedBeanExtractor_619f0d7c.java:44)
at com.ibm.ws.ejbpersistence.dataaccess.OneRowResultCollectionImpl.processOneRowToCacheEntry(Unknown Source)
at com.ibm.ws.ejbpersistence.dataaccess.DataAccessRequestImpl.executeOneRowFBPK(Unknown Source)
at com.ibm.ws.ejbpersistence.beanextensions.ConcreteBeanStatefulInstanceExtensionImpl.fetchRecordFromDataStore(Unknown Source)
at com.ibm.ws.ejbpersistence.beanextensions.ConcreteBeanStatefulInstanceExtensionImpl.getRecordForLoad(Unknown Source)
at com.ibm.ws.ejbpersistence.beanextensions.ConcreteBeanStatefulInstanceExtensionImpl.executeLoad(Unknown Source)
at com.ibm.ws.ejbpersistence.beanextensions.CBReadyState.ejbLoad(Unknown Source)
at com.ibm.ws.ejbpersistence.beanextensions.ConcreteBeanStatefulInstanceExtensionImpl.ejbLoad(Unknown Source)
at mhcs.physicianlink.cmp.ConcreteReqSched_619f0d7c.ejbLoad(ConcreteReqSched_619f0d7c.java:37)
at com.ibm.ejs.container.ContainerManaged2_0BeanO.loadForEnlist(ContainerManaged2_0BeanO.java(Compiled Code))
at com.ibm.ejs.container.EntityBeanO.enlist(EntityBeanO.java(Compiled Code))
at com.ibm.ejs.container.activator.OptCEntityActivationStrategy.atActivate(OptCEntityActivationStrategy.java(Compiled Code))
at com.ibm.ejs.container.activator.Activator.activateBean(Activator.java(Inlined Compiled Code))

[kenn...@hk1.ibm.com]

I found some solution in other forum,
It may be caused by the jt400.jar was not updated version

[varadh...@lycos.com]

Hi,

Thank you very much for your information. Let me try with the updated jt400.jar. And updated the results.

Regards

[varadh...@lycos.com]

Hi,

Thank you very much for your information. Let me try with the updating jt400.jar and update the results.

Regards