RE: tomcat 4.0.2/ SQL server 2000/ IIS 5.0 crashes
Have a look at the list archives _before_ posting a question. You would have noticed that this question has been answered many times. The JDBC-ODBC bridge from sun is not thread safe and is liable to crash like that periodically. There's a free JDBC driver available from Microsoft or other 3rd Party drivers available. -Original Message- From: Prashanth Pushpagiri [mailto:[EMAIL PROTECTED]] Sent: Monday, September 23, 2002 6:17 PM To: Tomcat Users List Subject: tomcat 4.0.2/ SQL server 2000/ IIS 5.0 crashes Tomcat 4.0.2 crahed and generated the following error messagecan anyone possibly think of a reason why it crashed? any workarounds or debugging help? Thanks Prashanth An unexpected exception has been detected in native code outside the VM. Unexpected Signal : EXCEPTION_ACCESS_VIOLATION occurred at PC=0x77F821E1 Function=RtlEnterCriticalSection+0xB Library=C:\WINNT\System32\ntdll.dll Current Java thread: at sun.jdbc.odbc.JdbcOdbc.colAttributes(Native Method) at sun.jdbc.odbc.JdbcOdbc.SQLColAttributes(JdbcOdbc.java:2036) at sun.jdbc.odbc.JdbcOdbcResultSet.getColAttribute(JdbcOdbcResult Set.java:5241) at sun.jdbc.odbc.JdbcOdbcResultSet.getColumnType(JdbcOdbcResultSe t.java:5870) at sun.jdbc.odbc.JdbcOdbcResultSet.getMaxCharLen(JdbcOdbcResultSe t.java:5269) at sun.jdbc.odbc.JdbcOdbcResultSet.getString(JdbcOdbcResultSet.java:267) at dlnet.TaxonBean.retrieve_List(TaxonBean.java:78) - locked 02BD0230 (a dlnet.TaxonBean) at dlnet.TaxonBean.getLevel2_id_list(TaxonBean.java:45) - locked 02BD0230 (a dlnet.TaxonBean) at dlnet.Search.BrowseBean.checkBrowseRequest(BrowseBean.java:125) at org.apache.jsp.Browse_0005fDLNET$jsp._jspService(Browse_0005fD LNET$jsp.java:212) 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.java: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.internalDoFilt er(ApplicationFilterChain.java:247) at org.apache.catalina.core.ApplicationFilterChain.doFilter(Appli cationFilterChain.java:193) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardW rapperValve.java:243) at org.apache.catalina.core.StandardPipeline.invokeNext(StandardP ipeline.java:566) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipel ine.java:472) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943) at org.apache.catalina.core.StandardContextValve.invoke(StandardC ontextValve.java:190) at org.apache.catalina.core.StandardPipeline.invokeNext(StandardP ipeline.java:566) at org.apache.catalina.valves.CertificatesValve.invoke(Certificat esValve.java:246) at org.apache.catalina.core.StandardPipeline.invokeNext(StandardP ipeline.java:564) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipel ine.java:472) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943) at org.apache.catalina.core.StandardContext.invoke(StandardContex t.java:2343) at org.apache.catalina.core.StandardHostValve.invoke(StandardHost Valve.java:180) at org.apache.catalina.core.StandardPipeline.invokeNext(StandardP ipeline.java:566) at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDi spatcherValve.java:170) at org.apache.catalina.core.StandardPipeline.invokeNext(StandardP ipeline.java:564) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReport Valve.java:170) at org.apache.catalina.core.StandardPipeline.invokeNext(StandardP ipeline.java:564) at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValv e.java:468) at org.apache.catalina.core.StandardPipeline.invokeNext(StandardP ipeline.java:564) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipel ine.java:472) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEn gineValve.java:174) at org.apache.catalina.core.StandardPipeline.invokeNext(StandardP ipeline.java:566) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipel ine.java:472) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943) at org.apache.ajp.tomcat4.Ajp13Processor.process(Ajp13Processor.java:429) at org.apache.ajp.tomcat4.Ajp13Processor.run(Ajp13Processor.java:495) at java.lang.Thread.run(Thread.java:536)
RE: tomcat 4.0.2/ SQL server 2000/ IIS 5.0 crashes
Could be anything...the JDBC/ODBC bridge isn't the most stable/robust driver in the world, and the error is actually outside both Tomcat and the JVM. You might want to try the Type 4 JDBC driver available from Microsoft, its free and provides native support for SQL Server instead of using the ODBC bridge. Switching drivers is relatively easy, and it will give you a quick indicator where the problem lies. John -Original Message- From: Prashanth Pushpagiri [mailto:[EMAIL PROTECTED]] Sent: Monday, September 23, 2002 12:17 PM To: Tomcat Users List Subject: tomcat 4.0.2/ SQL server 2000/ IIS 5.0 crashes Tomcat 4.0.2 crahed and generated the following error messagecan anyone possibly think of a reason why it crashed? any workarounds or debugging help? Thanks Prashanth An unexpected exception has been detected in native code outside the VM. Unexpected Signal : EXCEPTION_ACCESS_VIOLATION occurred at PC=0x77F821E1 Function=RtlEnterCriticalSection+0xB Library=C:\WINNT\System32\ntdll.dll Current Java thread: at sun.jdbc.odbc.JdbcOdbc.colAttributes(Native Method) at sun.jdbc.odbc.JdbcOdbc.SQLColAttributes(JdbcOdbc.java:2036) at sun.jdbc.odbc.JdbcOdbcResultSet.getColAttribute(JdbcOdbcResult Set.java:5241) at sun.jdbc.odbc.JdbcOdbcResultSet.getColumnType(JdbcOdbcResultSe t.java:5870) at sun.jdbc.odbc.JdbcOdbcResultSet.getMaxCharLen(JdbcOdbcResultSe t.java:5269) at sun.jdbc.odbc.JdbcOdbcResultSet.getString(JdbcOdbcResultSet.java:267) at dlnet.TaxonBean.retrieve_List(TaxonBean.java:78) - locked 02BD0230 (a dlnet.TaxonBean) at dlnet.TaxonBean.getLevel2_id_list(TaxonBean.java:45) - locked 02BD0230 (a dlnet.TaxonBean) at dlnet.Search.BrowseBean.checkBrowseRequest(BrowseBean.java:125) at org.apache.jsp.Browse_0005fDLNET$jsp._jspService(Browse_0005fD LNET$jsp.java:212) 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.java: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.internalDoFilt er(ApplicationFilterChain.java:247) at org.apache.catalina.core.ApplicationFilterChain.doFilter(Appli cationFilterChain.java:193) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardW rapperValve.java:243) at org.apache.catalina.core.StandardPipeline.invokeNext(StandardP ipeline.java:566) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipel ine.java:472) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943) at org.apache.catalina.core.StandardContextValve.invoke(StandardC ontextValve.java:190) at org.apache.catalina.core.StandardPipeline.invokeNext(StandardP ipeline.java:566) at org.apache.catalina.valves.CertificatesValve.invoke(Certificat esValve.java:246) at org.apache.catalina.core.StandardPipeline.invokeNext(StandardP ipeline.java:564) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipel ine.java:472) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943) at org.apache.catalina.core.StandardContext.invoke(StandardContex t.java:2343) at org.apache.catalina.core.StandardHostValve.invoke(StandardHost Valve.java:180) at org.apache.catalina.core.StandardPipeline.invokeNext(StandardP ipeline.java:566) at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDi spatcherValve.java:170) at org.apache.catalina.core.StandardPipeline.invokeNext(StandardP ipeline.java:564) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReport Valve.java:170) at org.apache.catalina.core.StandardPipeline.invokeNext(StandardP ipeline.java:564) at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValv e.java:468) at org.apache.catalina.core.StandardPipeline.invokeNext(StandardP ipeline.java:564) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipel ine.java:472) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEn gineValve.java:174) at org.apache.catalina.core.StandardPipeline.invokeNext(StandardP ipeline.java:566) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipel ine.java:472) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943) at org.apache.ajp.tomcat4.Ajp13Processor.process(Ajp13Processor.java:429) at
