Cezar Apulchro

Hi,
The solution for is return to good SQL.
Thanks and best regards.

Sorry by delay.
The solution for: "hibernate, WHERE x=? AND y=?" is return to good SQL.
Thanks and best regards.

Hi I can't understand, I read this link sended to me and many  others links in the web and I have created my query based  in this references for example in this https://docs.jboss.org/hibernate/orm/3.3/reference/en/html/queryhql.html are examples of update:
14.14. HQL examples Hibernate queries can be quite powerful and complex. In fact, the power of the query language is one of Hibernate's main strengths. The following example queries are similar to queries that have been used on recent projects. Please note that most queries you will write will be much simpler than the following examples. The following query returns the order id, number of items, the given minimum total value and the total value of the order for all unpaid orders for a particular customer. The results are ordered by total value. In determining the prices, it uses the current catalog. The resulting SQL query, against the ORDER, ORDER_LINE, PRODUCT, CATALOG and PRICE tables has four inner joins and an (uncorrelated) subselect. select order.id, sum(price.amount), count(item) from Order as order    join order.lineItems as item    join item.product as product,    Catalog as catalog    join catalog.prices as price where order.paid = false    and order.customer = :customer    and price.product = product    and catalog.effectiveDate < sysdate    and catalog.effectiveDate >= all (        select cat.effectiveDate        from Catalog as cat        where cat.effectiveDate < sysdate    ) group by order having sum(price.amount) > :minAmount order by sum(price.amount) desc
WhereI am wrong, give me an way.
Thanks.

I receiving an error of duplicate identifier when execute the query. I trying to update columns of table using two identifiers but I am receiving of duplicate. Where are the error of my query?
Query to update:
public void bp3Updt(Bean_Pre_Natal bpreNatal, String prontuario, String dataconsulta)    {        try(Session session = HibernateUtil.getSessionFactory().openSession())        {            session.beginTransaction();            String hql = "UPDATE FROM Bean_Pre_Natal " +                         "SET Teste_Gravidez =?0, " +                         "Teste_HIV =?0, " +                         "Teste_Sifilis =?0, " +                         "Dosagem_Proteinura =?0 " +                     "WHERE Prontuario = :prontuario " +                        "AND Data_Consulta = :dataconsulta";                        Query query = session.createQuery(hql);            query.setParameter("prontuario", prontuario);            query.setParameter("dataconsulta", dataconsulta);                        session.update(bpreNatal);                        session.getTransaction().commit();                    }catch(HibernateException he)        {            he.printStackTrace();        }    }
Hibernate:
Hibernate:    update        tabela_exames_prenatal    set        Teste_Gravidez=?,        Teste_HIV=?,        Teste_Sifilis=?,        Dosagem_Proteinura=?        ...    where        Prontuario=?
Log:
Type Exception Report Message org.hibernate.HibernateException: Duplicate identifier in table for: [com.itcsystems.beans.Bean_Pre_Natal#612.123.123-00] Description The server encountered an unexpected condition that prevented it from fulfilling the request. Exception javax.persistence.PersistenceException: org.hibernate.HibernateException: Duplicate identifier in table for: [com.itcsystems.beans.Bean_Pre_Natal#612.123.123-00] org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:154) org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:181) org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:188) org.hibernate.internal.SessionImpl.doFlush(SessionImpl.java:1395) org.hibernate.internal.SessionImpl.managedFlush(SessionImpl.java:482) org.hibernate.internal.SessionImpl.flushBeforeTransactionCompletion(SessionImpl.java:3274) org.hibernate.internal.SessionImpl.beforeTransactionCompletion(SessionImpl.java:2409) org.hibernate.engine.jdbc.internal.JdbcCoordinatorImpl.beforeTransactionCompletion(JdbcCoordinatorImpl.java:448) org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransactionCoordinatorImpl.beforeCompletionCallback(JdbcResourceLocalTransactionCoordinatorImpl.java:183) org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransactionCoordinatorImpl.access$300(JdbcResourceLocalTransactionCoordinatorImpl.java:40) org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransactionCoordinatorImpl$TransactionDriverControlImpl.commit(JdbcResourceLocalTransactionCoordinatorImpl.java:281) org.hibernate.engine.transaction.internal.TransactionImpl.commit(TransactionImpl.java:101) com.itcsystems.beans.SavUpdt.bp3Updt(SavUpdt.java:67) itc.systems.itcsystemsdemoweb.Pre_Natal_S003.doPost(Pre_Natal_S003.java:228) javax.servlet.http.HttpServlet.service(HttpServlet.java:660) javax.servlet.http.HttpServlet.service(HttpServlet.java:741) org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) Root Cause org.hibernate.HibernateException: Duplicate identifier in table for: [com.itcsystems.beans.Bean_Pre_Natal#612.123.123-00] org.hibernate.persister.entity.AbstractEntityPersister.check(AbstractEntityPersister.java:2735) org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:3573) org.hibernate.persister.entity.AbstractEntityPersister.updateOrInsert(AbstractEntityPersister.java:3436) org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:3850) org.hibernate.action.internal.EntityUpdateAction.execute(EntityUpdateAction.java:201) org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:604) org.hibernate.engine.spi.ActionQueue.lambda$executeActions$1(ActionQueue.java:478) java.base/java.util.LinkedHashMap.forEach(LinkedHashMap.java:723) org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:475) org.hibernate.event.internal.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:344) org.hibernate.event.internal.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:40) org.hibernate.event.service.internal.EventListenerGroupImpl.fireEventOnEachListener(EventListenerGroupImpl.java:107) org.hibernate.internal.SessionImpl.doFlush(SessionImpl.java:1391) org.hibernate.internal.SessionImpl.managedFlush(SessionImpl.java:482) org.hibernate.internal.SessionImpl.flushBeforeTransactionCompletion(SessionImpl.java:3274) org.hibernate.internal.SessionImpl.beforeTransactionCompletion(SessionImpl.java:2409) org.hibernate.engine.jdbc.internal.JdbcCoordinatorImpl.beforeTransactionCompletion(JdbcCoordinatorImpl.java:448) org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransactionCoordinatorImpl.beforeCompletionCallback(JdbcResourceLocalTransactionCoordinatorImpl.java:183) org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransactionCoordinatorImpl.access$300(JdbcResourceLocalTransactionCoordinatorImpl.java:40) org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransactionCoordinatorImpl$TransactionDriverControlImpl.commit(JdbcResourceLocalTransactionCoordinatorImpl.java:281) org.hibernate.engine.transaction.internal.TransactionImpl.commit(TransactionImpl.java:101) com.itcsystems.beans.SavUpdt.bp3Updt(SavUpdt.java:67) itc.systems.itcsystemsdemoweb.Pre_Natal_S003.doPost(Pre_Natal_S003.java:228) javax.servlet.http.HttpServlet.service(HttpServlet.java:660) javax.servlet.http.HttpServlet.service(HttpServlet.java:741) org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) Note The full stack trace of the root cause is available in the server logs. Apache Tomcat/9.0.14
Why hibernate aren't getting the dataconsulta parameter?
Thanks.

Hi, sorry by delay, in the beginning of this contact I showed two constructors prontuario and data_consulta, this configuration was to try to generate an hql with two parameters to update my table. What I need is to update my table whre prontuario is equal to ? and dataconsulta is equal to ?. I have created a method to do this but haven't work then I opened this contact. Now I have returned my method to try again but error are the same. Below my method and the error.
Method:
public class SavUpdt {    private String                    hibSql;        public void sveUpdt(Bean_Pre_Natal bpreNatal, String prontuario, String dataconsulta)    {        try(Session session = HibernateUtil.getSessionFactory().openSession())        {            session.beginTransaction();            hibSql = "SELECT * " +                     "FROM Tabela_Exames_Prenatal " +                     "WHERE Prontuario = :prontuario AND Data_Consulta = :dataconsulta";                        Query query = session.createQuery(hibSql);            query.setParameter("prontuario", prontuario);            query.setParameter("dataconsulta", dataconsulta);                        session.update(bpreNatal);                        session.getTransaction().commit();                    }catch(HibernateException he)        {            he.printStackTrace();        }    }        public void sveInsert(Bean_Pre_Natal bpreNatal)    {        try        {            Session session = HibernateUtil.getSessionFactory().openSession();                        session.beginTransaction();            session.save(bpreNatal);                        session.getTransaction().commit();                    }catch(HibernateException he)        {            he.printStackTrace();        }    } }
Log error:
Type Exception Report Message org.hibernate.hql.internal.ast.QuerySyntaxException: unexpected token: * near line 1, column 8 [SELECT * FROM Tabela_Exames_Prenatal WHERE Prontuario = :prontuario AND Data_Consulta = :dataconsulta] Description The server encountered an unexpected condition that prevented it from fulfilling the request. Exception java.lang.IllegalArgumentException: org.hibernate.hql.internal.ast.QuerySyntaxException: unexpected token: * near line 1, column 8 [SELECT * FROM Tabela_Exames_Prenatal WHERE Prontuario = :prontuario AND Data_Consulta = :dataconsulta] org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:138) org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:181) org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:188) org.hibernate.internal.AbstractSharedSessionContract.createQuery(AbstractSharedSessionContract.java:743) org.hibernate.internal.AbstractSharedSessionContract.createQuery(AbstractSharedSessionContract.java:114) com.itcsystems.beans.SavUpdt.sveUpdt(SavUpdt.java:33) itc.systems.itcsystemsdemoweb.Pre_Natal_S003.doPost(Pre_Natal_S003.java:228) javax.servlet.http.HttpServlet.service(HttpServlet.java:660) javax.servlet.http.HttpServlet.service(HttpServlet.java:741) org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) Root Cause org.hibernate.hql.internal.ast.QuerySyntaxException: unexpected token: * near line 1, column 8 [SELECT * FROM Tabela_Exames_Prenatal WHERE Prontuario = :prontuario AND Data_Consulta = :dataconsulta] org.hibernate.hql.internal.ast.QuerySyntaxException.convert(QuerySyntaxException.java:74) org.hibernate.hql.internal.ast.ErrorTracker.throwQueryException(ErrorTracker.java:93) org.hibernate.hql.internal.ast.QueryTranslatorImpl.parse(QueryTranslatorImpl.java:301) org.hibernate.hql.internal.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:189) org.hibernate.hql.internal.ast.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:144) org.hibernate.engine.query.spi.HQLQueryPlan.<init>(HQLQueryPlan.java:113) org.hibernate.engine.query.spi.HQLQueryPlan.<init>(HQLQueryPlan.java:73) org.hibernate.engine.query.spi.QueryPlanCache.getHQLQueryPlan(QueryPlanCache.java:162) org.hibernate.internal.AbstractSharedSessionContract.getQueryPlan(AbstractSharedSessionContract.java:622) org.hibernate.internal.AbstractSharedSessionContract.createQuery(AbstractSharedSessionContract.java:734) org.hibernate.internal.AbstractSharedSessionContract.createQuery(AbstractSharedSessionContract.java:114) com.itcsystems.beans.SavUpdt.sveUpdt(SavUpdt.java:33) itc.systems.itcsystemsdemoweb.Pre_Natal_S003.doPost(Pre_Natal_S003.java:228) javax.servlet.http.HttpServlet.service(HttpServlet.java:660) javax.servlet.http.HttpServlet.service(HttpServlet.java:741) org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) Note The full stack trace of the root cause is available in the server logs. Apache Tomcat/9.0.14
Thanks.

