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] <javascript:>>: > >> 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] <javascript:>>: >> >>> 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] >>> <javascript:>>: >>> >>>> 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<....XdsQueryParamsRecord,java.sql. >>>>>>>> Date> >>>>>>> >>>>>>> [javac] required: org.jooq.UDTField<.... >>>>>>>> XdsQueryParamsRecord,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] <javascript:>. >>>> 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.
