Subject: Re: JDBC Connection problem. From: Vic Cekvenich <[EMAIL PROTECTED]> === Unit test the beans in a java system main console application. Then put in Tomcat.
Diego, Emil wrote: > it works as a stand alone application. I have used this driver before many > times and have never had a problem using first() before. > > -----Original Message----- > From: peter lin [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, April 17, 2002 10:25 AM > To: Tomcat Users List > Subject: Re: JDBC Connection problem. > > > > Are you using a jdbc 2.0 compliant driver which supports scrollable > resultsets? > > jdbc 1.0 drivers typically do not support scrollable resultsets, so that > could be the cause. > > peter lin > > > "Diego, Emil" wrote: > >>Hello >> >>I am gettign a rather unusual exception everytime one of my beans calls >>Resultset.first(). I was able to trace the app at it seems to open the >>connection to mysql and execute the query without any problems. I keep >>getting an exception when the bean calls first though. If anyone has any >>ideas, please let me know. thanx. >> >>Here is the error: >> >>Apache Tomcat/4.0.3 - HTTP Status 500 - Internal Server Error >> >> >> > ---------------------------------------------------------------------------- > >>---- >> >>type Exception report >> >>message Internal Server Error >> >>description The server encountered an internal error (Internal Server >> > Error) > >>that prevented it from fulfilling this request. >> >>exception >> >>javax.servlet.ServletException: org.gjt.mm.mysql.ResultSet.first()Z >> at >> >> > org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImp > >>l.java:463) >> at org.apache.jsp.login$jsp._jspService(login$jsp.java:163) >> at >>org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:107) >> at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) >> at >> >> > org.apache.jasper.servlet.JspServlet$JspServletWrapper.service(JspServlet.ja > >>va:202) >> at >>org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:382) >> at >> > org.apache.jasper.servlet.JspServlet.service(JspServlet.java:474) > >> at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) >> at >> >> > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application > >>FilterChain.java:247) >> at >> >> > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh > >>ain.java:193) >> at >> >> > org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.ja > >>va:243) >> at >> >> > org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:5 > >>66) >> at >> >> > org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472) > >> at >>org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943) >> at >> >> > org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.ja > >>va:190) >> at >> >> > org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:5 > >>66) >> at >> >> > org.apache.catalina.valves.CertificatesValve.invoke(CertificatesValve.java:2 > >>46) >> at >> >> > org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:5 > >>64) >> at >> >> > org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472) > >> at >>org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943) >> at >>org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2343) >> at >> >> > org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180 > >>) >> at >> >> > org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:5 > >>66) >> at >> >> > org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve. > >>java:170) >> at >> >> > org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:5 > >>64) >> at >> >> > org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:170 > >>) >> at >> >> > org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:5 > >>64) >> at >> >> > org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472) > >> at >>org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943) >> at >> >> > org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java > >>:174) >> at >> >> > org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:5 > >>66) >> at >> >> > org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472) > >> at >>org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943) >> at >> >> > org.apache.catalina.connector.warp.WarpRequestHandler.handle(WarpRequestHand > >>ler.java:217) >> at >> >> > org.apache.catalina.connector.warp.WarpConnection.run(WarpConnection.java:19 > >>4) >> at java.lang.Thread.run(Thread.java:536) >> >>root cause >> >>java.lang.AbstractMethodError: org.gjt.mm.mysql.ResultSet.first()Z >> at umJavaLib.tbl_um_user.getUserID(tbl_um_user.java:431) >> at umJavaLib.sbaLogin.checkLogin(sbaLogin.java:185) >> at org.apache.jsp.login$jsp._jspService(login$jsp.java:138) >> at >>org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:107) >> at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) >> at >> >> > org.apache.jasper.servlet.JspServlet$JspServletWrapper.service(JspServlet.ja > >>va:202) >> at >>org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:382) >> at >> > org.apache.jasper.servlet.JspServlet.service(JspServlet.java:474) > >> at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) >> at >> >> > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application > >>FilterChain.java:247) >> at >> >> > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh > >>ain.java:193) >> at >> >> > org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.ja > >>va:243) >> at >> >> > org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:5 > >>66) >> at >> >> > org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472) > >> at >>org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943) >> at >> >> > org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.ja > >>va:190) >> at >> >> > org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:5 > >>66) >> at >> >> > org.apache.catalina.valves.CertificatesValve.invoke(CertificatesValve.java:2 > >>46) >> at >> >> > org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:5 > >>64) >> at >> >> > org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472) > >> at >>org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943) >> at >>org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2343) >> at >> >> > org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180 > >>) >> at >> >> > org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:5 > >>66) >> at >> >> > org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve. > >>java:170) >> at >> >> > org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:5 > >>64) >> at >> >> > org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:170 > >>) >> at >> >> > org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:5 > >>64) >> at >> >> > org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472) > >> at >>org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943) >> at >> >> > org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java > >>:174) >> at >> >> > org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:5 > >>66) >> at >> >> > org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472) > >> at >>org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943) >> at >> >> > org.apache.catalina.connector.warp.WarpRequestHandler.handle(WarpRequestHand > >>ler.java:217) >> at >> >> > org.apache.catalina.connector.warp.WarpConnection.run(WarpConnection.java:19 > >>4) >> at java.lang.Thread.run(Thread.java:536) >> >> >> > ---------------------------------------------------------------------------- > >>---- >> >>-- >>To unsubscribe: <mailto:[EMAIL PROTECTED]> >>For additional commands: <mailto:[EMAIL PROTECTED]> >>Troubles with the list: <mailto:[EMAIL PROTECTED]> >> > > -- > To unsubscribe: <mailto:[EMAIL PROTECTED]> > For additional commands: <mailto:[EMAIL PROTECTED]> > Troubles with the list: <mailto:[EMAIL PROTECTED]> > > -- > To unsubscribe: <mailto:[EMAIL PROTECTED]> > For additional commands: <mailto:[EMAIL PROTECTED]> > Troubles with the list: <mailto:[EMAIL PROTECTED]> > -- To unsubscribe: <mailto:[EMAIL PROTECTED]> For additional commands: <mailto:[EMAIL PROTECTED]> Troubles with the list: <mailto:[EMAIL PROTECTED]>
