We have created EntityBean using VAJ on a table temperature which has fields city(PK) ,country & temp . Generated (mapping the schema & browser map) & Run the VAJ client . When we call the homeinterface method create(String city) . the record is getting inserted into table but now when we call setCountry or setTemp method or any other RemoteInterface method we get following error.
ERROR: Exception thrown by method.
ERROR: Exception is: java.rmi.ServerException: RemoteException occurred in server thread; nested exception is:
com.ibm.ejs.persistence.EJSPersistenceException: getPStmt failed; nested exception is:
COM.ibm.db2.jdbc.app.DB2Exception: [IBM][CLI Driver] CLI0125E Function sequence error. SQLSTATE=HY010
THIS IS THE CASE WHEN WE RM USING DB2 DATABASE
WHILE THE SAME THING WITH ORACLE IS WORKING FINE…..