merge statement gives error

Hi, Trying to execute the following statement merge into ABC as n using dual on (n.id=123) when matched update set aaa=222, bbb=333 when not matched insert (id, aaa) values (NEXTVAL(id),555); but gives syntax error.What should be the proper syntax[ Parameter values are properly

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

On Tue, Feb 20, 2018 at 10:45 PM, Alban Hertroys wrote: > > > On 20 Feb 2018, at 8:13, Abhra Kar wrote: > > > > Hi , > > I have a stored procedure name "procedure()". Which I am > calling by -- > > > > Session sess = (Ses

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

On Tue, Feb 20, 2018 at 9:52 PM, Adrian Klaver wrote: > On 02/20/2018 08:17 AM, Abhra Kar wrote: > >> >> >> On Tue, Feb 20, 2018 at 9:21 PM, Adrian Klaver > <mailto:adrian.kla...@aklaver.com>> wrote: >> > > >> >> Please provide me th

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

On Tue, Feb 20, 2018 at 9:21 PM, Adrian Klaver 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 > <mailto:adrian.kla...@

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

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 t

Re: postgres connection with port option in shell script

On Wed, Feb 14, 2018 at 9:03 PM, David G. Johnston < david.g.johns...@gmail.com> wrote: > On Wed, Feb 14, 2018 at 8:21 AM, Abhra Kar wrote: > >> Hi, >> >> I want to get postgres connection in script file. I am executing >> below command and successfully

postgres connection with port option in shell script

Hi, I want to get postgres connection in script file. I am executing below command and successfully getting connected --- psql postgresql://$USER:$PASSWORD@$HOST/$DATABASE <

Found non-empty schema without metadata table error while migrating

Hi, Getting below error— exec] Flyway (Command-line Tool) v.1.1 [exec] [exec] Metadata table created: schema_version [exec] Schema initialized with version: 0 [exec] Flyway (Command-line Tool) v.1.1 [exec] [exec] ValidationException: Found non-empty schem

Re: Create schema with in a specific database from a script file

I executed the above script but schema created with in postgres db not with in ABC db. And in terminal didn't show the message connected to ABC database. What is wrong I am doing here? Regards, Abhra On Fri, Feb 2, 2018 at 7:48 AM, Melvin Davidson wrote: > > > On Thu,

Create schema with in a specific database from a script file

Hi, I have to write script for psql in a xyz.sh file which should create a schema in a specific data.In psql prompt I achieve it like -- postgres=# \c ABC ABC=# create schema authorization myschema In xyz.sh I executed the following script --- *su -c "psql -c \"\c ABC \"" postgres*

Equivalent shell script of create user and schema in specific postgres db

Create a user and schema of same name with in ‘abc’ db through linux shell – Psql steps--- 1> [/home]# su postgres 2> bash-4.1$ psql 3> postgres=# \c abc [ set database abc] 4> abc=# create user abhra with password ‘1234’ 5> abc=# alter user abhra with superuser 6> abc=# create s

Re: CannotAcquireResourceException in Junit

lPoolSize(50); cpds.setAcquireIncrement(5); cpds.setAcquireRetryAttempts(5); But the problem still persist.Please provide suggestion. Regards, Abhra On Thu, Jan 25, 2018 at 10:28 AM, Rob Sargent wrote: > > > On Jan 24, 2018, at 9:32 PM, Abhra Kar wrote: > > > > Thanks Rob

Re: CannotAcquireResourceException in Junit

, Rob Sargent wrote: > > > On Jan 24, 2018, at 9:57 AM, Abhra Kar wrote: > > > > > > Hi, > > I am getting the following error while running bunch of Junit > test cases through “ant test” command > > Caused by: com.mchange.v2.resour

Re: Call sql function in psql

Thanks On Thu, Jan 18, 2018 at 10:01 PM, David G. Johnston < david.g.johns...@gmail.com> wrote: > On Thu, Jan 18, 2018 at 9:22 AM, Abhra Kar wrote: > >> >> I tried to modify like >> >> >> >> sess.createSQLQuery("select reset_all()&qu

Call sql function in psql

Hi All, Please send me some info how to post directly in mailing list,somwhow I am not able to find out the way so I am mailing here. Present problem-- I tried to change below code in psql — Session sess = (Session) entityManager.getDelegate(); sess.createSQLQu

missing FROM-clause entry for table bbbb

Hi I tried to modify below sql command in postgres syntax--- insert into (id, groupid, ele_id, ro_element_id) ") select .nextval, :groupid, gosp.neteleid, gosp.hodev from net_ele gos, net_gos_prop gosp " where gos.eid in ( :eids ) and gos.id = gosp.net_ele