| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| DBInput is not polling records from table? |
« View previous topic :: View next topic » |
| Author |
Message
|
| junaid |
 Posted: Wed Sep 11, 2019 8:56 pm Post subject: DBInput is not polling records from table? |
 |
|
Acolyte
Joined: 29 Nov 2018
Posts: 58
|
Hi,
I want to poll record from APPLICATION_TABLE and I used DBInput node. Trigger APP_TO_EVENT is made which inserts record in EVENT_TABLE.
IIB Version: 10.0.0.15
steps which I followed from Youtube link
https://www.youtube.com/watch?v=S2lPNKTvobE
1. Created Data Design Project.
2. Created Data Definition
3. Created Message Model
4. Generated query on DBInput Node and deployed
It was working but when added another trigger in "AFTER UPDATE" case in
APPLICATION_TABLE, same event occurred. Both Triggers are working fine,
and inserting record in EVENT table but DB pooling is not working.
Kindly suggest?
| Code: |
CREATE TABLE "SCHEMA"."APPLICATION_TABLE" (
"PKEY" VARCHAR(10) NOT NULL ,
"NAME" VARCHAR(10) NOT NULL ,
"STREET" VARCHAR(10) NOT NULL )
IN "USERSPACE1" ;
ALTER TABLE "SCHEMA"."APPLICATION_TABLE"
ADD CONSTRAINT "CC1567517313306" PRIMARY KEY
("PKEY") ;
CREATE
TRIGGER "SCHEMA".APP_TO_EVENT AFTER INSERT
ON
"SCHEMA".APPLICATION_TABLE REFERENCING NEW AS N FOR EACH ROW MODE DB2SQL BEGIN ATOMIC INSERT
INTO
"SCHEMA" . EVENT_TABLE(
EVENT_PKEY,
APP_PKEY,
"OBJECT"
)
VALUES(
NEXT VALUE FOR PKEYSEQ,
N.PKEY,
'inser'
);
END ;
CREATE TABLE "SCHEMA"."EVENT_TABLE" (
"EVENT_PKEY" INTEGER NOT NULL ,
"APP_PKEY" VARCHAR(10) NOT NULL ,
"OBJECT" VARCHAR(10) NOT NULL )
IN "USERSPACE1" ;
ALTER TABLE "SCHEMA"."EVENT_TABLE"
ADD CONSTRAINT "CC1567517420065" PRIMARY KEY
("EVENT_PKEY") ;
|
|
|
| Back to top |
|
 |
| junaid |
| Posted: Wed Sep 18, 2019 9:42 pm Post subject: DBInput is not polling records from table? |
|
|
Acolyte
Joined: 29 Nov 2018
Posts: 58
|
| Pooling has been done. but it pools single record multiple times. DB input node is not deleting event table record . kindly suggest |
|
| Back to top |
|
|
| Vitor |
| Posted: Thu Sep 19, 2019 8:36 am Post subject: Re: DBInput is not polling records from table? |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| junaid wrote: |
| Pooling has been done. but it pools single record multiple times. DB input node is not deleting event table record . kindly suggest |
Transactionality of the flow is wrong?
What does the trace say is happening?
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| abhi_thri |
| Posted: Fri Sep 20, 2019 12:05 am Post subject: Re: DBInput is not polling records from table? |
|
|
Knight
Joined: 17 Jul 2017
Posts: 516
Location: UK
|
| junaid wrote: |
| DB input node is not deleting event table record . kindly suggest |
hi...what code do you have at the "EndEvent" procedure of the DatabaseInput node? Is it explicitly deleting records or doing something else...also as Vitor suggested running an user trace of the flow should tell you the whole story |
|
| Back to top |
|
|
| junaid |
| Posted: Tue Oct 01, 2019 2:21 am Post subject: Re: DBInput is not polling records from table? |
|
|
Acolyte
Joined: 29 Nov 2018
Posts: 58
|
| Yes it is deleting record . after event occur. secondly it pools multiple times due to error in esql which is used in DBInput flow |
|
| Back to top |
|
|
|
|
|
| |
|
Page 1 of 1 |
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
|
|
