Home.... | log in.... | Pub my question! | Sign-up....
Java-index >> Development Tools >> Java Tools

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

hi everyone

could help me, I faced problem when I run page contains table connect with SQLSERVER 2000

- --

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.GeneratedMethodAccessor177.invoke( Unknown Source )

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)

[6634 byte] By [Shamoos] at [2007-11-26 9:03:21]
«« glassfish application server 9 with mysql
»» Linux on SUN ENTERPRISE 250 SERVER
# 1
Could you check if the rowset's command/SQL is OK?Also verify that the connection pool pings successfully via the admin console.-Sakthi
sakthivelgopal at 2007-7-6 23:12:10 > top of Java-index,Development Tools,Java Tools...
# 2
Can you explain more please.......thanks,shamoos
Shamoos at 2007-7-6 23:12:10 > top of Java-index,Development Tools,Java Tools...
# 3

In the SessionBean where the rowset is, you should have something like this:

private void _init() throws Exception {

tripRowSet.setDataSourceName("java:comp/env/jdbc/Travel");

tripRowSet.setCommand("SELECT * FROM TRAVEL.TRIP");

tripRowSet.setTableName("TRIP");

}

If you invoke, admin console on the bundled AppServer i.e, In Servers Window> Deployment Server node, right click and choose Admin Console. Login with un=admin and pw=adminadmin. Then select Resources> JDBC> Connection Pools and choose your $connpool and click on ping button to ensure that it is good.

HTH,

Sakthi

sakthivelgopal at 2007-7-6 23:12:10 > top of Java-index,Development Tools,Java Tools...
# 4
Thanks so much......
Shamoos at 2007-7-6 23:12:10 > top of Java-index,Development Tools,Java Tools...
# 5

hi~everyone

I had the same problem when I deployed a .war file on to the WebSphere (Version 6.0.0.1)

I had tested the DB connection, and it worked well..

This problem will happen when I go to the page which has a table component and a data rowset, but it works well on the JSC.

the following is the trace log

[2006/8/1716:21:01:984 CST] 00000044 WebAppASRVE0181I: [test2.war] [/test34] [Servlet.LOG]: table2 Initialization Failure: javax.faces.FacesException: java.sql.SQLException: Internal Error in RowSetReader: no connection or command.

at com.sun.jsfcl.data.CachedRowSetDataModel.executeIfNecessary(CachedRowSetDataModel.java:372)

at com.sun.jsfcl.data.CachedRowSetDataModel.isRowAvailable(CachedRowSetDataModel.java:131)

at com.sun.jsfcl.data.CachedRowSetDataModel.setRowIndex(CachedRowSetDataModel.java:284)

at com.sun.jsfcl.data.CachedRowSetDataModel.setWrappedData(CachedRowSetDataModel.java:321)

at com.sun.jsfcl.data.CachedRowSetDataModel.setCachedRowSet(CachedRowSetDataModel.java:346)

at test2.table2._init(table2.java:42)

at test2.table2.init(table2.java:281)

at com.sun.rave.web.ui.appbase.faces.VariableResolverImpl.resolveVariable(VariableResolverImpl.java:123)

at com.sun.faces.el.impl.NamedValue.evaluate(NamedValue.java:125)

at com.sun.faces.el.impl.ExpressionEvaluatorImpl.evaluate(ExpressionEvaluatorImpl.java:243)

at com.sun.faces.el.ValueBindingImpl.getValue(ValueBindingImpl.java:156)

at com.sun.faces.el.ValueBindingImpl.getValue(ValueBindingImpl.java:137)

at com.sun.rave.web.ui.appbase.faces.ViewHandlerImpl.pageBean(ViewHandlerImpl.java:753)

at com.sun.rave.web.ui.appbase.faces.ViewHandlerImpl.pageBean(ViewHandlerImpl.java:728)

at com.sun.rave.web.ui.appbase.faces.ViewHandlerImpl.renderView(ViewHandlerImpl.java:278)

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

