NullPointerException when run executeQuery(sql)

Question

I have simple query in Java to run in SQL SERVER 2008. When it reaches to

rs = stmt.executeQuery(sql); it gives me java.lang.NullPointerException

1-I use jtds driver to connect my code to database.

2-When I execute the query directly in database it works.

3-To make code short and easy to understand I omitted the Try-Catch

    public class DataBases 
    {

        private  Connection link;
        private  java.sql.Statement  stmt;
        public    ResultSet rs;

        public DataBases() 
        {    

            Class.forName("net.sourceforge.jtds.jdbc.Driver"); 
            String connectionUrl = "jdbc:jtds:sqlserver://localhost:1433;databaseName=DB;integratedSecurity=true";
            Connection link = DriverManager.getConnection(connectionUrl);


        }


        public ResultSet select(String sql)
        {
         rs = stmt.executeQuery(sql);                        
             return rs; 
        }
}



    public static void main(String[] args)
    {   

        DataBases s=new DataBases();      
        String sql="SELECT * FROM [DB].[dbo].[quantities] ";                       
        ResultSet rs=s.select(sql); 
   }

Where do you instantiate stmt?

BobTheBuilder
– BobTheBuilder

2013-02-19 07:36:06 +00:00
Commented Feb 19, 2013 at 7:36 — BobTheBuilder
– BobTheBuilder, Commented Feb 19, 2013 at 7:36

BobTheBuilder · Accepted Answer · 2013-02-19 07:43:43Z

2

You need to instantiate stmt somewhere (in the constructor or inside select function)

You can also move stmt field to be a variable of select function.

    public ResultSet select(String sql)
    {
         Statement  stmt = link.createStatement();
         rs = stmt.executeQuery(sql);                        
         return rs; 
    }

edited Feb 19, 2013 at 7:43

answered Feb 19, 2013 at 7:36

BobTheBuilder

19.4k6 gold badges45 silver badges62 bronze badges

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

Comments

Vikdor · Accepted Answer · 2013-02-19 07:37:47Z

0

Your select method should look like this, just to get your code working:

    public ResultSet select(String sql)
    {
         stmt = link.createStatement();
         rs = stmt.executeQuery(sql);                        
         return rs; 
    }

You need to look at a good tutorial on how to perform a jdbc operation without leaking resources (like connections here).

answered Feb 19, 2013 at 7:37

Vikdor

24.2k10 gold badges66 silver badges86 bronze badges

Comments

Shurmajee · Accepted Answer · 2013-02-19 07:41:54Z

0

As the stmt object reference is not pointing to any object you are getting an NPE. try..

public DataBases() 
        {    

            Class.forName("net.sourceforge.jtds.jdbc.Driver"); 
            String connectionUrl = "jdbc:jtds:sqlserver://localhost:1433;databaseName=DB;integratedSecurity=true";
            Connection link = DriverManager.getConnection(connectionUrl);
            Statement stmt = link.createStatement();
        }

answered Feb 19, 2013 at 7:41

Shurmajee

1,0474 gold badges13 silver badges35 bronze badges

Collectives™ on Stack Overflow

NullPointerException when run executeQuery(sql)

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related