aspose file tools*
The moose likes Websphere and the fly likes ORA-00932: inconsistent datatypes exception using WSAD 4.0.3 and oracle 8 Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Products » Websphere
Bookmark "ORA-00932: inconsistent datatypes exception using WSAD 4.0.3 and oracle 8" Watch "ORA-00932: inconsistent datatypes exception using WSAD 4.0.3 and oracle 8" New topic
Author

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

Skye Roseboom
Greenhorn

Joined: Aug 09, 2002
Posts: 4
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
Greenhorn

Joined: Aug 09, 2002
Posts: 4
Well, I solved this mystery myself. You should use java.math.BigDecimal as com.ibm.math.BigDecimal wont ever work for some reason.
skye
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: ORA-00932: inconsistent datatypes exception using WSAD 4.0.3 and oracle 8