How do I use JayBird with Tomcat?
CATALINA_HOME is the installation directory for Tomcat 4.x or greater. An environment variable of that name is set up on the Tomcat server. TOMCAT_HOME was used in versions before Tomcat 4. To use JayBird with Tomcat you must put the jar files where your web apps can access them. Once they are available to your web apps you use JayBird in your servlets or beans just as you would in standalone programs. If you have only one webapp using JayBird or you need to keep JayBird separate from other web apps, put the jar files in the WEB-INF/lib/ subdirectory of your web app. It is more likely that Firebird will be used by all of your web apps and Tomcat itself. To have universal access to JayBird, put the jars in CATALINA_HOME/common/lib/. A simple example web app that creates a Firebird database and does a few transactions directly is included below. It is called test. Below that is the same web app set up to use a DataSource and connection pooling via DBCP. It is called dbTest. To use JayBir
