exception error

I created a project for trying the example "TwoPageCrudTable" which can be found in the section "Technical Articles & Tips ". My display page is a little bit different as the one in the example: I don't have the drop down list, just load everything from the table. But when I run the project, I got the following error. Could anybody give some help? Thanks in advance! I don't know if it it because the table is empty.

--

Here is the error:

Exception Handler

Description: An unhandled exception occurred during the execution of the web application. Please review the following stack trace for more information regarding the error.

Exception Details: org.apache.jasper.JasperException

java.sql.SQLException: Internal Error in RowSetReader: no connection or command.

Possible Source of Error:

Class Name: org.apache.jasper.servlet.JspServletWrapper

File Name: JspServletWrapper.java

Method Name: service

Line Number: 384

Source not available. Information regarding the location of the exception can be identified using the exception stack trace below.

Stack Trace:

org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:384)

org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:297)

org.apache.jasper.servlet.JspServlet.service(JspServlet.java:247)

javax.servlet.http.HttpServlet.service(HttpServlet.java:860)

sun.reflect.NativeMethodAccessorImpl.invoke0(NativeMethodAccessorImpl.java:-2)

sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.ja va:25)

java.lang.reflect.Method.invoke(Method.java:585)

org.apache.catalina.security.SecurityUtil$1.run(SecurityUtil.java:249)

java.security.AccessController.doPrivileged(AccessController.java:-2)

javax.security.auth.Subject.doAsPrivileged(Subject.java:517)

org.apache.catalina.security.SecurityUtil.execute(SecurityUtil.java:282)

org.apache.catalina.security.SecurityUtil.doAsPrivilege(SecurityUtil.java:165)

org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFil terChain.java:257)

org.apache.catalina.core.ApplicationFilterChain.access$000(ApplicationFilterCha in.java:55)

org.apache.catalina.core.ApplicationFilterChain$1.run(ApplicationFilterChain.ja va:161)

java.security.AccessController.doPrivileged(AccessController.java:-2)

org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain .java:157)

org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.jav a:723)

org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispat cher.java:482)

org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher. java:417)

org.apache.catalina.core.ApplicationDispatcher.access$000(ApplicationDispatcher .java:80)

org.apache.catalina.core.ApplicationDispatcher$PrivilegedForward.run(Applicatio nDispatcher.java:95)

java.security.AccessController.doPrivileged(AccessController.java:-2)

org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.ja va:313)

com.sun.faces.context.ExternalContextImpl.dispatch(ExternalContextImpl.java:322 )

com.sun.faces.application.ViewHandlerImpl.renderView(ViewHandlerImpl.java:130)

com.sun.rave.web.ui.appbase.faces.ViewHandlerImpl.renderView(ViewHandlerImpl.ja va:311)

com.sun.faces.lifecycle.RenderResponsePhase.execute(RenderResponsePhase.java:87 )

com.sun.faces.lifecycle.LifecycleImpl.phase(LifecycleImpl.java:221)

com.sun.faces.lifecycle.LifecycleImpl.render(LifecycleImpl.java:117)

javax.faces.webapp.FacesServlet.service(FacesServlet.java:198)

sun.reflect.NativeMethodAccessorImpl.invoke0(NativeMethodAccessorImpl.java:-2)

sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.ja va:25)

java.lang.reflect.Method.invoke(Method.java:585)

org.apache.catalina.security.SecurityUtil$1.run(SecurityUtil.java:249)

java.security.AccessController.doPrivileged(AccessController.java:-2)

javax.security.auth.Subject.doAsPrivileged(Subject.java:517)

org.apache.catalina.security.SecurityUtil.execute(SecurityUtil.java:282)

org.apache.catalina.security.SecurityUtil.doAsPrivilege(SecurityUtil.java:165)

org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFil terChain.java:257)

org.apache.catalina.core.ApplicationFilterChain.access$000(ApplicationFilterCha in.java:55)

org.apache.catalina.core.ApplicationFilterChain$1.run(ApplicationFilterChain.ja va:161)

java.security.AccessController.doPrivileged(AccessController.java:-2)

org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain .java:157)

com.sun.rave.web.ui.util.UploadFilter.doFilter(UploadFilter.java:194)

org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFil terChain.java:210)

org.apache.catalina.core.ApplicationFilterChain.access$000(ApplicationFilterCha in.java:55)

org.apache.catalina.core.ApplicationFilterChain$1.run(ApplicationFilterChain.ja va:161)

java.security.AccessController.doPrivileged(AccessController.java:-2)

