java.io.IOException: java.util.concurrent.ExecutionException: java.io.IOException: HTTP Status 500 Response:
jakarta.servlet.ServletException: org.hibernate.exception.SQLGrammarException: could not prepare statement [Table "FLIGHT" not found; SQL statement: select f1_0.flight_id,c1_0.comp_id,c1_0.name,c2_0.flights_flight_id,c2_1.id,c2_1.address,c2_1.name,t1_0.CUSTOMER_ID,t1_0.id,t1_0.number,f1_0.flight_name from Flight f1_0 left join Company c1_0 on c1_0.comp_id=f1_0.comp_id left join (Flight_Customer c2_0 join Customer c2_1 on c2_1.id=c2_0.customers_id) on f1_0.flight_id=c2_0.flights_flight_id left join Ticket t1_0 on c2_1.id=t1_0.CUSTOMER_ID where f1_0.flight_id=? [42102-214]] [select f1_0.flight_id,c1_0.comp_id,c1_0.name,c2_0.flights_flight_id,c2_1.id,c2_1.address,c2_1.name,t1_0.CUSTOMER_ID,t1_0.id,t1_0.number,f1_0.flight_name from Flight f1_0 left join Company c1_0 on c1_0.comp_id=f1_0.comp_id left join (Flight_Customer c2_0 join Customer c2_1 on c2_1.id=c2_0.customers_id) on f1_0.flight_id=c2_0.flights_flight_id left join Ticket t1_0 on c2_1.id=t1_0.CUSTOMER_ID where f1_0.flight_id=?] at deployment.web_jpa.war//org.jboss.as.test.integration.jpa.webtxem.TestServlet.doGet(TestServlet.java:94) at jakarta.servlet.api@6.0.0//jakarta.servlet.http.HttpServlet.service(HttpServlet.java:527) at jakarta.servlet.api@6.0.0//jakarta.servlet.http.HttpServlet.service(HttpServlet.java:614) at io.undertow.servlet@2.3.5.Final//io.undertow.servlet.handlers.ServletHandler.handleRequest(ServletHandler.java:74) at io.undertow.servlet@2.3.5.Final//io.undertow.servlet.handlers.security.ServletSecurityRoleHandler.handleRequest(ServletSecurityRoleHandler.java:62) at io.undertow.servlet@2.3.5.Final//io.undertow.servlet.handlers.ServletChain$1.handleRequest(ServletChain.java:68) at io.undertow.servlet@2.3.5.Final//io.undertow.servlet.handlers.ServletDispatchingHandler.handleRequest(ServletDispatchingHandler.java:36) at org.wildfly.security.elytron-web.undertow-server@3.0.1.Final//org.wildfly.elytron.web.undertow.server.ElytronRunAsHandler.lambda$handleRequest$1(ElytronRunAsHandler.java:68) at org.wildfly.security.elytron-base@2.1.0.Final//org.wildfly.security.auth.server.FlexibleIdentityAssociation.runAsFunctionEx(FlexibleIdentityAssociation.java:103) at org.wildfly.security.elytron-base@2.1.0.Final//org.wildfly.security.auth.server.Scoped.runAsFunctionEx(Scoped.java:161) at org.wildfly.security.elytron-base@2.1.0.Final//org.wildfly.security.auth.server.Scoped.runAs(Scoped.java:73) at org.wildfly.security.elytron-web.undertow-server@3.0.1.Final//org.wildfly.elytron.web.undertow.server.ElytronRunAsHandler.handleRequest(ElytronRunAsHandler.java:67) at io.undertow.servlet@2.3.5.Final//io.undertow.servlet.handlers.RedirectDirHandler.handleRequest(RedirectDirHandler.java:68) at io.undertow.servlet@2.3.5.Final//io.undertow.servlet.handlers.security.SSLInformationAssociationHandler.handleRequest(SSLInformationAssociationHandler.java:117) at io.undertow.servlet@2.3.5.Final//io.undertow.servlet.handlers.security.ServletAuthenticationCallHandler.handleRequest(ServletAuthenticationCallHandler.java:57) at io.undertow.core@2.3.5.Final//io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43) at io.undertow.core@2.3.5.Final//io.undertow.security.handlers.AbstractConfidentialityHandler.handleRequest(AbstractConfidentialityHandler.java:46) at io.undertow.servlet@2.3.5.Final//io.undertow.servlet.handlers.security.ServletConfidentialityConstraintHandler.handleRequest(ServletConfidentialityConstraintHandler.java:64) at io.undertow.core@2.3.5.Final//io.undertow.security.handlers.AbstractSecurityContextAssociationHandler.handleRequest(AbstractSecurityContextAssociationHandler.java:43) at org.wildfly.security.elytron-web.undertow-server-servlet@3.0.1.Final//org.wildfly.elytron.web.undertow.server.servlet.CleanUpHandler.handleRequest(CleanUpHandler.java:38) at io.undertow.core@2.3.5.Final//io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43) at org.wildfly.extension.undertow@29.0.0.Alpha1-SNAPSHOT//org.wildfly.extension.undertow.security.jacc.JACCContextIdHandler.handleRequest(JACCContextIdHandler.java:61) at io.undertow.core@2.3.5.Final//io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43) at org.wildfly.extension.undertow@29.0.0.Alpha1-SNAPSHOT//org.wildfly.extension.undertow.deployment.GlobalRequestControllerHandler.handleRequest(GlobalRequestControllerHandler.java:68) at io.undertow.servlet@2.3.5.Final//io.undertow.servlet.handlers.SendErrorPageHandler.handleRequest(SendErrorPageHandler.java:52) at io.undertow.core@2.3.5.Final//io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43) at io.undertow.servlet@2.3.5.Final//io.undertow.servlet.handlers.ServletInitialHandler.handleFirstRequest(ServletInitialHandler.java:276) at io.undertow.servlet@2.3.5.Final//io.undertow.servlet.handlers.ServletInitialHandler$2.call(ServletInitialHandler.java:135) at io.undertow.servlet@2.3.5.Final//io.undertow.servlet.handlers.ServletInitialHandler$2.call(ServletInitialHandler.java:132) at io.undertow.servlet@2.3.5.Final//io.undertow.servlet.core.ServletRequestContextThreadSetupAction$1.call(ServletRequestContextThreadSetupAction.java:48) at io.undertow.servlet@2.3.5.Final//io.undertow.servlet.core.ContextClassLoaderSetupAction$1.call(ContextClassLoaderSetupAction.java:43) at org.wildfly.extension.undertow@29.0.0.Alpha1-SNAPSHOT//org.wildfly.extension.undertow.deployment.UndertowDeploymentInfoService$UndertowThreadSetupAction.lambda$create$0(UndertowDeploymentInfoService.java:1430) at org.wildfly.extension.undertow@29.0.0.Alpha1-SNAPSHOT//org.wildfly.extension.undertow.deployment.UndertowDeploymentInfoService$UndertowThreadSetupAction.lambda$create$0(UndertowDeploymentInfoService.java:1430) at org.wildfly.extension.undertow@29.0.0.Alpha1-SNAPSHOT//org.wildfly.extension.undertow.deployment.UndertowDeploymentInfoService$UndertowThreadSetupAction.lambda$create$0(UndertowDeploymentInfoService.java:1430) at org.wildfly.extension.undertow@29.0.0.Alpha1-SNAPSHOT//org.wildfly.extension.undertow.deployment.UndertowDeploymentInfoService$UndertowThreadSetupAction.lambda$create$0(UndertowDeploymentInfoService.java:1430) at org.wildfly.extension.undertow@29.0.0.Alpha1-SNAPSHOT//org.wildfly.extension.undertow.deployment.UndertowDeploymentInfoService$UndertowThreadSetupAction.lambda$create$0(UndertowDeploymentInfoService.java:1430) at io.undertow.servlet@2.3.5.Final//io.undertow.servlet.handlers.ServletInitialHandler.dispatchRequest(ServletInitialHandler.java:256) at io.undertow.servlet@2.3.5.Final//io.undertow.servlet.handlers.ServletInitialHandler$1.handleRequest(ServletInitialHandler.java:101) at io.undertow.core@2.3.5.Final//io.undertow.server.Connectors.executeRootHandler(Connectors.java:393) at io.undertow.core@2.3.5.Final//io.undertow.server.HttpServerExchange$1.run(HttpServerExchange.java:859) at org.jboss.threads@2.4.0.Final//org.jboss.threads.ContextClassLoaderSavingRunnable.run(ContextClassLoaderSavingRunnable.java:35) at org.jboss.threads@2.4.0.Final//org.jboss.threads.EnhancedQueueExecutor.safeRun(EnhancedQueueExecutor.java:1990) at org.jboss.threads@2.4.0.Final//org.jboss.threads.EnhancedQueueExecutor$ThreadBody.doRunTask(EnhancedQueueExecutor.java:1486) at org.jboss.threads@2.4.0.Final//org.jboss.threads.EnhancedQueueExecutor$ThreadBody.run(EnhancedQueueExecutor.java:1377) at org.jboss.xnio@3.8.9.Final//org.xnio.XnioWorker$WorkerThreadFactory$1$1.run(XnioWorker.java:1282) at java.base/java.lang.Thread.run(Thread.java:833) Caused by: org.hibernate.exception.SQLGrammarException: could not prepare statement [Table "FLIGHT" not found; SQL statement: select f1_0.flight_id,c1_0.comp_id,c1_0.name,c2_0.flights_flight_id,c2_1.id,c2_1.address,c2_1.name,t1_0.CUSTOMER_ID,t1_0.id,t1_0.number,f1_0.flight_name from Flight f1_0 left join Company c1_0 on c1_0.comp_id=f1_0.comp_id left join (Flight_Customer c2_0 join Customer c2_1 on c2_1.id=c2_0.customers_id) on f1_0.flight_id=c2_0.flights_flight_id left join Ticket t1_0 on c2_1.id=t1_0.CUSTOMER_ID where f1_0.flight_id=? [42102-214]] [select f1_0.flight_id,c1_0.comp_id,c1_0.name,c2_0.flights_flight_id,c2_1.id,c2_1.address,c2_1.name,t1_0.CUSTOMER_ID,t1_0.id,t1_0.number,f1_0.flight_name from Flight f1_0 left join Company c1_0 on c1_0.comp_id=f1_0.comp_id left join (Flight_Customer c2_0 join Customer c2_1 on c2_1.id=c2_0.customers_id) on f1_0.flight_id=c2_0.flights_flight_id left join Ticket t1_0 on c2_1.id=t1_0.CUSTOMER_ID where f1_0.flight_id=?] at org.hibernate@6.2.2.Final//org.hibernate.exception.internal.SQLExceptionTypeDelegate.convert(SQLExceptionTypeDelegate.java:64) at org.hibernate@6.2.2.Final//org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:56) at org.hibernate@6.2.2.Final//org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:108) at org.hibernate@6.2.2.Final//org.hibernate.engine.jdbc.internal.StatementPreparerImpl$StatementPreparationTemplate.prepareStatement(StatementPreparerImpl.java:187) at org.hibernate@6.2.2.Final//org.hibernate.engine.jdbc.internal.StatementPreparerImpl.prepareStatement(StatementPreparerImpl.java:76) at org.hibernate@6.2.2.Final//org.hibernate.sql.exec.internal.JdbcSelectExecutorStandardImpl.lambda$list$0(JdbcSelectExecutorStandardImpl.java:102) at org.hibernate@6.2.2.Final//org.hibernate.sql.results.jdbc.internal.DeferredResultSetAccess.executeQuery(DeferredResultSetAccess.java:226) at org.hibernate@6.2.2.Final//org.hibernate.sql.results.jdbc.internal.DeferredResultSetAccess.getResultSet(DeferredResultSetAccess.java:163) at org.hibernate@6.2.2.Final//org.hibernate.sql.results.jdbc.internal.JdbcValuesResultSetImpl.advanceNext(JdbcValuesResultSetImpl.java:204) at org.hibernate@6.2.2.Final//org.hibernate.sql.results.jdbc.internal.JdbcValuesResultSetImpl.processNext(JdbcValuesResultSetImpl.java:84) at org.hibernate@6.2.2.Final//org.hibernate.sql.results.jdbc.internal.AbstractJdbcValues.next(AbstractJdbcValues.java:29) at org.hibernate@6.2.2.Final//org.hibernate.sql.results.internal.RowProcessingStateStandardImpl.next(RowProcessingStateStandardImpl.java:65) at org.hibernate@6.2.2.Final//org.hibernate.sql.results.spi.ListResultsConsumer.consume(ListResultsConsumer.java:178) at org.hibernate@6.2.2.Final//org.hibernate.sql.results.spi.ListResultsConsumer.consume(ListResultsConsumer.java:33) at org.hibernate@6.2.2.Final//org.hibernate.sql.exec.internal.JdbcSelectExecutorStandardImpl.doExecuteQuery(JdbcSelectExecutorStandardImpl.java:362) at org.hibernate@6.2.2.Final//org.hibernate.sql.exec.internal.JdbcSelectExecutorStandardImpl.executeQuery(JdbcSelectExecutorStandardImpl.java:168) at org.hibernate@6.2.2.Final//org.hibernate.sql.exec.internal.JdbcSelectExecutorStandardImpl.list(JdbcSelectExecutorStandardImpl.java:93) at org.hibernate@6.2.2.Final//org.hibernate.sql.exec.spi.JdbcSelectExecutor.list(JdbcSelectExecutor.java:31) at org.hibernate@6.2.2.Final//org.hibernate.loader.ast.internal.SingleIdLoadPlan.load(SingleIdLoadPlan.java:145) at org.hibernate@6.2.2.Final//org.hibernate.loader.ast.internal.SingleIdLoadPlan.load(SingleIdLoadPlan.java:117) at org.hibernate@6.2.2.Final//org.hibernate.loader.ast.internal.SingleIdEntityLoaderStandardImpl.load(SingleIdEntityLoaderStandardImpl.java:72) at org.hibernate@6.2.2.Final//org.hibernate.persister.entity.AbstractEntityPersister.doLoad(AbstractEntityPersister.java:3381) at org.hibernate@6.2.2.Final//org.hibernate.persister.entity.AbstractEntityPersister.load(AbstractEntityPersister.java:3371) at org.hibernate@6.2.2.Final//org.hibernate.event.internal.DefaultLoadEventListener.loadFromDatasource(DefaultLoadEventListener.java:602) at org.hibernate@6.2.2.Final//org.hibernate.event.internal.DefaultLoadEventListener.loadFromCacheOrDatasource(DefaultLoadEventListener.java:588) at org.hibernate@6.2.2.Final//org.hibernate.event.internal.DefaultLoadEventListener.load(DefaultLoadEventListener.java:557) at org.hibernate@6.2.2.Final//org.hibernate.event.internal.DefaultLoadEventListener.doLoad(DefaultLoadEventListener.java:550) at org.hibernate@6.2.2.Final//org.hibernate.event.internal.DefaultLoadEventListener.load(DefaultLoadEventListener.java:202) at org.hibernate@6.2.2.Final//org.hibernate.event.internal.DefaultLoadEventListener.proxyOrLoad(DefaultLoadEventListener.java:241) at org.hibernate@6.2.2.Final//org.hibernate.event.internal.DefaultLoadEventListener.doOnLoad(DefaultLoadEventListener.java:106) at org.hibernate@6.2.2.Final//org.hibernate.event.internal.DefaultLoadEventListener.onLoad(DefaultLoadEventListener.java:78) at org.hibernate@6.2.2.Final//org.hibernate.event.service.internal.EventListenerGroupImpl.fireEventOnEachListener(EventListenerGroupImpl.java:138) at org.hibernate@6.2.2.Final//org.hibernate.internal.SessionImpl.fireLoadNoChecks(SessionImpl.java:1231) at org.hibernate@6.2.2.Final//org.hibernate.internal.SessionImpl.fireLoad(SessionImpl.java:1219) at org.hibernate@6.2.2.Final//org.hibernate.loader.internal.IdentifierLoadAccessImpl.doLoad(IdentifierLoadAccessImpl.java:194) at org.hibernate@6.2.2.Final//org.hibernate.loader.internal.IdentifierLoadAccessImpl.lambda$load$1(IdentifierLoadAccessImpl.java:160) at org.hibernate@6.2.2.Final//org.hibernate.loader.internal.IdentifierLoadAccessImpl.perform(IdentifierLoadAccessImpl.java:107) at org.hibernate@6.2.2.Final//org.hibernate.loader.internal.IdentifierLoadAccessImpl.load(IdentifierLoadAccessImpl.java:160) at org.hibernate@6.2.2.Final//org.hibernate.internal.SessionImpl.get(SessionImpl.java:1024) at org.hibernate@6.2.2.Final//org.hibernate.event.internal.DefaultMergeEventListener.lambda$entityIsDetached$0(DefaultMergeEventListener.java:321) at org.hibernate@6.2.2.Final//org.hibernate.engine.spi.LoadQueryInfluencers.fromInternalFetchProfile(LoadQueryInfluencers.java:79) at org.hibernate@6.2.2.Final//org.hibernate.event.internal.DefaultMergeEventListener.entityIsDetached(DefaultMergeEventListener.java:319) at org.hibernate@6.2.2.Final//org.hibernate.event.internal.DefaultMergeEventListener.merge(DefaultMergeEventListener.java:150) at org.hibernate@6.2.2.Final//org.hibernate.event.internal.DefaultMergeEventListener.doMerge(DefaultMergeEventListener.java:143) at org.hibernate@6.2.2.Final//org.hibernate.event.internal.DefaultMergeEventListener.onMerge(DefaultMergeEventListener.java:123) at org.hibernate@6.2.2.Final//org.hibernate.event.internal.DefaultMergeEventListener.onMerge(DefaultMergeEventListener.java:81) at org.hibernate@6.2.2.Final//org.hibernate.event.service.internal.EventListenerGroupImpl.fireEventOnEachListener(EventListenerGroupImpl.java:127) at org.hibernate@6.2.2.Final//org.hibernate.internal.SessionImpl.fireMerge(SessionImpl.java:848) at org.hibernate@6.2.2.Final//org.hibernate.internal.SessionImpl.merge(SessionImpl.java:834) at org.jboss.as.jpa@29.0.0.Alpha1-SNAPSHOT//org.jboss.as.jpa.container.AbstractEntityManager.merge(AbstractEntityManager.java:568) at deployment.web_jpa.war//org.jboss.as.test.integration.jpa.webtxem.TestServlet.doGet(TestServlet.java:70) ... 45 more Caused by: org.h2.jdbc.JdbcSQLSyntaxErrorException: Table "FLIGHT" not found; SQL statement: select f1_0.flight_id,c1_0.comp_id,c1_0.name,c2_0.flights_flight_id,c2_1.id,c2_1.address,c2_1.name,t1_0.CUSTOMER_ID,t1_0.id,t1_0.number,f1_0.flight_name from Flight f1_0 left join Company c1_0 on c1_0.comp_id=f1_0.comp_id left join (Flight_Customer c2_0 join Customer c2_1 on c2_1.id=c2_0.customers_id) on f1_0.flight_id=c2_0.flights_flight_id left join Ticket t1_0 on c2_1.id=t1_0.CUSTOMER_ID where f1_0.flight_id=? [42102-214] at com.h2database.h2@2.1.214//org.h2.message.DbException.getJdbcSQLException(DbException.java:502) at com.h2database.h2@2.1.214//org.h2.message.DbException.getJdbcSQLException(DbException.java:477) at com.h2database.h2@2.1.214//org.h2.message.DbException.get(DbException.java:223) at com.h2database.h2@2.1.214//org.h2.message.DbException.get(DbException.java:199) at com.h2database.h2@2.1.214//org.h2.command.Parser.getTableOrViewNotFoundDbException(Parser.java:8398) at com.h2database.h2@2.1.214//org.h2.command.Parser.getTableOrViewNotFoundDbException(Parser.java:8369) at com.h2database.h2@2.1.214//org.h2.command.Parser.readTableOrView(Parser.java:8358) at com.h2database.h2@2.1.214//org.h2.command.Parser.readTablePrimary(Parser.java:1863) at com.h2database.h2@2.1.214//org.h2.command.Parser.readTableReference(Parser.java:2334) at com.h2database.h2@2.1.214//org.h2.command.Parser.parseSelectFromPart(Parser.java:2772) at com.h2database.h2@2.1.214//org.h2.command.Parser.parseSelect(Parser.java:2878) at com.h2database.h2@2.1.214//org.h2.command.Parser.parseQueryPrimary(Parser.java:2762) at com.h2database.h2@2.1.214//org.h2.command.Parser.parseQueryTerm(Parser.java:2633) at com.h2database.h2@2.1.214//org.h2.command.Parser.parseQueryExpressionBody(Parser.java:2612) at com.h2database.h2@2.1.214//org.h2.command.Parser.parseQueryExpressionBodyAndEndOfQuery(Parser.java:2605) at com.h2database.h2@2.1.214//org.h2.command.Parser.parseQueryExpression(Parser.java:2598) at com.h2database.h2@2.1.214//org.h2.command.Parser.parseQuery(Parser.java:2567) at com.h2database.h2@2.1.214//org.h2.command.Parser.parsePrepared(Parser.java:724) at com.h2database.h2@2.1.214//org.h2.command.Parser.parse(Parser.java:689) at com.h2database.h2@2.1.214//org.h2.command.Parser.parse(Parser.java:661) at com.h2database.h2@2.1.214//org.h2.command.Parser.prepareCommand(Parser.java:569) at com.h2database.h2@2.1.214//org.h2.engine.SessionLocal.prepareLocal(SessionLocal.java:631) at com.h2database.h2@2.1.214//org.h2.engine.SessionLocal.prepareCommand(SessionLocal.java:554) at com.h2database.h2@2.1.214//org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1116) at com.h2database.h2@2.1.214//org.h2.jdbc.JdbcPreparedStatement.<init>(JdbcPreparedStatement.java:92) at com.h2database.h2@2.1.214//org.h2.jdbc.JdbcConnection.prepareStatement(JdbcConnection.java:639) at org.jboss.ironjacamar.jdbcadapters@3.0.2.Final//org.jboss.jca.adapters.jdbc.BaseWrapperManagedConnection.doPrepareStatement(BaseWrapperManagedConnection.java:790) at org.jboss.ironjacamar.jdbcadapters@3.0.2.Final//org.jboss.jca.adapters.jdbc.BaseWrapperManagedConnection.prepareStatement(BaseWrapperManagedConnection.java:776) at org.jboss.ironjacamar.jdbcadapters@3.0.2.Final//org.jboss.jca.adapters.jdbc.WrappedConnection$4.produce(WrappedConnection.java:478) at org.jboss.ironjacamar.jdbcadapters@3.0.2.Final//org.jboss.jca.adapters.jdbc.WrappedConnection$4.produce(WrappedConnection.java:476) at org.jboss.ironjacamar.jdbcadapters@3.0.2.Final//org.jboss.jca.adapters.jdbc.SecurityActions.executeInTccl(SecurityActions.java:103) at org.jboss.ironjacamar.jdbcadapters@3.0.2.Final//org.jboss.jca.adapters.jdbc.WrappedConnection.prepareStatement(WrappedConnection.java:476) at org.hibernate@6.2.2.Final//org.hibernate.engine.jdbc.internal.StatementPreparerImpl$1.doPrepare(StatementPreparerImpl.java:91) at org.hibernate@6.2.2.Final//org.hibernate.engine.jdbc.internal.StatementPreparerImpl$StatementPreparationTemplate.prepareStatement(StatementPreparerImpl.java:177) ... 92 morejava.io.IOException: java.util.concurrent.ExecutionException: java.io.IOException: HTTP Status 500 Response:
jakarta.servlet.ServletException: org.hibernate.exception.SQLGrammarException: could not prepare statement [Table "FLIGHT" not found; SQL statement: select f1_0.flight_id,c1_0.comp_id,c1_0.name,c2_0.flights_flight_id,c2_1.id,c2_1.address,c2_1.name,t1_0.CUSTOMER_ID,t1_0.id,t1_0.number,f1_0.flight_name from Flight f1_0 left join Company c1_0 on c1_0.comp_id=f1_0.comp_id left join (Flight_Customer c2_0 join Customer c2_1 on c2_1.id=c2_0.customers_id) on f1_0.flight_id=c2_0.flights_flight_id left join Ticket t1_0 on c2_1.id=t1_0.CUSTOMER_ID where f1_0.flight_id=? [42102-214]] [select f1_0.flight_id,c1_0.comp_id,c1_0.name,c2_0.flights_flight_id,c2_1.id,c2_1.address,c2_1.name,t1_0.CUSTOMER_ID,t1_0.id,t1_0.number,f1_0.flight_name from Flight f1_0 left join Company c1_0 on c1_0.comp_id=f1_0.comp_id left join (Flight_Customer c2_0 join Customer c2_1 on c2_1.id=c2_0.customers_id) on f1_0.flight_id=c2_0.flights_flight_id left join Ticket t1_0 on c2_1.id=t1_0.CUSTOMER_ID where f1_0.flight_id=?] at deployment.web_jpa.war//org.jboss.as.test.integration.jpa.webtxem.TestServlet.doGet(TestServlet.java:94) at jakarta.servlet.api@6.0.0//jakarta.servlet.http.HttpServlet.service(HttpServlet.java:527) at jakarta.servlet.api@6.0.0//jakarta.servlet.http.HttpServlet.service(HttpServlet.java:614) at io.undertow.servlet@2.3.5.Final//io.undertow.servlet.handlers.ServletHandler.handleRequest(ServletHandler.java:74) at io.undertow.servlet@2.3.5.Final//io.undertow.servlet.handlers.security.ServletSecurityRoleHandler.handleRequest(ServletSecurityRoleHandler.java:62) at io.undertow.servlet@2.3.5.Final//io.undertow.servlet.handlers.ServletChain$1.handleRequest(ServletChain.java:68) at io.undertow.servlet@2.3.5.Final//io.undertow.servlet.handlers.ServletDispatchingHandler.handleRequest(ServletDispatchingHandler.java:36) at org.wildfly.security.elytron-web.undertow-server@3.0.1.Final//org.wildfly.elytron.web.undertow.server.ElytronRunAsHandler.lambda$handleRequest$1(ElytronRunAsHandler.java:68) at org.wildfly.security.elytron-base@2.1.0.Final//org.wildfly.security.auth.server.FlexibleIdentityAssociation.runAsFunctionEx(FlexibleIdentityAssociation.java:103) at org.wildfly.security.elytron-base@2.1.0.Final//org.wildfly.security.auth.server.Scoped.runAsFunctionEx(Scoped.java:161) at org.wildfly.security.elytron-base@2.1.0.Final//org.wildfly.security.auth.server.Scoped.runAs(Scoped.java:73) at org.wildfly.security.elytron-web.undertow-server@3.0.1.Final//org.wildfly.elytron.web.undertow.server.ElytronRunAsHandler.handleRequest(ElytronRunAsHandler.java:67) at io.undertow.servlet@2.3.5.Final//io.undertow.servlet.handlers.RedirectDirHandler.handleRequest(RedirectDirHandler.java:68) at io.undertow.servlet@2.3.5.Final//io.undertow.servlet.handlers.security.SSLInformationAssociationHandler.handleRequest(SSLInformationAssociationHandler.java:117) at io.undertow.servlet@2.3.5.Final//io.undertow.servlet.handlers.security.ServletAuthenticationCallHandler.handleRequest(ServletAuthenticationCallHandler.java:57) at io.undertow.core@2.3.5.Final//io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43) at io.undertow.core@2.3.5.Final//io.undertow.security.handlers.AbstractConfidentialityHandler.handleRequest(AbstractConfidentialityHandler.java:46) at io.undertow.servlet@2.3.5.Final//io.undertow.servlet.handlers.security.ServletConfidentialityConstraintHandler.handleRequest(ServletConfidentialityConstraintHandler.java:64) at io.undertow.core@2.3.5.Final//io.undertow.security.handlers.AbstractSecurityContextAssociationHandler.handleRequest(AbstractSecurityContextAssociationHandler.java:43) at org.wildfly.security.elytron-web.undertow-server-servlet@3.0.1.Final//org.wildfly.elytron.web.undertow.server.servlet.CleanUpHandler.handleRequest(CleanUpHandler.java:38) at io.undertow.core@2.3.5.Final//io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43) at org.wildfly.extension.undertow@29.0.0.Alpha1-SNAPSHOT//org.wildfly.extension.undertow.security.jacc.JACCContextIdHandler.handleRequest(JACCContextIdHandler.java:61) at io.undertow.core@2.3.5.Final//io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43) at org.wildfly.extension.undertow@29.0.0.Alpha1-SNAPSHOT//org.wildfly.extension.undertow.deployment.GlobalRequestControllerHandler.handleRequest(GlobalRequestControllerHandler.java:68) at io.undertow.servlet@2.3.5.Final//io.undertow.servlet.handlers.SendErrorPageHandler.handleRequest(SendErrorPageHandler.java:52) at io.undertow.core@2.3.5.Final//io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43) at io.undertow.servlet@2.3.5.Final//io.undertow.servlet.handlers.ServletInitialHandler.handleFirstRequest(ServletInitialHandler.java:276) at io.undertow.servlet@2.3.5.Final//io.undertow.servlet.handlers.ServletInitialHandler$2.call(ServletInitialHandler.java:135) at io.undertow.servlet@2.3.5.Final//io.undertow.servlet.handlers.ServletInitialHandler$2.call(ServletInitialHandler.java:132) at io.undertow.servlet@2.3.5.Final//io.undertow.servlet.core.ServletRequestContextThreadSetupAction$1.call(ServletRequestContextThreadSetupAction.java:48) at io.undertow.servlet@2.3.5.Final//io.undertow.servlet.core.ContextClassLoaderSetupAction$1.call(ContextClassLoaderSetupAction.java:43) at org.wildfly.extension.undertow@29.0.0.Alpha1-SNAPSHOT//org.wildfly.extension.undertow.deployment.UndertowDeploymentInfoService$UndertowThreadSetupAction.lambda$create$0(UndertowDeploymentInfoService.java:1430) at org.wildfly.extension.undertow@29.0.0.Alpha1-SNAPSHOT//org.wildfly.extension.undertow.deployment.UndertowDeploymentInfoService$UndertowThreadSetupAction.lambda$create$0(UndertowDeploymentInfoService.java:1430) at org.wildfly.extension.undertow@29.0.0.Alpha1-SNAPSHOT//org.wildfly.extension.undertow.deployment.UndertowDeploymentInfoService$UndertowThreadSetupAction.lambda$create$0(UndertowDeploymentInfoService.java:1430) at org.wildfly.extension.undertow@29.0.0.Alpha1-SNAPSHOT//org.wildfly.extension.undertow.deployment.UndertowDeploymentInfoService$UndertowThreadSetupAction.lambda$create$0(UndertowDeploymentInfoService.java:1430) at org.wildfly.extension.undertow@29.0.0.Alpha1-SNAPSHOT//org.wildfly.extension.undertow.deployment.UndertowDeploymentInfoService$UndertowThreadSetupAction.lambda$create$0(UndertowDeploymentInfoService.java:1430) at io.undertow.servlet@2.3.5.Final//io.undertow.servlet.handlers.ServletInitialHandler.dispatchRequest(ServletInitialHandler.java:256) at io.undertow.servlet@2.3.5.Final//io.undertow.servlet.handlers.ServletInitialHandler$1.handleRequest(ServletInitialHandler.java:101) at io.undertow.core@2.3.5.Final//io.undertow.server.Connectors.executeRootHandler(Connectors.java:393) at io.undertow.core@2.3.5.Final//io.undertow.server.HttpServerExchange$1.run(HttpServerExchange.java:859) at org.jboss.threads@2.4.0.Final//org.jboss.threads.ContextClassLoaderSavingRunnable.run(ContextClassLoaderSavingRunnable.java:35) at org.jboss.threads@2.4.0.Final//org.jboss.threads.EnhancedQueueExecutor.safeRun(EnhancedQueueExecutor.java:1990) at org.jboss.threads@2.4.0.Final//org.jboss.threads.EnhancedQueueExecutor$ThreadBody.doRunTask(EnhancedQueueExecutor.java:1486) at org.jboss.threads@2.4.0.Final//org.jboss.threads.EnhancedQueueExecutor$ThreadBody.run(EnhancedQueueExecutor.java:1377) at org.jboss.xnio@3.8.9.Final//org.xnio.XnioWorker$WorkerThreadFactory$1$1.run(XnioWorker.java:1282) at java.base/java.lang.Thread.run(Thread.java:833) Caused by: org.hibernate.exception.SQLGrammarException: could not prepare statement [Table "FLIGHT" not found; SQL statement: select f1_0.flight_id,c1_0.comp_id,c1_0.name,c2_0.flights_flight_id,c2_1.id,c2_1.address,c2_1.name,t1_0.CUSTOMER_ID,t1_0.id,t1_0.number,f1_0.flight_name from Flight f1_0 left join Company c1_0 on c1_0.comp_id=f1_0.comp_id left join (Flight_Customer c2_0 join Customer c2_1 on c2_1.id=c2_0.customers_id) on f1_0.flight_id=c2_0.flights_flight_id left join Ticket t1_0 on c2_1.id=t1_0.CUSTOMER_ID where f1_0.flight_id=? [42102-214]] [select f1_0.flight_id,c1_0.comp_id,c1_0.name,c2_0.flights_flight_id,c2_1.id,c2_1.address,c2_1.name,t1_0.CUSTOMER_ID,t1_0.id,t1_0.number,f1_0.flight_name from Flight f1_0 left join Company c1_0 on c1_0.comp_id=f1_0.comp_id left join (Flight_Customer c2_0 join Customer c2_1 on c2_1.id=c2_0.customers_id) on f1_0.flight_id=c2_0.flights_flight_id left join Ticket t1_0 on c2_1.id=t1_0.CUSTOMER_ID where f1_0.flight_id=?] at org.hibernate@6.2.2.Final//org.hibernate.exception.internal.SQLExceptionTypeDelegate.convert(SQLExceptionTypeDelegate.java:64) at org.hibernate@6.2.2.Final//org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:56) at org.hibernate@6.2.2.Final//org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:108) at org.hibernate@6.2.2.Final//org.hibernate.engine.jdbc.internal.StatementPreparerImpl$StatementPreparationTemplate.prepareStatement(StatementPreparerImpl.java:187) at org.hibernate@6.2.2.Final//org.hibernate.engine.jdbc.internal.StatementPreparerImpl.prepareStatement(StatementPreparerImpl.java:76) at org.hibernate@6.2.2.Final//org.hibernate.sql.exec.internal.JdbcSelectExecutorStandardImpl.lambda$list$0(JdbcSelectExecutorStandardImpl.java:102) at org.hibernate@6.2.2.Final//org.hibernate.sql.results.jdbc.internal.DeferredResultSetAccess.executeQuery(DeferredResultSetAccess.java:226) at org.hibernate@6.2.2.Final//org.hibernate.sql.results.jdbc.internal.DeferredResultSetAccess.getResultSet(DeferredResultSetAccess.java:163) at org.hibernate@6.2.2.Final//org.hibernate.sql.results.jdbc.internal.JdbcValuesResultSetImpl.advanceNext(JdbcValuesResultSetImpl.java:204) at org.hibernate@6.2.2.Final//org.hibernate.sql.results.jdbc.internal.JdbcValuesResultSetImpl.processNext(JdbcValuesResultSetImpl.java:84) at org.hibernate@6.2.2.Final//org.hibernate.sql.results.jdbc.internal.AbstractJdbcValues.next(AbstractJdbcValues.java:29) at org.hibernate@6.2.2.Final//org.hibernate.sql.results.internal.RowProcessingStateStandardImpl.next(RowProcessingStateStandardImpl.java:65) at org.hibernate@6.2.2.Final//org.hibernate.sql.results.spi.ListResultsConsumer.consume(ListResultsConsumer.java:178) at org.hibernate@6.2.2.Final//org.hibernate.sql.results.spi.ListResultsConsumer.consume(ListResultsConsumer.java:33) at org.hibernate@6.2.2.Final//org.hibernate.sql.exec.internal.JdbcSelectExecutorStandardImpl.doExecuteQuery(JdbcSelectExecutorStandardImpl.java:362) at org.hibernate@6.2.2.Final//org.hibernate.sql.exec.internal.JdbcSelectExecutorStandardImpl.executeQuery(JdbcSelectExecutorStandardImpl.java:168) at org.hibernate@6.2.2.Final//org.hibernate.sql.exec.internal.JdbcSelectExecutorStandardImpl.list(JdbcSelectExecutorStandardImpl.java:93) at org.hibernate@6.2.2.Final//org.hibernate.sql.exec.spi.JdbcSelectExecutor.list(JdbcSelectExecutor.java:31) at org.hibernate@6.2.2.Final//org.hibernate.loader.ast.internal.SingleIdLoadPlan.load(SingleIdLoadPlan.java:145) at org.hibernate@6.2.2.Final//org.hibernate.loader.ast.internal.SingleIdLoadPlan.load(SingleIdLoadPlan.java:117) at org.hibernate@6.2.2.Final//org.hibernate.loader.ast.internal.SingleIdEntityLoaderStandardImpl.load(SingleIdEntityLoaderStandardImpl.java:72) at org.hibernate@6.2.2.Final//org.hibernate.persister.entity.AbstractEntityPersister.doLoad(AbstractEntityPersister.java:3381) at org.hibernate@6.2.2.Final//org.hibernate.persister.entity.AbstractEntityPersister.load(AbstractEntityPersister.java:3371) at org.hibernate@6.2.2.Final//org.hibernate.event.internal.DefaultLoadEventListener.loadFromDatasource(DefaultLoadEventListener.java:602) at org.hibernate@6.2.2.Final//org.hibernate.event.internal.DefaultLoadEventListener.loadFromCacheOrDatasource(DefaultLoadEventListener.java:588) at org.hibernate@6.2.2.Final//org.hibernate.event.internal.DefaultLoadEventListener.load(DefaultLoadEventListener.java:557) at org.hibernate@6.2.2.Final//org.hibernate.event.internal.DefaultLoadEventListener.doLoad(DefaultLoadEventListener.java:550) at org.hibernate@6.2.2.Final//org.hibernate.event.internal.DefaultLoadEventListener.load(DefaultLoadEventListener.java:202) at org.hibernate@6.2.2.Final//org.hibernate.event.internal.DefaultLoadEventListener.proxyOrLoad(DefaultLoadEventListener.java:241) at org.hibernate@6.2.2.Final//org.hibernate.event.internal.DefaultLoadEventListener.doOnLoad(DefaultLoadEventListener.java:106) at org.hibernate@6.2.2.Final//org.hibernate.event.internal.DefaultLoadEventListener.onLoad(DefaultLoadEventListener.java:78) at org.hibernate@6.2.2.Final//org.hibernate.event.service.internal.EventListenerGroupImpl.fireEventOnEachListener(EventListenerGroupImpl.java:138) at org.hibernate@6.2.2.Final//org.hibernate.internal.SessionImpl.fireLoadNoChecks(SessionImpl.java:1231) at org.hibernate@6.2.2.Final//org.hibernate.internal.SessionImpl.fireLoad(SessionImpl.java:1219) at org.hibernate@6.2.2.Final//org.hibernate.loader.internal.IdentifierLoadAccessImpl.doLoad(IdentifierLoadAccessImpl.java:194) at org.hibernate@6.2.2.Final//org.hibernate.loader.internal.IdentifierLoadAccessImpl.lambda$load$1(IdentifierLoadAccessImpl.java:160) at org.hibernate@6.2.2.Final//org.hibernate.loader.internal.IdentifierLoadAccessImpl.perform(IdentifierLoadAccessImpl.java:107) at org.hibernate@6.2.2.Final//org.hibernate.loader.internal.IdentifierLoadAccessImpl.load(IdentifierLoadAccessImpl.java:160) at org.hibernate@6.2.2.Final//org.hibernate.internal.SessionImpl.get(SessionImpl.java:1024) at org.hibernate@6.2.2.Final//org.hibernate.event.internal.DefaultMergeEventListener.lambda$entityIsDetached$0(DefaultMergeEventListener.java:321) at org.hibernate@6.2.2.Final//org.hibernate.engine.spi.LoadQueryInfluencers.fromInternalFetchProfile(LoadQueryInfluencers.java:79) at org.hibernate@6.2.2.Final//org.hibernate.event.internal.DefaultMergeEventListener.entityIsDetached(DefaultMergeEventListener.java:319) at org.hibernate@6.2.2.Final//org.hibernate.event.internal.DefaultMergeEventListener.merge(DefaultMergeEventListener.java:150) at org.hibernate@6.2.2.Final//org.hibernate.event.internal.DefaultMergeEventListener.doMerge(DefaultMergeEventListener.java:143) at org.hibernate@6.2.2.Final//org.hibernate.event.internal.DefaultMergeEventListener.onMerge(DefaultMergeEventListener.java:123) at org.hibernate@6.2.2.Final//org.hibernate.event.internal.DefaultMergeEventListener.onMerge(DefaultMergeEventListener.java:81) at org.hibernate@6.2.2.Final//org.hibernate.event.service.internal.EventListenerGroupImpl.fireEventOnEachListener(EventListenerGroupImpl.java:127) at org.hibernate@6.2.2.Final//org.hibernate.internal.SessionImpl.fireMerge(SessionImpl.java:848) at org.hibernate@6.2.2.Final//org.hibernate.internal.SessionImpl.merge(SessionImpl.java:834) at org.jboss.as.jpa@29.0.0.Alpha1-SNAPSHOT//org.jboss.as.jpa.container.AbstractEntityManager.merge(AbstractEntityManager.java:568) at deployment.web_jpa.war//org.jboss.as.test.integration.jpa.webtxem.TestServlet.doGet(TestServlet.java:70) ... 45 more Caused by: org.h2.jdbc.JdbcSQLSyntaxErrorException: Table "FLIGHT" not found; SQL statement: select f1_0.flight_id,c1_0.comp_id,c1_0.name,c2_0.flights_flight_id,c2_1.id,c2_1.address,c2_1.name,t1_0.CUSTOMER_ID,t1_0.id,t1_0.number,f1_0.flight_name from Flight f1_0 left join Company c1_0 on c1_0.comp_id=f1_0.comp_id left join (Flight_Customer c2_0 join Customer c2_1 on c2_1.id=c2_0.customers_id) on f1_0.flight_id=c2_0.flights_flight_id left join Ticket t1_0 on c2_1.id=t1_0.CUSTOMER_ID where f1_0.flight_id=? [42102-214] at com.h2database.h2@2.1.214//org.h2.message.DbException.getJdbcSQLException(DbException.java:502) at com.h2database.h2@2.1.214//org.h2.message.DbException.getJdbcSQLException(DbException.java:477) at com.h2database.h2@2.1.214//org.h2.message.DbException.get(DbException.java:223) at com.h2database.h2@2.1.214//org.h2.message.DbException.get(DbException.java:199) at com.h2database.h2@2.1.214//org.h2.command.Parser.getTableOrViewNotFoundDbException(Parser.java:8398) at com.h2database.h2@2.1.214//org.h2.command.Parser.getTableOrViewNotFoundDbException(Parser.java:8369) at com.h2database.h2@2.1.214//org.h2.command.Parser.readTableOrView(Parser.java:8358) at com.h2database.h2@2.1.214//org.h2.command.Parser.readTablePrimary(Parser.java:1863) at com.h2database.h2@2.1.214//org.h2.command.Parser.readTableReference(Parser.java:2334) at com.h2database.h2@2.1.214//org.h2.command.Parser.parseSelectFromPart(Parser.java:2772) at com.h2database.h2@2.1.214//org.h2.command.Parser.parseSelect(Parser.java:2878) at com.h2database.h2@2.1.214//org.h2.command.Parser.parseQueryPrimary(Parser.java:2762) at com.h2database.h2@2.1.214//org.h2.command.Parser.parseQueryTerm(Parser.java:2633) at com.h2database.h2@2.1.214//org.h2.command.Parser.parseQueryExpressionBody(Parser.java:2612) at com.h2database.h2@2.1.214//org.h2.command.Parser.parseQueryExpressionBodyAndEndOfQuery(Parser.java:2605) at com.h2database.h2@2.1.214//org.h2.command.Parser.parseQueryExpression(Parser.java:2598) at com.h2database.h2@2.1.214//org.h2.command.Parser.parseQuery(Parser.java:2567) at com.h2database.h2@2.1.214//org.h2.command.Parser.parsePrepared(Parser.java:724) at com.h2database.h2@2.1.214//org.h2.command.Parser.parse(Parser.java:689) at com.h2database.h2@2.1.214//org.h2.command.Parser.parse(Parser.java:661) at com.h2database.h2@2.1.214//org.h2.command.Parser.prepareCommand(Parser.java:569) at com.h2database.h2@2.1.214//org.h2.engine.SessionLocal.prepareLocal(SessionLocal.java:631) at com.h2database.h2@2.1.214//org.h2.engine.SessionLocal.prepareCommand(SessionLocal.java:554) at com.h2database.h2@2.1.214//org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1116) at com.h2database.h2@2.1.214//org.h2.jdbc.JdbcPreparedStatement.<init>(JdbcPreparedStatement.java:92) at com.h2database.h2@2.1.214//org.h2.jdbc.JdbcConnection.prepareStatement(JdbcConnection.java:639) at org.jboss.ironjacamar.jdbcadapters@3.0.2.Final//org.jboss.jca.adapters.jdbc.BaseWrapperManagedConnection.doPrepareStatement(BaseWrapperManagedConnection.java:790) at org.jboss.ironjacamar.jdbcadapters@3.0.2.Final//org.jboss.jca.adapters.jdbc.BaseWrapperManagedConnection.prepareStatement(BaseWrapperManagedConnection.java:776) at org.jboss.ironjacamar.jdbcadapters@3.0.2.Final//org.jboss.jca.adapters.jdbc.WrappedConnection$4.produce(WrappedConnection.java:478) at org.jboss.ironjacamar.jdbcadapters@3.0.2.Final//org.jboss.jca.adapters.jdbc.WrappedConnection$4.produce(WrappedConnection.java:476) at org.jboss.ironjacamar.jdbcadapters@3.0.2.Final//org.jboss.jca.adapters.jdbc.SecurityActions.executeInTccl(SecurityActions.java:103) at org.jboss.ironjacamar.jdbcadapters@3.0.2.Final//org.jboss.jca.adapters.jdbc.WrappedConnection.prepareStatement(WrappedConnection.java:476) at org.hibernate@6.2.2.Final//org.hibernate.engine.jdbc.internal.StatementPreparerImpl$1.doPrepare(StatementPreparerImpl.java:91) at org.hibernate@6.2.2.Final//org.hibernate.engine.jdbc.internal.StatementPreparerImpl$StatementPreparationTemplate.prepareStatement(StatementPreparerImpl.java:177) ... 92 moreat org.jboss.as.test.integration.common.HttpRequest.execute(HttpRequest.java:61) at org.jboss.as.test.integration.common.HttpRequest.get(HttpRequest.java:82) at org.jboss.as.test.integration.jpa.webtxem.WebJPATestCase.performCall(WebJPATestCase.java:73) at org.jboss.as.test.integration.jpa.webtxem.WebJPATestCase.testReadWrite(WebJPATestCase.java:78) 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.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:59) at org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:12) at org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:56) at org.jboss.arquillian.junit.Arquillian$8$1.invokeMethod(Arquillian.java:325) at org.jboss.arquillian.junit.MethodInvoker$1.invoke(MethodInvoker.java:18) at org.jboss.arquillian.container.test.impl.execution.LocalTestExecuter.execute(LocalTestExecuter.java:57) at jdk.internal.reflect.GeneratedMethodAccessor27.invoke(Unknown Source) 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.arquillian.core.impl.ObserverImpl.invoke(ObserverImpl.java:86) at org.jboss.arquillian.core.impl.EventContextImpl.invokeObservers(EventContextImpl.java:103) at org.jboss.arquillian.core.impl.EventContextImpl.proceed(EventContextImpl.java:90) at org.jboss.arquillian.core.impl.ManagerImpl.fire(ManagerImpl.java:133) at org.jboss.arquillian.core.impl.ManagerImpl.fire(ManagerImpl.java:105) at org.jboss.arquillian.core.impl.EventImpl.fire(EventImpl.java:62) at org.jboss.arquillian.container.test.impl.execution.ClientTestExecuter.execute(ClientTestExecuter.java:50) at jdk.internal.reflect.GeneratedMethodAccessor17.invoke(Unknown Source) 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.arquillian.core.impl.ObserverImpl.invoke(ObserverImpl.java:86) at org.jboss.arquillian.core.impl.EventContextImpl.invokeObservers(EventContextImpl.java:103) at org.jboss.arquillian.core.impl.EventContextImpl.proceed(EventContextImpl.java:90) at org.jboss.arquillian.container.test.impl.client.ContainerEventController.createContext(ContainerEventController.java:128) at org.jboss.arquillian.container.test.impl.client.ContainerEventController.createTestContext(ContainerEventController.java:118) at jdk.internal.reflect.GeneratedMethodAccessor16.invoke(Unknown Source) 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.arquillian.core.impl.ObserverImpl.invoke(ObserverImpl.java:86) at org.jboss.arquillian.core.impl.EventContextImpl.proceed(EventContextImpl.java:95) at org.jboss.arquillian.test.impl.TestContextHandler.createTestContext(TestContextHandler.java:116) at jdk.internal.reflect.GeneratedMethodAccessor4.invoke(Unknown Source) 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.arquillian.core.impl.ObserverImpl.invoke(ObserverImpl.java:86) at org.jboss.arquillian.core.impl.EventContextImpl.proceed(EventContextImpl.java:95) at org.jboss.arquillian.test.impl.TestContextHandler.createClassContext(TestContextHandler.java:83) at jdk.internal.reflect.GeneratedMethodAccessor3.invoke(Unknown Source) 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.arquillian.core.impl.ObserverImpl.invoke(ObserverImpl.java:86) at org.jboss.arquillian.core.impl.EventContextImpl.proceed(EventContextImpl.java:95) at org.jboss.arquillian.test.impl.TestContextHandler.createSuiteContext(TestContextHandler.java:69) at jdk.internal.reflect.GeneratedMethodAccessor2.invoke(Unknown Source) 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.arquillian.core.impl.ObserverImpl.invoke(ObserverImpl.java:86) at org.jboss.arquillian.core.impl.EventContextImpl.proceed(EventContextImpl.java:95) at org.jboss.arquillian.core.impl.ManagerImpl.fire(ManagerImpl.java:133) at org.jboss.arquillian.test.impl.EventTestRunnerAdaptor.test(EventTestRunnerAdaptor.java:139) at org.jboss.arquillian.junit.MethodInvoker.invoke(MethodInvoker.java:15) at org.jboss.arquillian.junit.Arquillian$8.evaluate(Arquillian.java:332) at org.jboss.arquillian.junit.Arquillian$4.evaluate(Arquillian.java:204) at org.jboss.arquillian.junit.Arquillian.multiExecute(Arquillian.java:350) at org.jboss.arquillian.junit.Arquillian.access$200(Arquillian.java:54) at org.jboss.arquillian.junit.Arquillian$5.evaluate(Arquillian.java:215) at org.jboss.arquillian.junit.Arquillian$7$1.invoke(Arquillian.java:279) at org.jboss.arquillian.container.test.impl.execution.ClientBeforeAfterLifecycleEventExecuter.execute(ClientBeforeAfterLifecycleEventExecuter.java:88) at org.jboss.arquillian.container.test.impl.execution.ClientBeforeAfterLifecycleEventExecuter.on(ClientBeforeAfterLifecycleEventExecuter.java:66) at jdk.internal.reflect.GeneratedMethodAccessor6.invoke(Unknown Source) 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.arquillian.core.impl.ObserverImpl.invoke(ObserverImpl.java:86) at org.jboss.arquillian.core.impl.EventContextImpl.invokeObservers(EventContextImpl.java:103) at org.jboss.arquillian.core.impl.EventContextImpl.proceed(EventContextImpl.java:90) at org.jboss.arquillian.container.test.impl.client.ContainerEventController.createContext(ContainerEventController.java:128) at org.jboss.arquillian.container.test.impl.client.ContainerEventController.createBeforeContext(ContainerEventController.java:114) at jdk.internal.reflect.GeneratedMethodAccessor5.invoke(Unknown Source) 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.arquillian.core.impl.ObserverImpl.invoke(ObserverImpl.java:86) at org.jboss.arquillian.core.impl.EventContextImpl.proceed(EventContextImpl.java:95) at org.jboss.arquillian.test.impl.TestContextHandler.createTestContext(TestContextHandler.java:116) at jdk.internal.reflect.GeneratedMethodAccessor4.invoke(Unknown Source) 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.arquillian.core.impl.ObserverImpl.invoke(ObserverImpl.java:86) at org.jboss.arquillian.core.impl.EventContextImpl.proceed(EventContextImpl.java:95) at org.jboss.arquillian.test.impl.TestContextHandler.createClassContext(TestContextHandler.java:83) at jdk.internal.reflect.GeneratedMethodAccessor3.invoke(Unknown Source) 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.arquillian.core.impl.ObserverImpl.invoke(ObserverImpl.java:86) at org.jboss.arquillian.core.impl.EventContextImpl.proceed(EventContextImpl.java:95) at org.jboss.arquillian.test.impl.TestContextHandler.createSuiteContext(TestContextHandler.java:69) at jdk.internal.reflect.GeneratedMethodAccessor2.invoke(Unknown Source) 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.arquillian.core.impl.ObserverImpl.invoke(ObserverImpl.java:86) at org.jboss.arquillian.core.impl.EventContextImpl.proceed(EventContextImpl.java:95) at org.jboss.arquillian.core.impl.ManagerImpl.fire(ManagerImpl.java:133) at org.jboss.arquillian.core.impl.ManagerImpl.fire(ManagerImpl.java:105) at org.jboss.arquillian.test.impl.EventTestRunnerAdaptor.fireCustomLifecycle(EventTestRunnerAdaptor.java:159) at org.jboss.arquillian.junit.Arquillian$7.evaluate(Arquillian.java:273) at org.junit.runners.BlockJUnit4ClassRunner$1.evaluate(BlockJUnit4ClassRunner.java:100) at org.junit.runners.ParentRunner.runLeaf(ParentRunner.java:366) at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:103) at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:63) at org.junit.runners.ParentRunner$4.run(ParentRunner.java:331) at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:79) at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:329) at org.junit.runners.ParentRunner.access$100(ParentRunner.java:66) at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:293) at org.jboss.arquillian.junit.Arquillian$2.evaluate(Arquillian.java:166) at org.jboss.arquillian.junit.Arquillian.multiExecute(Arquillian.java:350) at org.jboss.arquillian.junit.Arquillian.access$200(Arquillian.java:54) at org.jboss.arquillian.junit.Arquillian$3.evaluate(Arquillian.java:177) at org.junit.runners.ParentRunner$3.evaluate(ParentRunner.java:306) at org.junit.runners.ParentRunner.run(ParentRunner.java:413) at org.jboss.arquillian.junit.Arquillian.run(Arquillian.java:115) at org.apache.maven.surefire.junit4.JUnit4Provider.execute(JUnit4Provider.java:365) at org.apache.maven.surefire.junit4.JUnit4Provider.executeWithRerun(JUnit4Provider.java:273) at org.apache.maven.surefire.junit4.JUnit4Provider.executeTestSet(JUnit4Provider.java:238) at org.apache.maven.surefire.junit4.JUnit4Provider.invoke(JUnit4Provider.java:159) at org.apache.maven.surefire.booter.ForkedBooter.invokeProviderInSameClassLoader(ForkedBooter.java:384) at org.apache.maven.surefire.booter.ForkedBooter.runSuitesInProcess(ForkedBooter.java:345) at org.apache.maven.surefire.booter.ForkedBooter.execute(ForkedBooter.java:126) at org.apache.maven.surefire.booter.ForkedBooter.main(ForkedBooter.java:418) Caused by: java.util.concurrent.ExecutionException: java.io.IOException: HTTP Status 500 Response:
jakarta.servlet.ServletException: org.hibernate.exception.SQLGrammarException: could not prepare statement [Table "FLIGHT" not found; SQL statement: select f1_0.flight_id,c1_0.comp_id,c1_0.name,c2_0.flights_flight_id,c2_1.id,c2_1.address,c2_1.name,t1_0.CUSTOMER_ID,t1_0.id,t1_0.number,f1_0.flight_name from Flight f1_0 left join Company c1_0 on c1_0.comp_id=f1_0.comp_id left join (Flight_Customer c2_0 join Customer c2_1 on c2_1.id=c2_0.customers_id) on f1_0.flight_id=c2_0.flights_flight_id left join Ticket t1_0 on c2_1.id=t1_0.CUSTOMER_ID where f1_0.flight_id=? [42102-214]] [select f1_0.flight_id,c1_0.comp_id,c1_0.name,c2_0.flights_flight_id,c2_1.id,c2_1.address,c2_1.name,t1_0.CUSTOMER_ID,t1_0.id,t1_0.number,f1_0.flight_name from Flight f1_0 left join Company c1_0 on c1_0.comp_id=f1_0.comp_id left join (Flight_Customer c2_0 join Customer c2_1 on c2_1.id=c2_0.customers_id) on f1_0.flight_id=c2_0.flights_flight_id left join Ticket t1_0 on c2_1.id=t1_0.CUSTOMER_ID where f1_0.flight_id=?] at deployment.web_jpa.war//org.jboss.as.test.integration.jpa.webtxem.TestServlet.doGet(TestServlet.java:94) at jakarta.servlet.api@6.0.0//jakarta.servlet.http.HttpServlet.service(HttpServlet.java:527) at jakarta.servlet.api@6.0.0//jakarta.servlet.http.HttpServlet.service(HttpServlet.java:614) at io.undertow.servlet@2.3.5.Final//io.undertow.servlet.handlers.ServletHandler.handleRequest(ServletHandler.java:74) at io.undertow.servlet@2.3.5.Final//io.undertow.servlet.handlers.security.ServletSecurityRoleHandler.handleRequest(ServletSecurityRoleHandler.java:62) at io.undertow.servlet@2.3.5.Final//io.undertow.servlet.handlers.ServletChain$1.handleRequest(ServletChain.java:68) at io.undertow.servlet@2.3.5.Final//io.undertow.servlet.handlers.ServletDispatchingHandler.handleRequest(ServletDispatchingHandler.java:36) at org.wildfly.security.elytron-web.undertow-server@3.0.1.Final//org.wildfly.elytron.web.undertow.server.ElytronRunAsHandler.lambda$handleRequest$1(ElytronRunAsHandler.java:68) at org.wildfly.security.elytron-base@2.1.0.Final//org.wildfly.security.auth.server.FlexibleIdentityAssociation.runAsFunctionEx(FlexibleIdentityAssociation.java:103) at org.wildfly.security.elytron-base@2.1.0.Final//org.wildfly.security.auth.server.Scoped.runAsFunctionEx(Scoped.java:161) at org.wildfly.security.elytron-base@2.1.0.Final//org.wildfly.security.auth.server.Scoped.runAs(Scoped.java:73) at org.wildfly.security.elytron-web.undertow-server@3.0.1.Final//org.wildfly.elytron.web.undertow.server.ElytronRunAsHandler.handleRequest(ElytronRunAsHandler.java:67) at io.undertow.servlet@2.3.5.Final//io.undertow.servlet.handlers.RedirectDirHandler.handleRequest(RedirectDirHandler.java:68) at io.undertow.servlet@2.3.5.Final//io.undertow.servlet.handlers.security.SSLInformationAssociationHandler.handleRequest(SSLInformationAssociationHandler.java:117) at io.undertow.servlet@2.3.5.Final//io.undertow.servlet.handlers.security.ServletAuthenticationCallHandler.handleRequest(ServletAuthenticationCallHandler.java:57) at io.undertow.core@2.3.5.Final//io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43) at io.undertow.core@2.3.5.Final//io.undertow.security.handlers.AbstractConfidentialityHandler.handleRequest(AbstractConfidentialityHandler.java:46) at io.undertow.servlet@2.3.5.Final//io.undertow.servlet.handlers.security.ServletConfidentialityConstraintHandler.handleRequest(ServletConfidentialityConstraintHandler.java:64) at io.undertow.core@2.3.5.Final//io.undertow.security.handlers.AbstractSecurityContextAssociationHandler.handleRequest(AbstractSecurityContextAssociationHandler.java:43) at org.wildfly.security.elytron-web.undertow-server-servlet@3.0.1.Final//org.wildfly.elytron.web.undertow.server.servlet.CleanUpHandler.handleRequest(CleanUpHandler.java:38) at io.undertow.core@2.3.5.Final//io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43) at org.wildfly.extension.undertow@29.0.0.Alpha1-SNAPSHOT//org.wildfly.extension.undertow.security.jacc.JACCContextIdHandler.handleRequest(JACCContextIdHandler.java:61) at io.undertow.core@2.3.5.Final//io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43) at org.wildfly.extension.undertow@29.0.0.Alpha1-SNAPSHOT//org.wildfly.extension.undertow.deployment.GlobalRequestControllerHandler.handleRequest(GlobalRequestControllerHandler.java:68) at io.undertow.servlet@2.3.5.Final//io.undertow.servlet.handlers.SendErrorPageHandler.handleRequest(SendErrorPageHandler.java:52) at io.undertow.core@2.3.5.Final//io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43) at io.undertow.servlet@2.3.5.Final//io.undertow.servlet.handlers.ServletInitialHandler.handleFirstRequest(ServletInitialHandler.java:276) at io.undertow.servlet@2.3.5.Final//io.undertow.servlet.handlers.ServletInitialHandler$2.call(ServletInitialHandler.java:135) at io.undertow.servlet@2.3.5.Final//io.undertow.servlet.handlers.ServletInitialHandler$2.call(ServletInitialHandler.java:132) at io.undertow.servlet@2.3.5.Final//io.undertow.servlet.core.ServletRequestContextThreadSetupAction$1.call(ServletRequestContextThreadSetupAction.java:48) at io.undertow.servlet@2.3.5.Final//io.undertow.servlet.core.ContextClassLoaderSetupAction$1.call(ContextClassLoaderSetupAction.java:43) at org.wildfly.extension.undertow@29.0.0.Alpha1-SNAPSHOT//org.wildfly.extension.undertow.deployment.UndertowDeploymentInfoService$UndertowThreadSetupAction.lambda$create$0(UndertowDeploymentInfoService.java:1430) at org.wildfly.extension.undertow@29.0.0.Alpha1-SNAPSHOT//org.wildfly.extension.undertow.deployment.UndertowDeploymentInfoService$UndertowThreadSetupAction.lambda$create$0(UndertowDeploymentInfoService.java:1430) at org.wildfly.extension.undertow@29.0.0.Alpha1-SNAPSHOT//org.wildfly.extension.undertow.deployment.UndertowDeploymentInfoService$UndertowThreadSetupAction.lambda$create$0(UndertowDeploymentInfoService.java:1430) at org.wildfly.extension.undertow@29.0.0.Alpha1-SNAPSHOT//org.wildfly.extension.undertow.deployment.UndertowDeploymentInfoService$UndertowThreadSetupAction.lambda$create$0(UndertowDeploymentInfoService.java:1430) at org.wildfly.extension.undertow@29.0.0.Alpha1-SNAPSHOT//org.wildfly.extension.undertow.deployment.UndertowDeploymentInfoService$UndertowThreadSetupAction.lambda$create$0(UndertowDeploymentInfoService.java:1430) at io.undertow.servlet@2.3.5.Final//io.undertow.servlet.handlers.ServletInitialHandler.dispatchRequest(ServletInitialHandler.java:256) at io.undertow.servlet@2.3.5.Final//io.undertow.servlet.handlers.ServletInitialHandler$1.handleRequest(ServletInitialHandler.java:101) at io.undertow.core@2.3.5.Final//io.undertow.server.Connectors.executeRootHandler(Connectors.java:393) at io.undertow.core@2.3.5.Final//io.undertow.server.HttpServerExchange$1.run(HttpServerExchange.java:859) at org.jboss.threads@2.4.0.Final//org.jboss.threads.ContextClassLoaderSavingRunnable.run(ContextClassLoaderSavingRunnable.java:35) at org.jboss.threads@2.4.0.Final//org.jboss.threads.EnhancedQueueExecutor.safeRun(EnhancedQueueExecutor.java:1990) at org.jboss.threads@2.4.0.Final//org.jboss.threads.EnhancedQueueExecutor$ThreadBody.doRunTask(EnhancedQueueExecutor.java:1486) at org.jboss.threads@2.4.0.Final//org.jboss.threads.EnhancedQueueExecutor$ThreadBody.run(EnhancedQueueExecutor.java:1377) at org.jboss.xnio@3.8.9.Final//org.xnio.XnioWorker$WorkerThreadFactory$1$1.run(XnioWorker.java:1282) at java.base/java.lang.Thread.run(Thread.java:833) Caused by: org.hibernate.exception.SQLGrammarException: could not prepare statement [Table "FLIGHT" not found; SQL statement: select f1_0.flight_id,c1_0.comp_id,c1_0.name,c2_0.flights_flight_id,c2_1.id,c2_1.address,c2_1.name,t1_0.CUSTOMER_ID,t1_0.id,t1_0.number,f1_0.flight_name from Flight f1_0 left join Company c1_0 on c1_0.comp_id=f1_0.comp_id left join (Flight_Customer c2_0 join Customer c2_1 on c2_1.id=c2_0.customers_id) on f1_0.flight_id=c2_0.flights_flight_id left join Ticket t1_0 on c2_1.id=t1_0.CUSTOMER_ID where f1_0.flight_id=? [42102-214]] [select f1_0.flight_id,c1_0.comp_id,c1_0.name,c2_0.flights_flight_id,c2_1.id,c2_1.address,c2_1.name,t1_0.CUSTOMER_ID,t1_0.id,t1_0.number,f1_0.flight_name from Flight f1_0 left join Company c1_0 on c1_0.comp_id=f1_0.comp_id left join (Flight_Customer c2_0 join Customer c2_1 on c2_1.id=c2_0.customers_id) on f1_0.flight_id=c2_0.flights_flight_id left join Ticket t1_0 on c2_1.id=t1_0.CUSTOMER_ID where f1_0.flight_id=?] at org.hibernate@6.2.2.Final//org.hibernate.exception.internal.SQLExceptionTypeDelegate.convert(SQLExceptionTypeDelegate.java:64) at org.hibernate@6.2.2.Final//org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:56) at org.hibernate@6.2.2.Final//org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:108) at org.hibernate@6.2.2.Final//org.hibernate.engine.jdbc.internal.StatementPreparerImpl$StatementPreparationTemplate.prepareStatement(StatementPreparerImpl.java:187) at org.hibernate@6.2.2.Final//org.hibernate.engine.jdbc.internal.StatementPreparerImpl.prepareStatement(StatementPreparerImpl.java:76) at org.hibernate@6.2.2.Final//org.hibernate.sql.exec.internal.JdbcSelectExecutorStandardImpl.lambda$list$0(JdbcSelectExecutorStandardImpl.java:102) at org.hibernate@6.2.2.Final//org.hibernate.sql.results.jdbc.internal.DeferredResultSetAccess.executeQuery(DeferredResultSetAccess.java:226) at org.hibernate@6.2.2.Final//org.hibernate.sql.results.jdbc.internal.DeferredResultSetAccess.getResultSet(DeferredResultSetAccess.java:163) at org.hibernate@6.2.2.Final//org.hibernate.sql.results.jdbc.internal.JdbcValuesResultSetImpl.advanceNext(JdbcValuesResultSetImpl.java:204) at org.hibernate@6.2.2.Final//org.hibernate.sql.results.jdbc.internal.JdbcValuesResultSetImpl.processNext(JdbcValuesResultSetImpl.java:84) at org.hibernate@6.2.2.Final//org.hibernate.sql.results.jdbc.internal.AbstractJdbcValues.next(AbstractJdbcValues.java:29) at org.hibernate@6.2.2.Final//org.hibernate.sql.results.internal.RowProcessingStateStandardImpl.next(RowProcessingStateStandardImpl.java:65) at org.hibernate@6.2.2.Final//org.hibernate.sql.results.spi.ListResultsConsumer.consume(ListResultsConsumer.java:178) at org.hibernate@6.2.2.Final//org.hibernate.sql.results.spi.ListResultsConsumer.consume(ListResultsConsumer.java:33) at org.hibernate@6.2.2.Final//org.hibernate.sql.exec.internal.JdbcSelectExecutorStandardImpl.doExecuteQuery(JdbcSelectExecutorStandardImpl.java:362) at org.hibernate@6.2.2.Final//org.hibernate.sql.exec.internal.JdbcSelectExecutorStandardImpl.executeQuery(JdbcSelectExecutorStandardImpl.java:168) at org.hibernate@6.2.2.Final//org.hibernate.sql.exec.internal.JdbcSelectExecutorStandardImpl.list(JdbcSelectExecutorStandardImpl.java:93) at org.hibernate@6.2.2.Final//org.hibernate.sql.exec.spi.JdbcSelectExecutor.list(JdbcSelectExecutor.java:31) at org.hibernate@6.2.2.Final//org.hibernate.loader.ast.internal.SingleIdLoadPlan.load(SingleIdLoadPlan.java:145) at org.hibernate@6.2.2.Final//org.hibernate.loader.ast.internal.SingleIdLoadPlan.load(SingleIdLoadPlan.java:117) at org.hibernate@6.2.2.Final//org.hibernate.loader.ast.internal.SingleIdEntityLoaderStandardImpl.load(SingleIdEntityLoaderStandardImpl.java:72) at org.hibernate@6.2.2.Final//org.hibernate.persister.entity.AbstractEntityPersister.doLoad(AbstractEntityPersister.java:3381) at org.hibernate@6.2.2.Final//org.hibernate.persister.entity.AbstractEntityPersister.load(AbstractEntityPersister.java:3371) at org.hibernate@6.2.2.Final//org.hibernate.event.internal.DefaultLoadEventListener.loadFromDatasource(DefaultLoadEventListener.java:602) at org.hibernate@6.2.2.Final//org.hibernate.event.internal.DefaultLoadEventListener.loadFromCacheOrDatasource(DefaultLoadEventListener.java:588) at org.hibernate@6.2.2.Final//org.hibernate.event.internal.DefaultLoadEventListener.load(DefaultLoadEventListener.java:557) at org.hibernate@6.2.2.Final//org.hibernate.event.internal.DefaultLoadEventListener.doLoad(DefaultLoadEventListener.java:550) at org.hibernate@6.2.2.Final//org.hibernate.event.internal.DefaultLoadEventListener.load(DefaultLoadEventListener.java:202) at org.hibernate@6.2.2.Final//org.hibernate.event.internal.DefaultLoadEventListener.proxyOrLoad(DefaultLoadEventListener.java:241) at org.hibernate@6.2.2.Final//org.hibernate.event.internal.DefaultLoadEventListener.doOnLoad(DefaultLoadEventListener.java:106) at org.hibernate@6.2.2.Final//org.hibernate.event.internal.DefaultLoadEventListener.onLoad(DefaultLoadEventListener.java:78) at org.hibernate@6.2.2.Final//org.hibernate.event.service.internal.EventListenerGroupImpl.fireEventOnEachListener(EventListenerGroupImpl.java:138) at org.hibernate@6.2.2.Final//org.hibernate.internal.SessionImpl.fireLoadNoChecks(SessionImpl.java:1231) at org.hibernate@6.2.2.Final//org.hibernate.internal.SessionImpl.fireLoad(SessionImpl.java:1219) at org.hibernate@6.2.2.Final//org.hibernate.loader.internal.IdentifierLoadAccessImpl.doLoad(IdentifierLoadAccessImpl.java:194) at org.hibernate@6.2.2.Final//org.hibernate.loader.internal.IdentifierLoadAccessImpl.lambda$load$1(IdentifierLoadAccessImpl.java:160) at org.hibernate@6.2.2.Final//org.hibernate.loader.internal.IdentifierLoadAccessImpl.perform(IdentifierLoadAccessImpl.java:107) at org.hibernate@6.2.2.Final//org.hibernate.loader.internal.IdentifierLoadAccessImpl.load(IdentifierLoadAccessImpl.java:160) at org.hibernate@6.2.2.Final//org.hibernate.internal.SessionImpl.get(SessionImpl.java:1024) at org.hibernate@6.2.2.Final//org.hibernate.event.internal.DefaultMergeEventListener.lambda$entityIsDetached$0(DefaultMergeEventListener.java:321) at org.hibernate@6.2.2.Final//org.hibernate.engine.spi.LoadQueryInfluencers.fromInternalFetchProfile(LoadQueryInfluencers.java:79) at org.hibernate@6.2.2.Final//org.hibernate.event.internal.DefaultMergeEventListener.entityIsDetached(DefaultMergeEventListener.java:319) at org.hibernate@6.2.2.Final//org.hibernate.event.internal.DefaultMergeEventListener.merge(DefaultMergeEventListener.java:150) at org.hibernate@6.2.2.Final//org.hibernate.event.internal.DefaultMergeEventListener.doMerge(DefaultMergeEventListener.java:143) at org.hibernate@6.2.2.Final//org.hibernate.event.internal.DefaultMergeEventListener.onMerge(DefaultMergeEventListener.java:123) at org.hibernate@6.2.2.Final//org.hibernate.event.internal.DefaultMergeEventListener.onMerge(DefaultMergeEventListener.java:81) at org.hibernate@6.2.2.Final//org.hibernate.event.service.internal.EventListenerGroupImpl.fireEventOnEachListener(EventListenerGroupImpl.java:127) at org.hibernate@6.2.2.Final//org.hibernate.internal.SessionImpl.fireMerge(SessionImpl.java:848) at org.hibernate@6.2.2.Final//org.hibernate.internal.SessionImpl.merge(SessionImpl.java:834) at org.jboss.as.jpa@29.0.0.Alpha1-SNAPSHOT//org.jboss.as.jpa.container.AbstractEntityManager.merge(AbstractEntityManager.java:568) at deployment.web_jpa.war//org.jboss.as.test.integration.jpa.webtxem.TestServlet.doGet(TestServlet.java:70) ... 45 more Caused by: org.h2.jdbc.JdbcSQLSyntaxErrorException: Table "FLIGHT" not found; SQL statement: select f1_0.flight_id,c1_0.comp_id,c1_0.name,c2_0.flights_flight_id,c2_1.id,c2_1.address,c2_1.name,t1_0.CUSTOMER_ID,t1_0.id,t1_0.number,f1_0.flight_name from Flight f1_0 left join Company c1_0 on c1_0.comp_id=f1_0.comp_id left join (Flight_Customer c2_0 join Customer c2_1 on c2_1.id=c2_0.customers_id) on f1_0.flight_id=c2_0.flights_flight_id left join Ticket t1_0 on c2_1.id=t1_0.CUSTOMER_ID where f1_0.flight_id=? [42102-214] at com.h2database.h2@2.1.214//org.h2.message.DbException.getJdbcSQLException(DbException.java:502) at com.h2database.h2@2.1.214//org.h2.message.DbException.getJdbcSQLException(DbException.java:477) at com.h2database.h2@2.1.214//org.h2.message.DbException.get(DbException.java:223) at com.h2database.h2@2.1.214//org.h2.message.DbException.get(DbException.java:199) at com.h2database.h2@2.1.214//org.h2.command.Parser.getTableOrViewNotFoundDbException(Parser.java:8398) at com.h2database.h2@2.1.214//org.h2.command.Parser.getTableOrViewNotFoundDbException(Parser.java:8369) at com.h2database.h2@2.1.214//org.h2.command.Parser.readTableOrView(Parser.java:8358) at com.h2database.h2@2.1.214//org.h2.command.Parser.readTablePrimary(Parser.java:1863) at com.h2database.h2@2.1.214//org.h2.command.Parser.readTableReference(Parser.java:2334) at com.h2database.h2@2.1.214//org.h2.command.Parser.parseSelectFromPart(Parser.java:2772) at com.h2database.h2@2.1.214//org.h2.command.Parser.parseSelect(Parser.java:2878) at com.h2database.h2@2.1.214//org.h2.command.Parser.parseQueryPrimary(Parser.java:2762) at com.h2database.h2@2.1.214//org.h2.command.Parser.parseQueryTerm(Parser.java:2633) at com.h2database.h2@2.1.214//org.h2.command.Parser.parseQueryExpressionBody(Parser.java:2612) at com.h2database.h2@2.1.214//org.h2.command.Parser.parseQueryExpressionBodyAndEndOfQuery(Parser.java:2605) at com.h2database.h2@2.1.214//org.h2.command.Parser.parseQueryExpression(Parser.java:2598) at com.h2database.h2@2.1.214//org.h2.command.Parser.parseQuery(Parser.java:2567) at com.h2database.h2@2.1.214//org.h2.command.Parser.parsePrepared(Parser.java:724) at com.h2database.h2@2.1.214//org.h2.command.Parser.parse(Parser.java:689) at com.h2database.h2@2.1.214//org.h2.command.Parser.parse(Parser.java:661) at com.h2database.h2@2.1.214//org.h2.command.Parser.prepareCommand(Parser.java:569) at com.h2database.h2@2.1.214//org.h2.engine.SessionLocal.prepareLocal(SessionLocal.java:631) at com.h2database.h2@2.1.214//org.h2.engine.SessionLocal.prepareCommand(SessionLocal.java:554) at com.h2database.h2@2.1.214//org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1116) at com.h2database.h2@2.1.214//org.h2.jdbc.JdbcPreparedStatement.<init>(JdbcPreparedStatement.java:92) at com.h2database.h2@2.1.214//org.h2.jdbc.JdbcConnection.prepareStatement(JdbcConnection.java:639) at org.jboss.ironjacamar.jdbcadapters@3.0.2.Final//org.jboss.jca.adapters.jdbc.BaseWrapperManagedConnection.doPrepareStatement(BaseWrapperManagedConnection.java:790) at org.jboss.ironjacamar.jdbcadapters@3.0.2.Final//org.jboss.jca.adapters.jdbc.BaseWrapperManagedConnection.prepareStatement(BaseWrapperManagedConnection.java:776) at org.jboss.ironjacamar.jdbcadapters@3.0.2.Final//org.jboss.jca.adapters.jdbc.WrappedConnection$4.produce(WrappedConnection.java:478) at org.jboss.ironjacamar.jdbcadapters@3.0.2.Final//org.jboss.jca.adapters.jdbc.WrappedConnection$4.produce(WrappedConnection.java:476) at org.jboss.ironjacamar.jdbcadapters@3.0.2.Final//org.jboss.jca.adapters.jdbc.SecurityActions.executeInTccl(SecurityActions.java:103) at org.jboss.ironjacamar.jdbcadapters@3.0.2.Final//org.jboss.jca.adapters.jdbc.WrappedConnection.prepareStatement(WrappedConnection.java:476) at org.hibernate@6.2.2.Final//org.hibernate.engine.jdbc.internal.StatementPreparerImpl$1.doPrepare(StatementPreparerImpl.java:91) at org.hibernate@6.2.2.Final//org.hibernate.engine.jdbc.internal.StatementPreparerImpl$StatementPreparationTemplate.prepareStatement(StatementPreparerImpl.java:177) ... 92 moreat java.base/java.util.concurrent.FutureTask.report(FutureTask.java:122) at java.base/java.util.concurrent.FutureTask.get(FutureTask.java:205) at org.jboss.as.test.integration.common.HttpRequest.execute(HttpRequest.java:52) ... 124 more Caused by: java.io.IOException: HTTP Status 500 Response:
jakarta.servlet.ServletException: org.hibernate.exception.SQLGrammarException: could not prepare statement [Table "FLIGHT" not found; SQL statement: select f1_0.flight_id,c1_0.comp_id,c1_0.name,c2_0.flights_flight_id,c2_1.id,c2_1.address,c2_1.name,t1_0.CUSTOMER_ID,t1_0.id,t1_0.number,f1_0.flight_name from Flight f1_0 left join Company c1_0 on c1_0.comp_id=f1_0.comp_id left join (Flight_Customer c2_0 join Customer c2_1 on c2_1.id=c2_0.customers_id) on f1_0.flight_id=c2_0.flights_flight_id left join Ticket t1_0 on c2_1.id=t1_0.CUSTOMER_ID where f1_0.flight_id=? [42102-214]] [select f1_0.flight_id,c1_0.comp_id,c1_0.name,c2_0.flights_flight_id,c2_1.id,c2_1.address,c2_1.name,t1_0.CUSTOMER_ID,t1_0.id,t1_0.number,f1_0.flight_name from Flight f1_0 left join Company c1_0 on c1_0.comp_id=f1_0.comp_id left join (Flight_Customer c2_0 join Customer c2_1 on c2_1.id=c2_0.customers_id) on f1_0.flight_id=c2_0.flights_flight_id left join Ticket t1_0 on c2_1.id=t1_0.CUSTOMER_ID where f1_0.flight_id=?] at deployment.web_jpa.war//org.jboss.as.test.integration.jpa.webtxem.TestServlet.doGet(TestServlet.java:94) at jakarta.servlet.api@6.0.0//jakarta.servlet.http.HttpServlet.service(HttpServlet.java:527) at jakarta.servlet.api@6.0.0//jakarta.servlet.http.HttpServlet.service(HttpServlet.java:614) at io.undertow.servlet@2.3.5.Final//io.undertow.servlet.handlers.ServletHandler.handleRequest(ServletHandler.java:74) at io.undertow.servlet@2.3.5.Final//io.undertow.servlet.handlers.security.ServletSecurityRoleHandler.handleRequest(ServletSecurityRoleHandler.java:62) at io.undertow.servlet@2.3.5.Final//io.undertow.servlet.handlers.ServletChain$1.handleRequest(ServletChain.java:68) at io.undertow.servlet@2.3.5.Final//io.undertow.servlet.handlers.ServletDispatchingHandler.handleRequest(ServletDispatchingHandler.java:36) at org.wildfly.security.elytron-web.undertow-server@3.0.1.Final//org.wildfly.elytron.web.undertow.server.ElytronRunAsHandler.lambda$handleRequest$1(ElytronRunAsHandler.java:68) at org.wildfly.security.elytron-base@2.1.0.Final//org.wildfly.security.auth.server.FlexibleIdentityAssociation.runAsFunctionEx(FlexibleIdentityAssociation.java:103) at org.wildfly.security.elytron-base@2.1.0.Final//org.wildfly.security.auth.server.Scoped.runAsFunctionEx(Scoped.java:161) at org.wildfly.security.elytron-base@2.1.0.Final//org.wildfly.security.auth.server.Scoped.runAs(Scoped.java:73) at org.wildfly.security.elytron-web.undertow-server@3.0.1.Final//org.wildfly.elytron.web.undertow.server.ElytronRunAsHandler.handleRequest(ElytronRunAsHandler.java:67) at io.undertow.servlet@2.3.5.Final//io.undertow.servlet.handlers.RedirectDirHandler.handleRequest(RedirectDirHandler.java:68) at io.undertow.servlet@2.3.5.Final//io.undertow.servlet.handlers.security.SSLInformationAssociationHandler.handleRequest(SSLInformationAssociationHandler.java:117) at io.undertow.servlet@2.3.5.Final//io.undertow.servlet.handlers.security.ServletAuthenticationCallHandler.handleRequest(ServletAuthenticationCallHandler.java:57) at io.undertow.core@2.3.5.Final//io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43) at io.undertow.core@2.3.5.Final//io.undertow.security.handlers.AbstractConfidentialityHandler.handleRequest(AbstractConfidentialityHandler.java:46) at io.undertow.servlet@2.3.5.Final//io.undertow.servlet.handlers.security.ServletConfidentialityConstraintHandler.handleRequest(ServletConfidentialityConstraintHandler.java:64) at io.undertow.core@2.3.5.Final//io.undertow.security.handlers.AbstractSecurityContextAssociationHandler.handleRequest(AbstractSecurityContextAssociationHandler.java:43) at org.wildfly.security.elytron-web.undertow-server-servlet@3.0.1.Final//org.wildfly.elytron.web.undertow.server.servlet.CleanUpHandler.handleRequest(CleanUpHandler.java:38) at io.undertow.core@2.3.5.Final//io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43) at org.wildfly.extension.undertow@29.0.0.Alpha1-SNAPSHOT//org.wildfly.extension.undertow.security.jacc.JACCContextIdHandler.handleRequest(JACCContextIdHandler.java:61) at io.undertow.core@2.3.5.Final//io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43) at org.wildfly.extension.undertow@29.0.0.Alpha1-SNAPSHOT//org.wildfly.extension.undertow.deployment.GlobalRequestControllerHandler.handleRequest(GlobalRequestControllerHandler.java:68) at io.undertow.servlet@2.3.5.Final//io.undertow.servlet.handlers.SendErrorPageHandler.handleRequest(SendErrorPageHandler.java:52) at io.undertow.core@2.3.5.Final//io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43) at io.undertow.servlet@2.3.5.Final//io.undertow.servlet.handlers.ServletInitialHandler.handleFirstRequest(ServletInitialHandler.java:276) at io.undertow.servlet@2.3.5.Final//io.undertow.servlet.handlers.ServletInitialHandler$2.call(ServletInitialHandler.java:135) at io.undertow.servlet@2.3.5.Final//io.undertow.servlet.handlers.ServletInitialHandler$2.call(ServletInitialHandler.java:132) at io.undertow.servlet@2.3.5.Final//io.undertow.servlet.core.ServletRequestContextThreadSetupAction$1.call(ServletRequestContextThreadSetupAction.java:48) at io.undertow.servlet@2.3.5.Final//io.undertow.servlet.core.ContextClassLoaderSetupAction$1.call(ContextClassLoaderSetupAction.java:43) at org.wildfly.extension.undertow@29.0.0.Alpha1-SNAPSHOT//org.wildfly.extension.undertow.deployment.UndertowDeploymentInfoService$UndertowThreadSetupAction.lambda$create$0(UndertowDeploymentInfoService.java:1430) at org.wildfly.extension.undertow@29.0.0.Alpha1-SNAPSHOT//org.wildfly.extension.undertow.deployment.UndertowDeploymentInfoService$UndertowThreadSetupAction.lambda$create$0(UndertowDeploymentInfoService.java:1430) at org.wildfly.extension.undertow@29.0.0.Alpha1-SNAPSHOT//org.wildfly.extension.undertow.deployment.UndertowDeploymentInfoService$UndertowThreadSetupAction.lambda$create$0(UndertowDeploymentInfoService.java:1430) at org.wildfly.extension.undertow@29.0.0.Alpha1-SNAPSHOT//org.wildfly.extension.undertow.deployment.UndertowDeploymentInfoService$UndertowThreadSetupAction.lambda$create$0(UndertowDeploymentInfoService.java:1430) at org.wildfly.extension.undertow@29.0.0.Alpha1-SNAPSHOT//org.wildfly.extension.undertow.deployment.UndertowDeploymentInfoService$UndertowThreadSetupAction.lambda$create$0(UndertowDeploymentInfoService.java:1430) at io.undertow.servlet@2.3.5.Final//io.undertow.servlet.handlers.ServletInitialHandler.dispatchRequest(ServletInitialHandler.java:256) at io.undertow.servlet@2.3.5.Final//io.undertow.servlet.handlers.ServletInitialHandler$1.handleRequest(ServletInitialHandler.java:101) at io.undertow.core@2.3.5.Final//io.undertow.server.Connectors.executeRootHandler(Connectors.java:393) at io.undertow.core@2.3.5.Final//io.undertow.server.HttpServerExchange$1.run(HttpServerExchange.java:859) at org.jboss.threads@2.4.0.Final//org.jboss.threads.ContextClassLoaderSavingRunnable.run(ContextClassLoaderSavingRunnable.java:35) at org.jboss.threads@2.4.0.Final//org.jboss.threads.EnhancedQueueExecutor.safeRun(EnhancedQueueExecutor.java:1990) at org.jboss.threads@2.4.0.Final//org.jboss.threads.EnhancedQueueExecutor$ThreadBody.doRunTask(EnhancedQueueExecutor.java:1486) at org.jboss.threads@2.4.0.Final//org.jboss.threads.EnhancedQueueExecutor$ThreadBody.run(EnhancedQueueExecutor.java:1377) at org.jboss.xnio@3.8.9.Final//org.xnio.XnioWorker$WorkerThreadFactory$1$1.run(XnioWorker.java:1282) at java.base/java.lang.Thread.run(Thread.java:833) Caused by: org.hibernate.exception.SQLGrammarException: could not prepare statement [Table "FLIGHT" not found; SQL statement: select f1_0.flight_id,c1_0.comp_id,c1_0.name,c2_0.flights_flight_id,c2_1.id,c2_1.address,c2_1.name,t1_0.CUSTOMER_ID,t1_0.id,t1_0.number,f1_0.flight_name from Flight f1_0 left join Company c1_0 on c1_0.comp_id=f1_0.comp_id left join (Flight_Customer c2_0 join Customer c2_1 on c2_1.id=c2_0.customers_id) on f1_0.flight_id=c2_0.flights_flight_id left join Ticket t1_0 on c2_1.id=t1_0.CUSTOMER_ID where f1_0.flight_id=? [42102-214]] [select f1_0.flight_id,c1_0.comp_id,c1_0.name,c2_0.flights_flight_id,c2_1.id,c2_1.address,c2_1.name,t1_0.CUSTOMER_ID,t1_0.id,t1_0.number,f1_0.flight_name from Flight f1_0 left join Company c1_0 on c1_0.comp_id=f1_0.comp_id left join (Flight_Customer c2_0 join Customer c2_1 on c2_1.id=c2_0.customers_id) on f1_0.flight_id=c2_0.flights_flight_id left join Ticket t1_0 on c2_1.id=t1_0.CUSTOMER_ID where f1_0.flight_id=?] at org.hibernate@6.2.2.Final//org.hibernate.exception.internal.SQLExceptionTypeDelegate.convert(SQLExceptionTypeDelegate.java:64) at org.hibernate@6.2.2.Final//org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:56) at org.hibernate@6.2.2.Final//org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:108) at org.hibernate@6.2.2.Final//org.hibernate.engine.jdbc.internal.StatementPreparerImpl$StatementPreparationTemplate.prepareStatement(StatementPreparerImpl.java:187) at org.hibernate@6.2.2.Final//org.hibernate.engine.jdbc.internal.StatementPreparerImpl.prepareStatement(StatementPreparerImpl.java:76) at org.hibernate@6.2.2.Final//org.hibernate.sql.exec.internal.JdbcSelectExecutorStandardImpl.lambda$list$0(JdbcSelectExecutorStandardImpl.java:102) at org.hibernate@6.2.2.Final//org.hibernate.sql.results.jdbc.internal.DeferredResultSetAccess.executeQuery(DeferredResultSetAccess.java:226) at org.hibernate@6.2.2.Final//org.hibernate.sql.results.jdbc.internal.DeferredResultSetAccess.getResultSet(DeferredResultSetAccess.java:163) at org.hibernate@6.2.2.Final//org.hibernate.sql.results.jdbc.internal.JdbcValuesResultSetImpl.advanceNext(JdbcValuesResultSetImpl.java:204) at org.hibernate@6.2.2.Final//org.hibernate.sql.results.jdbc.internal.JdbcValuesResultSetImpl.processNext(JdbcValuesResultSetImpl.java:84) at org.hibernate@6.2.2.Final//org.hibernate.sql.results.jdbc.internal.AbstractJdbcValues.next(AbstractJdbcValues.java:29) at org.hibernate@6.2.2.Final//org.hibernate.sql.results.internal.RowProcessingStateStandardImpl.next(RowProcessingStateStandardImpl.java:65) at org.hibernate@6.2.2.Final//org.hibernate.sql.results.spi.ListResultsConsumer.consume(ListResultsConsumer.java:178) at org.hibernate@6.2.2.Final//org.hibernate.sql.results.spi.ListResultsConsumer.consume(ListResultsConsumer.java:33) at org.hibernate@6.2.2.Final//org.hibernate.sql.exec.internal.JdbcSelectExecutorStandardImpl.doExecuteQuery(JdbcSelectExecutorStandardImpl.java:362) at org.hibernate@6.2.2.Final//org.hibernate.sql.exec.internal.JdbcSelectExecutorStandardImpl.executeQuery(JdbcSelectExecutorStandardImpl.java:168) at org.hibernate@6.2.2.Final//org.hibernate.sql.exec.internal.JdbcSelectExecutorStandardImpl.list(JdbcSelectExecutorStandardImpl.java:93) at org.hibernate@6.2.2.Final//org.hibernate.sql.exec.spi.JdbcSelectExecutor.list(JdbcSelectExecutor.java:31) at org.hibernate@6.2.2.Final//org.hibernate.loader.ast.internal.SingleIdLoadPlan.load(SingleIdLoadPlan.java:145) at org.hibernate@6.2.2.Final//org.hibernate.loader.ast.internal.SingleIdLoadPlan.load(SingleIdLoadPlan.java:117) at org.hibernate@6.2.2.Final//org.hibernate.loader.ast.internal.SingleIdEntityLoaderStandardImpl.load(SingleIdEntityLoaderStandardImpl.java:72) at org.hibernate@6.2.2.Final//org.hibernate.persister.entity.AbstractEntityPersister.doLoad(AbstractEntityPersister.java:3381) at org.hibernate@6.2.2.Final//org.hibernate.persister.entity.AbstractEntityPersister.load(AbstractEntityPersister.java:3371) at org.hibernate@6.2.2.Final//org.hibernate.event.internal.DefaultLoadEventListener.loadFromDatasource(DefaultLoadEventListener.java:602) at org.hibernate@6.2.2.Final//org.hibernate.event.internal.DefaultLoadEventListener.loadFromCacheOrDatasource(DefaultLoadEventListener.java:588) at org.hibernate@6.2.2.Final//org.hibernate.event.internal.DefaultLoadEventListener.load(DefaultLoadEventListener.java:557) at org.hibernate@6.2.2.Final//org.hibernate.event.internal.DefaultLoadEventListener.doLoad(DefaultLoadEventListener.java:550) at org.hibernate@6.2.2.Final//org.hibernate.event.internal.DefaultLoadEventListener.load(DefaultLoadEventListener.java:202) at org.hibernate@6.2.2.Final//org.hibernate.event.internal.DefaultLoadEventListener.proxyOrLoad(DefaultLoadEventListener.java:241) at org.hibernate@6.2.2.Final//org.hibernate.event.internal.DefaultLoadEventListener.doOnLoad(DefaultLoadEventListener.java:106) at org.hibernate@6.2.2.Final//org.hibernate.event.internal.DefaultLoadEventListener.onLoad(DefaultLoadEventListener.java:78) at org.hibernate@6.2.2.Final//org.hibernate.event.service.internal.EventListenerGroupImpl.fireEventOnEachListener(EventListenerGroupImpl.java:138) at org.hibernate@6.2.2.Final//org.hibernate.internal.SessionImpl.fireLoadNoChecks(SessionImpl.java:1231) at org.hibernate@6.2.2.Final//org.hibernate.internal.SessionImpl.fireLoad(SessionImpl.java:1219) at org.hibernate@6.2.2.Final//org.hibernate.loader.internal.IdentifierLoadAccessImpl.doLoad(IdentifierLoadAccessImpl.java:194) at org.hibernate@6.2.2.Final//org.hibernate.loader.internal.IdentifierLoadAccessImpl.lambda$load$1(IdentifierLoadAccessImpl.java:160) at org.hibernate@6.2.2.Final//org.hibernate.loader.internal.IdentifierLoadAccessImpl.perform(IdentifierLoadAccessImpl.java:107) at org.hibernate@6.2.2.Final//org.hibernate.loader.internal.IdentifierLoadAccessImpl.load(IdentifierLoadAccessImpl.java:160) at org.hibernate@6.2.2.Final//org.hibernate.internal.SessionImpl.get(SessionImpl.java:1024) at org.hibernate@6.2.2.Final//org.hibernate.event.internal.DefaultMergeEventListener.lambda$entityIsDetached$0(DefaultMergeEventListener.java:321) at org.hibernate@6.2.2.Final//org.hibernate.engine.spi.LoadQueryInfluencers.fromInternalFetchProfile(LoadQueryInfluencers.java:79) at org.hibernate@6.2.2.Final//org.hibernate.event.internal.DefaultMergeEventListener.entityIsDetached(DefaultMergeEventListener.java:319) at org.hibernate@6.2.2.Final//org.hibernate.event.internal.DefaultMergeEventListener.merge(DefaultMergeEventListener.java:150) at org.hibernate@6.2.2.Final//org.hibernate.event.internal.DefaultMergeEventListener.doMerge(DefaultMergeEventListener.java:143) at org.hibernate@6.2.2.Final//org.hibernate.event.internal.DefaultMergeEventListener.onMerge(DefaultMergeEventListener.java:123) at org.hibernate@6.2.2.Final//org.hibernate.event.internal.DefaultMergeEventListener.onMerge(DefaultMergeEventListener.java:81) at org.hibernate@6.2.2.Final//org.hibernate.event.service.internal.EventListenerGroupImpl.fireEventOnEachListener(EventListenerGroupImpl.java:127) at org.hibernate@6.2.2.Final//org.hibernate.internal.SessionImpl.fireMerge(SessionImpl.java:848) at org.hibernate@6.2.2.Final//org.hibernate.internal.SessionImpl.merge(SessionImpl.java:834) at org.jboss.as.jpa@29.0.0.Alpha1-SNAPSHOT//org.jboss.as.jpa.container.AbstractEntityManager.merge(AbstractEntityManager.java:568) at deployment.web_jpa.war//org.jboss.as.test.integration.jpa.webtxem.TestServlet.doGet(TestServlet.java:70) ... 45 more Caused by: org.h2.jdbc.JdbcSQLSyntaxErrorException: Table "FLIGHT" not found; SQL statement: select f1_0.flight_id,c1_0.comp_id,c1_0.name,c2_0.flights_flight_id,c2_1.id,c2_1.address,c2_1.name,t1_0.CUSTOMER_ID,t1_0.id,t1_0.number,f1_0.flight_name from Flight f1_0 left join Company c1_0 on c1_0.comp_id=f1_0.comp_id left join (Flight_Customer c2_0 join Customer c2_1 on c2_1.id=c2_0.customers_id) on f1_0.flight_id=c2_0.flights_flight_id left join Ticket t1_0 on c2_1.id=t1_0.CUSTOMER_ID where f1_0.flight_id=? [42102-214] at com.h2database.h2@2.1.214//org.h2.message.DbException.getJdbcSQLException(DbException.java:502) at com.h2database.h2@2.1.214//org.h2.message.DbException.getJdbcSQLException(DbException.java:477) at com.h2database.h2@2.1.214//org.h2.message.DbException.get(DbException.java:223) at com.h2database.h2@2.1.214//org.h2.message.DbException.get(DbException.java:199) at com.h2database.h2@2.1.214//org.h2.command.Parser.getTableOrViewNotFoundDbException(Parser.java:8398) at com.h2database.h2@2.1.214//org.h2.command.Parser.getTableOrViewNotFoundDbException(Parser.java:8369) at com.h2database.h2@2.1.214//org.h2.command.Parser.readTableOrView(Parser.java:8358) at com.h2database.h2@2.1.214//org.h2.command.Parser.readTablePrimary(Parser.java:1863) at com.h2database.h2@2.1.214//org.h2.command.Parser.readTableReference(Parser.java:2334) at com.h2database.h2@2.1.214//org.h2.command.Parser.parseSelectFromPart(Parser.java:2772) at com.h2database.h2@2.1.214//org.h2.command.Parser.parseSelect(Parser.java:2878) at com.h2database.h2@2.1.214//org.h2.command.Parser.parseQueryPrimary(Parser.java:2762) at com.h2database.h2@2.1.214//org.h2.command.Parser.parseQueryTerm(Parser.java:2633) at com.h2database.h2@2.1.214//org.h2.command.Parser.parseQueryExpressionBody(Parser.java:2612) at com.h2database.h2@2.1.214//org.h2.command.Parser.parseQueryExpressionBodyAndEndOfQuery(Parser.java:2605) at com.h2database.h2@2.1.214//org.h2.command.Parser.parseQueryExpression(Parser.java:2598) at com.h2database.h2@2.1.214//org.h2.command.Parser.parseQuery(Parser.java:2567) at com.h2database.h2@2.1.214//org.h2.command.Parser.parsePrepared(Parser.java:724) at com.h2database.h2@2.1.214//org.h2.command.Parser.parse(Parser.java:689) at com.h2database.h2@2.1.214//org.h2.command.Parser.parse(Parser.java:661) at com.h2database.h2@2.1.214//org.h2.command.Parser.prepareCommand(Parser.java:569) at com.h2database.h2@2.1.214//org.h2.engine.SessionLocal.prepareLocal(SessionLocal.java:631) at com.h2database.h2@2.1.214//org.h2.engine.SessionLocal.prepareCommand(SessionLocal.java:554) at com.h2database.h2@2.1.214//org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1116) at com.h2database.h2@2.1.214//org.h2.jdbc.JdbcPreparedStatement.<init>(JdbcPreparedStatement.java:92) at com.h2database.h2@2.1.214//org.h2.jdbc.JdbcConnection.prepareStatement(JdbcConnection.java:639) at org.jboss.ironjacamar.jdbcadapters@3.0.2.Final//org.jboss.jca.adapters.jdbc.BaseWrapperManagedConnection.doPrepareStatement(BaseWrapperManagedConnection.java:790) at org.jboss.ironjacamar.jdbcadapters@3.0.2.Final//org.jboss.jca.adapters.jdbc.BaseWrapperManagedConnection.prepareStatement(BaseWrapperManagedConnection.java:776) at org.jboss.ironjacamar.jdbcadapters@3.0.2.Final//org.jboss.jca.adapters.jdbc.WrappedConnection$4.produce(WrappedConnection.java:478) at org.jboss.ironjacamar.jdbcadapters@3.0.2.Final//org.jboss.jca.adapters.jdbc.WrappedConnection$4.produce(WrappedConnection.java:476) at org.jboss.ironjacamar.jdbcadapters@3.0.2.Final//org.jboss.jca.adapters.jdbc.SecurityActions.executeInTccl(SecurityActions.java:103) at org.jboss.ironjacamar.jdbcadapters@3.0.2.Final//org.jboss.jca.adapters.jdbc.WrappedConnection.prepareStatement(WrappedConnection.java:476) at org.hibernate@6.2.2.Final//org.hibernate.engine.jdbc.internal.StatementPreparerImpl$1.doPrepare(StatementPreparerImpl.java:91) at org.hibernate@6.2.2.Final//org.hibernate.engine.jdbc.internal.StatementPreparerImpl$StatementPreparationTemplate.prepareStatement(StatementPreparerImpl.java:177) ... 92 moreat org.jboss.as.test.integration.common.HttpRequest.processResponse(HttpRequest.java:157) at org.jboss.as.test.integration.common.HttpRequest$1.call(HttpRequest.java:79) at org.jboss.as.test.integration.common.HttpRequest$1.call(HttpRequest.java:74) at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264) at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1136) at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635) at java.base/java.lang.Thread.run(Thread.java:833) ------- Stdout: ------- &#27;15:30:56,452 INFO [org.jboss.as.repository] (management-handler-thread - 2) WFLYDR0001: Content added at location /opt/buildAgent/work/e34a6f994de9f7c6/testsuite/integration/basic/target/wildfly/standalone/data/content/d6/aa7f5d77e332240f99d56e574c3d0605da0056/content &#27;&#27;15:30:56,454 INFO [org.jboss.as.server.deployment] (MSC service thread 1-6) WFLYSRV0027: Starting deployment of "web_jpa.war" (runtime-name: "web_jpa.war") &#27;&#27;15:30:56,479 INFO [org.jboss.as.jpa] (MSC service thread 1-8) WFLYJPA0002: Read persistence.xml for web_jpa_pc &#27;&#27;15:30:56,485 WARN [org.jboss.as.dependency.private] (MSC service thread 1-8) WFLYSRV0018: Deployment "deployment.web_jpa.war" is using a private module ("org.wildfly.security.manager") which may be changed or removed in future versions without notice. &#27;&#27;15:30:56,485 INFO [org.jipijapa] (MSC service thread 1-6) JIPIORMV6020260: Second level cache enabled for web_jpa.war#web_jpa_pc &#27;&#27;15:30:56,491 INFO [org.infinispan.CONTAINER] (ServerService Thread Pool -- 37) ISPN000556: Starting user marshaller 'org.wildfly.clustering.infinispan.marshalling.jboss.JBossMarshaller' &#27;&#27;15:30:56,498 INFO [org.jboss.as.jpa] (ServerService Thread Pool -- 37) WFLYJPA0010: Starting Persistence Unit (phase 1 of 2) Service 'web_jpa.war#web_jpa_pc' &#27;&#27;15:30:56,498 INFO [org.hibernate.jpa.internal.util.LogHelper] (ServerService Thread Pool -- 37) HHH000204: Processing PersistenceUnitInfo [name: web_jpa_pc] &#27;&#27;15:30:56,503 INFO [org.hibernate.orm.dialect] (ServerService Thread Pool -- 37) HHH035001: Using dialect: org.hibernate.dialect.H2Dialect, version: 2.1.214 &#27;&#27;15:30:56,505 INFO [org.hibernate.envers.boot.internal.EnversServiceImpl] (ServerService Thread Pool -- 37) Envers integration enabled? : true &#27;&#27;15:30:56,507 INFO [org.hibernate.bytecode.internal.BytecodeProviderInitiator] (ServerService Thread Pool -- 37) HHH000021: Bytecode provider name : bytebuddy &#27;&#27;15:30:56,537 INFO [org.jipijapa] (MSC service thread 1-1) JIPIORMV6020260: Second level cache enabled for web_jpa.war#web_jpa_pc &#27;&#27;15:30:56,544 INFO [org.jboss.as.arquillian] (MSC service thread 1-3) Arquillian deployment detected: ArquillianConfig[service=jboss.arquillian.config."web_jpa.war",unit=web_jpa.war,tests=[org.jboss.as.test.integration.jpa.webtxem.WebJPATestCase]] &#27;&#27;15:30:56,544 INFO [org.jboss.as.jpa] (ServerService Thread Pool -- 37) WFLYJPA0010: Starting Persistence Unit (phase 2 of 2) Service 'web_jpa.war#web_jpa_pc' &#27;&#27;15:30:56,700 INFO [org.hibernate.orm.beans] (ServerService Thread Pool -- 37) HHH10005002: No explicit CDI BeanManager reference was passed to Hibernate, but CDI is available on the Hibernate ClassLoader. &#27;&#27;15:30:56,713 INFO [org.hibernate.bytecode.internal.BytecodeProviderInitiator] (ServerService Thread Pool -- 37) HHH000021: Bytecode provider name : bytebuddy &#27;&#27;15:30:56,764 WARN [org.hibernate.tool.schema.internal.ExceptionHandlerLoggedImpl] (ServerService Thread Pool -- 37) GenerationTarget encountered exception accepting command : Error executing DDL "create table Flight (comp_id bigint, flight_id bigint generated by default as identity, flight_name varchar(50) not null, primary key (flight_id))" via JDBC [GeneralError;]: org.hibernate.tool.schema.spi.CommandAcceptanceException: Error executing DDL "create table Flight (comp_id bigint, flight_id bigint generated by default as identity, flight_name varchar(50) not null, primary key (flight_id))" via JDBC [GeneralError;] at org.hibernate@6.2.2.Final//org.hibernate.tool.schema.internal.exec.GenerationTargetToDatabase.accept(GenerationTargetToDatabase.java:92) at org.hibernate@6.2.2.Final//org.hibernate.tool.schema.internal.Helper.applySqlString(Helper.java:235) at org.hibernate@6.2.2.Final//org.hibernate.tool.schema.internal.Helper.applySqlStrings(Helper.java:219) at org.hibernate@6.2.2.Final//org.hibernate.tool.schema.internal.SchemaCreatorImpl.createTables(SchemaCreatorImpl.java:419) at org.hibernate@6.2.2.Final//org.hibernate.tool.schema.internal.SchemaCreatorImpl.createSequencesTablesConstraints(SchemaCreatorImpl.java:340) at org.hibernate@6.2.2.Final//org.hibernate.tool.schema.internal.SchemaCreatorImpl.createFromMetadata(SchemaCreatorImpl.java:239) at org.hibernate@6.2.2.Final//org.hibernate.tool.schema.internal.SchemaCreatorImpl.performCreation(SchemaCreatorImpl.java:172) at org.hibernate@6.2.2.Final//org.hibernate.tool.schema.internal.SchemaCreatorImpl.doCreation(SchemaCreatorImpl.java:142) at org.hibernate@6.2.2.Final//org.hibernate.tool.schema.internal.SchemaCreatorImpl.doCreation(SchemaCreatorImpl.java:118) at org.hibernate@6.2.2.Final//org.hibernate.tool.schema.spi.SchemaManagementToolCoordinator.performDatabaseAction(SchemaManagementToolCoordinator.java:254) at org.hibernate@6.2.2.Final//org.hibernate.tool.schema.spi.SchemaManagementToolCoordinator.lambda$process$5(SchemaManagementToolCoordinator.java:143) at java.base/java.util.HashMap.forEach(HashMap.java:1421) at org.hibernate@6.2.2.Final//org.hibernate.tool.schema.spi.SchemaManagementToolCoordinator.process(SchemaManagementToolCoordinator.java:140) at org.hibernate@6.2.2.Final//org.hibernate.boot.internal.SessionFactoryObserverForSchemaExport.sessionFactoryCreated(SessionFactoryObserverForSchemaExport.java:37) at org.hibernate@6.2.2.Final//org.hibernate.internal.SessionFactoryObserverChain.sessionFactoryCreated(SessionFactoryObserverChain.java:35) at org.hibernate@6.2.2.Final//org.hibernate.internal.SessionFactoryImpl.