Hi Ben, SNAPSHOT builds are a part of our commercial offering.
If you're interested, I'd love to walk you over the other advantages we're offering to our jOOQ Professional Edition customers - which can also be of great help when using jOOQ with an Open Source database. Let me know and I'll get in touch. Best Regards, Lukas 2014-09-29 1:42 GMT+02:00 <[email protected]>: > Hi Lukas, > > I've just stumbled on this thread, and was gratified to see how quickly > this issue came and went. I'd like to incorporate your fix, ideally > without building jooq myself. Is the 3.5.0-SNAPSHOT version available on > any of the public repositories? > > Thanks, > Ben > > On Monday, September 8, 2014 3:53:50 AM UTC-7, Lukas Eder wrote: >> >> Hah, coincidence :-) >> >> Thank you very much for your nice words, that's very appreciated! >> >> Cheers, >> Lukas >> >> 2014-09-08 12:52 GMT+02:00 Sascha Herrmann <[email protected]>: >> >> Hi Lukas, >>> >>> wow, great. Great to hear that it will be part of 3.5.0. That release >>> really gears up to a pivotal release. >>> A snapshot would be much appreciated, of course :o) >>> >>> If I had to sum jOOQ up in one sentence, then it would be: "The >>> framework that delivers". Still being a learner, I tried often new ways to >>> execute a query for example and thought "wow, it would be great if that >>> worked" ... and it just worked. >>> And it's not just the framework that delivers ... the support does too. >>> Thanks. >>> >>> Regards from a happy customer. >>> >>> Sascha >>> >>> >>> Am Freitag, 5. September 2014 18:18:33 UTC+2 schrieb Lukas Eder: >>>> >>>> An update before the weekend: >>>> >>>> The compilation issue is fixed and could be released in a SNAPSHOT on >>>> Monday: >>>> https://github.com/jOOQ/jOOQ/issues/3624 >>>> >>>> The actual support for such types in procedures and more importantly in >>>> UDTs is still outstanding: >>>> https://github.com/jOOQ/jOOQ/issues/2155 >>>> >>>> I'm hoping to get this also done on Monday. >>>> >>>> Best Regards, >>>> Lukas >>>> >>>> >>>> 2014-09-05 15:32 GMT+02:00 Lukas Eder <[email protected]>: >>>> >>>>> In fact, Converter support for Routines (and apparently also UDTs) is >>>>> not yet implemented: >>>>> https://github.com/jOOQ/jOOQ/issues/2155 >>>>> >>>>> As a workaround, in the mean time, is it possible to express an >>>>> expression along with your forcedType that will exclude all UDTs? For >>>>> example: >>>>> >>>>> <forcedType> >>>>> <name>JodaDateTime</name> >>>>> >>>>> <expression>(\w+\.)?(?!UDT_PREFIX|PROC_PREFIX)\w+(\.\w+)?</ >>>>> expression> >>>>> >>>>> <types>DATE</types> >>>>> </forcedType> >>>>> >>>>> >>>>> Best Regards, >>>>> Lukas >>>>> >>>>> >>>>> 2014-09-05 15:09 GMT+02:00 Lukas Eder <[email protected]>: >>>>> >>>>>> Hello Sascha, >>>>>> >>>>>> I'm sorry for the delay. This is indeed a bug, that appears when >>>>>> matching data types using <types/>. The bug results in routine parameters >>>>>> and UDT attributes causing compilation errors. I have registered an issue >>>>>> for this: >>>>>> https://github.com/jOOQ/jOOQ/issues/3624 >>>>>> >>>>>> I'll need to further investigate and keep you posted. >>>>>> >>>>>> Best Regards, >>>>>> Lukas >>>>>> >>>>>> >>>>>> 2014-09-03 19:12 GMT+02:00 Sascha Herrmann <[email protected]>: >>>>>> >>>>>>> Hi Lukas, >>>>>>> >>>>>>> yes, it looks like packages and types, at least that's when >>>>>>> compilation breaks off. >>>>>>> >>>>>>> Thanks, >>>>>>> >>>>>>> Sascha >>>>>>> >>>>>>> Am Mittwoch, 3. September 2014 18:12:47 UTC+2 schrieb Lukas Eder: >>>>>>>> >>>>>>>> Hello Sascha, >>>>>>>> >>>>>>>> 2014-09-03 17:41 GMT+02:00 Sascha Herrmann <[email protected]>: >>>>>>>> >>>>>>>> Hi! >>>>>>>>> >>>>>>>>> Second posting, the other was swallowed by Google. >>>>>>>>> >>>>>>>> >>>>>>>> Yes, I'm sorry about that. It looks like mails from your E-Mail >>>>>>>> address are repeatedly considered as Spam by Google Groups, even if I >>>>>>>> keep >>>>>>>> marking it as acceptable. Do you have a regular GMail address that you >>>>>>>> could use instead? >>>>>>>> >>>>>>>> >>>>>>>>> We wrote a converter that is supposed to convert java.sql.Date to >>>>>>>>> Joda's DateTime during code generation. >>>>>>>>> We followed the example posted on the jOOQ website >>>>>>>>> (GregorianCalendar). >>>>>>>>> >>>>>>>>> But we run into problems: >>>>>>>>> >>>>>>>>> We configured the converter like this: >>>>>>>>> >>>>>>>>> <customTypes> >>>>>>>>>> <customType> >>>>>>>>>> <name>JodaDateTime</name> >>>>>>>>>> <type>org.joda.time.DateTime</type> >>>>>>>>>> <converter><package to converter>.DateTimeConverter</ >>>>>>>>>> converter> >>>>>>>>>> </customType> >>>>>>>>>> </customTypes> >>>>>>>>>> <forcedTypes> >>>>>>>>>> <forcedType> >>>>>>>>>> <!-- Specify any data type from >>>>>>>>>> org.jooq.impl.SQLDataType --> >>>>>>>>>> <name>DECIMAL</name> >>>>>>>>>> <types>NUMBER.*|INTEGER</types> >>>>>>>>>> </forcedType> >>>>>>>>>> <!-- SQL Date to DateTime --> >>>>>>>>>> <forcedType> >>>>>>>>>> <name>JodaDateTime</name> >>>>>>>>>> <types>DATE</types> >>>>>>>>>> </forcedType> >>>>>>>>>> </forcedTypes> >>>>>>>>> >>>>>>>>> >>>>>>>>> >>>>>>>>> But we get exceptions during creation: >>>>>>>>> >>>>>>>>> [javac] E:\oracle\jenkins\workspaces\Services_HEAD_DBAccess_All\ >>>>>>>>>>> generated\...\Getnextaccitemoverview.java:49: incompatible types >>>>>>>>>> >>>>>>>>>> [javac] found : org.jooq.Parameter<java.sql.Date> >>>>>>>>>> >>>>>>>>>> [javac] required: org.jooq.Parameter<org.joda.time.DateTime> >>>>>>>>>> >>>>>>>>>> [javac] public static final >>>>>>>>>> org.jooq.Parameter<org.joda.time.DateTime> >>>>>>>>>>> P_VALID_TO_DATE = createParameter("P_VALID_TO_DATE", >>>>>>>>>>> org.jooq.impl.SQLDataType.DATE); >>>>>>>>>> >>>>>>>>>> >>>>>>>>>>> >>>>>>>>>>> or: >>>>>>>>>> >>>>>>>>>> >>>>>>>>>>> [javac] E:\oracle\jenkins\workspaces\Services_HEAD_DBAccess_All\ >>>>>>>>>>> generated\...\XdsQueryParams.java:52: incompatible types >>>>>>>>>> >>>>>>>>>> [javac] found : org.jooq.UDTField<....XdsQuery >>>>>>>>>>> ParamsRecord,java.sql.Date> >>>>>>>>>> >>>>>>>>>> [javac] required: org.jooq.UDTField<....XdsQuery >>>>>>>>>>> ParamsRecord,org.joda.time.DateTime> >>>>>>>>>> >>>>>>>>>> [javac] public static final >>>>>>>>>> org.jooq.UDTField<.....XdsQueryParamsRecord, >>>>>>>>>>> org.joda.time.DateTime> CREATIONTIMETO = >>>>>>>>>>> createField("CREATIONTIMETO", >>>>>>>>>>> org.jooq.impl.SQLDataType.DATE, XDS_QUERY_PARAMS); >>>>>>>>>> >>>>>>>>>> >>>>>>>>> >>>>>>>>> What are we doing wrong? Using a snapshot 3.5.0 generator. >>>>>>>>> >>>>>>>> >>>>>>>> Thanks for your report. I'll investigate ASAP. If I get this >>>>>>>> correctly, only parameters (from stored procedures) and attributes >>>>>>>> (from >>>>>>>> UDTs) are affected? >>>>>>>> >>>>>>>> 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. >>>>>>> >>>>>> >>>>>> >>>>> >>>> -- >>> 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. > -- 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.
