jooq 3.12 with jpms

2019-09-07 Thread Christian Master
Is there a way to use the OS version the JPMS way? Thx chris -- 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 jooq-user+unsubscr...@googlegroups.com. To view

Record setvalue javadoc

2019-04-26 Thread Christian Master
[#2211] Future versions of jOOQ might remove the set(Field, Object) <../../org/jooq/Record.html#set-org.jooq.Field-T-> method. It is recommended to use set(Field, Object) <../../org/jooq/Record.html#set-org.jooq.Field-T-> instead. do you remove setValue or set ? I think javadoc should be

Re: copy records with primary key from one db to another

2019-03-29 Thread Christian Master
thank you so much! Am Freitag, 29. März 2019 09:09:57 UTC+1 schrieb Lukas Eder: > > > > On Fri, Mar 29, 2019 at 8:36 AM Christian Master > wrote: > >> Perfect, thank you. (to copy it from one db to another, create2 was >> missing) >> > > Yes of cou

Re: copy records with primary key from one db to another

2019-03-29 Thread Christian Master
t; > Hope this helps, > Lukas > > On Thu, Mar 28, 2019 at 9:39 AM Christian Master > wrote: > >> I try to copy the records from one database to another. >> >> create1.insertInto(Tables.KTO).select( >> create2.select().from(Tables.KTO)

copy records with primary key from one db to another

2019-03-28 Thread Christian Master
I try to copy the records from one database to another. create1.insertInto(Tables.KTO).select( create2.select().from(Tables.KTO) ).execute(); Since I have a primary key with auto_increment this wont work. In pure SQL it is not possible to exclude the primary key

Re: '_' is a keyword error

2019-02-20 Thread Christian Master
gen-matcherstrategy > > I hope this helps, > Lukas > > On Sat, Dec 15, 2018 at 10:56 PM Christian Master > wrote: > >> I get in my generated UserSslType class >> >> >> public enum UserSslType implements EnumType { >> _(""), >&

'_' is a keyword error

2018-12-15 Thread Christian Master
I get in my generated UserSslType class public enum UserSslType implements EnumType { _(""), ANY("ANY"), X509("X509"), . jdk12-ea+22 gradle 5.0 nu.studer.jooq 3.0.2 mysql-connector-java 6.0.6 sourceCompatibility = 9 targetCompatibility = 9 the error: error: as of release 9, '_'

Well done

2017-05-09 Thread Christian Master
Jooq rocks! Great docs, great support from Lukas in the group -- 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 jooq-user+unsubscr...@googlegroups.com. For

Re: JOOQ and JavaFX Properties

2017-04-29 Thread Christian Master
hi, take a look https://groups.google.com/forum/#!topic/jooq-user/KHVLUdbM-N0 r. Am Samstag, 29. April 2017 10:35:02 UTC+2 schrieb Julian Decker: > > Dear JOOQ Group, > > is there a solution to simply change the pojo variable types from e.x. > "String" to a JavaFX compatible

Re: Generator for JavaFX beans ?

2017-04-16 Thread Christian Master
Hi, any news on the JavaFx Property topic? Would be great for DB & JavaFx apps. Thx. Am Mittwoch, 27. April 2016 16:14:32 UTC+2 schrieb Lukas Eder: > > Yes, code generation has a different scale of "easy", I know :) > > 2016-04-27 14:43 GMT+02:00 : > >> Dear Lukas, >> >>

[h2] Re: full join alternative for h2

2016-12-27 Thread Christian Master
b on a.date = b.date > > > > On Saturday, 24 December 2016 13:11:22 UTC+1, Christian Master wrote: >> >> Hi, >> i have >> tableA (date, moneyIn) >> >> tabelB (date, moneyOut) >> >> i need >> select a.date, a.moneyIn, b.moneyOut >> fr

[h2] full join alternative for h2

2016-12-24 Thread Christian Master
Hi, i have tableA (date, moneyIn) tabelB (date, moneyOut) i need select a.date, a.moneyIn, b.moneyOut from tableA a full join tableB b a.date=b.date How to do it in H2, i think full join is not supported? thx chris -- You received this message because you are subscribed to the Google Groups

Re: YEAR an MONTH function for sum per month.

2016-12-23 Thread Christian Master
Thx Samir, this works. Connection conn = DriverManager.getConnection("jdb Result> fetch1 = DSL.using(conn) .select(DSL.year(TABLE.DATE), DSL.month(TABLE.DATE),

YEAR an MONTH function for sum per month.

2016-12-22 Thread Christian Master
Is there a YEAR function in JOOQ? I need to sum total per month. In SQL i write: SELECT YEAR(myDate) as SomeYear, MONTH(myDate) as SomeMonth, SUM(someInt) AS SomeTotal FROM myTable GROUP BY YEAR(myDate), MONTH(myDate) ORDER BY YEAR(myDate), MONTH(myDate) Is it possible