Hi All
We have added a new column in the database and done the necessary mapping. While deploying to Websphere App Server 5.1 on AIX m/c we get following error. Any help would be really appreciated.
Jay
Main Exception:
****************
com.ibm.ws.ejbpersistence.utilpm.ErrorProcessingResultCollectionRow: PMGR6031E: SQLException when trying to get resultSet column 44 as a String. RawBeanData=com.ibm.ws.ejbpersistence.dataaccess.RawBeanData@574794cb
currentBeanChunkOffset = 0
Result data is a ResultSet. /n com.ibm.ws.rsadapter.cci.WSRdbResultSetImpl@1de654ca
at com.ibm.ws.ejbpersistence.dataaccess.RawBeanData.getString(Unknown Source)
at com.xyz.abc.subscription.ejb.entity.websphere_deploy.ORACLE_V9_2.SubscriptionBeanExtractor_a6de9945.extractData(SubscriptionBeanExtractor_a6de9945.java:69)
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 com.xyz.abc.subscription.ejb.entity.ConcreteSubscription_a6de9945.ejbLoad(ConcreteSubscription_a6de9945.java:37)
at com.ibm.ejs.container.ContainerManaged2_0BeanO.loadForEnlist(ContainerManaged2_0BeanO.java:331)
at com.ibm.ejs.container.EntityBeanO.enlist(EntityBeanO.java:718)
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))
at com.ibm.ejs.container.EJSHome.activateBean_Common(EJSHome.java(Compiled Code))
at com.ibm.ejs.container.EJSHome.activateBean_Local(EJSHome.java(Compiled Code))
at com.xyz.abc.subscription.ejb.entity.EJSCMPSubscriptionHomeBean_a6de9945.findByPrimaryKey_Local(EJSCMPSubscriptionHomeBean_a6de9945.java(Inlined Compiled Code))
*************
Nested Exception:
-----------------
java.sql.SQLException: Invalid column index
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java(Compiled Code))
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java(Inlined Compiled Code))
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java(Inlined Compiled Code))
at oracle.jdbc.driver.OracleStatement.prepare_for_new_get(OracleStatement.java(Compiled Code))
at oracle.jdbc.driver.OracleStatement.getStringValue(OracleStatement.java(Compiled Code))
at oracle.jdbc.driver.OracleResultSetImpl.getString(OracleResultSetImpl.java(Compiled Code))
at oracle.jdbc.driver.UpdatableResultSet.getString(UpdatableResultSet.java:359)
at com.ibm.ws.rsadapter.cci.WSRdbResultSetImpl.getString(WSRdbResultSetImpl.java:2284)
at com.ibm.ws.ejbpersistence.dataaccess.RawBeanData.getString(Unknown Source)
at com.xyz.abc.subscription.ejb.entity.websphere_deploy.ORACLE_V9_2.SubscriptionBeanExtractor_a6de9945.extractData(SubscriptionBeanExtractor_a6de9945.java:69)
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 com.xyz.abc.subscription.ejb.entity.ConcreteSubscription_a6de9945.ejbLoad(ConcreteSubscription_a6de9945.java:37)
at com.ibm.ejs.container.ContainerManaged2_0BeanO.loadForEnlist(ContainerManaged2_0BeanO.java:331)
at com.ibm.ejs.container.EntityBeanO.enlist(EntityBeanO.java:718)
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))
at com.ibm.ejs.container.EJSHome.activateBean_Common(EJSHome.java(Compiled Code))
at com.ibm.ejs.container.EJSHome.activateBean_Local(EJSHome.java(Compiled Code))
at com.xyz.abc.subscription.ejb.entity.EJSCMPSubscriptionHomeBean_a6de9945.findByPrimaryKey_Local(EJSCMPSubscriptionHomeBean_a6de9945.java(Inlined Compiled Code))
