Hi Sheldon, Thank you for your message. A few questions on my side:
- You're using MySQL, correct? - What's the CREATE PROCEDURE declaration of your procedure? - What exactly is null that shouldn't be? Cheers, Lukas 2017-03-21 11:23 GMT+01:00 Sheldon D'Souza <[email protected]>: > We are facing an issue with Procedure calls > > when we call the procedure from CLI > > call `db`.`get_closest_time_slot`(1, time '15:49:58', > 2,@group_id,@start_time,@end_time,@min_id,@max_id,@min_time,@max_time); > > > we get the output but when the same is called from Jooq > > > GetClosestTimeSlot output = new GetClosestTimeSlot(); > > Configuration configuration = this.configuration.derive(); > > configuration.settings().setRenderNameStyle( > RenderNameStyle.AS_IS); > > output.setQueueid(queueId); > > output.setDayofweek((byte)dayOfWeek); > > output.setJointime(selectJoinTime); > > LOGGER.info("Get closest time slot for {}, {}, {}", queueId, > selectJoinTime, dayOfWeek); > > output.execute(configuration); > > > The output is null, is there something we are missing? > > -- > 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. > -- 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.
