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>
index | next in thread | previous in thread | raw e-mail
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
help
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?20021113090324.GA25372>