Generationg views in Jooq

2017-04-20 Thread samuel . laska
Hello, is possible to generate class for view in Jooq? Let's say i create view like create view tp0.test_receipts_view AS select field1, field2 from testschema and how can make mapping or generate class? -- You received this message because you are subscribed to the Google Groups "jOOQ User

Re: Generationg views in Jooq

2017-04-20 Thread Lukas Eder
Hi Samuel, jOOQ doesn't distinguish between views and tables, so you can just run the code generator as always. Is there anything that's not working for you right now? Cheers, Lukas 2017-04-20 9:18 GMT+02:00 : > Hello, > > is possible to generate class for view in Jooq? Let's say i create view

Re: implementing overlap array function - postgres 9.5

2017-04-20 Thread lehphyro
Hi, Are there plans to add native support for this in jOOQ itself? Sorry for bringing up an old thread. On Thursday, May 26, 2016 at 6:44:09 PM UTC+2, Lukas Eder wrote: > > Hi Leandro, > > You can use jOOQ's "plain SQL" capabilities to create your own predicates: > http://www.jooq.org/doc/latest/

Re: implementing overlap array function - postgres 9.5

2017-04-20 Thread Lukas Eder
Interesting, that must've been an oversight in https://github.com/jOOQ/jOOQ/issues/3985, or the function wasn't available at the time yet. I've added a feature request for this: https://github.com/jOOQ/jOOQ/issues/6108 Will be an easy fix. 2017-04-20 11:10 GMT+02:00 : > Hi, > > Are there plans

Re: implementing overlap array function - postgres 9.5

2017-04-20 Thread Leandro Aparecido
Great, thanks. 2017-04-20 11:18 GMT+02:00 Lukas Eder : > Interesting, that must've been an oversight in https://github.com/jOOQ/ > jOOQ/issues/3985, or the function wasn't available at the time yet. > > I've added a feature request for this: > https://github.com/jOOQ/jOOQ/issues/6108 > > Will be

Error when trying to insert a record with a LocalDate field set to null into a MS SQL database (evaluating trial professional edition)

2017-04-20 Thread Marcin Erdmann
Hi, Sorry if it's not the right support channel for this question but I could not find another one which seemed like a better fit. I'm currently evaluating jooq's professional edition with MS SQL Server. I have a generated table class with the following field: public final TableField EXPIRY_DA

Re: Error when trying to insert a record with a LocalDate field set to null into a MS SQL database (evaluating trial professional edition)

2017-04-20 Thread Lukas Eder
Hi Marcin, Thank you very much for your message and for your detailed error report. This is most certainly a good channel for reporting these things, just like GitHub or Stack Overflow. I believe that you may have run into this issue: https://github.com/jOOQ/jOOQ/issues/2738 It has been fixed fo

[ANNOUNCEMENT] Version 3.9.2 released with bug fixes

2017-04-20 Thread Lukas Eder
Version 3.9.2 - April 20, 2017 This is a patch release with some useful fixes for the 3.9 branch Features and Improvements - #5861 - Add a configuration option for varargs setters Bug Fixes -

Re: Error when trying to insert a record with a LocalDate field set to null into a MS SQL database (evaluating trial professional edition)

2017-04-20 Thread Marcin Erdmann
Thanks for a quick reply, Lukas. I'd rather use JSR-310 so I will see if I can implement a custom binding (as per https://www.jooq.org/doc/latest/manual/code-generation/custom-data-type-bindings/) and ask questions here if I run into any problems. Cheers, Marcin On Thursday, 20 April 2017 15