rawSQL plugin strange behaviour

Feedback
1

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

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

2

Hi Jos,

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

3

We are using sql server 2019.

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

4

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