• Post Reply Bookmark Topic Watch Topic
  • New Topic

com.ibm.websphere.cpi.CPIException  RSS feed

 
Rajesh Navduri
Ranch Hand
Posts: 31
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,

We are using WAS 4.0 Advanced Edition. While inserting a record in the database using Entity Bean its giving following err
***************************************************************
Non-application exception occurred while processing method create: com.ibm.websphere.cpi.CPIException: com.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver][Db2/NT] SQL0206N "MSGREFNO" is not valid in the context where it is used. SQLSTATE=42703.
****************************************************************
Our other Entity beans are working fine. But this bean only giving the problem.
Pl suggest..
Regds
Rajesh
 
Kyle Brown
author
Ranch Hand
Posts: 3892
5
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
What kind of Entity bean is this? CMP or BMP?
Kyle
------------------
Kyle Brown,
Author of Enterprise Java (tm) Programming with IBM Websphere
See my homepage at http://members.aol.com/kgb1001001 for other WebSphere information.
 
Rajesh Navduri
Ranch Hand
Posts: 31
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Kyle,
Its a CMP Bean...
Rajesh
 
Kyle Brown
author
Ranch Hand
Posts: 3892
5
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Are you using top-down, bottom-up or meet-in-the-middle mapping?
Kyle
------------------
Kyle Brown,
Author of Enterprise Java (tm) Programming with IBM Websphere
See my homepage at http://members.aol.com/kgb1001001 for other WebSphere information.
 
Rajesh Navduri
Ranch Hand
Posts: 31
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,
I am using top-down. while accessing a record with the Primar key its throwing
"[IBM][CLI Driver][DB2/NT] SQL0206N "T1.EMPNO" (where EMPNO is the primarkey) is not valid in the context where it is used SQLSTATE=42703"
Rajesh
 
Rajesh Navduri
Ranch Hand
Posts: 31
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Kyle,
Any suggestion on this please....

Rajesh
 
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!