Erru ao usar a propriedade update no persisntece.xml

nlsouza · Março 4, 2015, 12:58am

Colegas, quando a propriedade abaixo esta como create, não exibe o erro abaixo, no entanto quando esta como update acontece.
Podem me ajudar por favor??

<property name="hibernate.hbm2ddl.auto" value="update" />

21:53:43,632 ERROR [org.hibernate.tool.hbm2ddl.SchemaUpdate] (ServerService Thread Pool -- 50) HHH000299: Could not complete schema update: org.h2.jdbc.JdbcSQLException: Table "PG_CLASS" not found; SQL statement:
select relname from pg_class where relkind='S' [42102-173]

robsonsan · Março 4, 2015, 5:41pm

Cara,

o ideal e vc postar o log completo para analisarmos… mas o que diz seu log na vdd e que não achou a tabela PG_CLASS

nlsouza · Março 5, 2015, 12:32am

Obrigado por responder, abaixo o erro completo

21:28:23,490 INFO  [org.jboss.modules] (main) JBoss Modules version 1.3.3.Final
21:28:26,490 INFO  [org.jboss.msc] (main) JBoss MSC version 1.2.2.Final
21:28:26,833 INFO  [org.jboss.as] (MSC service thread 1-8) JBAS015899: WildFly 8.2.0.Final "Tweek" starting
21:28:43,219 INFO  [org.jboss.as.server.deployment.scanner] (DeploymentScanner-threads - 1) JBAS015003: Found AgenciaApp.war in deployment directory. To trigger deployment create a file called AgenciaApp.war.dodeploy
21:28:43,350 INFO  [org.jboss.as.server] (Controller Boot Thread) JBAS015888: Creating http management service using socket-binding (management-http)
21:28:43,610 INFO  [org.xnio] (MSC service thread 1-6) XNIO version 3.3.0.Final
21:28:43,720 INFO  [org.xnio.nio] (MSC service thread 1-6) XNIO NIO Implementation Version 3.3.0.Final
21:28:43,884 INFO  [org.jboss.as.naming] (ServerService Thread Pool -- 40) JBAS011800: Activating Naming Subsystem
21:28:43,884 INFO  [org.jboss.as.jsf] (ServerService Thread Pool -- 38) JBAS012615: Activated the following JSF Implementations: [main]
21:28:43,873 WARN  [org.jboss.as.txn] (ServerService Thread Pool -- 46) JBAS010153: Node identifier property is set to the default value. Please make sure it is unique.
21:28:43,914 INFO  [org.jboss.as.clustering.infinispan] (ServerService Thread Pool -- 32) JBAS010280: Activating Infinispan subsystem.
21:28:43,884 INFO  [org.jboss.as.security] (ServerService Thread Pool -- 45) JBAS013171: Activating Security Subsystem
21:28:43,933 INFO  [org.wildfly.extension.io] (ServerService Thread Pool -- 31) WFLYIO001: Worker 'default' has auto-configured to 8 core threads with 64 task threads based on your 4 available processors
21:28:44,005 INFO  [org.jboss.as.webservices] (ServerService Thread Pool -- 48) JBAS015537: Activating WebServices Extension
21:28:44,283 INFO  [org.jboss.as.naming] (MSC service thread 1-7) JBAS011802: Starting Naming Service
21:28:44,377 INFO  [org.wildfly.extension.undertow] (MSC service thread 1-5) JBAS017502: Undertow 1.1.0.Final starting
21:28:44,370 INFO  [org.wildfly.extension.undertow] (ServerService Thread Pool -- 47) JBAS017502: Undertow 1.1.0.Final starting
21:28:44,378 INFO  [org.jboss.as.connector.logging] (MSC service thread 1-8) JBAS010408: Starting JCA Subsystem (IronJacamar 1.1.9.Final)
21:28:44,388 INFO  [org.jboss.as.security] (MSC service thread 1-3) JBAS013170: Current PicketBox version=4.0.21.Final
21:28:44,388 INFO  [org.jboss.as.mail.extension] (MSC service thread 1-7) JBAS015400: Bound mail session [java:jboss/mail/Default]
21:28:44,790 INFO  [org.jboss.as.connector.subsystems.datasources] (ServerService Thread Pool -- 27) JBAS010404: Deploying non-JDBC-compliant driver class org.postgresql.Driver (version 9.3)
21:28:44,960 INFO  [org.jboss.as.connector.deployers.jdbc] (MSC service thread 1-4) JBAS010417: Started Driver service with driver-name = org.postgresql
21:28:45,230 INFO  [org.jboss.remoting] (MSC service thread 1-6) JBoss Remoting version 4.0.6.Final
21:28:45,490 INFO  [org.jboss.as.connector.subsystems.datasources] (ServerService Thread Pool -- 27) JBAS010403: Deploying JDBC-compliant driver class org.h2.Driver (version 1.3)
21:28:45,612 INFO  [org.jboss.as.connector.deployers.jdbc] (MSC service thread 1-8) JBAS010417: Started Driver service with driver-name = h2
21:28:46,965 INFO  [org.wildfly.extension.undertow] (ServerService Thread Pool -- 47) JBAS017527: Creating file handler for path D:\IDE\server\wildfly-8.2.0.Final/welcome-content
21:28:47,215 INFO  [org.wildfly.extension.undertow] (MSC service thread 1-4) JBAS017525: Started server default-server.
21:28:47,360 INFO  [org.wildfly.extension.undertow] (MSC service thread 1-3) JBAS017531: Host default-host starting
21:28:47,626 INFO  [org.wildfly.extension.undertow] (MSC service thread 1-4) JBAS017519: Undertow HTTP listener default listening on localhost/127.0.0.1:8080
21:28:49,468 INFO  [org.jboss.as.server.deployment.scanner] (MSC service thread 1-5) JBAS015012: Started FileSystemDeploymentService for directory D:\IDE\server\wildfly-8.2.0.Final\standalone\deployments
21:28:49,789 INFO  [org.jboss.as.connector.subsystems.datasources] (MSC service thread 1-5) JBAS010400: Bound data source [java:jboss/datasources/ExampleDS]
21:28:49,819 INFO  [org.jboss.as.server.deployment] (MSC service thread 1-6) JBAS015876: Starting deployment of "AgenciaApp.war" (runtime-name: "AgenciaApp.war")
21:28:49,829 INFO  [org.jboss.as.connector.subsystems.datasources] (MSC service thread 1-7) JBAS010400: Bound data source [java:jboss/datasources/agenciaDs]
21:28:54,227 INFO  [org.jboss.ws.common.management] (MSC service thread 1-4) JBWS022052: Starting JBoss Web Services - Stack CXF Server 4.3.2.Final
21:28:57,900 WARN  [org.jboss.as.server.deployment] (MSC service thread 1-6) JBAS015960: Class Path entry jaxb-api.jar in /D:/IDE/server/wildfly-8.2.0.Final/standalone/deployments/AgenciaApp.war/WEB-INF/lib/com.sun.tools.xjc_2.2.0.jar  does not point to a valid jar for a Class-Path reference.
21:28:57,900 WARN  [org.jboss.as.server.deployment] (MSC service thread 1-6) JBAS015960: Class Path entry jaxb-impl.jar in /D:/IDE/server/wildfly-8.2.0.Final/standalone/deployments/AgenciaApp.war/WEB-INF/lib/com.sun.tools.xjc_2.2.0.jar  does not point to a valid jar for a Class-Path reference.
21:28:57,900 WARN  [org.jboss.as.server.deployment] (MSC service thread 1-6) JBAS015960: Class Path entry jsr173_1.0_api.jar in /D:/IDE/server/wildfly-8.2.0.Final/standalone/deployments/AgenciaApp.war/WEB-INF/lib/com.sun.tools.xjc_2.2.0.jar  does not point to a valid jar for a Class-Path reference.
21:28:57,900 WARN  [org.jboss.as.server.deployment] (MSC service thread 1-6) JBAS015960: Class Path entry activation.jar in /D:/IDE/server/wildfly-8.2.0.Final/standalone/deployments/AgenciaApp.war/WEB-INF/lib/com.sun.tools.xjc_2.2.0.jar  does not point to a valid jar for a Class-Path reference.
21:28:59,351 INFO  [org.jboss.as.jpa] (MSC service thread 1-1) JBAS011401: Read persistence.xml for AgenciaApp
21:29:01,686 INFO  [org.jboss.as.jpa] (ServerService Thread Pool -- 50) JBAS011409: Starting Persistence Unit (phase 1 of 2) Service 'AgenciaApp.war#AgenciaApp'
21:29:01,757 INFO  [org.hibernate.jpa.internal.util.LogHelper] (ServerService Thread Pool -- 50) HHH000204: Processing PersistenceUnitInfo [
	name: AgenciaApp
	...]
