File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

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

 
Skye Roseboom
Greenhorn
Posts: 4
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 4
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Well, I solved this mystery myself. You should use java.math.BigDecimal as com.ibm.math.BigDecimal wont ever work for some reason.
skye
 
Don't get me started about those stupid light bulbs.
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic