RE: tomcat 4.0.2/ SQL server 2000/ IIS 5.0 crashes

2002-09-23 Thread Turner, John


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(C

RE: tomcat 4.0.2/ SQL server 2000/ IIS 5.0 crashes

2002-09-23 Thread Barney Hamish

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.tomca