My Bean:
@Entity @Table(name = “Tabela_Exames_PreNatal”) @Access(value = AccessType.FIELD) public class Bean_Pre_Natal implements Serializable { private static final long serialVersionUID = 1L; @Id @GeneratedValue( strategy = GenerationType.IDENTITY) @Column( name = “Prontuario”, updatable = true) private String prontuario = null; @Id @GeneratedValue( strategy = GenerationType.IDENTITY) @Column( name = “Data_Consulta”, updatable = true) private String data_consulta = null; @Column( name = “Nome”, updatable = true) private String nome = null; @Column( name = “Consulta_Do_Trimestre”, updatable = true) private String consulta_do_trimestre = null; @Column( name = “Semanas_Gestacao”, updatable = true) private String semanas_gestacao = null; … and many others fields getter and setter of all …
My HibernateUtil:
public class HibernateUtil { private static final SessionFactory sessionFactory = buildSessionFactory(); private static SessionFactory buildSessionFactory() {    try {        return new Configuration().configure().buildSessionFactory();    } catch (Throwable ex) {        System.err.println("build SeesionFactory failed :" + ex);        throw new ExceptionInInitializerError(ex);    } } public static SessionFactory getSessionFactory() {    return sessionFactory; } public static void close() {    // Close all cached and active connection pools    getSessionFactory().close(); } }
My method to save:
public void sveInsert(Bean_Pre_Natal bpreNatal) { try { Session session = HibernateUtil.getSessionFactory().openSession();        session.beginTransaction();        session.save(bpreNatal); ==> Line error.                session.getTransaction().commit();            }catch(HibernateException he)    {        he.printStackTrace();    } }
Log error:
by reflection : [class com.itcsystems.beans.Bean_Pre_Natal.prontuario] setter of com.itcsystems.beans.Bean_Pre_Natal.prontuario Send Pront.: 612.123.123-00 at org.hibernate.property.access.spi.SetterFieldImpl.set(SetterFieldImpl.java:72) at org.hibernate.mapping.Component$ValueGenerationPlan.execute(Component.java:510) at org.hibernate.id.CompositeNestedGeneratedValueGenerator.generate(CompositeNestedGeneratedValueGenerator.java:97) at org.hibernate.event.internal.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:115) at org.hibernate.event.internal.DefaultSaveOrUpdateEventListener.saveWithGeneratedOrRequestedId(DefaultSaveOrUpdateEventListener.java:194) at org.hibernate.event.internal.DefaultSaveEventListener.saveWithGeneratedOrRequestedId(DefaultSaveEventListener.java:38) at org.hibernate.event.internal.DefaultSaveOrUpdateEventListener.entityIsTransient(DefaultSaveOrUpdateEventListener.java:179) at org.hibernate.event.internal.DefaultSaveEventListener.performSaveOrUpdate(DefaultSaveEventListener.java:32) at org.hibernate.event.internal.DefaultSaveOrUpdateEventListener.onSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:75) at org.hibernate.event.service.internal.EventListenerGroupImpl.fireEventOnEachListener(EventListenerGroupImpl.java:107) at org.hibernate.internal.SessionImpl.fireSave(SessionImpl.java:665) at org.hibernate.internal.SessionImpl.save(SessionImpl.java:658) at org.hibernate.internal.SessionImpl.save(SessionImpl.java:653) at com.itcsystems.beans.SavUpdt.sveInsert(SavUpdt.java:43) at itc.systems.itcsystemsdemoweb.Pre_Natal_S005.doPost(Pre_Natal_S005.java:239) at javax.servlet.http.HttpServlet.service(HttpServlet.java:660) at javax.servlet.http.HttpServlet.service(HttpServlet.java:741) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:199) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:490) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:668) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343) at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:408) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:834) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1417) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1130) at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:630) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.base/java.lang.Thread.run(Thread.java:832) Caused by: java.lang.IllegalArgumentException: Can not set java.lang.String field com.itcsystems.beans.Bean_Pre_Natal.prontuario to org.hibernate.id.IdentifierGeneratorHelper$2 at java.base/jdk.internal.reflect.UnsafeFieldAccessorImpl.throwSetIllegalArgumentException(UnsafeFieldAccessorImpl.java:167) at java.base/jdk.internal.reflect.UnsafeFieldAccessorImpl.throwSetIllegalArgumentException(UnsafeFieldAccessorImpl.java:171) at java.base/jdk.internal.reflect.UnsafeObjectFieldAccessorImpl.set(UnsafeObjectFieldAccessorImpl.java:81) at java.base/java.lang.reflect.Field.set(Field.java:778) at org.hibernate.property.access.spi.SetterFieldImpl.set(SetterFieldImpl.java:52) … 38 more
I can’t any idea to solve thiss problem.
Thanks in advance.

