Tomcat, JNDI, JSTL, and “No suitable driver”

An article by Glen    No Comments

Been mucking around with getting JSTL to use a JNDI data source, and Tomcat has been giving me all sorts of grief. I knew my web.xml was right… and I’d created the JNDI source using Tomcat’s own admin interface, so I *figured* that was ok.



But every time I gave it a whirl, I’m getting the dreaded: DataSource invalid: "No suitable driver" deal. The mysql jar file was happily in CATALINA_HOME/common/lib, so it wasn’t that.



Turns out you need to have commons-dbcp.jar and commons-pool.jar in your /common/lib directory as well. I wasn’t specifying dbcp as my connection factory, so I don’t know what gives with the dependency there. But, whatever. It’s fixed now.



Anyways, that’s the story. I’m documenting this so that when I forget what the fix is I can hopefully find it via Google.