• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

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

 
Greenhorn
Posts: 4
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
 
reply
    Bookmark Topic Watch Topic
  • New Topic