Caused by: org.postgresql.util.PSQLException: ERROR: syntax error at or near "merge".

Sir, I am facing the error Caused by: org.postgresql.util.PSQLException: ERROR: syntax error at or near "merge". when I execute the below query in postgres database. The same works fine in Oracle. merge into net n using dual on (n.id=:id) when matched then update set Status=:status, lastStatusDa

Require assistance in Postgres + Hibernate : Error: java.math.BigInteger cannot be cast to java.math.BigDecimal

Hi, Require assistance on the below: Code snippet: Map ic; //Populate values for ic long count = ((BigDecimal)ic.get(“EB”)).longValue(); Getting the below error: java.math.BigInteger cannot be cast to java.math.BigDecimal ®java.lang.ClassCastException: java.math.BigInteger cannot be cas

Re: Require assistance in Postgres + Hibernate : Error: java.math.BigInteger cannot be cast to java.math.BigDecimal

Thanks for the update Francisco. I had one more query: In Oracle the syntax for calling a stored procedure is Session sess = (Session) entityManager.getDelegate(); sess.createSQLQuery("{ call reset() }").executeUpdate(); Can you please let me know if the below equivalent for postgres is correct

Postgres hangs for the query "lock table in exclusive mode"

Hi, Postgres hangs for the query "lock table in exclusive mode" Can you please let me know what could be the reason and how to resolve it? Regards, Vinodh.