Changes to plugins.rawSQL?

Classic Servoy
1

I have a solution that is working in Servoy 5.1.4 heavily utilizing stored procedures, thanks to the rawSQL plugin. When this solution is opened in 5.2.2, strange things begin happening with the stored procedures.

The main problem is that arguments I send to the stored procedure do not get sent. It seems like one argument I send is remembered and then used for all subsequent procedure calls, even if I pass something different in. Occasionally, the value I want to send across does get sent.

Were any changes made to the rawSQL plugin that could account for this?

Here’s how I’m calling it:

var serverName = 'my_data_server'
var procedure = '{call AR_CUSTOMERINFO(?)}'
var args = [forms.customer.customer_id]
var typesArray = [0]
var maxReturnedRows = -1

var dataset = plugins.rawSQL.executeStoredProcedure(
            serverName,
            procedure,
            args,
            typesArray,
            maxReturnedRows
        )
2

Troy,

The only code change from 5.1 to 5.2 in the rawsql plugin is that a check has been added that the user running the sql is actually logged in.
If not, all exec calls will return null or false.

Rob

3

By logged in what exactly do you mean? If I have enhanced security disabled will that make the rawsql plugin non-functional?

4

Client being logged-in is only checked when enhanced security is on.
When enhanced security is off the plugin will work as before.

Rob