Read Schedule Alternative - Database Connection Point

Hi,

Does anyone know any alternative to the limitation we have in database connection point for read? Right now when you send a read statement or call a stored procedure to get some data the reply is scheduled based on what you set.

Does anyone have any workaround for this to get the results immediately or even wait for it without setting a wait node?

Find more posts tagged with

ION Connect

Accepted answers

All comments

Kevin Heiman

Can you better describe your requirement? Are you wanting to invoke the DB read on demand or just once and done? Is there an event that invokes they process?

As you note, the Data Base Read connections are scheduled. If you set the timing too low for a polling scenario, you would hammer your database with unnecessary activity.

If the event could push the message to a responsive connection (IMS, JMS, or IO Box as examples) that would seem more practical.

DM9346

Hi, on demand is what I want. I know that right now it's a limitation but I was wondering if people have any workaround with this.

You mentioned other types of connections are these the workaround? Does that mean no workaround for DB connection itself?

Kevin Heiman

The DB connection Read scenario is a scheduled event. So polling frequently (ideally not to frequently) for a signal or data set would be how to use that.

If the application can push or orchestrate other methods such as IO Box and others (FTP, DB) are also polling events.

JMS Queue is a direct connection if the client can push to a JMS queue.

IMS (Infor Message Service) is a direct method, orchestrated by the client application though. It is a REST API service built into ION API.

DM9346

hmm the problem is that this is a pull scenario hence why the get stored procedure from API is used

Copyright © 2025 Infor. All rights reserved.