On Tue, Feb 20, 2018 at 9:21 PM, Adrian Klaver <adrian.klaver@xxxxxxxxxxx> wrote:
On 02/20/2018 07:35 AM, Abhra Kar wrote:
Please also reply to list so more people can see and answer.
Ccing list
On Tue, Feb 20, 2018 at 8:46 PM, Adrian Klaver <adrian.klaver@xxxxxxxxxxx <mailto:adrian.klaver@aklaver.com >> wrote:
On 02/19/2018 11:13 PM, Abhra Kar wrote:
Hi ,
I have a stored procedure name "procedure()". Which I
am calling by --
Session sess = (Session)entityManager.getDelegate();
//entityManager is javax.persistent.EntityManager[ Properly
Initialise]
sess.createSQLQuery("select procedure()");
procedure is containing some truncate queries like --
EXECUTE('truncate table abc');
It's not throwing any exception but not executing the
procedure.Using oracle query -- sess.createSQLQuery("{ call
procedure() }").executeUpdate(); procedure execution is
working fine.
What's need to be change here.
More information would help:
1) Postgres version.
2) JDBC driver and version?
3) Any relevant information from the Postgres logs.
The forthcoming Postgres version 11 will have stored procedures, but
at the moment Postgres has only stored functions.
Postgres Version -- 9.5
JDBC Driver - org.postgresql.Driver
JDVC driver version and relavant postgres logs didn't get.
Regards,
Abhra
--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx
Please provide me the list email.I don't know about it.
Thanks