Connecting MySQL from JSP [duplicate]

Asked 22/11, 2012 at 4:19 Answered 1/2, 2024 at 6:28

I just set foot on JSP. I started writing simple programs to display dates, system info. Then I tried to connect a MySQL database I have a free hosting account, but I am not able to connect to MySQL database. Here is my code:

<%@ page import="java.sql.*" %> 
<%@ page import="java.io.*" %> 
<html> 
<head> 
<title>Connection with mysql database</title>
</head> 
<body>
<h1>Connection status</h1>
<% 
try {
    String connectionURL = "jdbc:mysql://mysql2.000webhost.com/a3932573_product";
    Connection connection = null; 
    Class.forName("com.mysql.jdbc.Driver").newInstance(); 
    connection = DriverManager.getConnection(connectionURL, "a3932573_dibya", "******");
    if(!connection.isClosed())
         out.println("Successfully connected to " + "MySQL server using TCP/IP...");
    connection.close();
}catch(Exception ex){
    out.println("Unable to connect to database.");
}
%>
</font>
</body> 
</html>

I am getting Message as Connection Status unable to connect to database. I have tested this connection using PHP using the same username, password and database name. Where am I making mistake?

Nightie answered 22/11, 2012 at 4:19 Comment(18)

Are your JSP server and PHP server on the same machine? – Philoprogenitive 22/11, 2012 at 4:21

Please print this in catch and let me know ex.printStackTrace(); – Glacier 22/11, 2012 at 4:24

I am getting a single � character before my Connection status. – Nightie 22/11, 2012 at 4:26

Bet 10$ the driver isn't loaded – Philoprogenitive 22/11, 2012 at 4:28

I edited the question please check catch block and show the full exceptions. – Glacier 22/11, 2012 at 4:30

add printStacktrace in the catch block – Frenetic 22/11, 2012 at 4:37

@AlexandreLavoie Which driver? As I am very new to JSP I am not able to get which driver should be loaded – Nightie 22/11, 2012 at 4:45

Start by doing what @Glacier said... and show us the result. – Philoprogenitive 22/11, 2012 at 4:45

@sheldonCooper I have added the printStackTrace() in the catch block. – Nightie 22/11, 2012 at 4:46

Are you getting the error stacktrace ? – Frenetic 22/11, 2012 at 4:47

After adding printStackTrace() in catch statement there are no error messages. I am getting the same output with one � character before my output. – Nightie 22/11, 2012 at 4:49

Looks the driver is missing in your libraries please add it and try its should work fine .. – Zennas 22/11, 2012 at 4:50

@ATR Please tell me which driver am I missing? – Nightie 22/11, 2012 at 4:56

Add external jar mysql connector jar to the lib folder and to your class path of the project @Dibya – Zennas 22/11, 2012 at 4:58

I have added mysql connector jar before starting developing JSP. – Nightie 22/11, 2012 at 5:2

okies.. first try with standalone app and check it should work fine use the same connection statements please and lets know know the stack trace .. – Zennas 22/11, 2012 at 5:6

Why I got a down-vote? Pls leave a comment. – Nightie 22/11, 2012 at 5:21

@Dibya I gave you an upvote to counter the down vote. I think your question is legitimate :) – Organist 17/8, 2013 at 3:31

Reason is the driver have not been loaded in the libraries, it does not get instantiated in the connection so the connection failed:

try {
            String connectionURL = "jdbc:mysql://host/db";
            Connection connection = null; 
            Class.forName("com.mysql.jdbc.Driver").newInstance(); 
            connection = DriverManager.getConnection(connectionURL, "username", "password");
            if(!connection.isClosed())
                 out.println("Successfully connected to " + "MySQL server using TCP/IP...");
            connection.close();
        }catch(Exception ex){
            out.println("Unable to connect to database"+ex);
        }

Download Driver

Zennas answered 22/11, 2012 at 4:54 Comment(0)

I‘ve got the same problem. I'm pretty much sure what's wrong with your program: you haven't added .jar to web lib. Copy it and paste into WEB-INF/lib.

Sorry for not using the correct format for posting answers(I'm new here and this is my first anwser:( )

Fitly answered 18/9, 2014 at 16:0 Comment(0)

Download the right driver :

http://dev.mysql.com/downloads/connector/j/

And add the jar in the classpath of your project.

Philoprogenitive answered 22/11, 2012 at 4:58 Comment(0)

go to this location in your pc C:\Program Files\Apache Software Foundation\Tomcat 10.1\lib and paste .jar file and restart the server or your pc and that's it. The download link for it is in the above answers

that how mine got worked!

Eschatology answered 1/2, 2024 at 6:28 Comment(0)

Recommended topics

Hot tags