There are three jar that make up the SQL Server 2000 JDBC drivers - msbase.jar - mssqlserver.jar - msutil.jar
Make sure you have all three! Looks to me like you only have one, mssqlserver.jar. Nicholas Orr -----Original Message----- From: Adam Getchell [mailto:[EMAIL PROTECTED]] Sent: Thursday, 21 November 2002 7:57 AM To: 'Tomcat Users List' Subject: JDBC connectivity problems on Tomcat 4.0.6 running on OpenBSD 3.2 Hello all, I've got a web application on Tomcat which works fine using Sun ONE Studio 4 CE's Tomcat server, but fails on Tomcat 4.0.6 on my OpenBSD server. The example Tomcat servlets work, but JDBC doesn't (and this application talks to a back-end MS SQL Server 2000 for most things, including authentication). It uses the mssqlserver.jar for JDBC, which looks like the standard MS SQL JDBC driver (unzipping the jar gives a bunch of class files). How do I proceed to fix this? I unfortunately have a deadline of Friday. I can provide the class files if needed, but they show thrown exceptions when JDBC is invoked, and they do work on Forte's Tomcat server. Other information: javadevel@/var/tomcat/logs > tail catalina.out Zero categories error: SQL Exception caught: [Microsoft][SQLServer 2000 Driver for JDBC]Error setting up static cursor cache. [Microsoft][SQLServer 2000 Driver for JDBC]null value of id is null SQL Exception caught: [Microsoft][SQLServer 2000 Driver for JDBC]Error setting up static cursor cache. [Microsoft][SQLServer 2000 Driver for JDBC]null Zero categories error: SQL Exception caught: [Microsoft][SQLServer 2000 Driver for JDBC]Error setting up static cursor cache. [Microsoft][SQLServer 2000 Driver for JDBC]null value of id is null javadevel@/var/tomcat/logs > head -30 localhost_log.2002-11-20.txt 2002-11-20 01:08:59 StandardWrapperValve[EOBList]: Servlet.service() for servlet EOBList threw exception java.lang.NullPointerException: at EOBList.processRequest(EOBList.java:106) at EOBList.doGet(EOBList.java:199) at javax.servlet.http.HttpServlet.service(HttpServlet.java:740) 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.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:2347) 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.valves.AccessLogValve.invoke(AccessLogValve.java:468) 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) Thoughts? Pointers on troubleshooting JDBC? Thanks! *************************** * Adam Getchell [EMAIL PROTECTED] * System Architect/Programmer (530) 752-1584 * Human Resources Information Systems http://www.hr.ucdavis.edu/ *************************** "Invincibility is in oneself, vulnerability in the opponent." -- Sun Tzu -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]> ********************************************************************** The information contained in this e-mail is confidential and is intended only for the use of the addressee(s). If you receive this e-mail in error, any use, distribution or copying of this e-mail is not permitted. You are requested to forward unwanted e-mail and address any problems to the MIM Holdings Limited Support Centre. For general enquires: ++61 7 3833 8000 Support Centre e-mail: [EMAIL PROTECTED] Support Centre phone: Australia 1800500646 International ++61 7 38338042 ********************************************************************** -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>