Yeah exactly, When I perform the update operation, for example:
int result = ctx.update(MY_TABLE)
.set(MY_TABLE.MY_COLUMN, 2)
.execute();
I obtained a result of 1 with version 3.9 jOOQ, while with version 3.17, I
observed the result as the update count. Is this expected behavior, or will
it show the result as provided by the JDBC driver?
Regards,
Aravind k
On Wednesday, September 13, 2023 at 3:17:58 PM UTC+5:30 lukas...@gmail.com
wrote:
> I'm just going to have to assume what you mean, since you don't provide
> actual example code. I'm *assuming* you mean something like:
>
> int result =
> ctx.update(MY_TABLE)
> .set(MY_TABLE.MY_COLUMN, 2)
> .execute();
>
> You're wondering what "result" will be, and the answer is: The JDBC update
> count. There's no change in behaviour between jOOQ versions as far as I
> remember.
>
> If that's not what you're looking for, please provide example code.
>
> On Wed, Sep 13, 2023 at 10:56 AM Aravind Koonapureddy <
> akoona...@snaplogic.com> wrote:
>
>> I want to know that if I execute a simple update query after the
>> successful execution what's the output?
>>
>> Regards,
>> Aravind k.
>>
>> On Wed, 13 Sept 2023, 2:09 pm Lukas Eder, <lukas...@gmail.com> wrote:
>>
>>> Hi Aravind,
>>>
>>> Well, I don't know what "status" means, so can you please provide the
>>> complete context necessary to help you?
>>>
>>> On our issue tracker, we usually ask folks to provide us with an MCVE
>>> (minimal, complete, verifiable example). We have a template here:
>>> https://github.com/jOOQ/jOOQ-mcve
>>>
>>> This is probably not necessary in your case, but maybe you can see where
>>> I'm trying to go here? The idea of an MCVE is derived from Stack Overflow:
>>> https://stackoverflow.com/help/minimal-reproducible-example
>>>
>>> Without context, I can't really help you.
>>> I hope this helps,
>>> Lukas
>>>
>>> On Wed, Sep 13, 2023 at 10:32 AM Aravind Koonapureddy <
>>> akoona...@snaplogic.com> wrote:
>>>
>>>> When I update the records with old jar, I got message as:
>>>> "status":
>>>> 1
>>>> "message":
>>>> "success"
>>>>
>>>> But now it when I'm doing same update operation, it getting as :
>>>> "status":
>>>> 66
>>>> "message":
>>>> "success"
>>>>
>>>>
>>>>
>>>> Regards,
>>>> Aravind k.
>>>>
>>>> On Wednesday, September 13, 2023 at 12:26:55 PM UTC+5:30
>>>> lukas...@gmail.com wrote:
>>>>
>>>>> Hi Aravind,
>>>>>
>>>>> Thanks for your message.
>>>>>
>>>>> Can you please provide some example code showing what you're expecting
>>>>> and what you're seeing?
>>>>>
>>>>> Thanks,
>>>>> Lukas
>>>>>
>>>>> On Wed, Sep 13, 2023 at 7:52 AM Aravind Koonapureddy <
>>>>> akoona...@snaplogic.com> wrote:
>>>>>
>>>>>> I mean it provides the number of affected rows as a result, but I
>>>>>> couldn't find any documentation confirming this update.
>>>>>> On Wednesday, September 13, 2023 at 11:20:14 AM UTC+5:30 Aravind
>>>>>> Koonapureddy wrote:
>>>>>>
>>>>>>> The older version of jOOQ assigns a status of 1 for update
>>>>>>> operations, but with the latest jOOQ, it provides a different status.
>>>>>>>
>>>>>> --
>>>>>> 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+...@googlegroups.com.
>>>>>> To view this discussion on the web visit
>>>>>> https://groups.google.com/d/msgid/jooq-user/8927995b-2888-4eaf-879d-d8878336b98fn%40googlegroups.com
>>>>>>
>>>>>> <https://groups.google.com/d/msgid/jooq-user/8927995b-2888-4eaf-879d-d8878336b98fn%40googlegroups.com?utm_medium=email&utm_source=footer>
>>>>>> .
>>>>>>
>>>>> --
>>>> 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+...@googlegroups.com.
>>>> To view this discussion on the web visit
>>>> https://groups.google.com/d/msgid/jooq-user/c8c75719-7d93-4805-a56b-b0584a4c3fc0n%40googlegroups.com
>>>>
>>>> <https://groups.google.com/d/msgid/jooq-user/c8c75719-7d93-4805-a56b-b0584a4c3fc0n%40googlegroups.com?utm_medium=email&utm_source=footer>
>>>> .
>>>>
>>> --
>>> You received this message because you are subscribed to a topic in the
>>> Google Groups "jOOQ User Group" group.
>>> To unsubscribe from this topic, visit
>>> https://groups.google.com/d/topic/jooq-user/aYONYTFxc_0/unsubscribe.
>>> To unsubscribe from this group and all its topics, send an email to
>>> jooq-user+...@googlegroups.com.
>>> To view this discussion on the web visit
>>> https://groups.google.com/d/msgid/jooq-user/CAB4ELO6QS8uDZOKxwRb32X5Z9owObdVghVwp6o0CKV1nq3AokQ%40mail.gmail.com
>>>
>>> <https://groups.google.com/d/msgid/jooq-user/CAB4ELO6QS8uDZOKxwRb32X5Z9owObdVghVwp6o0CKV1nq3AokQ%40mail.gmail.com?utm_medium=email&utm_source=footer>
>>> .
>>>
>> --
>> 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+...@googlegroups.com.
>>
> To view this discussion on the web visit
>> https://groups.google.com/d/msgid/jooq-user/CAPDmEU4uauKekCtnJjU%2B%2BS-VHVUGtwFe%3DH_9hNa8Oq1tXRMR0w%40mail.gmail.com
>>
>> <https://groups.google.com/d/msgid/jooq-user/CAPDmEU4uauKekCtnJjU%2B%2BS-VHVUGtwFe%3DH_9hNa8Oq1tXRMR0w%40mail.gmail.com?utm_medium=email&utm_source=footer>
>> .
>>
>
--
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 this discussion on the web visit
https://groups.google.com/d/msgid/jooq-user/a06e6e84-837f-452d-a643-eb3afaba2cf5n%40googlegroups.com.
