ORA-00932: inconsistent datatypes exception using WSAD 4.0.3 and oracle 8

[Skye Roseboom]

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

[Skye Roseboom]

Well, I solved this mystery myself. You should use java.math.BigDecimal as com.ibm.math.BigDecimal wont ever work for some reason.
skye