rawSQL plugin strange behaviour

[Janssenjos]

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

[mboegem]

Hi Jos,

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

[Janssenjos]

We are using sql server 2019.

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

[mboegem]

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