org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain .java:157)

org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java: 263)

org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:551)

org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextVal ve.java:225)

org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java: 173)

org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:551)

org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:170)

org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:551)

org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:13 2)

org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:551)

org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:933)

org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:189)

com.sun.enterprise.web.connector.grizzly.ProcessorTask.doProcess(ProcessorTask. java:604)

com.sun.enterprise.web.connector.grizzly.ProcessorTask.process(ProcessorTask.ja va:475)

com.sun.enterprise.web.connector.grizzly.ReadTask.executeProcessorTask(ReadTask .java:371)

com.sun.enterprise.web.connector.grizzly.ReadTask.doTask(ReadTask.java:264)

com.sun.enterprise.web.connector.grizzly.TaskBase.run(TaskBase.java:281)

com.sun.enterprise.web.connector.grizzly.WorkerThread.run(WorkerThread.java:83)

Exception Details: javax.faces.FacesException

org.apache.jasper.JasperException: java.sql.SQLException: Internal Error in RowSetReader: no connection or command.

Possible Source of Error:

Class Name: com.sun.faces.context.ExternalContextImpl

File Name: ExternalContextImpl.java

Method Name: dispatch

Line Number: 327

Source not available. Information regarding the location of the exception can be identified using the exception stack trace below.

Stack Trace:

com.sun.faces.context.ExternalContextImpl.dispatch(ExternalContextImpl.java:327 )

com.sun.faces.application.ViewHandlerImpl.renderView(ViewHandlerImpl.java:130)

com.sun.rave.web.ui.appbase.faces.ViewHandlerImpl.renderView(ViewHandlerImpl.ja va:311)

com.sun.faces.lifecycle.RenderResponsePhase.execute(RenderResponsePhase.java:87 )

com.sun.faces.lifecycle.LifecycleImpl.phase(LifecycleImpl.java:221)

com.sun.faces.lifecycle.LifecycleImpl.render(LifecycleImpl.java:117)

javax.faces.webapp.FacesServlet.service(FacesServlet.java:198)

sun.reflect.NativeMethodAccessorImpl.invoke0(NativeMethodAccessorImpl.java:-2)

sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.ja va:25)

java.lang.reflect.Method.invoke(Method.java:585)

org.apache.catalina.security.SecurityUtil$1.run(SecurityUtil.java:249)

java.security.AccessController.doPrivileged(AccessController.java:-2)

javax.security.auth.Subject.doAsPrivileged(Subject.java:517)

org.apache.catalina.security.SecurityUtil.execute(SecurityUtil.java:282)

org.apache.catalina.security.SecurityUtil.doAsPrivilege(SecurityUtil.java:165)

org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFil terChain.java:257)

org.apache.catalina.core.ApplicationFilterChain.access$000(ApplicationFilterCha in.java:55)

org.apache.catalina.core.ApplicationFilterChain$1.run(ApplicationFilterChain.ja va:161)

java.security.AccessController.doPrivileged(AccessController.java:-2)

org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain .java:157)

com.sun.rave.web.ui.util.UploadFilter.doFilter(UploadFilter.java:194)

org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFil terChain.java:210)

org.apache.catalina.core.ApplicationFilterChain.access$000(ApplicationFilterCha in.java:55)

org.apache.catalina.core.ApplicationFilterChain$1.run(ApplicationFilterChain.ja va:161)

java.security.AccessController.doPrivileged(AccessController.java:-2)

org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain .java:157)

org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java: 263)

org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:551)

org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextVal ve.java:225)

org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java: 173)

org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:551)

org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:170)

org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:551)

org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:13 2)

org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:551)

org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:933)

org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:189)

com.sun.enterprise.web.connector.grizzly.ProcessorTask.doProcess(ProcessorTask. java:604)

com.sun.enterprise.web.connector.grizzly.ProcessorTask.process(ProcessorTask.ja va:475)

com.sun.enterprise.web.connector.grizzly.ReadTask.executeProcessorTask(ReadTask .java:371)

com.sun.enterprise.web.connector.grizzly.ReadTask.doTask(ReadTask.java:264)

com.sun.enterprise.web.connector.grizzly.TaskBase.run(TaskBase.java:281)

com.sun.enterprise.web.connector.grizzly.WorkerThread.run(WorkerThread.java:83)

Exception Details: com.sun.rave.web.ui.appbase.ApplicationException

org.apache.jasper.JasperException: java.sql.SQLException: Internal Error in RowSetReader: no connection or command.

