Servoy Forum

We are having problems with execution of stored procedures.
Does someone have a hint, where to look what goes wrong?

Code: Select all

var _sp = "exec axspTest @parameter= ?";
var _args = [12]
var _typeIO = [0]
var _return = plugins.rawSQL.executeStoredProcedure("abs_web", _sp, _args, _typeIO, 1);

The @parameter dissapears in the invoke of the procedure.

If I do a sql trace, it executes it as:

RPC:Starting exec axspTest 12

Strange thing is, when I debug it on our development, with same db/user, it does it correctly as:
RPC:Starting exec axspTest @parameter=12
Also with another servoy server instance: it also works correcly like that.

Only thing that is different is the Servoy version.
Could there be a bug or something changed?

It goes wrong in:
- Servoy version 2023.12.2 -releaseNumber 3924 (builddate: 2024-02-07 11:31)

It works in:
-Servoy version 2023.6.0 -releaseNumber 3883 (builddate: 2023-06-30 16:19)
- Servoy version 2023.9.0 -releaseNumber 3902 (builddate: 2023-09-27 15:31)

We really need to be able to specify the parameter

Hi Jos,

which database are you using?
Did you try using the jdbc connector version from .9 in .12?

We are using sql server 2019.

And we tried an older version what you suggested, and this solves our problem!

Still interesting to know why it was updated, and why it breaks.
You might want to raise a case for this in JIRA