On Tue, Feb 20, 2018 at 9:21 PM, Adrian Klaver <adrian.kla...@aklaver.com> 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.kla...@aklaver.com >> <mailto:adrian.kla...@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.kla...@aklaver.com > Please provide me the list email.I don't know about it. Thanks
