How to resolve No results were returned by the query in PostgreSQL?

Question

I'm trying to change the password of the non-admin user in PostgreSQL using jdbc connection.

statement.executeQuery("ALTER ROLE user1 WITH PASSWORD '6789'");

This above query is throwing:

org.postgresql.util.PSQLException: No results were returned by the query

How to resolve this issue?

Are you sure it isn't: ALTER ROLE user1 SET PASSWORD '6789' ? — Stultuske, Feb 17 '21 at 08:52
Using this psql query , I'm able to alter the password in pgadmin ALTER ROLE user1 WITH PASSWORD '6789' . — dev333, Feb 17 '21 at 09:00

score 3 · Accepted Answer · answered Feb 17 '21 at 08:58

3

statement.executeQuery() expects a resultset and you don't get one. Use statement.execute() for an ALTER-statement to avoid this issue.

answered Feb 17 '21 at 08:58

Frank Heikens

Using execute() method resolved my issue .. Thanks a lot for the suggestion. – dev333 Feb 18 '21 at 09:36

1 Answers1