Skip site navigation (1)Skip section navigation (2)
Date:      Wed, 13 Nov 2002 09:03:24 +0000
From:      Matthew Seaman <m.seaman@infracaninophile.co.uk>
To:        freebsd-questions@FreeBSD.ORG
Subject:   Re: Java and mysql and tomcat
Message-ID:  <20021113090324.GA25372@happy-idiot-talk.infracaninophi>
In-Reply-To: <1037147023.1592.98.camel@localhost.localdomain>
References:  <1037147023.1592.98.camel@localhost.localdomain>

next in thread | previous in thread | raw e-mail | index | archive | help
On Tue, Nov 12, 2002 at 03:23:43PM -0900, Jon Reynolds wrote:
> I am attempting to find and use a webcalendar and have found one I would
> like to use at sourceforge it says the requirements are this:

These are all available from ports:
 
> Java2Platform SE

    ports/java/jdk13
    jdk-1.3.1p7_2       Java Development Kit 1.3
    [Note: Sun licensing terms mean you have to register to download
     the source]

> Tomcat

    ports/www/jakarta-tomcat3
    jakarta-tomcat-3.3.1_16 Open-source Java web server by Apache, stable 3.x branch

> Mysql

    ports/databases/mysql323-server
    mysql-server-3.23.53 Multithreaded SQL database (server)

> MM.Mysql

    ports/databases/mysql-jdbc-mm
    mysql-jdbc-mm-2.0.14 The mm JDBC interface for MySQL

> My questions are these, do I need tomcat if I already have apache
> installed? And what is MM.Mysql and is it needed? The description for it
> is a JDBC driver to make the connection between java servlets and the
> MySQL database. Is there a port in FreeBSD for this?

Yes --- you do need all of these things to run a Java/JSP web-app with
a MySQL back end database.  MM.Mysql is a library of stuff to access
MySQL databases from within Java.

Ironically, the only thing you've mentioned that you could possibly
dispense with is apache, as jakarta-tomcat provides a complete
webserver written in java.  However, the usual method of deploying
java web apps is to use a fully-fledged webserver like apache and
install an interface module:

    ports/www/mod_jk
    mod_jk-3.3.1_2      Apache module for Tomcat 3

which passes the requests for .jsp pages between apache and tomcat,
whilst letting apache deal with all of the static files (images, etc)
for maximum efficiency.

There is also jakarta-tomcat4 and jakarta-tomcat41 in ports, but these
are apparently set up to work with apache2 and mod_webapp

> Or does somebody else have a better solution to making a webcalendar
> that sits on a site that can be easily updated.

There are any number of web calendar apps available around the 'net
--- nothing in ports that seems to fit your requirements though.  If
you haven't done this sort of thing before, you'll probably find it
easier to install and get working something based on PHP rather than
Java/JSP, but once it's up and running I doubt that the maintenance
load would be that different either way.

	Cheers,

	Matthew

-- 
Dr Matthew J Seaman MA, D.Phil.                       26 The Paddocks
                                                      Savill Way
                                                      Marlow
Tel: +44 1628 476614                                  Bucks., SL7 1TH UK

To Unsubscribe: send mail to majordomo@FreeBSD.org
with "unsubscribe freebsd-questions" in the body of the message




Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?20021113090324.GA25372>