Possible Source of Error:

Class Name: com.sun.rave.web.ui.appbase.faces.ViewHandlerImpl

File Name: ViewHandlerImpl.java

Method Name: destroy

Line Number: 601

Source not available. Information regarding the location of the exception can be identified using the exception stack trace below.

Stack Trace:

com.sun.rave.web.ui.appbase.faces.ViewHandlerImpl.destroy(ViewHandlerImpl.java: 601)

com.sun.rave.web.ui.appbase.faces.ViewHandlerImpl.renderView(ViewHandlerImpl.ja va:316)

com.sun.faces.lifecycle.RenderResponsePhase.execute(RenderResponsePhase.java:87 )

com.sun.faces.lifecycle.LifecycleImpl.phase(LifecycleImpl.java:221)

com.sun.faces.lifecycle.LifecycleImpl.render(LifecycleImpl.java:117)

javax.faces.webapp.FacesServlet.service(FacesServlet.java:198)

sun.reflect.NativeMethodAccessorImpl.invoke0(NativeMethodAccessorImpl.java:-2)

sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.ja va:25)

java.lang.reflect.Method.invoke(Method.java:585)

org.apache.catalina.security.SecurityUtil$1.run(SecurityUtil.java:249)

java.security.AccessController.doPrivileged(AccessController.java:-2)

javax.security.auth.Subject.doAsPrivileged(Subject.java:517)

org.apache.catalina.security.SecurityUtil.execute(SecurityUtil.java:282)

org.apache.catalina.security.SecurityUtil.doAsPrivilege(SecurityUtil.java:165)

org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFil terChain.java:257)

org.apache.catalina.core.ApplicationFilterChain.access$000(ApplicationFilterCha in.java:55)

org.apache.catalina.core.ApplicationFilterChain$1.run(ApplicationFilterChain.ja va:161)

java.security.AccessController.doPrivileged(AccessController.java:-2)

org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain .java:157)

com.sun.rave.web.ui.util.UploadFilter.doFilter(UploadFilter.java:194)

org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFil terChain.java:210)

org.apache.catalina.core.ApplicationFilterChain.access$000(ApplicationFilterCha in.java:55)

org.apache.catalina.core.ApplicationFilterChain$1.run(ApplicationFilterChain.ja va:161)

java.security.AccessController.doPrivileged(AccessController.java:-2)

org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain .java:157)

org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java: 263)

org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:551)

org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextVal ve.java:225)

org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java: 173)

org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:551)

org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:170)

org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:551)

org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:13 2)

org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:551)

org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:933)

org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:189)

com.sun.enterprise.web.connector.grizzly.ProcessorTask.doProcess(ProcessorTask. java:604)

com.sun.enterprise.web.connector.grizzly.ProcessorTask.process(ProcessorTask.ja va:475)

com.sun.enterprise.web.connector.grizzly.ReadTask.executeProcessorTask(ReadTask .java:371)

com.sun.enterprise.web.connector.grizzly.ReadTask.doTask(ReadTask.java:264)

com.sun.enterprise.web.connector.grizzly.TaskBase.run(TaskBase.java:281)

com.sun.enterprise.web.connector.grizzly.WorkerThread.run(WorkerThread.java:83)

[15573 byte] By [x_z] at [2007-11-26 9:38:01]
# 1
Hi There,Looks like some issue connecting to the db, check if your db is running and if you can connect to it from Creator, also if you followed the instructions correctly for configuring your db.ThanksK
kish@sun at 2007-7-7 0:32:25 > top of Java-index,Development Tools,Java Tools...
# 2
Hi:Yea. The problem was that I created a dataprovider, but the rowset was not in the sessionbean. So I deleted the old dataprovider and created a new one, then it is ok. Thanks a lot for your help!
x_z at 2007-7-7 0:32:25 > top of Java-index,Development Tools,Java Tools...
# 3

Hi

I had the same 'RowSetReader: no connection or command' exception. What I found was that the init method of my session bean was never being called. The init method sets up the properties of the RowSet object, so when the dataprovider tried to execute the RowSet object, its properties were not set, and it failed with the above exception. This was deployed in Tomcat 5.5.20 under the Liferay portal. I have no idea why the init method of the SessionBean is not being called. Any ideas anyone ? I had to add a call to the init method in the SessionBean's get method for the RowSet to make this work. After 2 days of trying to work this out, I hope this helps someone.

null

AGilmore at 2007-7-7 0:32:25 > top of Java-index,Development Tools,Java Tools...