After change my hibernate.cfg.xml, saveOrUpdate method, HibernateUtil and bean class I am receiving a new error " Row was updated or deleted by another transaction (or unsaved-value mapping was incorrect) : [com.itcsystems.beans.Bean_PreNatal6#612.123.123-00] ".
New hibernate.cfg.xml:
<?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE hibernate-configuration PUBLIC    "-//Hibernate/Hibernate Configuration DTD 3.0//EN"    "http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd"> <hibernate-configuration>    <session-factory>        <property name="connection.driver_class">com.mysql.cj.jdbc.Driver</property>        <property name="connection.url">jdbc:mysql://localhost/DB_Medical</property>        <property name="connection.username">root</property>        <property name="connection.password">cezar2017</property>        <property name="connection.pool_size">10</property>        <property name="dialect">org.hibernate.dialect.MySQLDialect</property>        <property name="show_sql">true</property>        <property name="format_sql">true</property>        <property name="current_session_context_class">thread</property>        <property name="hbm2ddl.auto">update</property>        <mapping class="com.itcsystems.beans.Bean_PreNatal6"></mapping>    </session-factory> </hibernate-configuration>
HibernateUtil:
public class HibernateUtil {    private static StandardServiceRegistry registry;    private static SessionFactory sessionFactory ;        public static SessionFactory getSessionFactory()    {        if(sessionFactory == null)        {            try            {                // create registry                registry = new StandardServiceRegistryBuilder().configure().build();                                MetadataSources sources = new MetadataSources(registry);                                Metadata metadata = sources.getMetadataBuilder().build();                                sessionFactory = metadata.getSessionFactoryBuilder().build();                            }catch(Exception e)            {                e.printStackTrace();                                if(registry != null)                {                    StandardServiceRegistryBuilder.destroy(registry);                }            }        }        return sessionFactory;    }            public static void shutdown()    {        if (registry != null) {            StandardServiceRegistryBuilder.destroy(registry);        }    }     }
Bean class:
@Entity @Table(name = "Tabela_Exames_PreNatal") public class Bean_PreNatal6 {    private static final long serialVersionUID = 1L; @Id @GeneratedValue( strategy = GenerationType.IDENTITY) @Column( name = "Prontuario")    private String            prontuario = null; @Column( name = "Data_Consulta")    private String            data_consulta = null; @Column( name = "Contagem_Plaquetas")    private String            contagem_plaquetas = null; @Column( name = "Dosagem_Ureia")    private String            dosagem_ureia = null; @Column( name = "Dosagem_Proteina_Urina24H")    private String            dosagem_proteina_urina24h = null; @Column( name = "Ultra_Obstetrico_Dopler")    private String            ultra_obstetrico_dopler = null; @Column( name = "Dosagem_AcidoUrico")    private String            dosagem_acidourico = null; @Column( name = "Dosagem_Creatinina")    private String            dosagem_creatinina = null; @Column( name = "Eletrocardiograma")    private String            eletrocardiograma = null; @Column( name = "Cardiotocografia")    private String            cardiotocografia = null; // Getter and Setter
Class of saveOrUpdate:
public class SavUpdt {    public static void svUpdt(Bean_PreNatal6 bpreNatal)    {                try(Session session = HibernateUtil.getSessionFactory().openSession())        {            session.beginTransaction();            session.saveOrUpdate(bpreNatal);                        session.getTransaction().commit();                    }catch(HibernateException he)        {            he.printStackTrace();        }    } }
Error log:
Type Exception Report Message Row was updated or deleted by another transaction (or unsaved-value mapping was incorrect) : [com.itcsystems.beans.Bean_PreNatal6#612.123.123-00] Description The server encountered an unexpected condition that prevented it from fulfilling the request. Exception javax.persistence.OptimisticLockException: Row was updated or deleted by another transaction (or unsaved-value mapping was incorrect) : [com.itcsystems.beans.Bean_PreNatal6#612.123.123-00] org.hibernate.internal.ExceptionConverterImpl.wrapStaleStateException(ExceptionConverterImpl.java:226) org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:93) org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:181) org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:188) org.hibernate.internal.SessionImpl.doFlush(SessionImpl.java:1395) org.hibernate.internal.SessionImpl.managedFlush(SessionImpl.java:482) org.hibernate.internal.SessionImpl.flushBeforeTransactionCompletion(SessionImpl.java:3274) org.hibernate.internal.SessionImpl.beforeTransactionCompletion(SessionImpl.java:2409) org.hibernate.engine.jdbc.internal.JdbcCoordinatorImpl.beforeTransactionCompletion(JdbcCoordinatorImpl.java:448) org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransactionCoordinatorImpl.beforeCompletionCallback(JdbcResourceLocalTransactionCoordinatorImpl.java:183) org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransactionCoordinatorImpl.access$300(JdbcResourceLocalTransactionCoordinatorImpl.java:40) org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransactionCoordinatorImpl$TransactionDriverControlImpl.commit(JdbcResourceLocalTransactionCoordinatorImpl.java:281) org.hibernate.engine.transaction.internal.TransactionImpl.commit(TransactionImpl.java:101) com.itcsystems.beans.SavUpdt.svUpdt(SavUpdt.java:38) itc.systems.itcsystemsdemoweb.Pre_Natal_S006.doPost(Pre_Natal_S006.java:254) javax.servlet.http.HttpServlet.service(HttpServlet.java:660) javax.servlet.http.HttpServlet.service(HttpServlet.java:741) org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) Root Cause org.hibernate.StaleObjectStateException: Row was updated or deleted by another transaction (or unsaved-value mapping was incorrect) : [com.itcsystems.beans.Bean_PreNatal6#612.123.123-00] org.hibernate.persister.entity.AbstractEntityPersister.check(AbstractEntityPersister.java:2728) org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:3573) org.hibernate.persister.entity.AbstractEntityPersister.updateOrInsert(AbstractEntityPersister.java:3436) org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:3850) org.hibernate.action.internal.EntityUpdateAction.execute(EntityUpdateAction.java:201) org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:604) org.hibernate.engine.spi.ActionQueue.lambda$executeActions$1(ActionQueue.java:478) java.base/java.util.LinkedHashMap.forEach(LinkedHashMap.java:723) org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:475) org.hibernate.event.internal.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:344) org.hibernate.event.internal.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:40) org.hibernate.event.service.internal.EventListenerGroupImpl.fireEventOnEachListener(EventListenerGroupImpl.java:107) org.hibernate.internal.SessionImpl.doFlush(SessionImpl.java:1391) org.hibernate.internal.SessionImpl.managedFlush(SessionImpl.java:482) org.hibernate.internal.SessionImpl.flushBeforeTransactionCompletion(SessionImpl.java:3274) org.hibernate.internal.SessionImpl.beforeTransactionCompletion(SessionImpl.java:2409) org.hibernate.engine.jdbc.internal.JdbcCoordinatorImpl.beforeTransactionCompletion(JdbcCoordinatorImpl.java:448) org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransactionCoordinatorImpl.beforeCompletionCallback(JdbcResourceLocalTransactionCoordinatorImpl.java:183) org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransactionCoordinatorImpl.access$300(JdbcResourceLocalTransactionCoordinatorImpl.java:40) org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransactionCoordinatorImpl$TransactionDriverControlImpl.commit(JdbcResourceLocalTransactionCoordinatorImpl.java:281) org.hibernate.engine.transaction.internal.TransactionImpl.commit(TransactionImpl.java:101) com.itcsystems.beans.SavUpdt.svUpdt(SavUpdt.java:38) itc.systems.itcsystemsdemoweb.Pre_Natal_S006.doPost(Pre_Natal_S006.java:254) javax.servlet.http.HttpServlet.service(HttpServlet.java:660) javax.servlet.http.HttpServlet.service(HttpServlet.java:741) org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) Note The full stack trace of the root cause is available in the server logs.
Thanks.

Hi mate, I changed how you told me but my problem was not to insert but to update, for this I am using saveOrUpdate hibernate method but I am receiving an error.
Class:
/* * To change this license header, choose License Headers in Project Properties. * To change this template file, choose Tools | Templates * and open the template in the editor. */ package com.itcsystems.beans; import org.hibernate.Session; import org.hibernate.SessionFactory; import org.hibernate.Transaction; /** * * @author Cezar Apulchro */ public class DBUtilSession {    public void saveAltera(Bean_Pre_Natal bpreNatal)    {        try        {            SessionFactory sessionFactory = HibernateUtil.getSessionFactory();            Session session = HibernateUtil.getSessionFactory().openSession();            Transaction trans = session.beginTransaction();                        session.saveOrUpdate(bpreNatal);            session.getTransaction().commit();            session.close();        }        catch (Exception ex)        {                            ex.printStackTrace();        }            } }
Log error:
org.hibernate.MappingException: Unknown entity: com.itcsystems.beans.Bean_Pre_Natal at org.hibernate.metamodel.internal.MetamodelImpl.entityPersister(MetamodelImpl.java:704) at org.hibernate.internal.SessionImpl.getEntityPersister(SessionImpl.java:1608) at org.hibernate.engine.internal.ForeignKeys.isTransient(ForeignKeys.java:293) at org.hibernate.event.internal.EntityState.getEntityState(EntityState.java:59) at org.hibernate.event.internal.DefaultSaveOrUpdateEventListener.performSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:85) at org.hibernate.event.internal.DefaultSaveOrUpdateEventListener.onSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:75) at org.hibernate.event.service.internal.EventListenerGroupImpl.fireEventOnEachListener(EventListenerGroupImpl.java:93) at org.hibernate.internal.SessionImpl.fireSaveOrUpdate(SessionImpl.java:616) at org.hibernate.internal.SessionImpl.saveOrUpdate(SessionImpl.java:609) at org.hibernate.internal.SessionImpl.saveOrUpdate(SessionImpl.java:604) at com.itcsystems.beans.DBUtilSession.saveAltera(DBUtilSession.java:26) at itc.systems.itcsystemsdemoweb.Pre_Natal_S006.doPost(Pre_Natal_S006.java:270) at javax.servlet.http.HttpServlet.service(HttpServlet.java:660) at javax.servlet.http.HttpServlet.service(HttpServlet.java:741) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:199) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:490) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:668) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343) at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:408) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:834) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1417) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1130) at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:630) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.base/java.lang.Thread.run(Thread.java:832)
Thanks.

