File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes need help configuring MySQL Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Badass: Making Users Awesome this week in the Game Development forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "need help configuring MySQL" Watch "need help configuring MySQL" New topic

need help configuring MySQL

aliasger talib
Ranch Hand

Joined: Aug 19, 2002
Posts: 37
hi there,
i want to use MySQL as my database for my aplication which runs with Tomcat 4.04. the database has been created but i cant seem to get y tomcat running. ive updated the server.xml file accordingly for my tomcat.
this what i added :
<Realm className="org.apache.catalina.realm.JDBCRealm" debug="99"
userTable="users" userNameCol="username" userCredCol="password"
userRoleTable="roles" roleNameCol="role" />
it gives me an exception on start up of tomcat saying that it cant open the database connection:
Catalina.start: LifecycleException: Exception opening database connection: jav
LifecycleException: Exception opening database connection: java.sql.SQLExcepti
anything im doing wrong here? im really stuck people. need help ASAP.
Jeremy Maddera

Joined: May 02, 2002
Posts: 16
You connection URL should look like this:
I agree. Here's the link:
subject: need help configuring MySQL