The jdbc driver from microsoft is ok supporting jdbc 2.0. Microsoft licensed the driver from merant / datadirect, and is now continuing developement / distributing it for free.
the jdbc-odbc bridge is not intended for production use (only testing). hope it helps -reynir > -----Original Message----- > From: Mike Jackson [mailto:[EMAIL PROTECTED]] > Sent: 20. �g�st 2002 16:29 > To: Tomcat Users List > Subject: RE: Tomcat Crashes > > > The jdbc-odbc bridge has some memory and other leaks. Don't > use it. Get > the jdbc driver from MS for MSSql server, it should be > better. Or get a > third party driver (but they cost money). I haven't used > tomcat and ms sql, > but using jrun and ms sql (and the jdbc-odbc bridge) I had > some similar > problems. > > --mikej > -=----- > mike jackson > [EMAIL PROTECTED] > > > -----Original Message----- > > From: Kingston Sew [mailto:[EMAIL PROTECTED]] > > Sent: Tuesday, August 20, 2002 5: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(JdbcOdbcResultSe > t.java:5494) > > at > > > sun.jdbc.odbc.JdbcOdbcResultSet.getString(JdbcOdbcResultSet.java:342) > > at > > com.applied.hr.ProcessJobClassification.ListAll(ProcessJobClassifi > > cation.java: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(Jsp > > Servlet.java: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(A > > pplicationFilterChain.java:247) > > at > > org.apache.catalina.core.ApplicationFilterChain.doFilter(Applicati > > onFilterChain.java:193) > > at > > org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapp > > erValve.java:243) > > at > > org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipel > > ine.java: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(StandardConte > > xtValve.java:190) > > at > > org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipel > > ine.java:566) > > at > > org.apache.catalina.valves.CertificatesValve.invoke(CertificatesVa > > lve.java:246) > > at > > org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipel > > ine.java: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(StandardContex > t.java:2347) > > at > > org.apache.catalina.core.StandardHostValve.invoke(StandardHostValv > > e.java:180) > > at > > org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipel > > ine.java:566) > > at > > org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispat > > cherValve.java:170) > > at > > org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipel > > ine.java:564) > > at > > org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValv > > e.java:170) > > at > > org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipel > > ine.java:564) > > at > > > org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValv > e.java:468) > > at > > org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipel > > ine.java: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(StandardEngine > > Valve.java:174) > > at > > org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipel > > ine.java: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(HttpProce > > ssor.java:1027) > > at > > org.apache.catalina.connector.http.HttpProcessor.run(HttpProcessor > > .java:1125) > > 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:[EMAIL PROTECTED]> > For additional commands, e-mail: > <mailto:[EMAIL PROTECTED]> > > > > > -- > To unsubscribe, e-mail: > <mailto:[EMAIL PROTECTED]> > For additional commands, e-mail: > <mailto:[EMAIL PROTECTED]> > > -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
