Test Client throws Exception when CMP EJB is tested

[Prasad Thirugnanam]

Hi Kyle Brown,
I am working on creating a new Entity Bean as given in
the WCS5.1 Programmer's Guide.pdf. I created a command
as given in the redbook. Its working fine.
I created an entity bean as given in the book.
Created EJB group, CMP Bean, added CMP fields,
added finder method.
I followed the steps to map the EJB to the database table.
When i created the access bean first i tried with
findFavoRecord(CtpshpfavKey) as zero arg constructor.
I generated the deployed code. It didn't gave any error.
When i run my CMP EJB from VAJ Test client,
it throws the following exception:
java.rmi.ServerException:RemoteException occurred i server thread:nested exception is:
com.ibm.ejs.persistence.EJSPersistenceException:findShopFavoRecords failed: nested exception is:
COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver] CLI0125E Function Sequence Error; SQLSTATE=HY010
As per the redbook, i changed the finder method return type from Enumeration to
"MyShop" type. Still i face the same problem.
Could you plese help me?
Thanks in advance,
T.Prasad
[email protected]

[Bob Zuidema]

You need to configure DB2 to use the following property:
connectionAttribute=cursorhold=1
In WSAD this value can be set as a resource property for the Data Source, in VAJ you must look at the documentation how this can be set.
Hope this helps,
Bob Zuidema