Fouad Almalki (
https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%...
) *created* an issue
Hibernate ORM (
https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiNDJhMzRiNjll...
) / Bug (
https://hibernate.atlassian.net/browse/HHH-15773?atlOrigin=eyJpIjoiNDJhMz...
) HHH-15773 (
https://hibernate.atlassian.net/browse/HHH-15773?atlOrigin=eyJpIjoiNDJhMz...
) MSSQL: java.util.Instant doesn't work anymore after upgrading to Hibernate 6 (
https://hibernate.atlassian.net/browse/HHH-15773?atlOrigin=eyJpIjoiNDJhMz...
)
Issue Type: Bug Affects Versions: 6.1.5 Assignee: Unassigned Created: 28/Nov/2022 01:19 AM
Environment: Spring Boot v3.0.0 | Java 19 Priority: Major Reporter: Fouad Almalki (
https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%...
)
When using java.time.Instant as field in an entity, I got the following exception:
com.microsoft.sqlserver.jdbc.SQLServerException: The conversion from
datetime2 to DATETIMEOFFSET is unsupported.
It was working before in Hibernate 5.
*Full stacktrace:*
at ommited
at
java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:104)
~[na:na]
at java.base/java.lang.reflect.Method.invoke(Method.java:578) ~[na:na]
at
org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethodWithGivenArgs(AbstractAspectJAdvice.java:633)
~[spring-aop-6.0.2.jar:6.0.2]
at
org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethod(AbstractAspectJAdvice.java:623)
~[spring-aop-6.0.2.jar:6.0.2]
at
org.springframework.aop.aspectj.AspectJAroundAdvice.invoke(AspectJAroundAdvice.java:71)
~[spring-aop-6.0.2.jar:6.0.2]
at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:173)
~[spring-aop-6.0.2.jar:6.0.2]
at
org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:97)
~[spring-aop-6.0.2.jar:6.0.2]
at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:184)
~[spring-aop-6.0.2.jar:6.0.2]
at
org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:218)
~[spring-aop-6.0.2.jar:6.0.2]
at
jdk.proxy2/jdk.proxy2.$Proxy241.queryFirstEntityByDeletedIsFalseAndIdAndTenantId(Unknown
Source) ~[na:na]
at ommited
at
java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:104)
~[na:na]
at java.base/java.lang.reflect.Method.invoke(Method.java:578) ~[na:na]
at
org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:343)
~[spring-aop-6.0.2.jar:6.0.2]
at
org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:196)
~[spring-aop-6.0.2.jar:6.0.2]
at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
~[spring-aop-6.0.2.jar:6.0.2]
at
org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:752)
~[spring-aop-6.0.2.jar:6.0.2]
at
org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:123)
~[spring-tx-6.0.2.jar:6.0.2]
at
org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:388)
~[spring-tx-6.0.2.jar:6.0.2]
at
org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:119)
~[spring-tx-6.0.2.jar:6.0.2]
at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:184)
~[spring-aop-6.0.2.jar:6.0.2]
at
org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:752)
~[spring-aop-6.0.2.jar:6.0.2]
at
org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:703)
~[spring-aop-6.0.2.jar:6.0.2]
at ommited
at ommited
at
java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:104)
~[na:na]
at java.base/java.lang.reflect.Method.invoke(Method.java:578) ~[na:na]
at
org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:343)
~[spring-aop-6.0.2.jar:6.0.2]
at
org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:196)
~[spring-aop-6.0.2.jar:6.0.2]
at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
~[spring-aop-6.0.2.jar:6.0.2]
at
org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:752)
~[spring-aop-6.0.2.jar:6.0.2]
at
org.springframework.validation.beanvalidation.MethodValidationInterceptor.invoke(MethodValidationInterceptor.java:134)
~[spring-context-6.0.2.jar:6.0.2]
at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:184)
~[spring-aop-6.0.2.jar:6.0.2]
at
org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:752)
~[spring-aop-6.0.2.jar:6.0.2]
at
org.springframework.security.authorization.method.AuthorizationManagerBeforeMethodInterceptor.invoke(AuthorizationManagerBeforeMethodInterceptor.java:199)
~[spring-security-core-6.0.0.jar:6.0.0]
at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:184)
~[spring-aop-6.0.2.jar:6.0.2]
at
org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:752)
~[spring-aop-6.0.2.jar:6.0.2]
at
org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:703)
~[spring-aop-6.0.2.jar:6.0.2]
at ommited
at
java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:104)
~[na:na]
at java.base/java.lang.reflect.Method.invoke(Method.java:578) ~[na:na]
at
org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:207)
~[spring-web-6.0.2.jar:6.0.2]
at
org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:152)
~[spring-web-6.0.2.jar:6.0.2]
at
org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:117)
~[spring-webmvc-6.0.2.jar:6.0.2]
at
org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:884)
~[spring-webmvc-6.0.2.jar:6.0.2]
at
org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:797)
~[spring-webmvc-6.0.2.jar:6.0.2]
at
org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87)
~[spring-webmvc-6.0.2.jar:6.0.2]
at
org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1080)
~[spring-webmvc-6.0.2.jar:6.0.2]
at
org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:973)
~[spring-webmvc-6.0.2.jar:6.0.2]
at
org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1003)
~[spring-webmvc-6.0.2.jar:6.0.2]
at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:877)
~[spring-webmvc-6.0.2.jar:6.0.2]
at jakarta.servlet.http.HttpServlet.service(HttpServlet.java:614)
~[jakarta.servlet-api-6.0.0.jar:6.0.0]
at io.undertow.servlet.handlers.ServletHandler.handleRequest(ServletHandler.java:74)
~[undertow-servlet-2.3.0.Final.jar:2.3.0.Final]
at
io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:129)
~[undertow-servlet-2.3.0.Final.jar:2.3.0.Final]
at
org.springframework.security.web.FilterChainProxy.lambda$doFilterInternal$3(FilterChainProxy.java:231)
~[spring-security-web-6.0.0.jar:6.0.0]
at
org.springframework.security.web.ObservationFilterChainDecorator$FilterObservation$SimpleFilterObservation.lambda$wrap$1(ObservationFilterChainDecorator.java:397)
~[spring-security-web-6.0.0.jar:6.0.0]
at
org.springframework.security.web.ObservationFilterChainDecorator$AroundFilterObservation$SimpleAroundFilterObservation.lambda$wrap$1(ObservationFilterChainDecorator.java:295)
~[spring-security-web-6.0.0.jar:6.0.0]
at
org.springframework.security.web.ObservationFilterChainDecorator.lambda$wrapSecured$0(ObservationFilterChainDecorator.java:79)
~[spring-security-web-6.0.0.jar:6.0.0]
at
org.springframework.security.web.ObservationFilterChainDecorator$VirtualFilterChain.doFilter(ObservationFilterChainDecorator.java:125)
~[spring-security-web-6.0.0.jar:6.0.0]
at
org.springframework.security.web.access.intercept.AuthorizationFilter.doFilter(AuthorizationFilter.java:100)
~[spring-security-web-6.0.0.jar:6.0.0]
at
org.springframework.security.web.ObservationFilterChainDecorator$ObservationFilter.wrapFilter(ObservationFilterChainDecorator.java:185)
~[spring-security-web-6.0.0.jar:6.0.0]
at
org.springframework.security.web.ObservationFilterChainDecorator$ObservationFilter.doFilter(ObservationFilterChainDecorator.java:173)
~[spring-security-web-6.0.0.jar:6.0.0]
at
org.springframework.security.web.ObservationFilterChainDecorator$VirtualFilterChain.doFilter(ObservationFilterChainDecorator.java:134)
~[spring-security-web-6.0.0.jar:6.0.0]
at
org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:126)
~[spring-security-web-6.0.0.jar:6.0.0]
at
org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:120)
~[spring-security-web-6.0.0.jar:6.0.0]
at
org.springframework.security.web.ObservationFilterChainDecorator$ObservationFilter.wrapFilter(ObservationFilterChainDecorator.java:185)
~[spring-security-web-6.0.0.jar:6.0.0]
at
org.springframework.security.web.ObservationFilterChainDecorator$ObservationFilter.doFilter(ObservationFilterChainDecorator.java:173)
~[spring-security-web-6.0.0.jar:6.0.0]
at
org.springframework.security.web.ObservationFilterChainDecorator$VirtualFilterChain.doFilter(ObservationFilterChainDecorator.java:134)
~[spring-security-web-6.0.0.jar:6.0.0]
at
org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:131)
~[spring-security-web-6.0.0.jar:6.0.0]
at
org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:85)
~[spring-security-web-6.0.0.jar:6.0.0]
at
org.springframework.security.web.ObservationFilterChainDecorator$ObservationFilter.wrapFilter(ObservationFilterChainDecorator.java:185)
~[spring-security-web-6.0.0.jar:6.0.0]
at
org.springframework.security.web.ObservationFilterChainDecorator$ObservationFilter.doFilter(ObservationFilterChainDecorator.java:173)
~[spring-security-web-6.0.0.jar:6.0.0]
at
org.springframework.security.web.ObservationFilterChainDecorator$VirtualFilterChain.doFilter(ObservationFilterChainDecorator.java:134)
~[spring-security-web-6.0.0.jar:6.0.0]
at
org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:100)
~[spring-security-web-6.0.0.jar:6.0.0]
at
org.springframework.security.web.ObservationFilterChainDecorator$ObservationFilter.wrapFilter(ObservationFilterChainDecorator.java:185)
~[spring-security-web-6.0.0.jar:6.0.0]
at
org.springframework.security.web.ObservationFilterChainDecorator$ObservationFilter.doFilter(ObservationFilterChainDecorator.java:173)
~[spring-security-web-6.0.0.jar:6.0.0]
at
org.springframework.security.web.ObservationFilterChainDecorator$VirtualFilterChain.doFilter(ObservationFilterChainDecorator.java:134)
~[spring-security-web-6.0.0.jar:6.0.0]
at
org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:179)
~[spring-security-web-6.0.0.jar:6.0.0]
at
org.springframework.security.web.ObservationFilterChainDecorator$ObservationFilter.wrapFilter(ObservationFilterChainDecorator.java:185)
~[spring-security-web-6.0.0.jar:6.0.0]
at
org.springframework.security.web.ObservationFilterChainDecorator$ObservationFilter.doFilter(ObservationFilterChainDecorator.java:173)
~[spring-security-web-6.0.0.jar:6.0.0]
at
org.springframework.security.web.ObservationFilterChainDecorator$VirtualFilterChain.doFilter(ObservationFilterChainDecorator.java:134)
~[spring-security-web-6.0.0.jar:6.0.0]
at
org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:63)
~[spring-security-web-6.0.0.jar:6.0.0]
at
org.springframework.security.web.ObservationFilterChainDecorator$ObservationFilter.wrapFilter(ObservationFilterChainDecorator.java:185)
~[spring-security-web-6.0.0.jar:6.0.0]
at
org.springframework.security.web.ObservationFilterChainDecorator$ObservationFilter.doFilter(ObservationFilterChainDecorator.java:173)
~[spring-security-web-6.0.0.jar:6.0.0]
at
org.springframework.security.web.ObservationFilterChainDecorator$VirtualFilterChain.doFilter(ObservationFilterChainDecorator.java:134)
~[spring-security-web-6.0.0.jar:6.0.0]
at
org.springframework.security.oauth2.server.resource.web.authentication.BearerTokenAuthenticationFilter.doFilterInternal(BearerTokenAuthenticationFilter.java:145)
~[spring-security-oauth2-resource-server-6.0.0.jar:6.0.0]
at
org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:116)
~[spring-web-6.0.2.jar:6.0.2]
at
org.springframework.security.web.ObservationFilterChainDecorator$ObservationFilter.wrapFilter(ObservationFilterChainDecorator.java:185)
~[spring-security-web-6.0.0.jar:6.0.0]
at
org.springframework.security.web.ObservationFilterChainDecorator$ObservationFilter.doFilter(ObservationFilterChainDecorator.java:173)
~[spring-security-web-6.0.0.jar:6.0.0]
at
org.springframework.security.web.ObservationFilterChainDecorator$VirtualFilterChain.doFilter(ObservationFilterChainDecorator.java:134)
~[spring-security-web-6.0.0.jar:6.0.0]
at org.springframework.web.filter.CorsFilter.doFilterInternal(CorsFilter.java:91)
~[spring-web-6.0.2.jar:6.0.2]
at
org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:116)
~[spring-web-6.0.2.jar:6.0.2]
at
org.springframework.security.web.ObservationFilterChainDecorator$ObservationFilter.wrapFilter(ObservationFilterChainDecorator.java:185)
~[spring-security-web-6.0.0.jar:6.0.0]
at
org.springframework.security.web.ObservationFilterChainDecorator$ObservationFilter.doFilter(ObservationFilterChainDecorator.java:173)
~[spring-security-web-6.0.0.jar:6.0.0]
at
org.springframework.security.web.ObservationFilterChainDecorator$VirtualFilterChain.doFilter(ObservationFilterChainDecorator.java:134)
~[spring-security-web-6.0.0.jar:6.0.0]
at
org.springframework.security.web.header.HeaderWriterFilter.doHeadersAfter(HeaderWriterFilter.java:90)
~[spring-security-web-6.0.0.jar:6.0.0]
at
org.springframework.security.web.header.HeaderWriterFilter.doFilterInternal(HeaderWriterFilter.java:75)
~[spring-security-web-6.0.0.jar:6.0.0]
at
org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:116)
~[spring-web-6.0.2.jar:6.0.2]
at
org.springframework.security.web.ObservationFilterChainDecorator$ObservationFilter.wrapFilter(ObservationFilterChainDecorator.java:185)
~[spring-security-web-6.0.0.jar:6.0.0]
at
org.springframework.security.web.ObservationFilterChainDecorator$ObservationFilter.doFilter(ObservationFilterChainDecorator.java:173)
~[spring-security-web-6.0.0.jar:6.0.0]
at
org.springframework.security.web.ObservationFilterChainDecorator$VirtualFilterChain.doFilter(ObservationFilterChainDecorator.java:134)
~[spring-security-web-6.0.0.jar:6.0.0]
at
org.springframework.security.web.context.SecurityContextHolderFilter.doFilterInternal(SecurityContextHolderFilter.java:69)
~[spring-security-web-6.0.0.jar:6.0.0]
at
org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:116)
~[spring-web-6.0.2.jar:6.0.2]
at
org.springframework.security.web.ObservationFilterChainDecorator$ObservationFilter.wrapFilter(ObservationFilterChainDecorator.java:185)
~[spring-security-web-6.0.0.jar:6.0.0]
at
org.springframework.security.web.ObservationFilterChainDecorator$ObservationFilter.doFilter(ObservationFilterChainDecorator.java:173)
~[spring-security-web-6.0.0.jar:6.0.0]
at
org.springframework.security.web.ObservationFilterChainDecorator$VirtualFilterChain.doFilter(ObservationFilterChainDecorator.java:134)
~[spring-security-web-6.0.0.jar:6.0.0]
at
org.springframework.security.web.context.request.async.WebAsyncManagerIntegrationFilter.doFilterInternal(WebAsyncManagerIntegrationFilter.java:62)
~[spring-security-web-6.0.0.jar:6.0.0]
at
org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:116)
~[spring-web-6.0.2.jar:6.0.2]
at
org.springframework.security.web.ObservationFilterChainDecorator$ObservationFilter.wrapFilter(ObservationFilterChainDecorator.java:185)
~[spring-security-web-6.0.0.jar:6.0.0]
at
org.springframework.security.web.ObservationFilterChainDecorator$ObservationFilter.doFilter(ObservationFilterChainDecorator.java:173)
~[spring-security-web-6.0.0.jar:6.0.0]
at
org.springframework.security.web.ObservationFilterChainDecorator$VirtualFilterChain.doFilter(ObservationFilterChainDecorator.java:134)
~[spring-security-web-6.0.0.jar:6.0.0]
at
org.springframework.security.web.session.DisableEncodeUrlFilter.doFilterInternal(DisableEncodeUrlFilter.java:42)
~[spring-security-web-6.0.0.jar:6.0.0]
at
org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:116)
~[spring-web-6.0.2.jar:6.0.2]
at
org.springframework.security.web.ObservationFilterChainDecorator$ObservationFilter.wrapFilter(ObservationFilterChainDecorator.java:185)
~[spring-security-web-6.0.0.jar:6.0.0]
at
org.springframework.security.web.ObservationFilterChainDecorator$AroundFilterObservation$SimpleAroundFilterObservation.lambda$wrap$0(ObservationFilterChainDecorator.java:278)
~[spring-security-web-6.0.0.jar:6.0.0]
at
org.springframework.security.web.ObservationFilterChainDecorator$ObservationFilter.doFilter(ObservationFilterChainDecorator.java:170)
~[spring-security-web-6.0.0.jar:6.0.0]
at
org.springframework.security.web.ObservationFilterChainDecorator$VirtualFilterChain.doFilter(ObservationFilterChainDecorator.java:134)
~[spring-security-web-6.0.0.jar:6.0.0]
at
org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:233)
~[spring-security-web-6.0.0.jar:6.0.0]
at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:191)
~[spring-security-web-6.0.0.jar:6.0.0]
at
org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:351)
~[spring-web-6.0.2.jar:6.0.2]
at
org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:267)
~[spring-web-6.0.2.jar:6.0.2]
at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:67)
~[undertow-servlet-2.3.0.Final.jar:2.3.0.Final]
at
io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
~[undertow-servlet-2.3.0.Final.jar:2.3.0.Final]
at
org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:100)
~[spring-web-6.0.2.jar:6.0.2]
at
org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:116)
~[spring-web-6.0.2.jar:6.0.2]
at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:67)
~[undertow-servlet-2.3.0.Final.jar:2.3.0.Final]
at
io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
~[undertow-servlet-2.3.0.Final.jar:2.3.0.Final]
at
org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:93)
~[spring-web-6.0.2.jar:6.0.2]
at
org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:116)
~[spring-web-6.0.2.jar:6.0.2]
at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:67)
~[undertow-servlet-2.3.0.Final.jar:2.3.0.Final]
at
io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
~[undertow-servlet-2.3.0.Final.jar:2.3.0.Final]
at
org.springframework.web.filter.ServerHttpObservationFilter.doFilterInternal(ServerHttpObservationFilter.java:109)
~[spring-web-6.0.2.jar:6.0.2]
at
org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:116)
~[spring-web-6.0.2.jar:6.0.2]
at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:67)
~[undertow-servlet-2.3.0.Final.jar:2.3.0.Final]
at
io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
~[undertow-servlet-2.3.0.Final.jar:2.3.0.Final]
at
org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:201)
~[spring-web-6.0.2.jar:6.0.2]
at
org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:116)
~[spring-web-6.0.2.jar:6.0.2]
at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:67)
~[undertow-servlet-2.3.0.Final.jar:2.3.0.Final]
at
io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
~[undertow-servlet-2.3.0.Final.jar:2.3.0.Final]
at ommited
at
org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:116)
~[spring-web-6.0.2.jar:6.0.2]
at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:67)
~[undertow-servlet-2.3.0.Final.jar:2.3.0.Final]
at
io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
~[undertow-servlet-2.3.0.Final.jar:2.3.0.Final]
at io.undertow.servlet.handlers.FilterHandler.handleRequest(FilterHandler.java:84)
~[undertow-servlet-2.3.0.Final.jar:2.3.0.Final]
at
io.undertow.servlet.handlers.security.ServletSecurityRoleHandler.handleRequest(ServletSecurityRoleHandler.java:62)
~[undertow-servlet-2.3.0.Final.jar:2.3.0.Final]
at io.undertow.servlet.handlers.ServletChain$1.handleRequest(ServletChain.java:68)
~[undertow-servlet-2.3.0.Final.jar:2.3.0.Final]
at
io.undertow.servlet.handlers.ServletDispatchingHandler.handleRequest(ServletDispatchingHandler.java:36)
~[undertow-servlet-2.3.0.Final.jar:2.3.0.Final]
at
io.undertow.servlet.handlers.RedirectDirHandler.handleRequest(RedirectDirHandler.java:68)
~[undertow-servlet-2.3.0.Final.jar:2.3.0.Final]
at
io.undertow.servlet.handlers.security.SSLInformationAssociationHandler.handleRequest(SSLInformationAssociationHandler.java:117)
~[undertow-servlet-2.3.0.Final.jar:2.3.0.Final]
at
io.undertow.servlet.handlers.security.ServletAuthenticationCallHandler.handleRequest(ServletAuthenticationCallHandler.java:57)
~[undertow-servlet-2.3.0.Final.jar:2.3.0.Final]
at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
~[undertow-core-2.3.0.Final.jar:2.3.0.Final]
at
io.undertow.security.handlers.AbstractConfidentialityHandler.handleRequest(AbstractConfidentialityHandler.java:46)
~[undertow-core-2.3.0.Final.jar:2.3.0.Final]
at
io.undertow.servlet.handlers.security.ServletConfidentialityConstraintHandler.handleRequest(ServletConfidentialityConstraintHandler.java:64)
~[undertow-servlet-2.3.0.Final.jar:2.3.0.Final]
at
io.undertow.security.handlers.AuthenticationMechanismsHandler.handleRequest(AuthenticationMechanismsHandler.java:60)
~[undertow-core-2.3.0.Final.jar:2.3.0.Final]
at
io.undertow.servlet.handlers.security.CachedAuthenticatedSessionHandler.handleRequest(CachedAuthenticatedSessionHandler.java:77)
~[undertow-servlet-2.3.0.Final.jar:2.3.0.Final]
at
io.undertow.security.handlers.AbstractSecurityContextAssociationHandler.handleRequest(AbstractSecurityContextAssociationHandler.java:43)
~[undertow-core-2.3.0.Final.jar:2.3.0.Final]
at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
~[undertow-core-2.3.0.Final.jar:2.3.0.Final]
at
io.undertow.servlet.handlers.SendErrorPageHandler.handleRequest(SendErrorPageHandler.java:52)
~[undertow-servlet-2.3.0.Final.jar:2.3.0.Final]
at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
~[undertow-core-2.3.0.Final.jar:2.3.0.Final]
at
io.undertow.servlet.handlers.ServletInitialHandler.handleFirstRequest(ServletInitialHandler.java:275)
~[undertow-servlet-2.3.0.Final.jar:2.3.0.Final]
at
io.undertow.servlet.handlers.ServletInitialHandler$2.call(ServletInitialHandler.java:134)
~[undertow-servlet-2.3.0.Final.jar:2.3.0.Final]
at
io.undertow.servlet.handlers.ServletInitialHandler$2.call(ServletInitialHandler.java:131)
~[undertow-servlet-2.3.0.Final.jar:2.3.0.Final]
at
io.undertow.servlet.core.ServletRequestContextThreadSetupAction$1.call(ServletRequestContextThreadSetupAction.java:48)
~[undertow-servlet-2.3.0.Final.jar:2.3.0.Final]
at
io.undertow.servlet.core.ContextClassLoaderSetupAction$1.call(ContextClassLoaderSetupAction.java:43)
~[undertow-servlet-2.3.0.Final.jar:2.3.0.Final]
at
io.undertow.servlet.handlers.ServletInitialHandler.dispatchRequest(ServletInitialHandler.java:255)
~[undertow-servlet-2.3.0.Final.jar:2.3.0.Final]
at
io.undertow.servlet.handlers.ServletInitialHandler$1.handleRequest(ServletInitialHandler.java:100)
~[undertow-servlet-2.3.0.Final.jar:2.3.0.Final]
at io.undertow.server.Connectors.executeRootHandler(Connectors.java:391)
~[undertow-core-2.3.0.Final.jar:2.3.0.Final]
at io.undertow.server.HttpServerExchange$1.run(HttpServerExchange.java:859)
~[undertow-core-2.3.0.Final.jar:2.3.0.Final]
at org.jboss.threads.ContextHandler$1.runWith(ContextHandler.java:18)
~[jboss-threads-3.5.0.Final.jar:3.5.0.Final]
at org.jboss.threads.EnhancedQueueExecutor$Task.run(EnhancedQueueExecutor.java:2513)
~[jboss-threads-3.5.0.Final.jar:3.5.0.Final]
at
org.jboss.threads.EnhancedQueueExecutor$ThreadBody.run(EnhancedQueueExecutor.java:1512)
~[jboss-threads-3.5.0.Final.jar:3.5.0.Final]
at org.xnio.XnioWorker$WorkerThreadFactory$1$1.run(XnioWorker.java:1282)
~[xnio-api-3.8.8.Final.jar:3.8.8.Final]
at java.base/java.lang.Thread.run(Thread.java:1589) ~[na:na]
Caused by: org.springframework.orm.jpa.JpaSystemException: Unable to extract JDBC value
for position `6`
at
org.springframework.orm.jpa.vendor.HibernateJpaDialect.convertHibernateAccessException(HibernateJpaDialect.java:321)
~[spring-orm-6.0.2.jar:6.0.2]
at
org.springframework.orm.jpa.vendor.HibernateJpaDialect.translateExceptionIfPossible(HibernateJpaDialect.java:233)
~[spring-orm-6.0.2.jar:6.0.2]
at
org.springframework.orm.jpa.AbstractEntityManagerFactoryBean.translateExceptionIfPossible(AbstractEntityManagerFactoryBean.java:550)
~[spring-orm-6.0.2.jar:6.0.2]
at
org.springframework.dao.support.ChainedPersistenceExceptionTranslator.translateExceptionIfPossible(ChainedPersistenceExceptionTranslator.java:61)
~[spring-tx-6.0.2.jar:6.0.2]
at
org.springframework.dao.support.DataAccessUtils.translateIfNecessary(DataAccessUtils.java:242)
~[spring-tx-6.0.2.jar:6.0.2]
at
org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:152)
~[spring-tx-6.0.2.jar:6.0.2]
at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:184)
~[spring-aop-6.0.2.jar:6.0.2]
at
org.springframework.data.jpa.repository.support.CrudMethodMetadataPostProcessor$CrudMethodMetadataPopulatingMethodInterceptor.invoke(CrudMethodMetadataPostProcessor.java:134)
~[spring-data-jpa-3.0.0.jar:3.0.0]
at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:184)
~[spring-aop-6.0.2.jar:6.0.2]
at
org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:97)
~[spring-aop-6.0.2.jar:6.0.2]
at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:184)
~[spring-aop-6.0.2.jar:6.0.2]
at
org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:218)
~[spring-aop-6.0.2.jar:6.0.2]
at
jdk.proxy2/jdk.proxy2.$Proxy241.queryFirstEntityByDeletedIsFalseAndIdAndTenantId(Unknown
Source) ~[na:na]
at
java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:104)
~[na:na]
at java.base/java.lang.reflect.Method.invoke(Method.java:578) ~[na:na]
at
org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:343)
~[spring-aop-6.0.2.jar:6.0.2]
at
org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:196)
~[spring-aop-6.0.2.jar:6.0.2]
at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
~[spring-aop-6.0.2.jar:6.0.2]
at
org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:137)
~[spring-tx-6.0.2.jar:6.0.2]
at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:184)
~[spring-aop-6.0.2.jar:6.0.2]
at
org.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint.proceed(MethodInvocationProceedingJoinPoint.java:89)
~[spring-aop-6.0.2.jar:6.0.2]
at ommited
... 173 common frames omitted
Caused by: org.hibernate.HibernateException: Unable to extract JDBC value for position
`6`
at
org.hibernate.sql.results.jdbc.internal.JdbcValuesResultSetImpl.readCurrentRowValues(JdbcValuesResultSetImpl.java:306)
~[hibernate-core-6.1.5.Final.jar:6.1.5.Final]
at
org.hibernate.sql.results.jdbc.internal.JdbcValuesResultSetImpl.advance(JdbcValuesResultSetImpl.java:279)
~[hibernate-core-6.1.5.Final.jar:6.1.5.Final]
at
org.hibernate.sql.results.jdbc.internal.JdbcValuesResultSetImpl.processNext(JdbcValuesResultSetImpl.java:85)
~[hibernate-core-6.1.5.Final.jar:6.1.5.Final]
at
org.hibernate.sql.results.jdbc.internal.AbstractJdbcValues.next(AbstractJdbcValues.java:29)
~[hibernate-core-6.1.5.Final.jar:6.1.5.Final]
at
org.hibernate.sql.results.internal.RowProcessingStateStandardImpl.next(RowProcessingStateStandardImpl.java:89)
~[hibernate-core-6.1.5.Final.jar:6.1.5.Final]
at
org.hibernate.sql.results.spi.ListResultsConsumer.consume(ListResultsConsumer.java:142)
~[hibernate-core-6.1.5.Final.jar:6.1.5.Final]
at org.hibernate.sql.results.spi.ListResultsConsumer.consume(ListResultsConsumer.java:32)
~[hibernate-core-6.1.5.Final.jar:6.1.5.Final]
at
org.hibernate.sql.exec.internal.JdbcSelectExecutorStandardImpl.doExecuteQuery(JdbcSelectExecutorStandardImpl.java:443)
~[hibernate-core-6.1.5.Final.jar:6.1.5.Final]
at
org.hibernate.sql.exec.internal.JdbcSelectExecutorStandardImpl.executeQuery(JdbcSelectExecutorStandardImpl.java:166)
~[hibernate-core-6.1.5.Final.jar:6.1.5.Final]
at
org.hibernate.sql.exec.internal.JdbcSelectExecutorStandardImpl.list(JdbcSelectExecutorStandardImpl.java:91)
~[hibernate-core-6.1.5.Final.jar:6.1.5.Final]
at org.hibernate.sql.exec.spi.JdbcSelectExecutor.list(JdbcSelectExecutor.java:31)
~[hibernate-core-6.1.5.Final.jar:6.1.5.Final]
at
org.hibernate.query.sqm.internal.ConcreteSqmSelectQueryPlan.lambda$new$0(ConcreteSqmSelectQueryPlan.java:102)
~[hibernate-core-6.1.5.Final.jar:6.1.5.Final]
at
org.hibernate.query.sqm.internal.ConcreteSqmSelectQueryPlan.withCacheableSqmInterpretation(ConcreteSqmSelectQueryPlan.java:305)
~[hibernate-core-6.1.5.Final.jar:6.1.5.Final]
at
org.hibernate.query.sqm.internal.ConcreteSqmSelectQueryPlan.performList(ConcreteSqmSelectQueryPlan.java:246)
~[hibernate-core-6.1.5.Final.jar:6.1.5.Final]
at org.hibernate.query.sqm.internal.QuerySqmImpl.doList(QuerySqmImpl.java:546)
~[hibernate-core-6.1.5.Final.jar:6.1.5.Final]
at org.hibernate.query.spi.AbstractSelectionQuery.list(AbstractSelectionQuery.java:363)
~[hibernate-core-6.1.5.Final.jar:6.1.5.Final]
at org.hibernate.query.sqm.internal.QuerySqmImpl.list(QuerySqmImpl.java:1032)
~[hibernate-core-6.1.5.Final.jar:6.1.5.Final]
at
org.hibernate.query.spi.AbstractSelectionQuery.getSingleResult(AbstractSelectionQuery.java:457)
~[hibernate-core-6.1.5.Final.jar:6.1.5.Final]
at org.hibernate.query.sqm.internal.QuerySqmImpl.getSingleResult(QuerySqmImpl.java:1062)
~[hibernate-core-6.1.5.Final.jar:6.1.5.Final]
at
org.springframework.data.jpa.repository.query.JpaQueryExecution$SingleEntityExecution.doExecute(JpaQueryExecution.java:193)
~[spring-data-jpa-3.0.0.jar:3.0.0]
at
org.springframework.data.jpa.repository.query.JpaQueryExecution.execute(JpaQueryExecution.java:90)
~[spring-data-jpa-3.0.0.jar:3.0.0]
at
org.springframework.data.jpa.repository.query.AbstractJpaQuery.doExecute(AbstractJpaQuery.java:148)
~[spring-data-jpa-3.0.0.jar:3.0.0]
at
org.springframework.data.jpa.repository.query.AbstractJpaQuery.execute(AbstractJpaQuery.java:136)
~[spring-data-jpa-3.0.0.jar:3.0.0]
at
org.springframework.data.repository.core.support.RepositoryMethodInvoker.doInvoke(RepositoryMethodInvoker.java:136)
~[spring-data-commons-3.0.0.jar:3.0.0]
at
org.springframework.data.repository.core.support.RepositoryMethodInvoker.invoke(RepositoryMethodInvoker.java:120)
~[spring-data-commons-3.0.0.jar:3.0.0]
at
org.springframework.data.repository.core.support.QueryExecutorMethodInterceptor.doInvoke(QueryExecutorMethodInterceptor.java:164)
~[spring-data-commons-3.0.0.jar:3.0.0]
at
org.springframework.data.repository.core.support.QueryExecutorMethodInterceptor.invoke(QueryExecutorMethodInterceptor.java:143)
~[spring-data-commons-3.0.0.jar:3.0.0]
at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:184)
~[spring-aop-6.0.2.jar:6.0.2]
at
org.springframework.data.projection.DefaultMethodInvokingMethodInterceptor.invoke(DefaultMethodInvokingMethodInterceptor.java:77)
~[spring-data-commons-3.0.0.jar:3.0.0]
at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:184)
~[spring-aop-6.0.2.jar:6.0.2]
at
org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:123)
~[spring-tx-6.0.2.jar:6.0.2]
at
org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:388)
~[spring-tx-6.0.2.jar:6.0.2]
at
org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:119)
~[spring-tx-6.0.2.jar:6.0.2]
at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:184)
~[spring-aop-6.0.2.jar:6.0.2]
at
org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:137)
~[spring-tx-6.0.2.jar:6.0.2]
... 189 common frames omitted
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: The conversion from datetime2
to DATETIMEOFFSET is unsupported.
at
com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(SQLServerException.java:237)
~[mssql-jdbc-11.2.1.jre17.jar:na]
at com.microsoft.sqlserver.jdbc.DataTypes.throwConversionError(DataTypes.java:1112)
~[mssql-jdbc-11.2.1.jre17.jar:na]
at com.microsoft.sqlserver.jdbc.ServerDTVImpl.getValue(dtv.java:3706)
~[mssql-jdbc-11.2.1.jre17.jar:na]
at com.microsoft.sqlserver.jdbc.DTV.getValue(dtv.java:247)
~[mssql-jdbc-11.2.1.jre17.jar:na]
at com.microsoft.sqlserver.jdbc.Column.getValue(Column.java:190)
~[mssql-jdbc-11.2.1.jre17.jar:na]
at com.microsoft.sqlserver.jdbc.SQLServerResultSet.getValue(SQLServerResultSet.java:2073)
~[mssql-jdbc-11.2.1.jre17.jar:na]
at com.microsoft.sqlserver.jdbc.SQLServerResultSet.getValue(SQLServerResultSet.java:2059)
~[mssql-jdbc-11.2.1.jre17.jar:na]
at
com.microsoft.sqlserver.jdbc.SQLServerResultSet.getDateTimeOffset(SQLServerResultSet.java:2758)
~[mssql-jdbc-11.2.1.jre17.jar:na]
at
com.microsoft.sqlserver.jdbc.SQLServerResultSet.getObject(SQLServerResultSet.java:2441)
~[mssql-jdbc-11.2.1.jre17.jar:na]
at com.zaxxer.hikari.pool.HikariProxyResultSet.getObject(HikariProxyResultSet.java)
~[HikariCP-5.0.1.jar:na]
at
org.hibernate.type.descriptor.jdbc.InstantAsTimestampWithTimeZoneJdbcType$2.doExtract(InstantAsTimestampWithTimeZoneJdbcType.java:110)
~[hibernate-core-6.1.5.Final.jar:6.1.5.Final]
at org.hibernate.type.descriptor.jdbc.BasicExtractor.extract(BasicExtractor.java:44)
~[hibernate-core-6.1.5.Final.jar:6.1.5.Final]
at
org.hibernate.sql.results.jdbc.internal.JdbcValuesResultSetImpl.readCurrentRowValues(JdbcValuesResultSetImpl.java:298)
~[hibernate-core-6.1.5.Final.jar:6.1.5.Final]
... 223 common frames omitted
*Workaround:*
spring.jpa.properties.hibernate.type.preferred_instant_jdbc_type=TIMESTAMP
(
https://hibernate.atlassian.net/browse/HHH-15773#add-comment?atlOrigin=ey...
) Add Comment (
https://hibernate.atlassian.net/browse/HHH-15773#add-comment?atlOrigin=ey...
)
Get Jira notifications on your phone! Download the Jira Cloud app for Android (
https://play.google.com/store/apps/details?id=com.atlassian.android.jira....
) or iOS (
https://itunes.apple.com/app/apple-store/id1006972087?pt=696495&ct=Em...
) This message was sent by Atlassian Jira (v1001.0.0-SNAPSHOT#100210- sha1:4037f92 )