Hi Chuck,
Thank you so much for you quick response.
For the server.xml I added quite a lot but this is exactly the same as
my server.xml from 6.0.33. I have added the server.xml file but edited
sensitive information from it.
For the web.xml all I have added extra are the following lines:
<servlet-mapping>
<servlet-name>jsp</servlet-name>
<url-pattern>*.html</url-pattern>
</servlet-mapping>
<mime-mapping>
<extension>shtm</extension>
<mime-type>text/html</mime-type>
</mime-mapping>
<error-page>
<exception-type>java.lang.Throwable</exception-type>
<location>/error.jsp</location>
</error-page>
For the tomcat-users - this is for testing only for use with probe and
manager. Once everything is working this will be removed.
The mysql jar file is located in $Catalina-home/lib directory for global
use.
I am using java-1.6.0-openjdk-1.6.0.0-1.23.1.9.10.el5_7
java-1.6.0-openjdk-devel-1.6.0.0-1.23.1.9.10.el5_7
And
kernel-2.6.18-274.12.1.el5
kernel-devel-2.6.18-274.12.1.el5
kernel-headers-2.6.18-274.12.1.el5
Thanks again
Charlotte Binns
IS Technical Architect
(020) 7887 8622
-----Original Message-----
From: Caldarale, Charles R [mailto:[email protected]]
Sent: 12 December 2011 14:49
To: Tomcat Users List
Subject: RE: Cannot create JDBC driver of class error occurs when
upgrading from tomcat-6.0.33 to tomcat 6.0.35
> From: Charlotte Binns [mailto:[email protected]]
> Subject: Cannot create JDBC driver of class error occurs when
> upgrading from tomcat-6.0.33 to tomcat 6.0.35
> I added all my configuration to server.xml/web.xml
Exactly what did you change there?
> and tomcat-users.xml
Not suitable for a production environment.
> then copied in my web applications and /tomcat/conf/Catalina/localhost
> xml files required for my web applications.
And where did you put the MySQL driver jar?
- Chuck
THIS COMMUNICATION MAY CONTAIN CONFIDENTIAL AND/OR OTHERWISE PROPRIETARY
MATERIAL and is thus for use only by the intended recipient. If you
received this in error, please contact the sender and delete the e-mail
and its attachments from all computers.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
<?xml version='1.0' encoding='utf-8'?>
<Server port="8005" shutdown="complicatedPassword">
<Listener className="org.apache.catalina.core.AprLifecycleListener" SSLEngine="on" />
<Listener className="org.apache.catalina.core.JasperListener" />
<Listener className="org.apache.catalina.core.JreMemoryLeakPreventionListener" />
<Listener className="org.apache.catalina.mbeans.ServerLifecycleListener" />
<Listener className="org.apache.catalina.mbeans.GlobalResourcesLifecycleListener" />
<GlobalNamingResources>
<Resource name="UserDatabase" auth="Container"
type="org.apache.catalina.UserDatabase"
description="User database that can be updated and saved"
factory="org.apache.catalina.users.MemoryUserDatabaseFactory"
pathname="conf/tomcat-users.xml" />
<Resource
name="jdbc/dbnameO"
auth="Container"
type="javax.sql.DataSource"
driverClassName="oracle.jdbc.OracleDriver"
url="jdbc:oracle:thin:@servername:1521:dbnameO"
username="username"
password="passwordO"
maxActive="100"
maxIdle="10"
minIdle="0"
maxWait="10000"
validationQuery="select 1 from dual"
timeBetweenEvictionRunsMillis="300000" />
<Resource
name="jdbc/dbname1"
auth="Container"
type="javax.sql.DataSource"
DriverClassName="com.mysql.jdbc.Driver"
url="jdbc:mysql://hostname/dbname1"
username="username"
password="password"
maxActive="10"
maxIdle="5"
minIdle="1"
maxWait="15000" />
<Resource
name="jdbc/TatePaint"
auth="Container"
type="javax.sql.DataSource"
DriverClassName="com.mysql.jdbc.Driver"
url="jdbc:mysql://hostname/dbname2"
username="username2"
password="password2"
maxActive="10"
maxIdle="5"
minIdle="1"
maxWait="15000" />
<Resource
name="mail/Session"
auth="Container"
type="javax.mail.Session"
mail.smtp.host="mail.tate.org.uk" />
<Environment
name="application/filestore"
type="java.lang.String"
value="/folderpath/filestore" />
<Environment
name="application/filestorePrefix"
type="java.lang.String"
value="mg_" />
<Environment
name="application/headIncludeUrl"
type="java.lang.String"
value="http://application.url/includes/transparencynew.htm"; />
<Environment
name="mygallery/headerUrl"
type="java.lang.String"
value="http://application.url/includes/trans_header.htm"; />
<Environment
name="application/footerUrl"
type="java.lang.String"
value="http://application.url/includes/webtrends.htm"; />
<Environment
name="application/adminPassword"
type="java.lang.String"
value="password" />
<Environment
name="application2_fileStoreDirectoryName"
type="java.lang.String"
value="/folderpath2/filestore" />
<Environment
name="application2_fileStorePrefix"
type="java.lang.String"
value="tp_" />
<Environment
name="application2_ArtifactUploadURL"
type="java.lang.String"
value="http://application2_URL/artupload"; />
<Environment
name="application2_actionHandlerKey"
type="java.lang.String"
value="Key_value" />
<Environment
name="application2_headIncludeURL"
type="java.lang.String"
value="http://application2_URL/includes/transparencynew.htm"; />
<Environment
name="application2_headerURL"
type="java.lang.String"
value="http://application2_URL/includes/trans_header.htm"; />
<Environment
name="application2_footerURL"
type="java.lang.String"
value="http://application2_url/includes/webtrends.htm"; />
<Environment
name="application2_adminPassword"
type="java.lang.String"
value="password" />
</GlobalNamingResources>
<Service name="Catalina">
<Connector port="8080" protocol="HTTP/1.1"
MaxThreads="100"
connectionTimeout="20000"
redirectPort="8443"
proxyPort="80" />
<Connector executor="tomcatThreadPool"
port="8081" protocol="HTTP/1.1"
connectionTimeout="20000"
redirectPort="8443" />
<!-- Define a SSL HTTP/1.1 Connector on port 8443
This connector uses the JSSE configuration, when using APR, the
connector should be using the OpenSSL style configuration
described in the APR documentation -->
<!--
<Connector port="8443" protocol="HTTP/1.1" SSLEnabled="true"
maxThreads="150" scheme="https" secure="true"
clientAuth="false" sslProtocol="TLS" />
-->
<Connector port="8009" protocol="AJP/1.3" redirectPort="8443" />
<Engine name="Catalina" defaultHost="localhost" jvmRoute="jvm1">
<Realm className="org.apache.catalina.realm.UserDatabaseRealm"
resourceName="UserDatabase"/>
<Host name="localhost" appBase="webapps"
unpackWARs="true" autoDeploy="true"
xmlValidation="false" xmlNamespaceAware="false">
<!--For clustering, please take a look at documentation at:
/docs/cluster-howto.html (simple how to)
/docs/config/cluster.html (reference documentation) -->
<Cluster className="org.apache.catalina.ha.tcp.SimpleTcpCluster"
channelSendOptions="8" clustername="LAMPCLUSTER1" >
<Manager className="org.apache.catalina.ha.session.BackupManager"
expireSessionOnShutdown="false"
notifyListenersOnReplication="true"
mapSendOptions="6"/>
<Manager className="org.apache.catalina.ha.session.DeltaManager"
expireSessionsOnShutdown="false"
notifyListenersOnReplication="true"/>
<Channel className="org.apache.catalina.tribes.group.GroupChannel">
<Membership className="org.apache.catalina.tribes.membership.McastService"
address="228.0.0.5"
port="45564"
frequency="500"
dropTime="3000"/>
<Receiver className="org.apache.catalina.tribes.transport.nio.NioReceiver"
address="auto"
port="4000"
autoBind="100"
selectorTimeout="100"
maxThreads="6"/>
<Sender className="org.apache.catalina.tribes.transport.ReplicationTransmitter">
<Transport className="org.apache.catalina.tribes.transport.nio.PooledParallelSender"/>
</Sender>
<Interceptor className="org.apache.catalina.tribes.group.interceptors.TcpFailureDetector"/>
<Interceptor className="org.apache.catalina.tribes.group.interceptors.MessageDispatch15Interceptor"/>
<Interceptor className="org.apache.catalina.tribes.group.interceptors.ThroughputInterceptor"/>
</Channel>
<Valve className="org.apache.catalina.ha.tcp.ReplicationValve"
filter=".*\.gif;.*\.js;.*\.jpeg;.*\.png;.*\.htm;.*\.html;.*\css;.*\.txt;"/>
<Valve className="org.apache.catalina.ha.session.JvmRouteBinderValve"/>
<ClusterListener className="org.apache.catalina.ha.session.JvmRouteSessionIDBinderListener"/>
<ClusterListener className="org.apache.catalina.ha.session.ClusterSessionListener"/>
</Cluster>
<!-- Access log processes all example.
Documentation at: /docs/config/valve.html -->
<Valve className="org.apache.catalina.valves.AccessLogValve"
directory="logs"
prefix="localhost_access_log."
suffix=".txt"
pattern="%h %1 %u %t "%r" %s %b "%{Referer}i"%{User-Agent}i" %D"
resolveHosts="false"/>
</Host>
</Engine>
</Service>
</Server>
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
