java.lang.NullPointerException: Cannot invoke "java.sql.Connection.createStatement()" because "connection" is null

Asked May 10 '21 at 14:08

Active May 10 '21 at 14:35

Viewed 64 times

<%@ page import="java.sql.*" %>
<%@ page import="java.util.*" %>

<%

Connection connection=null;
    try{
            Class.forName("com.mysql.jdbc.Driver");
            connection= DriverManager.getConnection("jdbc:mysql://localhost:3306/social_network","root","Apsa@123");
        }
        catch(Exception e)
        {
            System.out.println(e);
        }       

%>

I am getting the exception below

java.lang.NullPointerException: Cannot invoke "java.sql.Connection.createStatement()" because "connection" is null

edited May 10 '21 at 14:35

Dhyey Vachhani

asked May 10 '21 at 14:08

BELLIAPPA K A

You most likely have an exception printed to System.out you need to attend to. – Thorbjørn Ravn Andersen May 10 '21 at 14:36
Check your service like ( XAMPP,etc) is running or not, before running the code. – naveen4181 May 10 '21 at 14:53
Your connection is obviously null. Probably because of exception. You need either find out, what System.out.println(e); prints, or use logger to log exception. Also if all of that is hard for you, you could just write details of Exception to a file manually in catch block. – Ilya Sazonov May 10 '21 at 15:55
Do not catch exceptions and continue on as if nothing happened. – Mark Rotteveel May 10 '21 at 16:48

java.lang.NullPointerException: Cannot invoke "java.sql.Connection.createStatement()" because "connection" is null

0 Answers0