Hi,
I am facing the same issue as well. How do we set the mode.limit as true
with application yaml. This is my configuration currently in spring boot
application yaml under test/resources. Not sure where to set the mode limit
as true. Please help !!
application:
datasource:
database: H2
url: jdbc:h2:mem:testdb:envers;Mode=Oracle;
userName: sa
password:
showSql: true
driverClassName: org.h2.Driver
jpaDialect: org.hibernate.dialect.H2Dialect
generateDDL: true
connectionPoolSize: 10
Like mentioned same as above in the thread, the query is generated by
Hibernate having no control on how the limiting clause is implemented cause
of pageable. Need a work around to resolve this.
Thanks in advance.
Vinay
On Sunday, March 20, 2022 at 4:16:18 AM UTC-4 [email protected] wrote:
> Hi,
> Im struggling with same issue but could not set the mode.limit.
> Can somewhere be shared some piece of code?
> Thank you
>
> On Thursday, January 13, 2022 at 9:11:14 PM UTC+1 [email protected]
> wrote:
>
>> OK, thanks. I succeeded by putting the code in the datasource
>> configuration as explained in
>> https://www.baeldung.com/spring-testing-separate-data-source#using-spring-profiles
>> .
>>
>> Thansk again Evgenij!
>>
>> Le jeudi 13 janvier 2022 à 14 h 34 min 01 s UTC-5, Pierre Caron a écrit :
>>
>>> Thanks a lot Evgenij for the tip.
>>>
>>> However, sorry for not understanding. I tried those two lines :
>>>
>>>
>>> - in my application-test.properties
>>> - concetenated at the end of the url
>>>
>>>
>>> and neither one did work.
>>>
>>> What am I missing?
>>>
>>> Thanks.
>>>
>>>
>>>
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/h2-database/c706822a-128b-4084-9598-f781cd52320dn%40googlegroups.com.
