• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

Test Client throws Exception when CMP EJB is tested

 
Ranch Hand
Posts: 39
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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
prasad@lincsoftware.soft.net
 
Greenhorn
Posts: 1
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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
 
Hoo hoo hoo! Looks like we got a live one! Here, wave this tiny ad at it:
a bit of art, as a gift, that will fit in a stocking
https://gardener-gift.com
reply
    Bookmark Topic Watch Topic
  • New Topic