Re: MSSQL Stored Procedures Call

On Thu, 2016-03-17 at 22:26 +1000, Don Brown wrote:

Looking for any suggestions;

I have a call to a stored procedure on a MSSQL server. The function is used
by multiple users and called multiple times.

My thinking is to create two keyed data queues and a monitor program that
can start the JVM and create the connection to the MSSQL server, then wait
on requests on the data queue. A request is then processed and the result
returned on the second data queue.

Is there a better solution to avoid the overhead of starting the JVM and
initiating the connection to the MSSQL server for each request?

Thank you for any suggestions

I may be wrong but, I am fairly sure there is an "ODBC" style/method (I
can't remember the term, but I might be confusing it with the way(s)
that the SQL is embedded within RPG, not its ability to talk to an
outside server) or a "linked server" method. If so, surely it would be
better to just call the MSSQL procedure directly via SQL from within RPG
(or your language of choice) and cut out the middle men (dataq/jvm).

Don

Sent from my iPhone