change adapterconnection settings in runtime - maximum row


If you want to change the Maximum Row property of a select JDBC adapter service i.e., if you have to set the value during runtime, create a variable - select.maxRow under adapterServiceSettings in using the service -

Check this attached screenshot for further info.


You may use a may step before calling the service add a string under adapterServiceSettings with the name - select.maxRow. Map your runtime variable to this variable.

Great…thanks for sharing this info to the forum.

It’s a very helpful Info::slight_smile:

Interesting, though I’m not sure on the scenario where this is desirable/useful.

How does this behave when multiple threads are calling the service?