Hi sorry by delay, I was having serious problems. I have six servlet to six pages, this is because I have many radio buttons. All servlet have the same procedure to save  the record, below is an piece of method to insert records.
if ("Salvar".equals(acaobotao))        {            Date data = new Date();                        SimpleDateFormat dfm = new SimpleDateFormat("dd/MM/yyyy");            dtaconsulta = dfm.format(data);                        prontuario = request.getParameter("prontuario");            nome = request.getParameter("nome");            tcoombss = request.getParameter("tcoombss");            parafezess = request.getParameter("parafezess");            ttots = request.getParameter("ttots");            teletrofs = request.getParameter("teletrofs");            if (tcoombss != null) {                tcoombss = "sim";            } else {                tcoombss = " ";            }            if (parafezess != null) {                parafezess = "sim";            } else {                parafezess = " ";            }            if (ttots != null) {                ttots = "sim";            } else {                ttots = " ";            }            if (teletrofs != null) {                teletrofs = "sim";            } else {                teletrofs = " ";            }            EntityManagerFactory emf = Persistence.createEntityManagerFactory("ITCSystems");            EntityManager em = emf.createEntityManager();            EntityTransaction et = null;            try            {                et = em.getTransaction();                et.begin();                Bean_Pre_Natal bpreNatal = new Bean_Pre_Natal();                            bpreNatal.setProntuario(prontuario);                bpreNatal.setNome(nome);                bpreNatal.setData_consulta(dtaconsulta);                bpreNatal.setCoombs_indireto_positivo(tcoombss);                bpreNatal.setParasitologia_fezes(parafezess);                bpreNatal.setTot_alterado(ttots);                bpreNatal.setEletroforese_hemoglobina_alterado(teletrofs);                            em.persist(bpreNatal);                et.commit();            }            catch (Exception ex)            {                if(et != null)                {                    et.rollback();                }                ex.printStackTrace();            }            finally            {                em.close();            }                                  request.setAttribute("prontuario", prontuario);            request.setAttribute("nome", nome);            request.setAttribute("nascimento", nascimento);            request.setAttribute("sexo", sexo);            request.setAttribute("estcivil", estcivil);            request.setAttribute("cartaosus", cartaosus);                                      RequestDispatcher retorna = request.getRequestDispatcher("Consulta_Pacientes_W001.jsp");            retorna.forward(request, response);                    }
I'm using save or update to records that was already writed in my db that have the same prontuario and dtconsulta equals. The method above works fine in all six servlet, what I want  is change to  save or update method, defined in the opened contact. I this case I don't have DOA I have an persistence file that shown at beginning of this contact.
Class to access DB:
/* * To change this license header, choose License Headers in Project Properties. * To change this template file, choose Tools | Templates * and open the template in the editor. */ package com.itcsystems.beans; import java.io.IOException; import java.io.PrintWriter; import javax.servlet.ServletException; import javax.servlet.http.HttpServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import java.sql.Connection; import java.sql.DriverManager; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; /** * * @author Cezar Apulchro */ public class Conectar_Banco_W00 extends HttpServlet {    private final String DRIVER = "com.mysql.cj.jdbc.Driver";    private final String URL = "jdbc:mysql://localhost:3306/DB_Medical";    private final String USER = "root";    private final String PASS = "";        public Connection getConnection()    {        Connection conn = null;                try        {            Class.forName(DRIVER);                        return DriverManager.getConnection(URL, USER, PASS);                    }        catch (ClassNotFoundException | SQLException exc)        {            System.out.println("Conectando DB...");            System.out.println("Erro na conexão: " + exc);            exc.printStackTrace();        }        return conn;    }        public static void fecharConexao(Connection conn)    {        try        {            if (conn != null) { conn.close(); } } catch (Exception e) { System.out.println("Não foi possí­vel fechar a conexão"                                + "com o banco de dados " + e.getMessage());        }    }    public static void fecharConexao(Connection conn, PreparedStatement pstm)    {        try        {            if (conn != null) { fecharConexao(conn); } if (pstm != null) { pstm.close(); } } catch (Exception e) { System.out.println("Não foi possí­vel fechar o statement " + e.getMessage());        }    }        public static void fecharConexao(Connection conn, PreparedStatement pstm,            ResultSet rs)    {        try        {            if (conn != null || pstm != null) { fecharConexao(conn, pstm); } if (rs != null)                        { rs.close(); } } catch (Exception e) { System.out.println("Não foi possível fechar o ResultSet " + e.getMessage());                }                    }        PreparedStatement prepareStatement(String sqlInsert) {        throw new UnsupportedOperationException("Not supported yet."); //To change body of generated methods, choose Tools | Templates.    }        /**     * Processes requests for both HTTP <code>GET</code> and <code>POST</code>     * methods.     *     * @param request servlet request     * @param response servlet response     * @throws ServletException if a servlet-specific error occurs     * @throws IOException if an I/O error occurs     */    protected void processRequest(HttpServletRequest request, HttpServletResponse response)            throws ServletException, IOException    {        }    // <editor-fold defaultstate="collapsed" desc="HttpServlet methods. Click on the + sign on the left to edit the code.">    /**     * Handles the HTTP <code>GET</code> method.     *     * @param request servlet request     * @param response servlet response     * @throws ServletException if a servlet-specific error occurs     * @throws IOException if an I/O error occurs     */    @Override    protected void doGet(HttpServletRequest request, HttpServletResponse response)            throws ServletException, IOException {        processRequest(request, response);    }    /**     * Handles the HTTP <code>POST</code> method.     *     * @param request servlet request     * @param response servlet response     * @throws ServletException if a servlet-specific error occurs     * @throws IOException if an I/O error occurs     */    @Override    protected void doPost(HttpServletRequest request, HttpServletResponse response)            throws ServletException, IOException {        processRequest(request, response);    }    /**     * Returns a short description of the servlet.     *     * @return a String containing servlet description     */    @Override    public String getServletInfo() {        return "Short description";    }// </editor-fold> }
Thanks by help.

Hi, no news?

Are there some other place to see if db_demonstracao is defined?

Hi, sorry by delay, this is my database connection.

I don't understand, I created the db_demonstracao only to do some tests and then I deleted. I don't have reference to this db in my persistence file and in my hibernate.cfg.xml too, why this error occur? I clean and build the project many times, where this reference my be occur?

Hi, I'm trying to use Hibernate saveorupdate but I'm receiving an error. I have a servlet class that I use persistence file to insert records in my DB and work without any problem. For the saveOrUpdate I  created hibernate.cfg.xml.
My hibernate.cfg.xml:
<?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE hibernate-configuration PUBLIC    "-//Hibernate/Hibernate Configuration DTD 3.0//EN"    "http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd"> <hibernate-configuration>  <session-factory>    <property name="connection.driver_class">com.mysql.cj.jdbc.Driver</property>    <property name="hibernate.connection.url">jdbc:mysql://localhost/db_medical</property>    <property name="hibernate.connection.username">root</property>    <property name="hibernate.connection.password">cezar2017</property>    <property name="hibernate.connection.pool_size">10</property>    <property name="show_sql">true</property>    <property name="dialect">org.hibernate.dialect.MySQLDialect</property>    <mapping class="com.itcsystems.beans.Bean_Pre_Natal"/>   </session-factory> </hibernate-configuration>
My servlet:
/* * To change this license header, choose License Headers in Project Properties. * To change this template file, choose Tools | Templates * and open the template in the editor. */ package itc.systems.itcsystemsdemoweb; import com.itcsystems.beans.Bean_Pre_Natal; import com.itcsystems.beans.Conectar_Banco_W00; import com.itcsystems.beans.DadosPaciente; import com.itcsystems.beans.HibernateUtil; import com.itcsystems.beans.PacientesDAO_W01; import com.itcsystems.beans.Usuarios_DAO; import java.io.File; import java.io.FileInputStream; import java.io.IOException; import java.io.InputStream; import java.io.PrintWriter; import java.sql.Connection; import java.sql.SQLException; import java.text.SimpleDateFormat; import java.util.Date; import java.util.HashMap; import java.util.logging.Level; import java.util.logging.Logger; import javax.servlet.RequestDispatcher; import javax.servlet.ServletException; import javax.servlet.http.HttpServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import javax.swing.JOptionPane; import net.sf.jasperreports.engine.JREmptyDataSource; import net.sf.jasperreports.engine.JRException; import net.sf.jasperreports.engine.JasperCompileManager; import net.sf.jasperreports.engine.JasperExportManager; import net.sf.jasperreports.engine.JasperFillManager; import net.sf.jasperreports.engine.JasperPrint; import net.sf.jasperreports.engine.JasperReport; import org.hibernate.Session; /** * * @author Cezar Apulchro */ public class Pre_Natal_S006 extends HttpServlet {    public Connection conectar;    PacientesDAO_W01 pcdao = new PacientesDAO_W01();    DadosPaciente dpaciente = new DadosPaciente();    Usuarios_DAO usuario = new Usuarios_DAO();    private String                    prontuario = null,                    nome = null,                    nascimento = null,                    sexo = null,                    estcivil = null,                    cartaosus = null,                    dtaconsulta = null,                    acaobotao = null,                    tcontplaqs = null,                    dosureias = null,                    dosprots = null,                    ultrobsds = null,                    dacidurs = null,                    doscreats = null,                    eletros = null,                    cardtocos = null;        /**     * Processes requests for both HTTP <code>GET</code> and <code>POST</code>     * methods.     *     * @param request servlet request     * @param response servlet response     * @throws ServletException if a servlet-specific error occurs     * @throws IOException if an I/O error occurs     */    protected void processRequest(HttpServletRequest request, HttpServletResponse response)            throws ServletException, IOException {        response.setContentType("text/html;charset=UTF-8");        try ( PrintWriter out = response.getWriter()) {            /* TODO output your page here. You may use following sample code. */            out.println("<!DOCTYPE html>");            out.println("<html>");            out.println("<head>");            out.println("<title>Servlet Pre_Natal_S006</title>");                        out.println("</head>");            out.println("<body>");            out.println("<h1>Servlet Pre_Natal_S006 at " + request.getContextPath() + "</h1>");            out.println("</body>");            out.println("</html>");        }    }    // <editor-fold defaultstate="collapsed" desc="HttpServlet methods. Click on the + sign on the left to edit the code.">    /**     * Handles the HTTP <code>GET</code> method.     *     * @param request servlet request     * @param response servlet response     * @throws ServletException if a servlet-specific error occurs     * @throws IOException if an I/O error occurs     */    @Override    protected void doGet(HttpServletRequest request, HttpServletResponse response)            throws ServletException, IOException {        processRequest(request, response);    }    /**     * Handles the HTTP <code>POST</code> method.     *     * @param request servlet request     * @param response servlet response     * @throws ServletException if a servlet-specific error occurs     * @throws IOException if an I/O error occurs     */    @Override    protected void doPost(HttpServletRequest request, HttpServletResponse response)            throws ServletException, IOException    {        acaobotao = request.getParameter("acaobotao");                if ("Abrir".equals(acaobotao))        {            prontuario = request.getParameter("prontuario");                        try            {                dpaciente = pcdao.getConsultaPaciente(prontuario, request, response);                                nome = dpaciente.getNome().trim();                nascimento = dpaciente.getData_Nascimento().trim();                sexo = dpaciente.getSexo().trim();                estcivil = dpaciente.getEstado_Civil().trim();                cartaosus = dpaciente.getCartao_SUS();                                request.setAttribute("prontuario", prontuario);                request.setAttribute("nome", nome);                request.setAttribute("nascimento", nascimento);                request.setAttribute("sexo", sexo);                request.setAttribute("estcivil", estcivil);                request.setAttribute("cartaosus", cartaosus);                            RequestDispatcher retorna = request.getRequestDispatcher("Pre_Natal_W06.jsp");                retorna.forward(request, response);                            } catch (Exception ex)            {                ex.printStackTrace();            }        }                if ("Voltar".equals(acaobotao))        {            request.setAttribute("prontuario", prontuario);            request.setAttribute("nome", nome);            request.setAttribute("nascimento", nascimento);            request.setAttribute("sexo", sexo);            request.setAttribute("estcivil", estcivil);            request.setAttribute("cartaosus", cartaosus);            RequestDispatcher retorna = request.getRequestDispatcher("Consulta_Pacientes_W001.jsp");            retorna.forward(request, response);                      }                if ("Salvar".equals(acaobotao))        {            Date data = new Date();                        SimpleDateFormat dfm = new SimpleDateFormat("dd/MM/yyyy");            dtaconsulta = dfm.format(data);                        prontuario = request.getParameter("prontuario");            nome = request.getParameter("nome");            tcontplaqs = request.getParameter("tcontplaqs");            dosureias = request.getParameter("dosureias");            dosprots = request.getParameter("dosprots");            ultrobsds = request.getParameter("ultrobsds");            dacidurs = request.getParameter("dacidurs");            doscreats = request.getParameter("doscreats");            eletros = request.getParameter("eletros");            cardtocos = request.getParameter("cardtocos");            if (tcontplaqs != null) {                tcontplaqs = "sim";            } else {                tcontplaqs = " ";            }            if (dosureias != null) {                dosureias = "sim";            } else {                dosureias = " ";            }            if (dosprots != null) {                dosprots = "sim";            } else {                dosprots = " ";            }            if (ultrobsds != null) {                ultrobsds = "sim";            } else {                ultrobsds = " ";            }            if (dacidurs != null) {                dacidurs = "sim";            } else {                dacidurs = " ";            }            if (doscreats != null) {                doscreats = "sim";            } else {                doscreats = " ";            }            if (eletros != null) {                eletros = "sim";            } else {                eletros = " ";            }            if (cardtocos != null) {                cardtocos = "sim";            } else {                cardtocos = " ";            }            try            {                                Session session = HibernateUtil.getSessionFactory().openSession();                session.beginTransaction();                                Bean_Pre_Natal bpreNatal = new Bean_Pre_Natal();                            bpreNatal.setProntuario(prontuario);                bpreNatal.setNome(nome);                bpreNatal.setData_consulta(dtaconsulta);                bpreNatal.setContagem_plaquetas(tcontplaqs);                bpreNatal.setDosagem_ureia(dosureias);                bpreNatal.setDosagem_proteina_urina24h(dosprots);                bpreNatal.setUltra_obstetrico_dopler(ultrobsds);                bpreNatal.setDosagem_acidourico(dacidurs);                bpreNatal.setDosagem_creatinina(doscreats);                bpreNatal.setEletrocardiograma(eletros);                bpreNatal.setCardiotocografia(cardtocos);                                                session.saveOrUpdate(bpreNatal);                session.getTransaction().commit();                session.close();                            }            catch (Exception ex)            {                                ex.printStackTrace();            }                                            request.setAttribute("prontuario", prontuario);            request.setAttribute("nome", nome);            request.setAttribute("nascimento", nascimento);            request.setAttribute("sexo", sexo);            request.setAttribute("estcivil", estcivil);            request.setAttribute("cartaosus", cartaosus);                                      RequestDispatcher retorna = request.getRequestDispatcher("Consulta_Pacientes_W001.jsp");            retorna.forward(request, response);                    }    }    /**     * Returns a short description of the servlet.     *     * @return a String containing servlet description     */    @Override    public String getServletInfo() {        return "Short description";    }// </editor-fold> }
Log error:
org.hibernate.MappingException: Unknown entity: com.itcsystems.beans.Bean_Pre_Natal Erro na conexão: java.sql.SQLSyntaxErrorException: Unknown database 'db_demonstracao' at org.hibernate.metamodel.internal.MetamodelImpl.entityPersister(MetamodelImpl.java:704) at org.hibernate.internal.SessionImpl.getEntityPersister(SessionImpl.java:1608) at org.hibernate.engine.internal.ForeignKeys.isTransient(ForeignKeys.java:293) at org.hibernate.event.internal.EntityState.getEntityState(EntityState.java:59) at org.hibernate.event.internal.DefaultSaveOrUpdateEventListener.performSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:85) at org.hibernate.event.internal.DefaultSaveOrUpdateEventListener.onSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:75) at org.hibernate.event.service.internal.EventListenerGroupImpl.fireEventOnEachListener(EventListenerGroupImpl.java:93) at org.hibernate.internal.SessionImpl.fireSaveOrUpdate(SessionImpl.java:616) at org.hibernate.internal.SessionImpl.saveOrUpdate(SessionImpl.java:609) at org.hibernate.internal.SessionImpl.saveOrUpdate(SessionImpl.java:604) at itc.systems.itcsystemsdemoweb.Pre_Natal_S006.doPost(Pre_Natal_S006.java:256) at javax.servlet.http.HttpServlet.service(HttpServlet.java:660) at javax.servlet.http.HttpServlet.service(HttpServlet.java:741) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:199) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:490) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:668) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343) at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:408) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:834) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1417) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1130) at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:630) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.base/java.lang.Thread.run(Thread.java:832)
Thanks in advance.

