You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@tomcat.apache.org by Justin Larose <Ju...@nexweb.org> on 2012/12/11 15:06:51 UTC

Tomcat 7.33 update on Windows

I just updated Tomcat 7 from version 7.11 to 7.33 on my windows server but 
when I goto the URL I am seeing 500 error, "Cannot load JDBC driver class 
'com.microsoft.sqlserver.jdbc.SQLServerDriver'"
Not sure why. I made a copy of all config directories prior to install and 
copied them all to the new Tomcat home. Below is the full stack.

_____________

HTTP Status 500 - javax.servlet.ServletException: 
org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot load JDBC driver 
class 'com.microsoft.sqlserver.jdbc.SQLServerDriver'

--------------------------------------------------------------------------------

type Exception report

message javax.servlet.ServletException: 
org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot load JDBC driver 
class 'com.microsoft.sqlserver.jdbc.SQLServerDriver'

description The server encountered an internal error that prevented it 
from fulfilling this request.

exception 

org.apache.jasper.JasperException: javax.servlet.ServletException: 
org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot load JDBC driver 
class 'com.microsoft.sqlserver.jdbc.SQLServerDriver'
 
org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:549)
 
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:455)
 org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:390)
        org.apache.jasper.servlet.JspServlet.service(JspServlet.java:334)
        javax.servlet.http.HttpServlet.service(HttpServlet.java:728)


root cause 

javax.servlet.ServletException: 
org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot load JDBC driver 
class 'com.microsoft.sqlserver.jdbc.SQLServerDriver'
 
org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:912)
 
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:841)
        org.apache.jsp.index_jsp._jspService(index_jsp.java:286)
        org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
        javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
 
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:432)
 org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:390)
        org.apache.jasper.servlet.JspServlet.service(JspServlet.java:334)
        javax.servlet.http.HttpServlet.service(HttpServlet.java:728)


root cause 

org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot load JDBC driver 
class 'com.microsoft.sqlserver.jdbc.SQLServerDriver'
 
org.apache.tomcat.dbcp.dbcp.BasicDataSource.createConnectionFactory(BasicDataSource.java:1429)
 
org.apache.tomcat.dbcp.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1371)
 
org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044)
 com.compasseng.jsp.client.cors.Scanner.getScanners(Scanner.java:156)
        org.apache.jsp.index_jsp._jspService(index_jsp.java:151)
        org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
        javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
 
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:432)
 org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:390)
        org.apache.jasper.servlet.JspServlet.service(JspServlet.java:334)
        javax.servlet.http.HttpServlet.service(HttpServlet.java:728)


root cause 

java.lang.ClassNotFoundException: 
com.microsoft.sqlserver.jdbc.SQLServerDriver
 
org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1714)
 
org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1559)
 
org.apache.tomcat.dbcp.dbcp.BasicDataSource.createConnectionFactory(BasicDataSource.java:1420)
 
org.apache.tomcat.dbcp.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1371)
 
org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044)
 com.compasseng.jsp.client.cors.Scanner.getScanners(Scanner.java:156)
        org.apache.jsp.index_jsp._jspService(index_jsp.java:151)
        org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
        javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
 
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:432)
 org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:390)
        org.apache.jasper.servlet.JspServlet.service(JspServlet.java:334)
        javax.servlet.http.HttpServlet.service(HttpServlet.java:728)


note The full stack trace of the root cause is available in the Apache 
Tomcat/7.0.33 logs.


--------------------------------------------------------------------------------

Apache Tomcat/7.0.33

Thanks,
Justin
******************************************************************************
This email and any files transmitted with it are intended solely for 
the use of the individual or agency to whom they are addressed. 
If you have received this email in error please notify the Navy 
Exchange Service Command e-mail administrator. This footnote 
also confirms that this email message has been scanned for the
presence of computer viruses.

Thank You!            
******************************************************************************


Re: Tomcat 7.33 update on Windows

Posted by Ed Ludvig <ed...@gmail.com>.
good post

On Wed, Dec 12, 2012 at 8:51 AM, Justin Larose <Ju...@nexweb.org>wrote:

> Konstantin Kolinko <kn...@gmail.com> wrote on 12/11/2012 09:12:16
> AM:
>
> > From: Konstantin Kolinko <kn...@gmail.com>
> > To: Tomcat Users List <us...@tomcat.apache.org>
> > Date: 12/11/2012 09:12 AM
> > Subject: Re: Tomcat 7.33 update on Windows
> >
> > 2012/12/11 Justin Larose <Ju...@nexweb.org>:
> > > I just updated Tomcat 7 from version 7.11 to 7.33 on my windows server
> but
> > > when I goto the URL I am seeing 500 error, "Cannot load JDBC driver
> class
> > > 'com.microsoft.sqlserver.jdbc.SQLServerDriver'"
> > > Not sure why. I made a copy of all config directories prior to install
> and
> > > copied them all to the new Tomcat home. Below is the full stack.
> > >
> > > (...)
> > >
> > > root cause
> > >
> > > java.lang.ClassNotFoundException:
> > > com.microsoft.sqlserver.jdbc.SQLServerDriver
> > >
>
> > What jar contains the above class and whether it is present in your
> > installation? I guess you forgot to copy it.
>
> > (It should be placed into Tomcat's lib/ directory).
>
> Thanks for your help Konstantin.
> It was missing a sql file in the lib directory. It wasn't there when I
> copied the old Tomcat directory so I had to copy it from another server.
>
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
> > For additional commands, e-mail: users-help@tomcat.apache.org
>
>
> ******************************************************************************
> This email and any files transmitted with it are intended solely for
> the use of the individual or agency to whom they are addressed.
> If you have received this email in error please notify the Navy
> Exchange Service Command e-mail administrator. This footnote
> also confirms that this email message has been scanned for the
> presence of computer viruses.
>
> Thank You!
>
> ******************************************************************************
>
>

Re: Tomcat 7.33 update on Windows

Posted by Justin Larose <Ju...@nexweb.org>.
Konstantin Kolinko <kn...@gmail.com> wrote on 12/11/2012 09:12:16 
AM:

> From: Konstantin Kolinko <kn...@gmail.com>
> To: Tomcat Users List <us...@tomcat.apache.org>
> Date: 12/11/2012 09:12 AM
> Subject: Re: Tomcat 7.33 update on Windows
> 
> 2012/12/11 Justin Larose <Ju...@nexweb.org>:
> > I just updated Tomcat 7 from version 7.11 to 7.33 on my windows server 
but
> > when I goto the URL I am seeing 500 error, "Cannot load JDBC driver 
class
> > 'com.microsoft.sqlserver.jdbc.SQLServerDriver'"
> > Not sure why. I made a copy of all config directories prior to install 
and
> > copied them all to the new Tomcat home. Below is the full stack.
> >
> > (...)
> >
> > root cause
> >
> > java.lang.ClassNotFoundException:
> > com.microsoft.sqlserver.jdbc.SQLServerDriver
> >

> What jar contains the above class and whether it is present in your
> installation? I guess you forgot to copy it.

> (It should be placed into Tomcat's lib/ directory).

Thanks for your help Konstantin.
It was missing a sql file in the lib directory. It wasn't there when I 
copied the old Tomcat directory so I had to copy it from another server.

> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
> For additional commands, e-mail: users-help@tomcat.apache.org

******************************************************************************
This email and any files transmitted with it are intended solely for 
the use of the individual or agency to whom they are addressed. 
If you have received this email in error please notify the Navy 
Exchange Service Command e-mail administrator. This footnote 
also confirms that this email message has been scanned for the
presence of computer viruses.

Thank You!            
******************************************************************************


Re: Tomcat 7.33 update on Windows

Posted by Konstantin Kolinko <kn...@gmail.com>.
2012/12/11 Justin Larose <Ju...@nexweb.org>:
> I just updated Tomcat 7 from version 7.11 to 7.33 on my windows server but
> when I goto the URL I am seeing 500 error, "Cannot load JDBC driver class
> 'com.microsoft.sqlserver.jdbc.SQLServerDriver'"
> Not sure why. I made a copy of all config directories prior to install and
> copied them all to the new Tomcat home. Below is the full stack.
>
> (...)
>
> root cause
>
> java.lang.ClassNotFoundException:
> com.microsoft.sqlserver.jdbc.SQLServerDriver
>

What jar contains the above class and whether it is present in your
installation? I guess you forgot to copy it.

(It should be placed into Tomcat's lib/ directory).

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org