21:29:02,149 INFO  [org.hibernate.Version] (ServerService Thread Pool -- 50) HHH000412: Hibernate Core {4.3.7.Final}
21:29:02,159 INFO  [org.hibernate.cfg.Environment] (ServerService Thread Pool -- 50) HHH000206: hibernate.properties not found
21:29:02,189 INFO  [org.hibernate.cfg.Environment] (ServerService Thread Pool -- 50) HHH000021: Bytecode provider name : javassist
21:29:02,871 INFO  [org.jboss.weld.deployer] (MSC service thread 1-4) JBAS016002: Processing weld deployment AgenciaApp.war
21:29:04,022 INFO  [org.hibernate.validator.internal.util.Version] (MSC service thread 1-4) HV000001: Hibernate Validator 5.1.3.Final
21:29:06,237 INFO  [org.jboss.as.connector.deployers.jdbc] (MSC service thread 1-4) JBAS010404: Deploying non-JDBC-compliant driver class org.postgresql.Driver (version 9.3)
21:29:06,237 INFO  [org.jboss.weld.deployer] (MSC service thread 1-4) JBAS016005: Starting Services for CDI deployment: AgenciaApp.war
21:29:06,488 INFO  [org.jboss.weld.Version] (MSC service thread 1-4) WELD-000900: 2.2.6 (Final)
21:29:06,668 INFO  [org.jboss.as.connector.deployers.jdbc] (MSC service thread 1-1) JBAS010417: Started Driver service with driver-name = AgenciaApp.war_org.postgresql.Driver_9_3
21:29:06,678 INFO  [org.jboss.weld.deployer] (MSC service thread 1-1) JBAS016008: Starting weld service for deployment AgenciaApp.war
21:29:07,480 INFO  [org.jboss.as.jpa] (ServerService Thread Pool -- 50) JBAS011409: Starting Persistence Unit (phase 2 of 2) Service 'AgenciaApp.war#AgenciaApp'
21:29:07,891 INFO  [org.hibernate.annotations.common.Version] (ServerService Thread Pool -- 50) HCANN000001: Hibernate Commons Annotations {4.0.4.Final}
21:29:08,721 INFO  [org.hibernate.dialect.Dialect] (ServerService Thread Pool -- 50) HHH000400: Using dialect: org.hibernate.dialect.PostgreSQLDialect
21:29:09,572 INFO  [org.hibernate.hql.internal.ast.ASTQueryTranslatorFactory] (ServerService Thread Pool -- 50) HHH000397: Using ASTQueryTranslatorFactory
21:29:12,364 INFO  [org.hibernate.tool.hbm2ddl.SchemaUpdate] (ServerService Thread Pool -- 50) HHH000228: Running hbm2ddl schema update
21:29:12,364 INFO  [org.hibernate.tool.hbm2ddl.SchemaUpdate] (ServerService Thread Pool -- 50) HHH000102: Fetching database metadata
21:29:12,374 ERROR [org.hibernate.tool.hbm2ddl.SchemaUpdate] (ServerService Thread Pool -- 50) HHH000319: Could not get database metadata: org.h2.jdbc.JdbcSQLException: Table "PG_CLASS" not found; SQL statement:
select relname from pg_class where relkind='S' [42102-173]
	at org.h2.message.DbException.getJdbcSQLException(DbException.java:331)
	at org.h2.message.DbException.get(DbException.java:171)
	at org.h2.message.DbException.get(DbException.java:148)
	at org.h2.command.Parser.readTableOrView(Parser.java:4864)
	at org.h2.command.Parser.readTableFilter(Parser.java:1107)
	at org.h2.command.Parser.parseSelectSimpleFromPart(Parser.java:1713)
	at org.h2.command.Parser.parseSelectSimple(Parser.java:1821)
	at org.h2.command.Parser.parseSelectSub(Parser.java:1707)
	at org.h2.command.Parser.parseSelectUnion(Parser.java:1550)
	at org.h2.command.Parser.parseSelect(Parser.java:1538)
	at org.h2.command.Parser.parsePrepared(Parser.java:405)
	at org.h2.command.Parser.parse(Parser.java:279)
	at org.h2.command.Parser.parse(Parser.java:251)
	at org.h2.command.Parser.prepareCommand(Parser.java:218)
	at org.h2.engine.Session.prepareLocal(Session.java:428)
	at org.h2.engine.Session.prepareCommand(Session.java:377)
	at org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1138)
	at org.h2.jdbc.JdbcStatement.executeQuery(JdbcStatement.java:72)
	at org.jboss.jca.adapters.jdbc.WrappedStatement.executeQuery(WrappedStatement.java:344)
	at org.hibernate.tool.hbm2ddl.DatabaseMetadata.initSequences(DatabaseMetadata.java:178) [hibernate-core-4.3.7.Final.jar:4.3.7.Final]
	at org.hibernate.tool.hbm2ddl.DatabaseMetadata.<init>(DatabaseMetadata.java:92) [hibernate-core-4.3.7.Final.jar:4.3.7.Final]
	at org.hibernate.tool.hbm2ddl.DatabaseMetadata.<init>(DatabaseMetadata.java:84) [hibernate-core-4.3.7.Final.jar:4.3.7.Final]
	at org.hibernate.tool.hbm2ddl.SchemaUpdate.execute(SchemaUpdate.java:196) [hibernate-core-4.3.7.Final.jar:4.3.7.Final]
	at org.hibernate.tool.hbm2ddl.SchemaUpdate.execute(SchemaUpdate.java:178) [hibernate-core-4.3.7.Final.jar:4.3.7.Final]
	at org.hibernate.internal.SessionFactoryImpl.<init>(SessionFactoryImpl.java:522) [hibernate-core-4.3.7.Final.jar:4.3.7.Final]
	at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1859) [hibernate-core-4.3.7.Final.jar:4.3.7.Final]
	at org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl$4.perform(EntityManagerFactoryBuilderImpl.java:852) [hibernate-entitymanager-4.3.7.Final.jar:4.3.7.Final]
	at org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl$4.perform(EntityManagerFactoryBuilderImpl.java:845) [hibernate-entitymanager-4.3.7.Final.jar:4.3.7.Final]
	at org.hibernate.boot.registry.classloading.internal.ClassLoaderServiceImpl.withTccl(ClassLoaderServiceImpl.java:398) [hibernate-core-4.3.7.Final.jar:4.3.7.Final]
	at org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.build(EntityManagerFactoryBuilderImpl.java:844) [hibernate-entitymanager-4.3.7.Final.jar:4.3.7.Final]
	at org.jboss.as.jpa.hibernate4.TwoPhaseBootstrapImpl.build(TwoPhaseBootstrapImpl.java:44) [jipijapa-hibernate4-3-1.0.1.Final.jar:]
	at org.jboss.as.jpa.service.PersistenceUnitServiceImpl$1$1.run(PersistenceUnitServiceImpl.java:154) [wildfly-jpa-8.2.0.Final.jar:8.2.0.Final]
	at org.jboss.as.jpa.service.PersistenceUnitServiceImpl$1$1.run(PersistenceUnitServiceImpl.java:117) [wildfly-jpa-8.2.0.Final.jar:8.2.0.Final]
	at java.security.AccessController.doPrivileged(Native Method) [rt.jar:1.7.0_51]
	at org.wildfly.security.manager.WildFlySecurityManager.doChecked(WildFlySecurityManager.java:474) [wildfly-security-manager-1.0.0.Final.jar:1.0.0.Final]
	at org.jboss.as.jpa.service.PersistenceUnitServiceImpl$1.run(PersistenceUnitServiceImpl.java:182) [wildfly-jpa-8.2.0.Final.jar:8.2.0.Final]
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) [rt.jar:1.7.0_51]
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) [rt.jar:1.7.0_51]
	at java.lang.Thread.run(Thread.java:744) [rt.jar:1.7.0_51]
	at org.jboss.threads.JBossThread.run(JBossThread.java:122) [jboss-threads-2.1.1.Final.jar:2.1.1.Final]

