mysql jdbc jar missing from the weceem app 1.1.1?

Hi,

I'm trying to upgrade to the 1.1.1 version of the app (not the plugin) and I can't: I get an exception:

i can see that the mysql jdbc jar file is missing from the war file, is that normal? Are we now supposed to specify the classpath where to reach this jar file by other means?

Thanks!

This message was edited 1 time. Last update was at 20/11/2011 01:06:58

Install this plugin http://grails.org/plugin/mysql-connectorj

I saw this problem recently and I forget but I think it was a configuration problem. Give that a try first

This message was edited 1 time. Last update was at 23/11/2011 00:47:17

If you're still having trouble its because the jar needs to be accessible to Tomcat, even more importantly than to your Grails app.

You must have the correct mysql-connectorJ jar in your *tomcat classpath*.

So, if you run startup.sh and get the following output:

You need to place that jar in: /local/devel/tomcat/bin/

Hope that helps,

Jason

Hi,

Thanks for picking this up guys.

I'm not sure if we ever shipped the mysql driver in weceem app. I don't think so.

You need to get your own JDBC driver, as the other posters have said.

Marc

Thanks for your replies.

Since I'm using the Weceem "app", I couldn't take the "install plugin" route, but I just reused the connector jar file I had previously.

Maybe I did that manually the first time also, my memory doesn't serve me well sometimes. It is possible that I manually repackaged the war file to include the driver for simpler deployment with jetty.

Thanks again!

Hi,

Normally you want your jdbc driver jar in the endorsed/common folder of your servlet container, shipping it in the WAR is not a good idea as it may not be the correct version of the jdbc driver for the database you are accessing (which is dependent on the hosting environment).

Marc