🚀 go-pugleaf

JBuilder Ent 2006 SP3
I'd been struggling to get the MySQL JDBC driver work inside Tomcat via
JNDI, when I came across this posting and found that I (think I) had done
everything suggested, yet it still didn't work.

I was getting the following error :-
org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot load JDBC driver
class 'com.mysql.jdbc.Driver'

I could see from the message window that the JDBC library wasn't on the
classpath for Tomcat. When I opted to build a WAR file it seemed to include
the jar file in the right place (WEB_INF/lib).

I may have done something wrong, so sorry if I cause confusion. But in case
others are having problems with this and I haven't made a mistake, here's
what I did to get it working.

Select "Project"|"Project Properties" from the menu. Select run from the
left hand pane and from the right hand pane select the server configuration
used for Tomcat 5.5.9 and click edit.

From the left hand pane find the Library option (the one directly off run).
In the right hand pane select "Use the specified libraries" and make sure
that the MySQL library jar file is present and ONLY any other libraries that
you need Tomcat to access.

Then select run in the left hand pane. In the right hand pane, select
"Server" from the tree structure and to the right make sure the "make
project libraries available on run" is checked.

Click OK twice to close the windows. Now run the project and the path to the
MySQL jar file should no be included in the Tomcat classpath.