> From: [email protected]
> To: [email protected]
> Subject: RE: Upgrade to Tomcat 7 Issues
> Date: Mon, 12 Aug 2013 11:09:59 +0100
>
> Sorry, I didn't realise it wouls remove the highlighted red. This is what I
> have changed from 8080 to 8088:
>
> <Connector connectionTimeout="20000" port="8088" protocol="HTTP/1.1"
> redirectPort="8443"/>
>
> This is what I have added just above the Host tag/element:
>
> <Realm className="org.apache.catalina.realm.JNDIRealm"
> connectionURL="xxx://xxx:3268"
> connectionName="[email protected]" connectionPassword="xxx"
> referrals="follow" userBase="dc=xxx,dc=local"
> userSearch="(sAMAccountName={0})" userSubtree="true"
> roleBase="dc=xxx,dc=local" roleSearch="(member={0})"
> roleName="cn" roleSubtree="true" />
>
> Sorry again about that.
>
I've added my application.xml file to Tomcat/conf/Catalina/localhost/ directory
which contains all the database connection resources.
This has removed the error I was getting in my 1st post for today. I now have
this error:
org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot load JDBC driver class
'com.mysql.jdbc.Driver'
at
org.apache.tomcat.dbcp.dbcp.BasicDataSource.createConnectionFactory(BasicDataSource.java:1429)
at
org.apache.tomcat.dbcp.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1371)
at
org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044)
at com.viatel.soportal.helpers.Database.getSopConnection(Database.java:18)
at com.viatel.soportal.util.UserUtil.getUser(UserUtil.java:36)
at com.viatel.soportal.P1_00Action.portalExecute(P1_00Action.java:60)
at com.viatel.soportal.PortalBaseAction.execute(PortalBaseAction.java:200)
at
org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:421)
at
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:226)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1164)
at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:397)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:621)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
at com.viatel.soportal.RequestFilter.doFilter(RequestFilter.java:47)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
at com.viatel.commonlib.ADGroupFilter.doFilter(ADGroupFilter.java:62)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
at jcifs.http.NtlmHttpFilter.doFilter(NtlmHttpFilter.java:118)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222)
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)
at
org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:99)
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:953)
at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408)
at
org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1023)
at
org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:589)
at
org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:312)
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
Caused by: java.lang.ClassNotFoundException: com.mysql.jdbc.Driver
at
org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1714)
at
org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1559)
at
org.apache.tomcat.dbcp.dbcp.BasicDataSource.createConnectionFactory(BasicDataSource.java:1420)
... 37 more
Do i need to add the my-sql-connector-java-5.0.8-bin jar somewhere? Or do I
need to do something else?
Thanks
> > Date: Mon, 12 Aug 2013 12:05:51 +0200
> > From: [email protected]
> > To: [email protected]
> > Subject: Re: Upgrade to Tomcat 7 Issues
> >
> > Seema Patel wrote:
> > >
> > ...>
> > > Right, I've re-installed Tomcat 7.0.42. The only things I've changed are
> > > in the server.xml file, here is what's in the server.xml file (what I
> > > have added/changed are in red,
> >
> > Not the easiest to spot, for a list which works only with plain text
> > messages and strips
> > most attachments.
> >
> > Please check the recommendations in http://tomcat.apache.org/lists.html
> >
> >
> > ...
> >
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail: [email protected]
> > For additional commands, e-mail: [email protected]
> >
>
