Apache Tomcat use XAMPP MySQL Database

Question

I have installed Tomcat 6 and apache XAMPP on MAC OS. XAMPP includes MySQL.

I turn on TOMCAT and XAMPP.

Then i try to connect with JDBC to MySQL.

public class main {

    public static void main(String[] args) {

        Connection conn = null;
        try
        {
            String userName = "root";
            String password = "";
            //<facility> is the name of the database i created
            String url = "jdbc:mysql://localhost/facility"; 
            Class.forName ("com.mysql.jdbc.Driver").newInstance ();
            conn = DriverManager.getConnection (url, userName, password);
            System.out.println ("Database connection established");
        }
        catch (Exception e)
        {
            System.out.println ("Cannot connect to database server");
        }

        finally
        {
            if (conn != null)
            {
                try
                {
                    conn.close ();
                    System.out.println ("Database connection terminated");
                }
                catch (Exception e) { /* ignore close errors */ }
            }
        }


    }
}

Well it gives me back "Cannot connect to database server".

Is it possible to interact XAMPP with TOMCAT without any further configuration. In my example i get an exception that connection failed. — kostas trichas
– kostas trichas, Commented Mar 22, 2011 at 11:23
print the exception and read the message: System.out.println ("Cannot connect to database server " + e.getMessage()); — Costis Aivalis
– Costis Aivalis, Commented Mar 22, 2011 at 11:26
Yes it can. With phpMyAdmin i created the "facility" database — kostas trichas
– kostas trichas, Commented Mar 22, 2011 at 11:26
Can you also print the exception type e.getClass().getName()? I'm thinking it might not be able to find/load the driver. — Eelke
– Eelke, Commented Mar 22, 2011 at 11:30

kostas trichas · Accepted Answer · 2011-03-22 11:46:58Z

2

The problem is at the JDBC driver. You must include it to your classpath.

You download it here: http://dev.mysql.com/downloads/connector/j/5.0.html

Add the mysql-connector-java-5.1.15-bin.jar to your classpath

Then it will work.

answered Mar 22, 2011 at 11:46

kostas trichas

3,0337 gold badges30 silver badges37 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Apache Tomcat use XAMPP MySQL Database

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related