ResultSet object returning null

[Arpit Panwar]

public ResultSet selectQuery(String query){
         
            try{
                    Statement st = conct.createStatement();
                   rs= st.executeQuery(query);
                    st.executeUpdate("COMMIT");
                    new Connect().closeConnection(conct);
            }catch(SQLException se){
                    se.printStackTrace();
            }
         return(rs);
     }    

where ResultSet is defined in class as

  private  ResultSet rs=null;  

conct is a valid connection object
and query is also valid and the table also has rows in it...still resultset keeps fetching null....Can anyone help..

[Jan Cumps]

What happens to a ResultSet when you close its connection?
You close the connection. Then you return the resultset.

keeps fetching null

What does that mean: no rows? rs == null ?

[Arpit Panwar]

Yup ResultSet returns no rows

ResultSet.getFetchSize() returns 0 i.e. no rows are being fetched

And should closing the Connection have anything to do with ResultSet object???

[Jan Cumps]

Arpit Panwar wrote:

And should closing the Connection have anything to do with ResultSet object???

Yes.
You can think of a resultset as a cursor into the database. The connection is needed to navigate to the next record.

[Jan Cumps]

Arpit Panwar wrote:Yup ResultSet returns no rows

ResultSet.getFetchSize() returns 0 i.e. no rows are being fetched

This method might not do what you expect that it does:
https://coderanch.com/t/299924/JDBC/java/workings-ResultSet-getFetchSize

[Arpit Panwar]

I tried it without closing the connection the result is the same....
Still i keep Getting 0 rows
has is something to do with my Connection

public Connection getConnection(){
      try{
           Class.forName(driver).newInstance();
           con = DriverManager.getConnection(url+database, username, password);
           System.out.println(con.getClientInfo());
       }catch(ClassNotFoundException cnfe){
                    System.out.println("Class Not Found");
                    cnfe.printStackTrace();

       }catch(InstantiationException ie){
                        System.out.println("Cannot Instantiate");
                      ie.printStackTrace();

       }catch(IllegalAccessException ilae){
                     System.out.println("Illegal Access to the Database");
                    ilae.printStackTrace();

       }
     catch(SQLException se){
                     System.out.println("Sql Exception");
                    se.printStackTrace();

       }
        return con;
    }    

[Arpit Panwar]

Jan Cumps wrote:

Arpit Panwar wrote:Yup ResultSet returns no rows

ResultSet.getFetchSize() returns 0 i.e. no rows are being fetched

This method might not do what you expect that it does:
https://coderanch.com/t/299924/JDBC/java/workings-ResultSet-getFetchSize

Ok Thanks
Il try it out right away

[Arpit Panwar]

Thanks
It Really Helped

[Jan Cumps]

Ah. Good!