[hibernate-issues] [JIRA] (HHH-16017) JPA with Geometry column won't persist for MySql

dt pham ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=5e14f16... ) *created* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiN2UxNDFjOWUz... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-16017?atlOrigin=eyJpIjoiN2UxND... ) HHH-16017 ( https://hibernate.atlassian.net/browse/HHH-16017?atlOrigin=eyJpIjoiN2UxND... ) JPA with Geometry column won't persist for MySql ( https://hibernate.atlassian.net/browse/HHH-16017?atlOrigin=eyJpIjoiN2UxND... ) Issue Type: Bug Affects Versions: 6.1.5 Assignee: Unassigned Components: hibernate-core, hibernate-spatial Created: 10/Jan/2023 13:51 PM Environment: When migrating wildfly 24 (hibernate 5.3.20 and jdk 13) to wildfly 27 (hibernate 6.1.5 and jdk 17). Test on MySql 8.0.31. The application on wildffly 24 is working fine, but on wildfly 27 it won't persists the JPA object unless the geometry data is NULL. Stack trace: DEBUG [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (default task-7) could not execute statement [n/a]: com.mysql.cj.jdbc.exceptions.MysqlDataTruncation: Data truncation: Cannot get geometry object from data you send to the GEOMETRY field at com.networks.database.mysql(a)8.0.19 ( com.networks.database.mysql(a)8.0.19 ) //com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:104) at com.networks.database.mysql(a)8.0.19 ( com.networks.database.mysql(a)8.0.19 ) //com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:953) at com.networks.database.mysql(a)8.0.19 ( com.networks.database.mysql(a)8.0.19 ) //com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdateInternal(ClientPreparedStatement.java:1092) at com.networks.database.mysql(a)8.0.19 ( com.networks.database.mysql(a)8.0.19 ) //com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdateInternal(ClientPreparedStatement.java:1040) at com.networks.database.mysql(a)8.0.19 ( com.networks.database.mysql(a)8.0.19 ) //com.mysql.cj.jdbc.ClientPreparedStatement.executeLargeUpdate(ClientPreparedStatement.java:1347) at com.networks.database.mysql(a)8.0.19 ( com.networks.database.mysql(a)8.0.19 ) //com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdate(ClientPreparedStatement.java:1025) at org.jboss.ironjacamar.jdbcadapters(a)1.5.9.Final ( org.jboss.ironjacamar.jdbcadapters(a)1.5.9.Final ) //org.jboss.jca.adapters.jdbc.WrappedPreparedStatement.executeUpdate(WrappedPreparedStatement.java:537) at org.hibernate(a)6.1.5.Final ( org.hibernate(a)6.1.5.Final ) //org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:197) at org.hibernate(a)6.1.5.Final ( org.hibernate(a)6.1.5.Final ) //org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:3587) at org.hibernate(a)6.1.5.Final ( org.hibernate(a)6.1.5.Final ) //org.hibernate.persister.entity.AbstractEntityPersister.updateOrInsert(AbstractEntityPersister.java:3449) at org.hibernate(a)6.1.5.Final ( org.hibernate(a)6.1.5.Final ) //org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:3864) at org.hibernate(a)6.1.5.Final ( org.hibernate(a)6.1.5.Final ) //org.hibernate.action.internal.EntityUpdateAction.execute(EntityUpdateAction.java:164) at org.hibernate(a)6.1.5.Final ( org.hibernate(a)6.1.5.Final ) //org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:612) at org.hibernate(a)6.1.5.Final ( org.hibernate(a)6.1.5.Final ) //org.hibernate.engine.spi.ActionQueue.lambda$executeActions$1(ActionQueue.java:483) at java.base/java.util.LinkedHashMap.forEach(LinkedHashMap.java:721) at org.hibernate(a)6.1.5.Final ( org.hibernate(a)6.1.5.Final ) //org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:480) at org.hibernate(a)6.1.5.Final ( org.hibernate(a)6.1.5.Final ) //org.hibernate.event.internal.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:329) at org.hibernate(a)6.1.5.Final ( org.hibernate(a)6.1.5.Final ) //org.hibernate.event.internal.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:39) at org.hibernate(a)6.1.5.Final ( org.hibernate(a)6.1.5.Final ) //org.hibernate.event.service.internal.EventListenerGroupImpl.fireEventOnEachListener(EventListenerGroupImpl.java:107) at org.hibernate(a)6.1.5.Final ( org.hibernate(a)6.1.5.Final ) //org.hibernate.internal.SessionImpl.doFlush(SessionImpl.java:1422) at org.hibernate(a)6.1.5.Final ( org.hibernate(a)6.1.5.Final ) //org.hibernate.internal.SessionImpl.flush(SessionImpl.java:1408) at org.jboss.as.jpa(a)27.0.1.Final ( org.jboss.as.jpa(a)27.0.1.Final ) //org.jboss.as.jpa.container.AbstractEntityManager.flush(AbstractEntityManager.java:462) at deployment.atms.ear.event-ejb.jar//com.networks.events.ManagerSSB.update(ManagerSSB.java:264) at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77) at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.base/java.lang.reflect.Method.invoke(Method.java:568) at org.jboss.as.ee(a)27.0.1.Final ( org.jboss.as.ee(a)27.0.1.Final ) //org.jboss.as.ee.component.ManagedReferenceMethodInterceptor.processInvocation(ManagedReferenceMethodInterceptor.java:52) at org.jboss.invocation(a)1.7.0.Final ( org.jboss.invocation(a)1.7.0.Final ) //org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:422) at org.jboss.invocation(a)1.7.0.Final ( org.jboss.invocation(a)1.7.0.Final ) //org.jboss.invocation.InterceptorContext$Invocation.proceed(InterceptorContext.java:509) at org.jboss.as.weld.common(a)27.0.1.Final ( org.jboss.as.weld.common(a)27.0.1.Final ) //org.jboss.as.weld.interceptors.Jsr299BindingsInterceptor.delegateInterception(Jsr299BindingsInterceptor.java:79) at org.jboss.as.weld.common(a)27.0.1.Final ( org.jboss.as.weld.common(a)27.0.1.Final ) //org.jboss.as.weld.interceptors.Jsr299BindingsInterceptor.doMethodInterception(Jsr299BindingsInterceptor.java:89) at org.jboss.as.weld.common(a)27.0.1.Final ( org.jboss.as.weld.common(a)27.0.1.Final ) //org.jboss.as.weld.interceptors.Jsr299BindingsInterceptor.processInvocation(Jsr299BindingsInterceptor.java:102) at org.jboss.as.ee(a)27.0.1.Final ( org.jboss.as.ee(a)27.0.1.Final ) //org.jboss.as.ee.component.interceptors.UserInterceptorFactory$1.processInvocation(UserInterceptorFactory.java:63) at org.jboss.invocation(a)1.7.0.Final ( org.jboss.invocation(a)1.7.0.Final ) //org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:422) at org.jboss.as.ejb3(a)27.0.1.Final ( org.jboss.as.ejb3(a)27.0.1.Final ) //org.jboss.as.ejb3.component.invocationmetrics.ExecutionTimeInterceptor.processInvocation(ExecutionTimeInterceptor.java:43) at org.jboss.invocation(a)1.7.0.Final ( org.jboss.invocation(a)1.7.0.Final ) //org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:422) at org.jboss.as.jpa(a)27.0.1.Final ( org.jboss.as.jpa(a)27.0.1.Final ) //org.jboss.as.jpa.interceptor.SBInvocationInterceptor.processInvocation(SBInvocationInterceptor.java:47) at org.jboss.invocation(a)1.7.0.Final ( org.jboss.invocation(a)1.7.0.Final ) //org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:422) at org.jboss.as.ee(a)27.0.1.Final ( org.jboss.as.ee(a)27.0.1.Final ) //org.jboss.as.ee.concurrent.ConcurrentContextInterceptor.processInvocation(ConcurrentContextInterceptor.java:45) at org.jboss.invocation(a)1.7.0.Final ( org.jboss.invocation(a)1.7.0.Final ) //org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:422) at org.jboss.invocation(a)1.7.0.Final ( org.jboss.invocation(a)1.7.0.Final ) //org.jboss.invocation.InitialInterceptor.processInvocation(InitialInterceptor.java:40) at org.jboss.invocation(a)1.7.0.Final ( org.jboss.invocation(a)1.7.0.Final ) //org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:422) at org.jboss.invocation(a)1.7.0.Final ( org.jboss.invocation(a)1.7.0.Final ) //org.jboss.invocation.ChainedInterceptor.processInvocation(ChainedInterceptor.java:53) at org.jboss.as.ee(a)27.0.1.Final ( org.jboss.as.ee(a)27.0.1.Final ) //org.jboss.as.ee.component.interceptors.ComponentDispatcherInterceptor.processInvocation(ComponentDispatcherInterceptor.java:52) at org.jboss.invocation(a)1.7.0.Final ( org.jboss.invocation(a)1.7.0.Final ) //org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:422) at org.jboss.as.ejb3(a)27.0.1.Final ( org.jboss.as.ejb3(a)27.0.1.Final ) //org.jboss.as.ejb3.component.pool.PooledInstanceInterceptor.processInvocation(PooledInstanceInterceptor.java:51) at org.jboss.invocation(a)1.7.0.Final ( org.jboss.invocation(a)1.7.0.Final ) //org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:422) at org.jboss.as.ejb3(a)27.0.1.Final ( org.jboss.as.ejb3(a)27.0.1.Final ) //org.jboss.as.ejb3.component.interceptors.AdditionalSetupInterceptor.processInvocation(AdditionalSetupInterceptor.java:56) at org.jboss.invocation(a)1.7.0.Final ( org.jboss.invocation(a)1.7.0.Final ) //org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:422) at org.jboss.as.ejb3(a)27.0.1.Final ( org.jboss.as.ejb3(a)27.0.1.Final ) //org.jboss.as.ejb3.tx.CMTTxInterceptor.invokeInOurTx(CMTTxInterceptor.java:254) at org.jboss.as.ejb3(a)27.0.1.Final ( org.jboss.as.ejb3(a)27.0.1.Final ) //org.jboss.as.ejb3.tx.CMTTxInterceptor.requiresNew(CMTTxInterceptor.java:416) at org.jboss.as.ejb3(a)27.0.1.Final ( org.jboss.as.ejb3(a)27.0.1.Final ) //org.jboss.as.ejb3.tx.CMTTxInterceptor.processInvocation(CMTTxInterceptor.java:162) at org.jboss.invocation(a)1.7.0.Final ( org.jboss.invocation(a)1.7.0.Final ) //org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:422) at org.jboss.invocation(a)1.7.0.Final ( org.jboss.invocation(a)1.7.0.Final ) //org.jboss.invocation.InterceptorContext$Invocation.proceed(InterceptorContext.java:509) at org.jboss.weld.core(a)5.1.0.Final ( org.jboss.weld.core(a)5.1.0.Final ) //org.jboss.weld.module.ejb.AbstractEJBRequestScopeActivationInterceptor.aroundInvoke(AbstractEJBRequestScopeActivationInterceptor.java:81) at org.jboss.as.weld.common(a)27.0.1.Final ( org.jboss.as.weld.common(a)27.0.1.Final ) //org.jboss.as.weld.ejb.EjbRequestScopeActivationInterceptor.processInvocation(EjbRequestScopeActivationInterceptor.java:89) at org.jboss.invocation(a)1.7.0.Final ( org.jboss.invocation(a)1.7.0.Final ) //org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:422) at org.jboss.as.ejb3(a)27.0.1.Final ( org.jboss.as.ejb3(a)27.0.1.Final ) //org.jboss.as.ejb3.component.interceptors.CurrentInvocationContextInterceptor.processInvocation(CurrentInvocationContextInterceptor.java:41) at org.jboss.invocation(a)1.7.0.Final ( org.jboss.invocation(a)1.7.0.Final ) //org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:422) at org.jboss.as.ejb3(a)27.0.1.Final ( org.jboss.as.ejb3(a)27.0.1.Final ) //org.jboss.as.ejb3.component.invocationmetrics.WaitTimeInterceptor.processInvocation(WaitTimeInterceptor.java:47) at org.jboss.invocation(a)1.7.0.Final ( org.jboss.invocation(a)1.7.0.Final ) //org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:422) at org.jboss.as.ejb3(a)27.0.1.Final ( org.jboss.as.ejb3(a)27.0.1.Final ) //org.jboss.as.ejb3.security.IdentityOutflowInterceptor.processInvocation(IdentityOutflowInterceptor.java:73) at org.jboss.invocation(a)1.7.0.Final ( org.jboss.invocation(a)1.7.0.Final ) //org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:422) at org.jboss.as.ejb3(a)27.0.1.Final ( org.jboss.as.ejb3(a)27.0.1.Final ) //org.jboss.as.ejb3.security.RolesAllowedInterceptor.processInvocation(RolesAllowedInterceptor.java:63) at org.jboss.invocation(a)1.7.0.Final ( org.jboss.invocation(a)1.7.0.Final ) //org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:422) at org.jboss.as.ejb3(a)27.0.1.Final ( org.jboss.as.ejb3(a)27.0.1.Final ) //org.jboss.as.ejb3.security.SecurityDomainInterceptor.processInvocation(SecurityDomainInterceptor.java:44) at org.jboss.invocation(a)1.7.0.Final ( org.jboss.invocation(a)1.7.0.Final ) //org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:422) at org.jboss.as.ejb3(a)27.0.1.Final ( org.jboss.as.ejb3(a)27.0.1.Final ) //org.jboss.as.ejb3.deployment.processors.StartupAwaitInterceptor.processInvocation(StartupAwaitInterceptor.java:22) at org.jboss.invocation(a)1.7.0.Final ( org.jboss.invocation(a)1.7.0.Final ) //org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:422) at org.jboss.as.ejb3(a)27.0.1.Final ( org.jboss.as.ejb3(a)27.0.1.Final ) //org.jboss.as.ejb3.component.interceptors.ShutDownInterceptorFactory$1.processInvocation(ShutDownInterceptorFactory.java:64) at org.jboss.invocation(a)1.7.0.Final ( org.jboss.invocation(a)1.7.0.Final ) //org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:422) at org.jboss.as.ejb3(a)27.0.1.Final ( org.jboss.as.ejb3(a)27.0.1.Final ) //org.jboss.as.ejb3.deployment.processors.EjbSuspendInterceptor.processInvocation(EjbSuspendInterceptor.java:45) at org.jboss.invocation(a)1.7.0.Final ( org.jboss.invocation(a)1.7.0.Final ) //org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:422) at org.jboss.as.ejb3(a)27.0.1.Final ( org.jboss.as.ejb3(a)27.0.1.Final ) //org.jboss.as.ejb3.component.interceptors.LoggingInterceptor.processInvocation(LoggingInterceptor.java:67) at org.jboss.invocation(a)1.7.0.Final ( org.jboss.invocation(a)1.7.0.Final ) //org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:422) at org.jboss.as.ee(a)27.0.1.Final ( org.jboss.as.ee(a)27.0.1.Final ) //org.jboss.as.ee.component.NamespaceContextInterceptor.processInvocation(NamespaceContextInterceptor.java:50) at org.jboss.invocation(a)1.7.0.Final ( org.jboss.invocation(a)1.7.0.Final ) //org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:422) at org.jboss.invocation(a)1.7.0.Final ( org.jboss.invocation(a)1.7.0.Final ) //org.jboss.invocation.ContextClassLoaderInterceptor.processInvocation(ContextClassLoaderInterceptor.java:60) at org.jboss.invocation(a)1.7.0.Final ( org.jboss.invocation(a)1.7.0.Final ) //org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:422) at org.jboss.invocation(a)1.7.0.Final ( org.jboss.invocation(a)1.7.0.Final ) //org.jboss.invocation.InterceptorContext.run(InterceptorContext.java:438) at org.wildfly.security.elytron-base(a)2.0.0.Final ( org.wildfly.security.elytron-base(a)2.0.0.Final ) //org.wildfly.security.manager.WildFlySecurityManager.doChecked(WildFlySecurityManager.java:633) at org.jboss.invocation(a)1.7.0.Final ( org.jboss.invocation(a)1.7.0.Final ) //org.jboss.invocation.AccessCheckingInterceptor.processInvocation(AccessCheckingInterceptor.java:57) at org.jboss.invocation(a)1.7.0.Final ( org.jboss.invocation(a)1.7.0.Final ) //org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:422) at org.jboss.invocation(a)1.7.0.Final ( org.jboss.invocation(a)1.7.0.Final ) //org.jboss.invocation.ChainedInterceptor.processInvocation(ChainedInterceptor.java:53) at org.jboss.as.ee(a)27.0.1.Final ( org.jboss.as.ee(a)27.0.1.Final ) //org.jboss.as.ee.component.ViewService$View.invoke(ViewService.java:198) at org.jboss.as.ejb3(a)27.0.1.Final ( org.jboss.as.ejb3(a)27.0.1.Final ) //org.jboss.as.ejb3.remote.LocalEjbReceiver.processInvocation(LocalEjbReceiver.java:257) at org.jboss.ejb-client(a)5.0.1.Final ( org.jboss.ejb-client(a)5.0.1.Final ) //org.jboss.ejb.client.EJBClientInvocationContext.sendRequest(EJBClientInvocationContext.java:499) at org.jboss.ejb-client(a)5.0.1.Final ( org.jboss.ejb-client(a)5.0.1.Final ) //org.jboss.ejb.protocol.remote.RemotingEJBClientInterceptor.handleInvocation(RemotingEJBClientInterceptor.java:52) at org.jboss.ejb-client(a)5.0.1.Final ( org.jboss.ejb-client(a)5.0.1.Final ) //org.jboss.ejb.client.EJBClientInvocationContext.sendRequest(EJBClientInvocationContext.java:514) at org.jboss.ejb-client(a)5.0.1.Final ( org.jboss.ejb-client(a)5.0.1.Final ) //org.jboss.ejb.client.TransactionPostDiscoveryInterceptor.handleInvocation(TransactionPostDiscoveryInterceptor.java:82) at org.jboss.ejb-client(a)5.0.1.Final ( org.jboss.ejb-client(a)5.0.1.Final ) //org.jboss.ejb.client.EJBClientInvocationContext.sendRequest(EJBClientInvocationContext.java:514) at org.jboss.ejb-client(a)5.0.1.Final ( org.jboss.ejb-client(a)5.0.1.Final ) //org.jboss.ejb.client.DiscoveryEJBClientInterceptor.handleInvocation(DiscoveryEJBClientInterceptor.java:116) at org.jboss.ejb-client(a)5.0.1.Final ( org.jboss.ejb-client(a)5.0.1.Final ) //org.jboss.ejb.client.EJBClientInvocationContext.sendRequest(EJBClientInvocationContext.java:514) at org.jboss.ejb-client(a)5.0.1.Final ( org.jboss.ejb-client(a)5.0.1.Final ) //org.jboss.ejb.client.NamingEJBClientInterceptor.handleInvocation(NamingEJBClientInterceptor.java:69) at org.jboss.ejb-client(a)5.0.1.Final ( org.jboss.ejb-client(a)5.0.1.Final ) //org.jboss.ejb.client.EJBClientInvocationContext.sendRequest(EJBClientInvocationContext.java:514) at org.jboss.ejb-client(a)5.0.1.Final ( org.jboss.ejb-client(a)5.0.1.Final ) //org.jboss.ejb.client.AuthenticationContextEJBClientInterceptor.lambda$handleInvocation$0(AuthenticationContextEJBClientInterceptor.java:45) at org.jboss.ejb-client(a)5.0.1.Final ( org.jboss.ejb-client(a)5.0.1.Final ) //org.jboss.ejb.client.AuthenticationContextEJBClientInterceptor.call(AuthenticationContextEJBClientInterceptor.java:59) at org.jboss.ejb-client(a)5.0.1.Final ( org.jboss.ejb-client(a)5.0.1.Final ) //org.jboss.ejb.client.AuthenticationContextEJBClientInterceptor.handleInvocation(AuthenticationContextEJBClientInterceptor.java:44) at org.jboss.ejb-client(a)5.0.1.Final ( org.jboss.ejb-client(a)5.0.1.Final ) //org.jboss.ejb.client.EJBClientInvocationContext.sendRequest(EJBClientInvocationContext.java:514) Priority: Major Reporter: dt pham ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=5e14f16... ) ( https://hibernate.atlassian.net/browse/HHH-16017#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16017#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#100213- sha1:cca7326 )