I use ms-sql 2000, weblogic8.1 and cmp for entity bean. There 3 tables. Their relationship
are Itinerary - (1:N)FlightNo - (1:N)CabinPrice. When my Sessionbean call, db
will select an Itinerary object from the three table.

I use Statement Cache Size:10
Statement Cache Type:LUR

Any idea for the following exception?
Stephen

javax.ejb.FinderException: Exception in findByAirItinerary_mlrvrw__WebLogic_CMP_RDBMS_flig htItems__WL_
while preparing or executing statement: 'weblogic.jdbc.wrapper.PreparedStatement_weblogic_ jdbcx_base_BasePreparedStatementWrapper@497e41'
java.sql.SQLException: [BEA][SQLServer JDBC Driver][SQLServer]sp_cursorclose:
the cursor value provided£šabe4f68£© is invalid¡£
java.sql.SQLException: [BEA][SQLServer JDBC Driver][SQLServer]sp_cursorclose:
the cursor value provided£šabe4f68£© is invalid¡£
at weblogic.jdbc.base.BaseExceptions.createException( Unknown Source)
at weblogic.jdbc.base.BaseExceptions.getException(Unk nown Source)
at weblogic.jdbc.sqlserver.tds.TDSRequest.processErro rToken(Unknown Source)
at weblogic.jdbc.sqlserver.tds.TDSRequest.processRepl yToken(Unknown Source)
at weblogic.jdbc.sqlserver.tds.TDSRPCRequest.processR eplyToken(Unknown Source)
at weblogic.jdbc.sqlserver.tds.TDSRPCCursorExecuteReq uest.processReplyToken(Unknown
Source)
at weblogic.jdbc.sqlserver.tds.TDSRequest.processRepl y(Unknown Source)
at weblogic.jdbc.sqlserver.tds.TDSRPCCursorExecuteReq uest.closeCursor(Unknown
Source)
at weblogic.jdbc.sqlserver.tds.TDSRPCCursorExecuteReq uest.completeRowProcessing(Unknown
Source)
at weblogic.jdbc.sqlserver.SQLServerImplResultSet.int ernalClose(Unknown Source)
at weblogic.jdbc.sqlserver.SQLServerImplResultSetServ erSideCursor.close(Unknown
Source)
at weblogic.jdbc.base.BaseResultSet.close(Unknown Source)
at weblogic.jdbc.base.BaseStatement.closeCurrentResul ts(Unknown Source)
at weblogic.jdbc.base.BaseStatement.commonTransitionT oState(Unknown Source)
at weblogic.jdbc.base.BasePreparedStatement.executeQu ery(Unknown Source)
at weblogic.jdbcx.base.BasePreparedStatementWrapper.e xecuteQuery(Unknown Source)
at weblogic.jdbc.wrapper.PreparedStatement.executeQue ry(PreparedStatement.java:80)
at com.netsboss.WSBE.flightcache.data.FlightItem_9pn3 vk__WebLogic_CMP_RDBMS.ejbFindByAirItinerary_mlrvr w__WebLogic_CMP_RDBMS_flightItems__WL_(FlightItem_ 9pn3vk__WebLogic_CMP_RDBMS.java:3277)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Nativ e Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Native MethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(De legatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at weblogic.ejb20.cmp.rdbms.RDBMSPersistenceManager.c ollectionFinder(RDBMSPersistenceManager.java:342)
at weblogic.ejb20.manager.BaseEntityManager.wrapperSe tFinder(BaseEntityManager.java:1756)
at weblogic.ejb20.manager.BaseEntityManager.localWrap perSetFinder(BaseEntityManager.java:1727)
at com.netsboss.WSBE.flightcache.data.AirItinerary_ml rvrw__WebLogic_CMP_RDBMS_flightItems_Set.populateC ache(AirItinerary_mlrvrw__WebLogic_CMP_RDBMS_fligh tItems_Set.java:113)
at com.netsboss.WSBE.flightcache.data.AirItinerary_ml rvrw__WebLogic_CMP_RDBMS_flightItems_Set.iterator( AirItinerary_mlrvrw__WebLogic_CMP_RDBMS_flightItem s_Set.java:245)
at com.netsboss.WSBE.flightcache.session.impl.FightCa cheSession.getCache(FightCacheSession.java:611)
at com.netsboss.WSBE.flightcache.session.impl.FlightC acheSession_ylx9ls_EOImpl.getCache(FlightCacheSess ion_ylx9ls_EOImpl.java:372)
at com.netsboss.WSBE.flightcache.message.impl.FlightC acheMSGBean.onMessage(FlightCacheMSGBean.java:75)
at weblogic.ejb20.internal.MDListener.execute(MDListe ner.java:382)
at weblogic.ejb20.internal.MDListener.transactionalOn Message(MDListener.java:316)
at weblogic.ejb20.internal.MDListener.onMessage(MDLis tener.java:281)
at weblogic.jms.client.JMSSession.onMessage(JMSSessio n.java:2596)
at weblogic.jms.client.JMSSession.execute(JMSSession. java:2516)
at weblogic.kernel.ExecuteThread.execute(ExecuteThrea d.java:197)
at weblogic.kernel.ExecuteThread.run(ExecuteThread.ja va:170)

at com.netsboss.WSBE.flightcache.data.AirItinerary_ml rvrw__WebLogic_CMP_RDBMS_flightItems_Set.populateC ache(AirItinerary_mlrvrw__WebLogic_CMP_RDBMS_fligh tItems_Set.java:144)
at com.netsboss.WSBE.flightcache.data.AirItinerary_ml rvrw__WebLogic_CMP_RDBMS_flightItems_Set.iterator( AirItinerary_mlrvrw__WebLogic_CMP_RDBMS_flightItem s_Set.java:245)
at com.netsboss.WSBE.flightcache.session.impl.FightCa cheSession.getCache(FightCacheSession.java:611)
at com.netsboss.WSBE.flightcache.session.impl.FlightC acheSession_ylx9ls_EOImpl.getCache(FlightCacheSess ion_ylx9ls_EOImpl.java:372)
at com.netsboss.WSBE.flightcache.message.impl.FlightC acheMSGBean.onMessage(FlightCacheMSGBean.java:75)
at weblogic.ejb20.internal.MDListener.execute(MDListe ner.java:382)
at weblogic.ejb20.internal.MDListener.transactionalOn Message(MDListener.java:316)
at weblogic.ejb20.internal.MDListener.onMessage(MDLis tener.java:281)
at weblogic.jms.client.JMSSession.onMessage(JMSSessio n.java:2596)
at weblogic.jms.client.JMSSession.execute(JMSSession. java:2516)
at weblogic.kernel.ExecuteThread.execute(ExecuteThrea d.java:197)
at weblogic.kernel.ExecuteThread.run(ExecuteThread.ja va:170)