This week's book giveaway is in the Servlets forum.
We're giving away four copies of Murach's Java Servlets and JSP and have Joel Murach on-line!
See this thread for details.
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 Murach's Java Servlets and JSP this week in the Servlets 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" />
jQuery in Action, 2nd edition
subject: Newbie: Deploying .war file, getting it working with MySQL
Similar Threads
DataSource Invalid
JDBC Realm inside the COntext element
the SQLNestedException makes my crazy
J2EE Deployment using ANT
Tomcat 5.5.9 getting Database Connection