Execute Stored Procedure

This plug in has a cloud badge. So - will work with the Appian Cloud database - MariaDB?

Hi Juergen! Yes this works with Appian Cloud and MariaDB

Hi Pete,
Thanks for the confirmation. 

We are only using the smart service at this point so I can't comment on the function, but as noted above the function is not supposed to be used to modify data, only read. Most of our critical path processes use write to data store smart services, but a few do use procedures. We have observed no issues with procedures- that includes modifying the DB as well.

Hi - we have recently upgraded to 20.4 with Maria DB and also have extensive use of the Stored Procedure plug in.

So far all of our Smart Service calls have been ok - which perform create, read, update and delete statements. 

We also ensured that any use of the stored procedure function in expressions and script tasks were limited to read functions.

We have had a niggle with one stored proc returning inconsistent results but on the whole the Plug In still operates as it did on MySQL. Bearing in mind that if you are on Cloud DB, the function warned users not to use this with procedures that created data due to GTID enforcement.

Hope this helps. 

As with all upgrades though thorough testing is highly recommended.  

Cheers 

Paul

Hello phorning

reading Migration to MariaDB guidelines, I've read that this plugin has some problems with procedures that modify database (insert, delete, update etc..). Is this true? In the application we developed for our main customers we use procedures for this purpose, is this a problem? Is it only related to functions or even to smart services?

Thanks in advance

Best Regards

Stefano

Hello phorning

reading Migration to MariaDB guidelines, I've read that this plugin has some problems with procedures that modify database (insert, delete, update etc..). Is this true? In the application we developed for our main customers we use procedures for this purpose, is this a problem? Is it only related to functions or even to smart services?

Thanks in advance

Best Regards

Stefano

We are only using the smart service at this point so I can't comment on the function, but as noted above the function is not supposed to be used to modify data, only read. Most of our critical path processes use write to data store smart services, but a few do use procedures. We have observed no issues with procedures- that includes modifying the DB as well.

Hi - we have recently upgraded to 20.4 with Maria DB and also have extensive use of the Stored Procedure plug in.

So far all of our Smart Service calls have been ok - which perform create, read, update and delete statements. 

We also ensured that any use of the stored procedure function in expressions and script tasks were limited to read functions.

We have had a niggle with one stored proc returning inconsistent results but on the whole the Plug In still operates as it did on MySQL. Bearing in mind that if you are on Cloud DB, the function warned users not to use this with procedures that created data due to GTID enforcement.

Hope this helps. 

As with all upgrades though thorough testing is highly recommended.  

Cheers 

Paul