I am tring to get an web site that I have developed with Java Studio Creator working on a VPS. I cannot get tomcat to comunicate with the MySQL database. I have got a minimal web site working, and I have added a simple dtabase query to it and I get the error at  (for full error see http://18.104.22.168:8080/minimal/). I have got a simple java app. working with MySQL.
What I have done;
Put the minimal.war file in /usr/local/jakarta/jakarta-tomcat-5.5.9/webapps. Put in a Context tag in server.xml file relating to the .war file . This is expanded by tomcat. Put in a Realm tag relating to the jdbc driver .