RE: problem with ResultSet Object
CachedRowSet doesn't participate in transactions as it is teared-off object and it stores stale (old) data. For high-volume concurrent updating requests use it with care ( or better not to use if you are not sure ). I use it for read-only data infrequent access. -Original Message- From: sachin mahajan [SMTP:[EMAIL PROTECTED]] Sent:15 2002 6:32 To: Orion-Interest Subject:Re: problem with ResultSet Object Hello Thanks. Can u explain me if i will use CachedRowSet object instead of ResultSet object. How my application is affected and it is scalable or not. sachin - Original Message - From: Dvornikov Victor [EMAIL PROTECTED] To: Orion-Interest [EMAIL PROTECTED] Sent: Thursday, February 14, 2002 1:48 PM Subject: RE: problem with ResultSet Object ResultSEt is not a serializable object. For RMI purpose use CachedRowSet object Take into account that this object is not for scalable applications! -Original Message- From: sachin mahajan [SMTP:[EMAIL PROTECTED]] Sent: 14 2002 6:51 To: Orion-Interest Cc: sachin mahajan Subject: problem with ResultSet Object Dear Sir Currently i am working om the orion server. i have deployed my application properly. But i am facing some problem with transfering ResultSet object from my EJB to jsp . It error i am facing is this inside basedl The statement is oracle.jdbc.driver.OracleStatement@9617f825 inside basedl The resultset is oracle.jdbc.driver.OracleResultSet@c72ff82a Resultset is before returning :*** oracle.jdbc.driver.OracleResultSet@c72ff82a inside buildselect exception is com.evermind.server.rmi.OrionRemoteException: Error (de-)serializing object: ora cle.jdbc.driver.OracleResultSet at com.evermind.server.ejb.EJBUtils.cloneObject(Unknown Source) at ConnectionPool_StatelessSessionBeanWrapper0.read(ConnectionPool_State lessSessionBeanWrapper0.java, Compiled Code) can any body tell me how to solve this problem Waiting for your reply.. regds sachin _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com
Re: problem with ResultSet Object
Sachin: I think you have a design problem. Please,anyone correct me if you think i'm wrong. From inside a JSP page you should not access a recordset returned by an EJB. EJB components represent mostly bussines objects that contains rules and data access services. From outside the EJB (from a JSP page or remote client) the data that this component encapsulates should be accesed using services that returns serializable data types (objects thart starts with an uppercase or even another EJBS throught it's remote interface). In design terms, you are innecesarily coupling presentation layer with data layer if you return a ResultSet. Capture the resultset in private variables of your EJB and provide "getter"services if it is a stateful bean, or you can returna Hashtable with attributes if it is a stateless one. Hope this can help you. JJ - Original Message - From: sachin mahajan To: Orion-Interest Cc: sachin mahajan Sent: Thursday, February 14, 2002 1:50 AM Subject: problem with ResultSet Object Dear Sir Currently i am workingom the orion server. i have deployed my application properly. But i am facing some problem with transfering ResultSet object from my EJB to jsp . It error i am facing is this inside basedl The statement is oracle.jdbc.driver.OracleStatement@9617f825inside basedl The resultset is oracle.jdbc.driver.OracleResultSet@c72ff82aResultset is before returning :*** oracle.jdbc.driver.OracleResultSet@c72ff82a inside buildselect exception is com.evermind.server.rmi.OrionRemoteException: Error (de-)serializing object: oracle.jdbc.driver.OracleResultSet at com.evermind.server.ejb.EJBUtils.cloneObject(Unknown Source) at ConnectionPool_StatelessSessionBeanWrapper0.read(ConnectionPool_StatelessSessionBeanWrapper0.java, Compiled Code) can any body tell me how to solve this problem Waiting for your reply.. regds sachin
Re: problem with ResultSet Object
ResultSet is not a seralizable object. ResultSet is opened cursor to the database. If you want to pass ResultSet to client i.e jsp/servlet either conver the ResultSet data into you own custom objects or collection classes. The other alternate is to use CachedRowSet. CachedRowset is serializable object and contains all the information what ResultSet contains. You can get more information on RowSet at http://www.javaworld.com/javaworld/jw-02-2001/jw-0202-cachedrow.html -kesav - Original Message - From: sachin mahajan To: Orion-Interest Cc: sachin mahajan Sent: Wednesday, February 13, 2002 8:50 PM Subject: problem with ResultSet Object Dear Sir Currently i am workingom the orion server. i have deployed my application properly. But i am facing some problem with transfering ResultSet object from my EJB to jsp . It error i am facing is this inside basedl The statement is oracle.jdbc.driver.OracleStatement@9617f825inside basedl The resultset is oracle.jdbc.driver.OracleResultSet@c72ff82aResultset is before returning :*** oracle.jdbc.driver.OracleResultSet@c72ff82a inside buildselect exception is com.evermind.server.rmi.OrionRemoteException: Error (de-)serializing object: oracle.jdbc.driver.OracleResultSet at com.evermind.server.ejb.EJBUtils.cloneObject(Unknown Source) at ConnectionPool_StatelessSessionBeanWrapper0.read(ConnectionPool_StatelessSessionBeanWrapper0.java, Compiled Code) can any body tell me how to solve this problem Waiting for your reply.. regds sachin
Re: problem with ResultSet Object
Hello Thanks. Can u explain me if i will use CachedRowSet object instead of ResultSet object. How my application is affected and it is scalable or not. sachin - Original Message - From: Dvornikov Victor [EMAIL PROTECTED] To: Orion-Interest [EMAIL PROTECTED] Sent: Thursday, February 14, 2002 1:48 PM Subject: RE: problem with ResultSet Object ResultSEt is not a serializable object. For RMI purpose use CachedRowSet object Take into account that this object is not for scalable applications! -Original Message- From: sachin mahajan [SMTP:[EMAIL PROTECTED]] Sent: 14 2002 6:51 To: Orion-Interest Cc: sachin mahajan Subject: problem with ResultSet Object Dear Sir Currently i am working om the orion server. i have deployed my application properly. But i am facing some problem with transfering ResultSet object from my EJB to jsp . It error i am facing is this inside basedl The statement is oracle.jdbc.driver.OracleStatement@9617f825 inside basedl The resultset is oracle.jdbc.driver.OracleResultSet@c72ff82a Resultset is before returning :*** oracle.jdbc.driver.OracleResultSet@c72ff82a inside buildselect exception is com.evermind.server.rmi.OrionRemoteException: Error (de-)serializing object: ora cle.jdbc.driver.OracleResultSet at com.evermind.server.ejb.EJBUtils.cloneObject(Unknown Source) at ConnectionPool_StatelessSessionBeanWrapper0.read(ConnectionPool_State lessSessionBeanWrapper0.java, Compiled Code) can any body tell me how to solve this problem Waiting for your reply.. regds sachin _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com