21:29:12,395 ERROR [org.hibernate.tool.hbm2ddl.SchemaUpdate] (ServerService Thread Pool -- 50) HHH000299: Could not complete schema update: org.h2.jdbc.JdbcSQLException: Table "PG_CLASS" not found; SQL statement:
select relname from pg_class where relkind='S' [42102-173]
	at org.h2.message.DbException.getJdbcSQLException(DbException.java:331)
	at org.h2.message.DbException.get(DbException.java:171)
	at org.h2.message.DbException.get(DbException.java:148)
	at org.h2.command.Parser.readTableOrView(Parser.java:4864)
	at org.h2.command.Parser.readTableFilter(Parser.java:1107)
	at org.h2.command.Parser.parseSelectSimpleFromPart(Parser.java:1713)
	at org.h2.command.Parser.parseSelectSimple(Parser.java:1821)
	at org.h2.command.Parser.parseSelectSub(Parser.java:1707)
	at org.h2.command.Parser.parseSelectUnion(Parser.java:1550)
	at org.h2.command.Parser.parseSelect(Parser.java:1538)
	at org.h2.command.Parser.parsePrepared(Parser.java:405)
	at org.h2.command.Parser.parse(Parser.java:279)
	at org.h2.command.Parser.parse(Parser.java:251)
	at org.h2.command.Parser.prepareCommand(Parser.java:218)
	at org.h2.engine.Session.prepareLocal(Session.java:428)
	at org.h2.engine.Session.prepareCommand(Session.java:377)
	at org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1138)
	at org.h2.jdbc.JdbcStatement.executeQuery(JdbcStatement.java:72)
	at org.jboss.jca.adapters.jdbc.WrappedStatement.executeQuery(WrappedStatement.java:344)
	at org.hibernate.tool.hbm2ddl.DatabaseMetadata.initSequences(DatabaseMetadata.java:178) [hibernate-core-4.3.7.Final.jar:4.3.7.Final]
	at org.hibernate.tool.hbm2ddl.DatabaseMetadata.<init>(DatabaseMetadata.java:92) [hibernate-core-4.3.7.Final.jar:4.3.7.Final]
	at org.hibernate.tool.hbm2ddl.DatabaseMetadata.<init>(DatabaseMetadata.java:84) [hibernate-core-4.3.7.Final.jar:4.3.7.Final]
	at org.hibernate.tool.hbm2ddl.SchemaUpdate.execute(SchemaUpdate.java:196) [hibernate-core-4.3.7.Final.jar:4.3.7.Final]
	at org.hibernate.tool.hbm2ddl.SchemaUpdate.execute(SchemaUpdate.java:178) [hibernate-core-4.3.7.Final.jar:4.3.7.Final]
	at org.hibernate.internal.SessionFactoryImpl.<init>(SessionFactoryImpl.java:522) [hibernate-core-4.3.7.Final.jar:4.3.7.Final]
	at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1859) [hibernate-core-4.3.7.Final.jar:4.3.7.Final]
	at org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl$4.perform(EntityManagerFactoryBuilderImpl.java:852) [hibernate-entitymanager-4.3.7.Final.jar:4.3.7.Final]
	at org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl$4.perform(EntityManagerFactoryBuilderImpl.java:845) [hibernate-entitymanager-4.3.7.Final.jar:4.3.7.Final]
	at org.hibernate.boot.registry.classloading.internal.ClassLoaderServiceImpl.withTccl(ClassLoaderServiceImpl.java:398) [hibernate-core-4.3.7.Final.jar:4.3.7.Final]
	at org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.build(EntityManagerFactoryBuilderImpl.java:844) [hibernate-entitymanager-4.3.7.Final.jar:4.3.7.Final]
	at org.jboss.as.jpa.hibernate4.TwoPhaseBootstrapImpl.build(TwoPhaseBootstrapImpl.java:44) [jipijapa-hibernate4-3-1.0.1.Final.jar:]
	at org.jboss.as.jpa.service.PersistenceUnitServiceImpl$1$1.run(PersistenceUnitServiceImpl.java:154) [wildfly-jpa-8.2.0.Final.jar:8.2.0.Final]
	at org.jboss.as.jpa.service.PersistenceUnitServiceImpl$1$1.run(PersistenceUnitServiceImpl.java:117) [wildfly-jpa-8.2.0.Final.jar:8.2.0.Final]
	at java.security.AccessController.doPrivileged(Native Method) [rt.jar:1.7.0_51]
	at org.wildfly.security.manager.WildFlySecurityManager.doChecked(WildFlySecurityManager.java:474) [wildfly-security-manager-1.0.0.Final.jar:1.0.0.Final]
	at org.jboss.as.jpa.service.PersistenceUnitServiceImpl$1.run(PersistenceUnitServiceImpl.java:182) [wildfly-jpa-8.2.0.Final.jar:8.2.0.Final]
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) [rt.jar:1.7.0_51]
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) [rt.jar:1.7.0_51]
	at java.lang.Thread.run(Thread.java:744) [rt.jar:1.7.0_51]
	at org.jboss.threads.JBossThread.run(JBossThread.java:122) [jboss-threads-2.1.1.Final.jar:2.1.1.Final]

