CachedRowSet

Thu, 19 Sep 2002 03:57:14 -0700

Hi all,
 
I want to ask several questions about CachedRowSet object. I want to develop an application using RowSet. This application is a "servlet-to-RMI communication" application. Servlet (it is a RMI client) send a student number to the RMI server. RMI server is connect an access database using the student number and execute query and create a RecordSet object. Then RecordSet is converted to RowSet object by using the populate( ) metod of rowset (for example CachedRowSet crset = polulate(rset);) and returned to the servlet (return crset;).
Servlet will read needed information from rowset (for example crset.getString("Name")) and create a HTML table and send it client.
 
To this application, I wrote needed codes and compiled them. Then I started RMI server and tomcat3.3.1 and sent a student number to servlet. While I hope to see student information, I saw an error message.
 
"Error:500 Internal Server Error"

The complite error message is end of the email. Now I wan to ask my questions;
 
1- According to the document whic I read, I must use  CachedRowSet object which is "idel for sending data in a distributed environment". To use this object Which package (javax.sql or  sun.jdbc.rowset) must use?
 
2- Which jar file must added Classpath? rowset.jar or jdbc2_0-stdext.jar?
 
3- What can I do to correct error?
 
thanks....
 
 

Error: 500

Location: /rowset/servlet/RowsetServlet

Internal Servlet Error:
java.rmi.UnmarshalException: error unmarshalling return; nested exception is: 
        java.lang.ClassNotFoundException: sun.jdbc.rowset.CachedRowSet (no security manager: RMI class loader disabled)
        at sun.rmi.server.UnicastRef.invoke(UnicastRef.java:169)
        at RowsetImpl_Stub.Query(Unknown Source)
        at RowsetServlet.doPost(RowsetServlet.java:49)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java)
        at org.apache.tomcat.facade.ServletHandler.doService(ServletHandler.java:574)
        at org.apache.tomcat.core.Handler.invoke(Handler.java:322)
        at org.apache.tomcat.core.Handler.service(Handler.java:235)
        at org.apache.tomcat.facade.ServletHandler.service(ServletHandler.java:485)
        at org.apache.tomcat.core.ContextManager.internalService(ContextManager.java:917)
        at org.apache.tomcat.core.ContextManager.service(ContextManager.java:833)
        at org.apache.tomcat.modules.server.Http10Interceptor.processConnection(Http10Interceptor.java:176)
        at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:494)
        at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:516)
        at java.lang.Thread.run(Thread.java:536)
Caused by: java.lang.ClassNotFoundException: sun.jdbc.rowset.CachedRowSet (no security manager: RMI class loader disabled)
        at sun.rmi.server.LoaderHandler.loadClass(LoaderHandler.java:368)
        at sun.rmi.server.LoaderHandler.loadClass(LoaderHandler.java:161)
        at java.rmi.server.RMIClassLoader$2.loadClass(RMIClassLoader.java:629)
        at java.rmi.server.RMIClassLoader.loadClass(RMIClassLoader.java:257)
        at sun.rmi.server.MarshalInputStream.resolveClass(MarshalInputStream.java:200)
        at java.io.ObjectInputStream.readNonProxyDesc(ObjectInputStream.java:1503)
        at java.io.ObjectInputStream.readClassDesc(ObjectInputStream.java:1425)
        at java.io.ObjectInputStream.readOrdinaryObject(ObjectInputStream.java:1616)
        at java.io.ObjectInputStream.readObject0(ObjectInputStream.java:1264)
        at java.io.ObjectInputStream.readObject(ObjectInputStream.java:322)
        at sun.rmi.server.UnicastRef.unmarshalValue(UnicastRef.java:297)
        at sun.rmi.server.UnicastRef.invoke(UnicastRef.java:146)
        ... 14 more

Reply via email to