CODEWITHSUNDEEP
javamysqlexceptionresultset
Louay Ali
Louay Ali

Reputation: 11

The ResultSet can not be null for Statement.executeQuery

I am inserting data to a MySQL DB, but get an error, when executing the insert statement:

The ResultSet can not be null for Statement.executeQuery.

Although if i check the database table, I find that the values have been successfully inserted. This is confusing.

Code Snippet

Connection connection = null;
connection = DriverManager.getConnection("jdbc:google:rdbms://name-of-instance");
Statement check = connection.createStatement();
java.sql.ResultSet resultset = null;
resultset = check.executeQuery("insert into table_name values (values-inserted-here);");

Upvotes: 0

Views: 643

Answers (2)

abkhan
abkhan

Reputation: 5

No need to use ResultSet. ResultSet only used when you fetch data from query like select query. Just use 

Statement check = connection.createStatement();
check.executeUpdate("insert into table_name values (values-inserted-here)");

and for tutorial use this link

Upvotes: 0

Armfoot
Armfoot

Reputation: 4921

To execute queries that update, delete or insert any data in your DB, you cannot use executeQuery(String sql) (check here the docs), but executeUpdate(String sql) instead.

So instead of:

check.executeQuery("insert into table_name values (values-inserted-here);");

You should do: 

check.executeUpdate("insert into table_name values (values-inserted-here);");

The ResultSet is always null in an insert, delete or update, that is why it was giving you that error. If you use executeUpdate the error should be gone.

Hope it helps!

Upvotes: 1

Related Questions