After change my pom to jaxb-api 2.3.1 indicated in your response, problem still the same.
Pom:
<?xml version="1.0" encoding="UTF-8"?> <project xmlns="http://maven.apache.org/POM/4.0.0"         xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"         xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">    <modelVersion>4.0.0</modelVersion>    <groupId>com.itcsystems.teste</groupId>    <artifactId>ITCSystems_ClientsWeb</artifactId>    <version>1.0-SNAPSHOT</version>    <packaging>war</packaging>    <name>ITCSystems_ClientsWeb</name>    <properties>        <endorsed.dir>${project.build.directory}/endorsed</endorsed.dir>        <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>    </properties>        <dependencies>        <dependency>            <groupId>javax</groupId>            <artifactId>javaee-web-api</artifactId>            <version>7.0</version>            <scope>provided</scope>        </dependency>        <!-- https://mvnrepository.com/artifact/org.glassfish/javax.faces --> <dependency>    <groupId>org.glassfish</groupId>    <artifactId>javax.faces</artifactId>    <version>2.4.0</version> </dependency> <!-- https://mvnrepository.com/artifact/org.primefaces/primefaces --> <dependency>    <groupId>org.primefaces</groupId>    <artifactId>primefaces</artifactId>    <version>10.0.0</version> </dependency> <!-- https://mvnrepository.com/artifact/org.primefaces.extensions/primefaces-extensions --> <dependency>    <groupId>org.primefaces.extensions</groupId>    <artifactId>primefaces-extensions</artifactId>    <version>10.0.2</version> </dependency> <!-- https://mvnrepository.com/artifact/mysql/mysql-connector-java --> <dependency>    <groupId>mysql</groupId>    <artifactId>mysql-connector-java</artifactId>    <version>8.0.25</version> </dependency> <!-- https://mvnrepository.com/artifact/org.hibernate/hibernate-core --> <dependency>    <groupId>org.hibernate</groupId>    <artifactId>hibernate-core</artifactId>    <version>5.5.2.Final</version> </dependency> <!-- https://mvnrepository.com/artifact/org.hibernate/hibernate-entitymanager --> <dependency>    <groupId>org.hibernate</groupId>    <artifactId>hibernate-entitymanager</artifactId>    <version>5.5.2.Final</version> </dependency> <!-- https://mvnrepository.com/artifact/javax.servlet/javax.servlet-api --> <dependency>    <groupId>javax.servlet</groupId>    <artifactId>javax.servlet-api</artifactId>    <version>4.0.1</version>    <scope>provided</scope> </dependency> <!-- https://mvnrepository.com/artifact/org.apache.maven.plugins/maven-compiler-plugin --> <dependency>    <groupId>org.apache.maven.plugins</groupId>    <artifactId>maven-compiler-plugin</artifactId>    <version>3.8.1</version> </dependency>        <dependency>            <groupId>javax.xml.bind</groupId>            <artifactId>jaxb-api</artifactId>            <version>2.3.1</version>        </dependency>    </dependencies>    <build>        <plugins>            <plugin>                <groupId>org.apache.maven.plugins</groupId>                <artifactId>maven-compiler-plugin</artifactId>                <version>3.1</version>                <configuration>                    <source>1.8</source>                    <target>1.8</target>                    <compilerArguments>                        <endorseddirs>${endorsed.dir}</endorseddirs>                    </compilerArguments>                </configuration>            </plugin>            <plugin>                <groupId>org.apache.maven.plugins</groupId>                <artifactId>maven-war-plugin</artifactId>                <version>2.3</version>                <configuration>                    <failOnMissingWebXml>false</failOnMissingWebXml>                </configuration>            </plugin>            <plugin>                <groupId>org.apache.maven.plugins</groupId>                <artifactId>maven-dependency-plugin</artifactId>                <version>2.6</version>                <executions>                    <execution>                        <phase>validate</phase>                        <goals>                            <goal>copy</goal>                        </goals>                        <configuration>                            <outputDirectory>${endorsed.dir}</outputDirectory>                            <silent>true</silent>                            <artifactItems>                                <artifactItem>                                    <groupId>javax</groupId>                                    <artifactId>javaee-endorsed-api</artifactId>                                    <version>7.0</version>                                    <type>jar</type>                                </artifactItem>                            </artifactItems>                        </configuration>                    </execution>                </executions>            </plugin>        </plugins>    </build> </project>
Error log:
java.lang.RuntimeException: java.lang.NoClassDefFoundError: javax/xml/bind/JAXB at com.sun.faces.config.ConfigureListener.contextInitialized(ConfigureListener.java:292) at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4688) at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5151) at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183) at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:717) at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:690) at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:705) at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:631) at org.apache.catalina.startup.HostConfig$DeployDescriptor.run(HostConfig.java:1831) at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:515) at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264) at org.apache.tomcat.util.threads.InlineExecutorService.execute(InlineExecutorService.java:75) at java.base/java.util.concurrent.AbstractExecutorService.submit(AbstractExecutorService.java:123) at org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:526) at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:425) at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1576) at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:309) at org.apache.catalina.util.LifecycleBase.fireLifecycleEvent(LifecycleBase.java:123) at org.apache.catalina.util.LifecycleBase.setStateInternal(LifecycleBase.java:423) at org.apache.catalina.util.LifecycleBase.setState(LifecycleBase.java:366) at org.apache.catalina.core.ContainerBase.startInternal(ContainerBase.java:936) at org.apache.catalina.core.StandardHost.startInternal(StandardHost.java:841) at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183) at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1384) at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1374) at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264) at org.apache.tomcat.util.threads.InlineExecutorService.execute(InlineExecutorService.java:75) at java.base/java.util.concurrent.AbstractExecutorService.submit(AbstractExecutorService.java:145) at org.apache.catalina.core.ContainerBase.startInternal(ContainerBase.java:909) at org.apache.catalina.core.StandardEngine.startInternal(StandardEngine.java:262) at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183) at org.apache.catalina.core.StandardService.startInternal(StandardService.java:421) at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183) at org.apache.catalina.core.StandardServer.startInternal(StandardServer.java:930) at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183) at org.apache.catalina.startup.Catalina.start(Catalina.java:633) at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:78) at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.base/java.lang.reflect.Method.invoke(Method.java:567) at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:343) at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:474) Caused by: java.lang.NoClassDefFoundError: javax/xml/bind/JAXB at org.richfaces.javascript.ClientServiceConfigParser.parse(ClientServiceConfigParser.java:81) at org.richfaces.javascript.ClientServiceConfigParser.parseConfig(ClientServiceConfigParser.java:70) at org.richfaces.application.ValidatorModule.createClientScriptService(ValidatorModule.java:65) at org.richfaces.application.ValidatorModule.configure(ValidatorModule.java:60) at org.richfaces.application.ServicesFactoryImpl.init(ServicesFactoryImpl.java:60) at org.richfaces.application.InitializationListener.createFactory(InitializationListener.java:110) at org.richfaces.application.InitializationListener.onStart(InitializationListener.java:69) at org.richfaces.application.InitializationListener.processEvent(InitializationListener.java:167) at javax.faces.event.SystemEvent.processListener(SystemEvent.java:108) at com.sun.faces.application.ApplicationImpl.processListeners(ApplicationImpl.java:2169) at com.sun.faces.application.ApplicationImpl.invokeListenersFor(ApplicationImpl.java:2142) at com.sun.faces.application.ApplicationImpl.publishEvent(ApplicationImpl.java:301) at com.sun.faces.config.ConfigManager.publishPostConfigEvent(ConfigManager.java:704) at com.sun.faces.config.ConfigureListener.contextInitialized(ConfigureListener.java:270) ... 41 more Caused by: java.lang.ClassNotFoundException: javax.xml.bind.JAXB at org.apache.catalina.loader.WebappClassLoaderBase.loadClass(WebappClassLoaderBase.java:1365) at org.apache.catalina.loader.WebappClassLoaderBase.loadClass(WebappClassLoaderBase.java:1188) ... 55 more 16-Jul-2021 19:14:49.525 SEVERE [main] org.apache.catalina.core.StandardContext.listenerStart Exceção ao enviar evento de contexto iniciado para instância listener da classe [com.sun.faces.config.ConfigureListener] java.lang.RuntimeException: java.lang.NoClassDefFoundError: javax/xml/bind/JAXB at com.sun.faces.config.ConfigureListener.contextInitialized(ConfigureListener.java:292) at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4688) at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5151) at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183) at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:717) at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:690) at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:705) at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:631) at org.apache.catalina.startup.HostConfig$DeployDescriptor.run(HostConfig.java:1831) at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:515) at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264) at org.apache.tomcat.util.threads.InlineExecutorService.execute(InlineExecutorService.java:75) at java.base/java.util.concurrent.AbstractExecutorService.submit(AbstractExecutorService.java:123) at org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:526) at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:425) at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1576) at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:309) at org.apache.catalina.util.LifecycleBase.fireLifecycleEvent(LifecycleBase.java:123) at org.apache.catalina.util.LifecycleBase.setStateInternal(LifecycleBase.java:423) at org.apache.catalina.util.LifecycleBase.setState(LifecycleBase.java:366) at org.apache.catalina.core.ContainerBase.startInternal(ContainerBase.java:936) at org.apache.catalina.core.StandardHost.startInternal(StandardHost.java:841) at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183) at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1384) at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1374) at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264) at org.apache.tomcat.util.threads.InlineExecutorService.execute(InlineExecutorService.java:75) at java.base/java.util.concurrent.AbstractExecutorService.submit(AbstractExecutorService.java:145) at org.apache.catalina.core.ContainerBase.startInternal(ContainerBase.java:909) at org.apache.catalina.core.StandardEngine.startInternal(StandardEngine.java:262) at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183) at org.apache.catalina.core.StandardService.startInternal(StandardService.java:421) at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183) at org.apache.catalina.core.StandardServer.startInternal(StandardServer.java:930) at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183) at org.apache.catalina.startup.Catalina.start(Catalina.java:633) at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:78) at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.base/java.lang.reflect.Method.invoke(Method.java:567) at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:343) at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:474) Caused by: java.lang.NoClassDefFoundError: javax/xml/bind/JAXB at org.richfaces.javascript.ClientServiceConfigParser.parse(ClientServiceConfigParser.java:81) at org.richfaces.javascript.ClientServiceConfigParser.parseConfig(ClientServiceConfigParser.java:70) at org.richfaces.application.ValidatorModule.createClientScriptService(ValidatorModule.java:65) at org.richfaces.application.ValidatorModule.configure(ValidatorModule.java:60) at org.richfaces.application.ServicesFactoryImpl.init(ServicesFactoryImpl.java:60) at org.richfaces.application.InitializationListener.createFactory(InitializationListener.java:110) at org.richfaces.application.InitializationListener.onStart(InitializationListener.java:69) at org.richfaces.application.InitializationListener.processEvent(InitializationListener.java:167) at javax.faces.event.SystemEvent.processListener(SystemEvent.java:108) at com.sun.faces.application.ApplicationImpl.processListeners(ApplicationImpl.java:2169) at com.sun.faces.application.ApplicationImpl.invokeListenersFor(ApplicationImpl.java:2142) at com.sun.faces.application.ApplicationImpl.publishEvent(ApplicationImpl.java:301) at com.sun.faces.config.ConfigManager.publishPostConfigEvent(ConfigManager.java:704) at com.sun.faces.config.ConfigureListener.contextInitialized(ConfigureListener.java:270) ... 41 more Caused by: java.lang.ClassNotFoundException: javax.xml.bind.JAXB at org.apache.catalina.loader.WebappClassLoaderBase.loadClass(WebappClassLoaderBase.java:1365) at org.apache.catalina.loader.WebappClassLoaderBase.loadClass(WebappClassLoaderBase.java:1188) ... 55 more
Thanks.