I cannot connect to a simpple Mysql dBase using the example in the beginning JSP book. I think it might have something to do with my jar file set up. Can someone please step through the process with me. I'm using XP and using version 5 of tomcat. I'd appreciate some urgent help as I need to finish an assignment shortly.

Thank you in advance, Darren

Darren

The jarfile with the JDBC driver should be in the WEB-INF/lib directory of your web application.
Put it there and if your JDBC code is correct it should be picked up.

Thank you very much for your response I'll try it now and let you know the result.

Darren

Darren

Should the jar file be included anywhere else. DO in need to keep adding the jar file to the lib dir of each application
Sincerely

Darren

As standard in J2EE applications each has its own classpath so would have its own libraries.

If you use JNDI and the facilities of the application server only the app server needs to have access to the actual driver (as your application will never directly access those classes, seeing only the interfaces exposed by JDBC).

I have also experienced similar problem and by adding the driver in the WEB-INF\lib it does not work
could anyone tell me why.