File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes Tomcat and the fly likes Newbie: Deploying .war file, getting it working with MySQL Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of REST with Spring (video course) this week in the Spring forum!
JavaRanch » Java Forums » Products » Tomcat
Bookmark "Newbie: Deploying .war file, getting it working with MySQL" Watch "Newbie: Deploying .war file, getting it working with MySQL" New topic

Newbie: Deploying .war file, getting it working with MySQL

Huw Morgan

Joined: Mar 07, 2006
Posts: 23
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 [1] (for full error see 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 [2]. This is expanded by tomcat.
Put in a Realm tag relating to the jdbc driver [3].

You can see my .war file at It requires a database called smsserver, with a table called unit, with a column called name.

Apache Tomcat/5.5.9
Java Studio Creator 2004Q2 Version 9
Linux 2.4.20-021stab028.24.777-enterprise #1 SMP Fri Jan 6 19:39:27 MSK 2006 i686 athlon i386 GNU/Linux

Any suggestions? Thanks very much, my boss is breathing down my neck.

javax.servlet.ServletException: javax.servlet.jsp.JspException: javax.faces.FacesException: org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create JDBC driver of class '' for connect URL 'null'

<Context path="/minimal" docBase="minimal" debug="0"
reloadable="false" crossContext="true">

<Realm className="org.apache.catalina.realm.JDBCRealm"
connectionName="root" connectionPassword="ROOT_PASSWORD"
userTable="users" userNameCol="user_name" userCredCol="user_pass"
userRoleTable="user_roles" roleNameCol="role_name" />
subject: Newbie: Deploying .war file, getting it working with MySQL
It's not a secret anymore!