Re: Can I disable type conversions for NaN in JOOQ?

2018-04-09 Thread Charles Henry
Hi Lukas, Thank you for the explanation, and information! I will have a look at the custom bindings link that you provided. I definitely don't want to turn off all of JOOQ's type conversion, but I am aiming to find a way to force it to not convert in the case of NaN. As we discussed, that is

Re: Can I disable type conversions for NaN in JOOQ?

2018-04-09 Thread Lukas Eder
Hi Charlie, Thanks for explaining. I think I see now what you're trying to do, although, I'm not sure why you're doing it. In any case, here's the explanation of the current behaviour: jOOQ tries to implement as useful data type specific behaviour as possible, if the column data type (as in

Re: Can I disable type conversions for NaN in JOOQ?

2018-04-07 Thread Charles Henry
Hi Lukas, Thanks so much for responding to me! For starters, I agree with you. I think what I am trying to do sort of goes against what JOOQ is trying to do. Yes, sometimes I definitely ramble and think aloud as I go along :-) Before I start a new message, I'll describe the issue in a minimal

Re: Can I disable type conversions for NaN in JOOQ?

2018-04-07 Thread Lukas Eder
Hi Charles, Thank you very much for your messages. I see, you've been kinda having a conversation with yourself. :) In order to get to the same level, would you mind starting a new conversation again with the current state of your findings? Also, do not yet make any assumptions about a possible

Re: Can I disable type conversions for NaN in JOOQ?

2018-04-06 Thread Charles Henry
LOL, nope...I was wrong. It was not preserved. On Friday, April 6, 2018 at 11:18:39 AM UTC-7, Charles Henry wrote: > > Hi folks, > > I realize that one of the purposes of JOOQ is to ensure safe datatype > conversions, and this question may be flying in the face of the purpose of > JOOQ. > > I

Re: Can I disable type conversions for NaN in JOOQ?

2018-04-06 Thread Charles Henry
Hi folks, It appears as though if I tweak the StatementType from StatementType.PREPARED_STATEMENT to StatementType.STATIC_STATEMENT that my NaN is preserved. I need to investigate more as to why, but this looks promising. Any opinions or experience, is still more than appreciated. Thanks

Re: Can I disable type conversions for NaN in JOOQ?

2018-04-06 Thread Charles Henry
Hi folks, In addition, I should note that when I examine the DSLContext which performs the insertInto, I don't see anything in the Settings parameter that would allow me to switch off the type conversion. Any advice is greatly appreciated. Thanks, -Charlie On Friday, April 6, 2018 at 11:18:39