Subject Re: [Firebird-Java] Firebird, JDBC and Tomcat
Author William L. Thomson Jr.

On Wed, 2003-02-12 at 09:32, jessica0012003 wrote:
> Hi
> I am trying to configure Firebird and a JDBC driver for access by a
> JSP application hosted by Tomcat. I am having difficulty in getting
> it all to work. Firebird is up and running as a service, and Tomcat
> runs the JSP app, but the app fails to connect to the database. I am
> rather baffled by things like CLASSPATH etc, and where the client
> should be installed. I am using Win2000.

To begin with since you are using Win2k you will need to place any JDBC
driver jar files inside your Tomcat installation dir. There are many
places to put them, but I would recommend putting them in your


> The JSP app's documentation recommends using InterClient. What I
> would like is a systematic description of how to install InterClient
> and how to test it by using some kind of supplied utility. I have not
> found much useful documentation for this. Any suggestions please?

Yes, forget about InterClient. Unless you are going to use IB 6.5 or
greater then stick with Jaybird. I am not sure if Jaybird has any sort
of supplied testing utility, but I have yet to have a need.

> Then, I would need to test the JDBC connectivity. How could I do
> that independently of my JSP application?

Simply write a small test app, and put all your code in the main
function. Should be fairly straight forward, and if needed consult the
Jaybird documentation.

> I have been advised to use JayBird instead of InterClient. However,
> it seems to me that JayBird is just a JDBC driver, and is not
> supplied with any utilities that I can run for tests. Any comments?

Part of the reason why InterClient needs a test utility is because it's
a two part driver. You install part on the db server itself, and then
another part on the client.

So the test app is really to test out the client server communications.
Just because that works, does not mean that the JDBC driver will work
for your app.

Now in order for you to create your own test app outside of Tomcat, you
will need to set your system classpath. If that is over your head then
make a jsp or servlet test app, and it should work fine. Tomcat set's
it's own internal classpath so even if a global one exists it will not
use it.

So to get Jaybird to work with Tomcat, simply place all of the Jaybirds
jar files except the test one into the dir mentioned above.

That should be it, and form there Jaybird should work via Tomcat.

Let me know if you have problems or questions. However it's all fairly
straight forward. If you consult the Tomcat docs, or the Jaybird docs.

William L. Thomson Jr.
Support Group
Obsidian-Studios Inc.
439 Amber Way
Petaluma, Ca. 94952
Phone 707.766.9509
Fax 707.766.8989