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.klaver@aklaver.com <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@aklaver.com