[JIRA] (HHH-16017) JPA with Geometry column won't persist for MySql
by dt pham (JIRA)
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=EmailN... ) This message was sent by Atlassian Jira (v1001.0.0-SNAPSHOT#100213- sha1:cca7326 )
1 year, 11 months