Thanks On Thu, Jan 18, 2018 at 10:01 PM, David G. Johnston < david.g.johns...@gmail.com> wrote:
> On Thu, Jan 18, 2018 at 9:22 AM, Abhra Kar <abhra....@gmail.com> wrote: > >> >> I tried to modify like >> >> >> >> sess.createSQLQuery("select reset_all()") >> > > This part is correct > > > >> .executeUpdate(); >> >> >> >> getting error -- org.postgresql.util.PSQLException: A result was >> returned when none was expected. >> >> >> > You need execute the above the same way you would execute "SELECT * FROM > tbl"; then just ignore the result set that is returned. > > David J. > >