21:29:12,415 WARN  [org.hibernate.internal.SessionFactoryImpl] (ServerService Thread Pool -- 50) HHH000008: JTASessionContext being used with JDBCTransactionFactory; auto-flush will not operate correctly with getCurrentSession()
21:29:17,014 INFO  [io.undertow.servlet] (MSC service thread 1-7) Spring WebApplicationInitializers detected on classpath: [com.agenciafretebem.security.SecurityWebApplicationInitializer@1818ea0]
21:29:17,645 INFO  [javax.enterprise.resource.webcontainer.jsf.config] (MSC service thread 1-7) Inicializando Mojarra 2.2.8-jbossorg-1 20140822-1131 para o contexto '/AgenciaApp'
21:29:25,875 INFO  [org.primefaces.webapp.PostConstructApplicationEventListener] (MSC service thread 1-7) Running on PrimeFaces 5.1
21:29:25,885 INFO  [io.undertow.servlet] (MSC service thread 1-7) Initializing Spring root WebApplicationContext
21:29:25,885 INFO  [org.springframework.web.context.ContextLoader] (MSC service thread 1-7) Root WebApplicationContext: initialization started
21:29:25,896 INFO  [org.springframework.web.context.support.AnnotationConfigWebApplicationContext] (MSC service thread 1-7) Refreshing Root WebApplicationContext: startup date [Wed Mar 04 21:29:25 BRT 2015]; root of context hierarchy
21:29:25,986 INFO  [org.springframework.web.context.support.AnnotationConfigWebApplicationContext] (MSC service thread 1-7) Registering annotated classes: [class com.agenciafretebem.security.SecurityConfig]
21:29:26,376 INFO  [org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor] (MSC service thread 1-7) JSR-330 'javax.inject.Inject' annotation found and supported for autowiring
21:29:26,426 INFO  [org.springframework.beans.factory.support.DefaultListableBeanFactory] (MSC service thread 1-7) Pre-instantiating singletons in org.springframework.beans.factory.support.DefaultListableBeanFactory@a7218e: defining beans [org.springframework.context.annotation.internalConfigurationAnnotationProcessor,org.springframework.context.annotation.internalAutowiredAnnotationProcessor,org.springframework.context.annotation.internalRequiredAnnotationProcessor,org.springframework.context.annotation.internalCommonAnnotationProcessor,securityConfig,org.springframework.context.annotation.ConfigurationClassPostProcessor.importAwareProcessor,org.springframework.security.config.annotation.authentication.configuration.AuthenticationConfiguration,authenticationManagerBuilder,enableGlobalAuthenticationAutowiredConfigurer,org.springframework.security.config.annotation.web.configuration.WebSecurityConfiguration,springSecurityFilterChain,webSecurityExpressionHandler,privilegeEvaluator,autowiredWebSecurityConfigurersIgnoreParents,org.springframework.security.config.annotation.configuration.ObjectPostProcessorConfiguration,objectPostProcessor]; root of factory hierarchy
21:29:26,968 INFO  [org.springframework.security.web.DefaultSecurityFilterChain] (MSC service thread 1-7) Creating filter chain: org.springframework.security.web.util.matcher.AnyRequestMatcher@1, [org.springframework.security.web.context.request.async.WebAsyncManagerIntegrationFilter@1014a06, org.springframework.security.web.context.SecurityContextPersistenceFilter@3d587d, org.springframework.security.web.header.HeaderWriterFilter@9c9d04, org.springframework.security.web.authentication.logout.LogoutFilter@aa98eb, org.springframework.security.web.authentication.UsernamePasswordAuthenticationFilter@1e5e86b, org.springframework.security.web.savedrequest.RequestCacheAwareFilter@51e467, org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter@18f0298, org.springframework.security.web.authentication.AnonymousAuthenticationFilter@1a2dbb6, org.springframework.security.web.session.SessionManagementFilter@4e639a, org.springframework.security.web.access.ExceptionTranslationFilter@13bd950, org.springframework.security.web.access.intercept.FilterSecurityInterceptor@13140cb]
21:29:27,006 INFO  [org.springframework.web.context.ContextLoader] (MSC service thread 1-7) Root WebApplicationContext: initialization completed in 1121 ms
21:29:28,140 INFO  [org.jboss.resteasy.spi.ResteasyDeployment] (MSC service thread 1-7) Deploying javax.ws.rs.core.Application: class org.eclipse.persistence.jpa.rs.service.JPARSApplication
21:29:28,150 INFO  [org.jboss.resteasy.spi.ResteasyDeployment] (MSC service thread 1-7) Adding provider class org.eclipse.persistence.jpa.rs.exceptions.IllegalArgumentExceptionMapper from Application class org.eclipse.persistence.jpa.rs.service.JPARSApplication
21:29:28,150 INFO  [org.jboss.resteasy.spi.ResteasyDeployment] (MSC service thread 1-7) Adding class resource org.eclipse.persistence.jpa.rs.resources.unversioned.PersistenceUnitResource from Application class org.eclipse.persistence.jpa.rs.service.JPARSApplication
21:29:28,150 INFO  [org.jboss.resteasy.spi.ResteasyDeployment] (MSC service thread 1-7) Adding class resource org.eclipse.persistence.jpa.rs.resources.QueryResource from Application class org.eclipse.persistence.jpa.rs.service.JPARSApplication
21:29:28,150 INFO  [org.jboss.resteasy.spi.ResteasyDeployment] (MSC service thread 1-7) Adding class resource org.eclipse.persistence.jpa.rs.resources.PersistenceUnitResource from Application class org.eclipse.persistence.jpa.rs.service.JPARSApplication
21:29:28,150 INFO  [org.jboss.resteasy.spi.ResteasyDeployment] (MSC service thread 1-7) Adding provider class org.eclipse.persistence.jpa.rs.exceptions.EntityExistsExceptionMapper from Application class org.eclipse.persistence.jpa.rs.service.JPARSApplication
21:29:28,150 INFO  [org.jboss.resteasy.spi.ResteasyDeployment] (MSC service thread 1-7) Adding provider class org.eclipse.persistence.jpa.rs.exceptions.QueryTimeoutExceptionMapper from Application class org.eclipse.persistence.jpa.rs.service.JPARSApplication
21:29:28,150 INFO  [org.jboss.resteasy.spi.ResteasyDeployment] (MSC service thread 1-7) Adding provider class org.eclipse.persistence.jpa.rs.exceptions.DatabaseExceptionMapper from Application class org.eclipse.persistence.jpa.rs.service.JPARSApplication
21:29:28,150 INFO  [org.jboss.resteasy.spi.ResteasyDeployment] (MSC service thread 1-7) Adding provider class org.eclipse.persistence.jpa.rs.exceptions.ClassNotFoundExceptionMapper from Application class org.eclipse.persistence.jpa.rs.service.JPARSApplication
21:29:28,150 INFO  [org.jboss.resteasy.spi.ResteasyDeployment] (MSC service thread 1-7) Adding class resource org.eclipse.persistence.jpa.rs.resources.PersistenceResource from Application class org.eclipse.persistence.jpa.rs.service.JPARSApplication
21:29:28,150 INFO  [org.jboss.resteasy.spi.ResteasyDeployment] (MSC service thread 1-7) Adding class resource org.eclipse.persistence.jpa.rs.resources.unversioned.PersistenceResource from Application class org.eclipse.persistence.jpa.rs.service.JPARSApplication
21:29:28,150 INFO  [org.jboss.resteasy.spi.ResteasyDeployment] (MSC service thread 1-7) Adding class resource org.eclipse.persistence.jpa.rs.resources.EntityResource from Application class org.eclipse.persistence.jpa.rs.service.JPARSApplication
21:29:28,150 INFO  [org.jboss.resteasy.spi.ResteasyDeployment] (MSC service thread 1-7) Adding provider class org.eclipse.persistence.jpa.rs.exceptions.JPARSExceptionMapper from Application class org.eclipse.persistence.jpa.rs.service.JPARSApplication
21:29:28,150 INFO  [org.jboss.resteasy.spi.ResteasyDeployment] (MSC service thread 1-7) Adding provider class org.eclipse.persistence.jpa.rs.exceptions.IllegalAccessExceptionMapper from Application class org.eclipse.persistence.jpa.rs.service.JPARSApplication
21:29:28,150 INFO  [org.jboss.resteasy.spi.ResteasyDeployment] (MSC service thread 1-7) Adding provider class org.eclipse.persistence.jpa.rs.exceptions.NamingExceptionMapper from Application class org.eclipse.persistence.jpa.rs.service.JPARSApplication
21:29:28,150 INFO  [org.jboss.resteasy.spi.ResteasyDeployment] (MSC service thread 1-7) Adding provider class org.eclipse.persistence.jpa.rs.exceptions.NoSuchMethodExceptionMapper from Application class org.eclipse.persistence.jpa.rs.service.JPARSApplication
21:29:28,150 INFO  [org.jboss.resteasy.spi.ResteasyDeployment] (MSC service thread 1-7) Adding class resource org.eclipse.persistence.jpa.rs.resources.unversioned.QueryResource from Application class org.eclipse.persistence.jpa.rs.service.JPARSApplication
21:29:28,150 INFO  [org.jboss.resteasy.spi.ResteasyDeployment] (MSC service thread 1-7) Adding provider class org.eclipse.persistence.jpa.rs.exceptions.JAXBExceptionMapper from Application class org.eclipse.persistence.jpa.rs.service.JPARSApplication
21:29:28,150 INFO  [org.jboss.resteasy.spi.ResteasyDeployment] (MSC service thread 1-7) Adding provider class org.eclipse.persistence.jpa.rs.exceptions.MalformedURLExceptionMapper from Application class org.eclipse.persistence.jpa.rs.service.JPARSApplication
21:29:28,150 INFO  [org.jboss.resteasy.spi.ResteasyDeployment] (MSC service thread 1-7) Adding provider class org.eclipse.persistence.jpa.rs.exceptions.OptimisticLockExceptionMapper from Application class org.eclipse.persistence.jpa.rs.service.JPARSApplication
21:29:28,150 INFO  [org.jboss.resteasy.spi.ResteasyDeployment] (MSC service thread 1-7) Adding provider class org.eclipse.persistence.jpa.rs.exceptions.NoResultExceptionMapper from Application class org.eclipse.persistence.jpa.rs.service.JPARSApplication
21:29:28,150 INFO  [org.jboss.resteasy.spi.ResteasyDeployment] (MSC service thread 1-7) Adding provider class org.eclipse.persistence.jpa.rs.exceptions.JPARSConfigurationExceptionMapper from Application class org.eclipse.persistence.jpa.rs.service.JPARSApplication
21:29:28,150 INFO  [org.jboss.resteasy.spi.ResteasyDeployment] (MSC service thread 1-7) Adding class resource org.eclipse.persistence.jpa.rs.resources.SingleResultQueryResource from Application class org.eclipse.persistence.jpa.rs.service.JPARSApplication
21:29:28,160 INFO  [org.jboss.resteasy.spi.ResteasyDeployment] (MSC service thread 1-7) Adding provider class org.eclipse.persistence.jpa.rs.exceptions.PersistenceExceptionMapper from Application class org.eclipse.persistence.jpa.rs.service.JPARSApplication
21:29:28,160 INFO  [org.jboss.resteasy.spi.ResteasyDeployment] (MSC service thread 1-7) Adding provider class org.eclipse.persistence.jpa.rs.exceptions.NonUniqueResultExceptionExceptionMapper from Application class org.eclipse.persistence.jpa.rs.service.JPARSApplication
21:29:28,161 INFO  [org.jboss.resteasy.spi.ResteasyDeployment] (MSC service thread 1-7) Adding provider class org.eclipse.persistence.jpa.rs.exceptions.IOExceptionMapper from Application class org.eclipse.persistence.jpa.rs.service.JPARSApplication
21:29:28,161 INFO  [org.jboss.resteasy.spi.ResteasyDeployment] (MSC service thread 1-7) Adding class resource org.eclipse.persistence.jpa.rs.resources.unversioned.EntityResource from Application class org.eclipse.persistence.jpa.rs.service.JPARSApplication
21:29:28,161 INFO  [org.jboss.resteasy.spi.ResteasyDeployment] (MSC service thread 1-7) Adding provider class org.eclipse.persistence.jpa.rs.exceptions.PessimisticLockExceptionMapper from Application class org.eclipse.persistence.jpa.rs.service.JPARSApplication
21:29:28,161 INFO  [org.jboss.resteasy.spi.ResteasyDeployment] (MSC service thread 1-7) Adding provider class org.eclipse.persistence.jpa.rs.exceptions.EntityNotFoundExceptionMapper from Application class org.eclipse.persistence.jpa.rs.service.JPARSApplication
21:29:28,161 INFO  [org.jboss.resteasy.spi.ResteasyDeployment] (MSC service thread 1-7) Adding provider class org.eclipse.persistence.jpa.rs.exceptions.IllegalStateExceptionMapper from Application class org.eclipse.persistence.jpa.rs.service.JPARSApplication
21:29:28,161 INFO  [org.jboss.resteasy.spi.ResteasyDeployment] (MSC service thread 1-7) Adding provider class org.eclipse.persistence.jpa.rs.exceptions.InvocationTargetExceptionMapper from Application class org.eclipse.persistence.jpa.rs.service.JPARSApplication
21:29:28,161 INFO  [org.jboss.resteasy.spi.ResteasyDeployment] (MSC service thread 1-7) Adding class resource org.eclipse.persistence.jpa.rs.resources.unversioned.SingleResultQueryResource from Application class org.eclipse.persistence.jpa.rs.service.JPARSApplication
21:29:28,161 INFO  [org.jboss.resteasy.spi.ResteasyDeployment] (MSC service thread 1-7) Adding provider class org.eclipse.persistence.jpa.rs.exceptions.TransactionRequiredExceptionMapper from Application class org.eclipse.persistence.jpa.rs.service.JPARSApplication
21:29:28,161 INFO  [org.jboss.resteasy.spi.ResteasyDeployment] (MSC service thread 1-7) Adding provider class org.eclipse.persistence.jpa.rs.exceptions.RollbackExceptionMapper from Application class org.eclipse.persistence.jpa.rs.service.JPARSApplication
21:29:28,161 INFO  [org.jboss.resteasy.spi.ResteasyDeployment] (MSC service thread 1-7) Adding provider class org.eclipse.persistence.jpa.rs.exceptions.ConversionExceptionMapper from Application class org.eclipse.persistence.jpa.rs.service.JPARSApplication
21:29:29,267 INFO  [org.wildfly.extension.undertow] (MSC service thread 1-7) JBAS017534: Registered web context: /AgenciaApp
21:29:29,667 INFO  [org.jboss.as.server] (ServerService Thread Pool -- 28) JBAS018559: Deployed "AgenciaApp.war" (runtime-name : "AgenciaApp.war")
21:29:29,864 INFO  [org.jboss.as] (Controller Boot Thread) JBAS015961: Http management interface listening on http://127.0.0.1:9990/management
21:29:29,864 INFO  [org.jboss.as] (Controller Boot Thread) JBAS015951: Admin console listening on http://127.0.0.1:9990
21:29:29,864 INFO  [org.jboss.as] (Controller Boot Thread) JBAS015874: WildFly 8.2.0.Final "Tweek" started in 67674ms - Started 301 of 355 services (92 services are lazy, passive or on-demand)

