Hi Sugeeth 2015-01-14 13:15 GMT+01:00 Sugeeth Adassuriya <[email protected]>:
> Hello Lukas, > > Thanks a lot for your reply. > > What are ID_PIN and PIN_NAME? Domains? > They are Domains: > CREATE DOMAIN ID_PIN AS INTEGER; > CREATE DOMAIN PIN_NAME AS VARCHAR(50) CHARACTER SET UTF8 COLLATE UTF8; > That's what I feared. Domains are currently not supported explicitly by jOOQ. Support is on the roadmap for a future version, but I cannot make any promises: https://github.com/jOOQ/jOOQ/issues/681 > What do you get when you run > SELECT * FROM RDB$PROCEDURES; > I can see my procedure name under the field values RDB$PARAMETER_NAME > SELECT * FROM RDB$PROCEDURE_PARAMETERS; > I can see Parameters ID_PIN and PIN_NAME under the parameters. > > I just build my Routines class "manually" by adding the "out put" > parameters. > So, Now I found another problem. The procedure.getResults() returns NULL !! > But when I check procedure.getPinName(), I am getting correct values. > So it execute the Stored procedure correctly and return the values, but it > does not get List<Result<Record>> from procedure.getResults() > > Any idea ? > > Just for your info, I update my Jaybird driver to > version jaybird-2.2.6.jar (Latest) > What happens if your do not use the domain in your procedure for the time being? Best Regards, Lukas -- 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.
