tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Hugh Morgan <>
Subject Newbie: Deploying .war file, getting it working with MySQL
Date Mon, 08 May 2006 10:49:23 GMT
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].
Put the tag libarys in the correct place.

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: 
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" 
           userRoleTable="user_roles" roleNameCol="role_name" />

To unsubscribe, e-mail:
For additional commands, e-mail:

View raw message