nlsouza · Março 5, 2015, 12:39am

Esqueci, este é o meu persistence.xml

<?xml version="1.0" encoding="UTF-8"?>
<persistence version="2.1" xmlns="http://xmlns.jcp.org/xml/ns/persistence" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://xmlns.jcp.org/xml/ns/persistence http://xmlns.jcp.org/xml/ns/persistence/persistence_2_1.xsd">
	<persistence-unit name="AgenciaApp" transaction-type="RESOURCE_LOCAL">
	<provider>org.hibernate.ejb.HibernatePersistence</provider>
	<class>com.agenciafretebem.model.Avaliacao</class>
	<class>com.agenciafretebem.model.Chamado</class>
	<class>com.agenciafretebem.model.Chamadosub</class>
	<class>com.agenciafretebem.model.ChaveAcesso</class>
	<class>com.agenciafretebem.model.Fornecedor</class>
	<class>com.agenciafretebem.model.Funcionario</class>
	<class>com.agenciafretebem.model.Grupo</class>
	<class>com.agenciafretebem.model.Imagemcliente</class>
	<class>com.agenciafretebem.model.Orcamento</class>
	<class>com.agenciafretebem.model.Pedido</class>
	<class>com.agenciafretebem.model.Usuario</class>
	<class>com.agenciafretebem.model.Veiculo</class>
	<properties>
			<property name="javax.persistence.jdbc.driver" value="org.postgresql.Driver" />
			<property name="javax.persistence.jdbc.url"	value="jdbc:postgresql://localhost:5432/agenciaFrenteBem"></property>
			<property name="javax.persistence.jdbc.user" value="postgres" />
			<property name="javax.persistence.jdbc.password" value="1234" />
			
			<property name="hibernate.dialect" value="org.hibernate.dialect.PostgreSQLDialect" />
			<property name="hibernate.hbm2ddl.auto" value="update" />
			<property name="hibernate.show_sql" value="true" />
			<property name="hibernate.format_sql" value="true" />
		</properties>
	</persistence-unit>
</persistence>

rmendes08 · Março 5, 2015, 11:53am

Fato curioso, a exceção está sendo lançado pelo driver do H2, e não do PostgreSQL:

HHH000299: Could not complete schema update: org.h2.jdbc.JdbcSQLException: Table "PG_CLASS" not found; SQL statement:  
select relname from pg_class where relkind='S' [42102-173]

nlsouza · Março 5, 2015, 4:28pm

vou excluir a configuração do standalone.xhtml do jboss 8.2, acho que ira resolver

jrxxjr · Dezembro 14, 2020, 2:50pm

Sei que é antigo esse post, mas fiz um tutorial sobre JPA, com a sua configuração, por favor, veja se ajuda. Seguem os links:
http://www.tidicas.com.br/?p=1864
http://www.tidicas.com.br/?p=130

Erru ao usar a propriedade update no persisntece.xml

Cursos de Mobile

Cursos de Programação

Cursos de Front-end

Cursos de DevOps

Cursos de Design & UX

Cursos de Business

Cursos de Data & BI