Re: StoredProcedures and Cayenne

2016-04-22 Thread Andrus Adamchik
I finally got around to building an environment on the same version of MariaDB. I used the following simplified versions of 2 stored procedures (as of course I don't have the exact definitions of your tables) : DELIMITER $$ CREATE DEFINER=`root`@`localhost` PROCEDURE `readShoplistIngredientsSort

Re: StoredProcedures and Cayenne

2016-04-22 Thread Andrus Adamchik
Thanks for more info. Trying to find time to setup a test env with your exact procedure. >> CALL StoreDepartments(id_store); I asked before, but I don't see you mentioning it anywhere. 'StoreDepartments' is called from within 'readShoplistIngredientsSortedByStore'. Could you post a definition