at com.sun.faces.lifecycle.LifecycleImpl.phase(LifecycleImpl.java:201)

at com.sun.faces.lifecycle.LifecycleImpl.render(LifecycleImpl.java:118)

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

at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1212)

at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1173)

at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:92)

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

at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:142)

at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:77)

at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:626)

at com.ibm.ws.webcontainer.webapp.WebApp.handleRequest(WebApp.java:2841)

at com.ibm.ws.webcontainer.webapp.WebGroup.handleRequest(WebGroup.java:220)

at com.ibm.ws.webcontainer.VirtualHost.handleRequest(VirtualHost.java:204)

at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:1681)

at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:77)

at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:421)

at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewInformation(HttpInboundLink.java:367)

at com.ibm.ws.http.channel.inbound.impl.HttpICLReadCallback.complete(HttpICLReadCallback.java:94)

at com.ibm.ws.tcp.channel.impl.WorkQueueManager.requestComplete(WorkQueueManager.java:548)

at com.ibm.ws.tcp.channel.impl.WorkQueueManager.attemptIO(WorkQueueManager.java:601)

at com.ibm.ws.tcp.channel.impl.WorkQueueManager.workerRun(WorkQueueManager.java:934)

at com.ibm.ws.tcp.channel.impl.WorkQueueManager$Worker.run(WorkQueueManager.java:1021)

at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1332)

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

at com.sun.sql.rowset.internal.CachedRowSetXReader.readData(CachedRowSetXReader.java:130)

at com.sun.sql.rowset.CachedRowSetXImpl.execute(CachedRowSetXImpl.java:950)

at com.sun.sql.rowset.CachedRowSetXImpl.execute(CachedRowSetXImpl.java:1410)

at com.sun.jsfcl.data.CachedRowSetDataModel.executeIfNecessary(CachedRowSetDataModel.java:370)

Please tell me how I can fix this problem...

thanks a lot!

jasonlin at 2007-7-6 23:12:10 > top of Java-index,Development Tools,Java Tools...
# 6

Hi,

Did anyone found a solution for that problem? I am encountering the same problem when running my war file under tomcat 5.5. I tested the connection and it works fine.

Any help will be appreciated.

Here is my error message:

com.sun.rave.web.ui.appbase.ApplicationException: org.apache.jasper.JasperException: java.sql.SQLException: Internal Error in RowSetReader: no connection or command.

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

com.sun.rave.web.ui.appbase.faces.ViewHandlerImpl.renderView(ViewHandlerImpl.java: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)

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

Lyly at 2007-7-6 23:12:10 > top of Java-index,Development Tools,Java Tools...
# 7
Looks to me as a problem with datasource config.Check out these: http://developers.sun.com/prodtech/javatools/jscreator/reference/docs/help/2upd ate1/deploy/howtodeploy/deploy_tomcat.htmlEnsure you datasources are configured right.HTH,Sakthi
sakthivelgopal at 2007-7-6 23:12:10 > top of Java-index,Development Tools,Java Tools...
# 8

Hi Sakthi,

Thanks for your reply. I think that my datasource is configured right, because the example described in "JNDI Datasource HOW-TO" work fine for me. I can use the datasource in oder example. The problem occurs with the jsf table. Do you have any other idea?

Thanks

Lyly

Lyly at 2007-7-6 23:12:10 > top of Java-index,Development Tools,Java Tools...
# 9
Make sure the rowset's datasourceName looks right and check the printStatements property on the rowset to see, if that provides any clue.-Sakthi
sakthivelgopal at 2007-7-6 23:12:10 > top of Java-index,Development Tools,Java Tools...
# 10
I'm getting the same error when i deployed to weblogic8.1 SP2 and connecting to sybase database. My datasource is configured correct. is there any solution for this? is this RowSet functionality works in 1.4.1?. please help
gjakkamsetti at 2007-7-6 23:12:10 > top of Java-index,Development Tools,Java Tools...
Development Tools
Java Tools

Development Tools New Topic

Development Tools Hot Topic

Development Tools

All Classified