Re: stored procedure call is not working with "select procedure()" option

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(dot)klaver(at)aklaver(dot)com <mailto:adrian(dot)klaver(at)aklaver(dot)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(dot)klaver(at)aklaver(dot)com