No results returned by the Query error in PostgreSQL

java database jsp postgresql sql-insert
Ragesh Kr picture Ragesh Kr · Jan 22, 2014 · Viewed 33.4k times · Source

I am trying to insert a data into a table. After executing the query i am getting an exception stating

org.postgresql.util.PSQLException: No results were returned by the query.
org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:284)

The data is getting inserted successfully, but i have no idea why i am getting this exception ??

Answer

Paul Draper picture Paul Draper · Jan 22, 2014

Use

executeUpdate

instead of 

executeQuery

if no data will be returned (i.e. a non-SELECT operation).

Related questions

Upload image and Save inside Web Content Folder in JSP and Save Image Path in Database

My goal is to upload an image and save inside images folder to Web Content Folder. {Please see the image below} and save the image path into database {Please see the image below} I encountered some problem at this link …

Read More
How do I find out my MySQL URL, host, port and username?

I need to find my MySQL username. When I open the MySQL command line client, it only asks me for my password. I don't remember my username. And for connectivity with JDBC, I need the URL, host and port number. …

Read More
What is the easiest way to ignore a JPA field during persistence?

I'm essentially looking for a "@Ignore" type annotation with which I can stop a particular field from being persisted. How can this be achieved?

Read More