[openroad-developer] OR Server

[David Tondreau]

Hello!

I’ve got a relatively simple OR application that is one piece of our 
overall SOA interface architecture. It polls a DB table every .X sec to 
see if there are any records to process, does some simple SQL if there 
is work to be done then goes back to the .X sec wait. I currently manage 
the wait loop by using the delay attribute of the SendUserEvent command. 
I initially had it running as a ghost frame but converted it to a user 
frame so I can stop and start it via a GUI as well as set some runtime 
options on the fly for debugging purposes.

This process needs to be running exclusively (one instance per DB) and 
we’d like for it to execute within the scope of a server and not an 
active Windows user session. The functionality I’m looking for is to 
enable different clients to inquire about as well as control the status 
of the process (stop, start, is it running?) . I initially thought this 
might be a candidate for the OR app server but after reading the 
documentation it looks to me that the OR server is not geared toward 
this type of scenario – it doesn’t seem that you can initiate a 
perpetual looping process/service that has no active client session 
attached to it. Having to use a simple client to do the initial start of 
the process isn’t a problem. Our scenario is that you would start the 
process somewhere then disconnect while it continues to execute until 
told otherwise, possibly by a completely different client session.

We’re interested in the app server concept for a couple of reasons but 
primarily because this will ultimately be a ‘back room’ process that 
shouldn’t need an active Windows user session context to continue to 
execute under and can respond to commands/inquiries from different 
remote clients within the scope of one executing instance.

Is my conclusion about the app server correct? Using java/tomcat, etc is 
an option for us but we’re trying to avoid that route if possible. 
Likewise it needs to be DBMS agnostic.

Thanks in advance for any suggestions or ideas you may be able to offer,

Dan

*Dan McOdrum| Sr. Principal Architect |** Infor** | office: 610.407.8025 
| cell: 484.431.5400 | email: **daniel.mcodrum at infor.com* 
<mailto:daniel.mcodrum at infor.com>**