Assuming Java middleware, the software components we need to
perform these operations are:
Ø Databases: any database
that has a JDBC driver. For Access, use
http://www.j-netdirect.com/, a solid driver that's free for two
connections. There is also a JDBC-ODBC bridge that comes with the
JDK; you can use any database that has an ODBC driver with it, but
not in production environments. For MySQL, use the driver from
www.worldserver.com/
mm.mysql/
Ø JDBC: part of Java 2
Standard Edition (J2SE), JDK 1.2.2
Ø XML Java API: any recent
parser from Sun, IBM, Oracle or Microsoft. We use Sun's JAXP (Java
API for XML Parsing) reference implementation, from
java.sun.com/xml.
Ø Servlet/JSP engine: the
most common combinations are IIS + JRun (www.allaire.com) and
Apache + Tomcat. You can also use the reference implementation,
Tomcat, by itself, as it has a built-in web server. This is what we
will use.
Ø Client browser and UP Phone
SDK
To use XSLT, you will need an XSLT processor implemented as a
servlet (for example, James Clark's xt, Michael Kay's Saxon, or
Apache Xalan). We'll use xt.
James Clark announced recently on xsl-dev that he is unlikely to
continue supporting xt, but there is an Open Source group that has
declared its willingness to take over. Michael Kay is actively
supporting Saxon, and is also the author of XSLT Programmer's
Reference (Wrox Press).