Hi, It's your driver. The JDBC-ODBC approach tends to suck ;) Did you try to the type 4 driver from MS? Or better yet, forget MS SQL and go to MySQL or another more java-friendly database? If nothing else, try doing MySQL approach just to validate that it's neither tomcat nor your app that are the problem. The MySQL test will enable you to pinpoint the ODBC bridge as the guilty party.
As an aside, maybe it's my mail reader but I got four copies of your question. Please only post once ;) Yoav Shapira Millennium ChemInformatics >-----Original Message----- >From: Kingston Sew [mailto:[EMAIL PROTECTED]] >Sent: Tuesday, August 20, 2002 8:26 AM >To: [EMAIL PROTECTED] >Subject: Tomcat Crashes > >Hi > >I am currently running Tomcat 4.0.4 Server on a >Windows 2000 Server (v5.0.2195) with MS SQL >Server 2000 (v8.00.194) and J2SDK 1.4.0. I am also >using JDBC-ODBC bridge to access the database. After >conducting a few tests on my application, I notice >that sometimes Tomcat crashes. When I check the >server, the Tomcat console is missing. I receive the >following log file as shown belo > >Can anyone help me with this problem > >Thanks >Kingston Sew > > > >An unexpected exception has been detected in native >code outside the VM. >Unexpected Signal : EXCEPTION_ACCESS_VIOLATION >occurred at PC=0x41166ABA >Function=SQLGetData+0x15 >Library=C:\WINNT\System32\SQLSRV32.dll > >Current Java thread: > at sun.jdbc.odbc.JdbcOdbc.getDataString(Native >Method) > at >sun.jdbc.odbc.JdbcOdbc.SQLGetDataString(JdbcOdbc.java:3285) > at >sun.jdbc.odbc.JdbcOdbcResultSet.getDataString(JdbcOdbcResultSet.java:54 94) > at >sun.jdbc.odbc.JdbcOdbcResultSet.getString(JdbcOdbcResultSet.java:342) > at >com.applied.hr.ProcessJobClassification.ListAll(ProcessJobClassificatio n.ja >va:221) > at >org.apache.jsp.lu_0005fjob$jsp._jspService(lu_0005fjob$jsp.java:216) > 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(JspServl et.j >ava:201) > at >org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:381 ) > at >org.apache.jasper.servlet.JspServlet.service(JspServlet.java:473) > at >javax.servlet.http.HttpServlet.service(HttpServlet.java:853) > at >org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applic atio >nFilterChain.java:247) > at >org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFil terC >hain.java:193) > at >org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperVal ve.j >ava:243) > at >org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.j ava: >566) > 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(StandardContextVal ve.j >ava:190) > at >org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.j ava: >566) > at >org.apache.catalina.valves.CertificatesValve.invoke(CertificatesValve.j ava: >246) > at >org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.j ava: >564) > 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:23 47) > at >org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.jav a:18 >0) > at >org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.j ava: >566) > at >org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherV alve >.java:170) > at >org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.j ava: >564) > at >org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.jav a:17 >0) > at >org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.j ava: >564) > at >org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:46 8) > at >org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.j ava: >564) > 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 .jav >a:174) > at >org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.j ava: >566) > 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.http.HttpProcessor.process(HttpProcessor. java >:1027) > at >org.apache.catalina.connector.http.HttpProcessor.run(HttpProcessor.java :112 >5) > at java.lang.Thread.run(Thread.java:536) > >Dynamic libraries: >0x00400000 - 0x00406000 C:\j2sdk1.4.0\bin\java.exe >0x77F80000 - 0x77FF9000 C:\WINNT\System32\ntdll.dll >0x77DB0000 - 0x77E0A000 >C:\WINNT\system32\ADVAPI32.dll >0x77E80000 - 0x77F36000 >C:\WINNT\system32\KERNEL32.DLL >0x77D40000 - 0x77DAF000 C:\WINNT\system32\RPCRT4.DLL >0x78000000 - 0x78046000 C:\WINNT\system32\MSVCRT.dll >0x6D330000 - 0x6D442000 >C:\j2sdk1.4.0\jre\bin\client\jvm.dll >0x77E10000 - 0x77E75000 C:\WINNT\system32\USER32.dll >0x77F40000 - 0x77F7C000 C:\WINNT\system32\GDI32.DLL >0x77570000 - 0x775A0000 C:\WINNT\System32\WINMM.dll >0x6D1D0000 - 0x6D1D7000 C:\j2sdk1.4.0\jre\bin\hpi.dll >0x6D300000 - 0x6D30D000 >C:\j2sdk1.4.0\jre\bin\verify.dll >0x6D210000 - 0x6D228000 >C:\j2sdk1.4.0\jre\bin\java.dll >0x6D320000 - 0x6D32D000 C:\j2sdk1.4.0\jre\bin\zip.dll >0x6D2D0000 - 0x6D2DD000 C:\j2sdk1.4.0\jre\bin\net.dll >0x75050000 - 0x75058000 C:\WINNT\System32\WSOCK32.dll >0x75030000 - 0x75044000 C:\WINNT\System32\WS2_32.DLL >0x75020000 - 0x75028000 C:\WINNT\System32\WS2HELP.DLL >0x74FD0000 - 0x74FE1000 C:\WINNT\system32\msafd.dll >0x75010000 - 0x75017000 >C:\WINNT\System32\wshtcpip.dll >0x6D250000 - 0x6D25A000 >C:\j2sdk1.4.0\jre\bin\JdbcOdbc.dll >0x1F7F0000 - 0x1F825000 C:\WINNT\System32\ODBC32.dll >0x76B30000 - 0x76B6E000 >C:\WINNT\system32\comdlg32.dll >0x77C70000 - 0x77CBA000 C:\WINNT\system32\SHLWAPI.DLL >0x77B50000 - 0x77BDA000 >C:\WINNT\system32\COMCTL32.DLL >0x775A0000 - 0x777E0000 C:\WINNT\system32\SHELL32.DLL >0x1F8E0000 - 0x1F8F6000 C:\WINNT\System32\odbcint.dll >0x77820000 - 0x77827000 C:\WINNT\system32\VERSION.dll >0x759B0000 - 0x759B6000 C:\WINNT\system32\LZ32.DLL >0x77A50000 - 0x77B45000 C:\WINNT\system32\ole32.dll >0x77BE0000 - 0x77BEF000 C:\WINNT\System32\SECUR32.DLL >0x1F840000 - 0x1F85A000 >C:\WINNT\System32\odbccp32.dll >0x78140000 - 0x7815A000 C:\WINNT\system32\msv1_0.dll >0x77840000 - 0x7784C000 C:\WINNT\System32\rnr20.dll >0x77980000 - 0x779A4000 C:\WINNT\System32\DNSAPI.DLL >0x777E0000 - 0x777E8000 C:\WINNT\System32\winrnr.dll >0x77950000 - 0x77979000 C:\WINNT\system32\WLDAP32.DLL >0x777F0000 - 0x777F5000 >C:\WINNT\System32\rasadhlp.dll >0x77830000 - 0x7783E000 C:\WINNT\System32\RTUTILS.DLL >0x77920000 - 0x77942000 >C:\WINNT\system32\imagehlp.dll >0x72A00000 - 0x72A2D000 C:\WINNT\system32\DBGHELP.dll >0x41160000 - 0x411D3000 >C:\WINNT\System32\SQLSRV32.dll >0x41090000 - 0x410BD000 >C:\WINNT\System32\SQLUNIRL.DLL >0x77800000 - 0x7781D000 >C:\WINNT\System32\WINSPOOL.DRV >0x779B0000 - 0x77A45000 >C:\WINNT\system32\OLEAUT32.DLL >0x75170000 - 0x751BF000 >C:\WINNT\System32\NETAPI32.DLL >0x751C0000 - 0x751C6000 C:\WINNT\System32\NETRAP.DLL >0x75150000 - 0x7515F000 C:\WINNT\System32\SAMLIB.DLL >0x769A0000 - 0x769A7000 C:\WINNT\System32\NDDEAPI.DLL >0x10A00000 - 0x10A16000 >C:\WINNT\System32\sqlsrv32.rll >0x00000000 - 0x00000000 >0x00000000 - 0x00000000 >0x00000000 - 0x00000000 >0x00000000 - 0x00000000 >0x00000000 - 0x00000000 >0x00000000 - 0x00000000 >0x690A0000 - 0x690AB000 C:\WINNT\System32\PSAPI.DLL > >Local Time = Tue Aug 20 15:04:56 2002 >Elapsed Time = 78257 ># ># The exception above was detected in native code >outside the VM ># ># Java VM: Java HotSpot(TM) Client VM (1.4.0-b92 mixed >mode) ># > > >__________________________________________________ >Do You Yahoo!? >HotJobs - Search Thousands of New Jobs >http://www.hotjobs.com > >-- >To unsubscribe, e-mail: <mailto:tomcat-user- >[EMAIL PROTECTED]> >For additional commands, e-mail: <mailto:tomcat-user- >[EMAIL PROTECTED]>
This e-mail, including any attachments, is a confidential business communication, and may contain information that is confidential, proprietary and/or privileged. This e-mail is intended only for the individual(s) to whom it is addressed, and may not be saved, copied, printed, disclosed or used by anyone else. If you are not the(an) intended recipient, please immediately delete this e-mail from your computer system and notify the sender. Thank you.
-- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
