Open j-nc opened 1 month ago
@ajay-abrol2 , @bilalahmed-3, @oualib , @sitingren , @vertica-cla : This issue is observed when using the latest vertica dialect jar with hibernate 6.x. Please look into this issue.
Hello,
Currently am working in a different project,Request @Ajay @.***> to take it further.
Thanks, Bilal Ahmed
From: armanjupriya-er @.>
Sent: 16 October 2024 20:31
To: vertica/hibernate-verticadialect @.>
Cc: Bilal.a @.>; Mention @.>
Subject: Re: [vertica/hibernate-verticadialect] Issue with Pageable
queries (Issue #3)
@ajay-abrol2https://github.com/ajay-abrol2 , @bilalahmed-3https://github.com/bilalahmed-3, @oualibhttps://github.com/oualib , @sitingrenhttps://github.com/sitingren , @vertica-clahttps://github.com/vertica-cla : This issue is observed when using the latest vertica dialect jar with hibernate 6.x. Please look into this issue.
— Reply to this email directly, view it on GitHubhttps://github.com/vertica/hibernate-verticadialect/issues/3#issuecomment-2417089719, or unsubscribehttps://github.com/notifications/unsubscribe-auth/BGD2NOOB2IRXR2G74KJSH4DZ3Z5V5AVCNFSM6AAAAABNW3MDB2VHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDIMJXGA4DSNZRHE. You are receiving this because you were mentioned.Message ID: @.***>
Disclaimer: The information transmitted is intended only for recipient(s) to whom it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you have received this in error, please contact the sender and then delete it. Disclaimer: The information transmitted is intended only for recipient(s) to whom it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you have received this in error, please contact the sender and then delete it.
Hello,
I will work on this issue and will update repository accordingly.
Thanks & Regards, Ajay Abrol
Hello,
I will work on this issue and will update repository accordingly.
Thanks & Regards, Ajay Abrol
Thanks @ajay-abrol2
As described at https://stackoverflow.com/questions/78949941, it's not possible to use
Pageable
queries in@Repository
methods because the standard query translation is wrong for Vertica specifically. It would be nice if you could provide an implementation that works for all (or at least relatively common) cases. The answer to the linked question provides a simple workaround forLIMIT
andOFFSET
commands, but this needs to be more thoroughly tested, and I'm not sure about the rest.