I am simply trying to call the findByPrimaryKey method for a CMP entity bean. I am using com.ibm.math.BigDecimal for the key type which is mapped to an oracle number(10,0) data type.
I can successfully instantiate the home interface for the entity bean in a
JSP but when I attempt to make a call to the default finder method I get this stack trace:
Error Message: RemoteException occurred in server
thread; nested exception is: com.ibm.websphere.cpi.CPIException: java.sql.SQLException: ORA-00932: inconsistent datatypes ; nested exception is: java.sql.SQLException: ORA-00932: inconsistent datatypes
Error Code: 500
Target
Servlet: null
Error Stack:
java.rmi.ServerException: RemoteException occurred in server thread; nested exception is:
com.ibm.websphere.cpi.CPIException: java.sql.SQLException: ORA-00932: inconsistent datatypes
; nested exception is:
java.sql.SQLException: ORA-00932: inconsistent datatypes
com.ibm.websphere.cpi.CPIException: java.sql.SQLException: ORA-00932: inconsistent datatypes
; nested exception is:
java.sql.SQLException: ORA-00932: inconsistent datatypes
java.sql.SQLException: ORA-00932: inconsistent datatypes
Any help as to why this exception is happening would be very appreciated. Thanks
skye