Hi, Is this still the case? I have a MySQL stored procedure that I would like to return a cursor on (since the number of records returned could be potentially large) vs an array. If this has been fixed - since which version (so I can make sure we are using it in our project).
Thanks, Sharon On Wednesday, June 25, 2014 at 4:40:06 PM UTC-4, Lukas Eder wrote: > > Hi, > > Indeed, we currently do not support MySQL procedures that return cursors, > because (to our knowledge), MySQL's INFORMATION_SCHEMA does not provide any > such information to the code generator. We may be wrong about that, of > course, in case of which we would be more than happy to add this kind of > support to jOOQ... > > What you can do, of course, is: > > - Base your source code generation on H2 instead of MySQL (I personally > wouldn't recommend that, though - the databases are too different...) > - Implement your own MySQLDatabase in jOOQ-Meta, that provides / patches > the relevant procedures with cursor results > > Cheers, > Lukas > > > 2014-06-25 21:03 GMT+02:00 <[email protected] <javascript:>>: > >> We use MySQL for production and H2 for unit testing. There are several >> stored procedures that return result sets for data consumptions. We would >> like to use jOOQ to help map the procedure calls to actual java code and >> POJOs. >> >> I have seen information in this group in regards to trying to return >> result sets from stored procs, and they mostly state that you can't do it >> except when using Oracle. Any insight would be helpful on how do do this >> with the use of a simple fetchMany("call myProc(?)"). We would really like >> to use the code generation tool to create concrete java code. >> >> Example MySQL procedure: >> >> DELIMITER $$ >> DROP PROCEDURE IF EXISTS getUsers; $$ >> CREATE DEFINER=`company`@`%` PROCEDURE `getUsers`(accountName >> VARCHAR(255)) >> BEGIN >> >> SELECT a.id >> FROM tblUsers a >> JOIN tblAccounts b >> ON b.id = a.accountId >> WHERE b.name = accountName; >> >> END$$ >> DELIMITER ; >> >> -- >> You received this message because you are subscribed to the Google Groups >> "jOOQ User Group" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to [email protected] <javascript:>. >> For more options, visit https://groups.google.com/d/optout. >> > > -- You received this message because you are subscribed to the Google Groups "jOOQ User Group" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
