• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

getting familiar with Tomcat 5.5

 
Ranch Hand
Posts: 237
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hi there,

I had an application running on an older release of Tomcat where I had
placed important info in the server.xml file regarding the applications
context. This info initialized a connection pool to a database and provided
the appropriate data regarding the number of connections, user name and
password, etc. The entire xml data is provided below.

I'm trying to port over my application to the latest release of Tomcat
version 5.5 and I'm having difficulty in determining where to place the
context information for the application. This latest release doesn't seem
to include any context info on any of the example applications in the
server.xml file, so where does one put this context info? I noticed there
is an xml file named context.xml in the Apache Software Foundation\
Tomcat 5.5\conf directory, and even tried appending my own context
info there, but Tomcat didn't like my doing that!

Please advise,

Alan

<!-- New Context for MySQL Database Driver -->
<Context path="/school" docBase="school"
debug="0" reloadable="true" crossContext="true">

<Logger className="org.apache.catalina.logger.FileLogger"
prefix="localhost_School_log." suffix=".txt"
timestamp="true"/>

<Resource name="jdbc/School"
auth="Container"
type="javax.sql.DataSource"/>

<ResourceParams name="jdbc/School">
<parameter>
<name>factory</name>
<value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
</parameter>

<!-- Maximum number of dB connections in pool. Make sure you
configure your mysqld max_connections large enough to handle
all of your db connections. Set to 0 for no limit.
-->
<parameter>
<name>maxActive</name>
<value>3</value>
</parameter>

<!-- Maximum number of idle dB connections to retain in pool.
Set to 0 for no limit.
-->
<parameter>
<name>maxIdle</name>
<value>3</value>
</parameter>

<!-- Maximum time to wait for a dB connection to become available
in ms, in this example 10 seconds. An Exception is thrown if
this timeout is exceeded. Set to -1 to wait indefinitely.
-->
<parameter>
<name>maxWait</name>
<value>10000</value>
</parameter>

<!-- MySQL dB username and password for dB connections -->
<parameter>
<name>username</name>
<value>sqlapp</value>
</parameter>
<parameter>
<name>password</name>
<value>aplus</value>
</parameter>

<!-- Class name for mm.mysql JDBC driver -->
<parameter>
<name>driverClassName</name>
<value>org.gjt.mm.mysql.Driver</value>
</parameter>

<!-- The JDBC connection url for connecting to your MySQL dB.
The autoReconnect=true argument to the url makes sure that the
mm.mysql JDBC Driver will automatically reconnect if mysqld closed
the
connection. mysqld by default closes idle connections after 8
hours.
-->
<parameter>
<name>url</name>

<value>jdbc:mysql://192.168.2.75:3306/school_db?autoReconnect=true</value>
</parameter>
</ResourceParams>
</Context>
 
Ranch Hand
Posts: 3695
IntelliJ IDE Java Ubuntu
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
The 'preferred' method of configuring applications in Tomcat 5.0 changed considerably between version 4.x and 5.0.x.

http://jakarta.apache.org/tomcat/tomcat-5.0-doc/config/context.html

(4th paragraph).

With Tomcat 5.5 (of which I have zero experience), it might be even more strictly enforced as to the location of the context configuration information. I seem to recall that the DataSource configuration changed LOTS. Everything that was a pair of tags is now attributes within one tag (or something like that).

It is better that you start with a clean server.xml and reconfigure your application, using the TC 5.x docs as a guide. Things move around.

Here's the docs for 5.5:
http://jakarta.apache.org/tomcat/tomcat-5.5-doc/index.html


I'll also ask that this post be moved to Apache/Tomcat.
 
ranger
Posts: 17347
11
Mac IntelliJ IDE Spring
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Moving to the Apache/Tomcat forum.

Mark
 
Don't get me started about those stupid light bulbs.
reply
    Bookmark Topic Watch Topic
  • New Topic