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 EJB 3 in Action this week in the EJB and other Java EE Technologies 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" />
I agree. Here's the link:
subject: Newbie: Deploying .war file, getting it working with MySQL
Similar Threads
the SQLNestedException makes my crazy
J2EE Deployment using ANT
Tomcat 5.5.9 getting Database Connection
DataSource Invalid
JDBC Realm inside the COntext element