-
1. Re: ERROR [SessionFactoryImpl] Error in named query: Process
tashtego May 8, 2009 10:16 AM (in response to tashtego)this error seems to be thrown because of multiple persistence.xml files. does anyone know of that error message and can tell me more about what to do?
-
2. Re: ERROR [SessionFactoryImpl] Error in named query: Process
kconner May 13, 2009 6:21 AM (in response to tashtego)It looks like there is a conflict arising somewhere, possibly from a version clash in some of the jars.
What are you doing within your webapp? What jars do you include?
Kev -
3. Re: ERROR [SessionFactoryImpl] Error in named query: Process
tashtego May 13, 2009 7:11 AM (in response to tashtego)It is yet a prototype, which means there is not much jars involved yet:
- I downloaded JBoss 4.2.3
- I added ESB 4.5
- I added my datasource
- I added one new jar postgresql-8.1-405.jdbc3.jar in lib folder
- I deployed my ear. Thats all as far as I am concerned.
I have both the JBossAS and the JBoss ESB added to Eclipse Server View. When deploying to the first, the EAR works. Deploying to the second fails. Maybe my ESB is misconfigured? Anything I can test or post to help fix this problem? -
4. Re: ERROR [SessionFactoryImpl] Error in named query: Process
tashtego May 13, 2009 7:23 AM (in response to tashtego)Within the EAR I have:
- One jar for the myEJB module
(mentioned as module/ejb in application.xml)
- One persistence.jar containing the META-INF/persistence.xml
(also mentioned as module/ejb in application.xml)
- One empty myEJBClient.jar
- No webapp exists so far. -
5. Re: ERROR [SessionFactoryImpl] Error in named query: Process
tashtego May 13, 2009 10:23 AM (in response to tashtego)What I found out right now is, that shutting down the server and starting it all new leads to no error messages. My app seams to work. Then when I try to redeploy in eclipse (copy the ear into deploy folder again) without having done any changes to the files, it leads to the posted error! ?...
-
6. Re: ERROR [SessionFactoryImpl] Error in named query: Process
tashtego May 14, 2009 12:04 PM (in response to tashtego)is there yet any solution? :( i extended my prototype with more EJB modules and unfortunately just the first table is being created. after that the error occurs and further creation fails. one more time the (this time complete) log right after deploying:
17:59:14,906 INFO [EARDeployer] Init J2EE application: file:/C:/jboss-4.2.3.GA/server/default/deploy/myapp.ear 17:59:14,937 INFO [JmxKernelAbstraction] creating wrapper delegate for: org.jboss.ejb3.entity.PersistenceUnitDeployment 17:59:14,937 INFO [JmxKernelAbstraction] installing MBean: persistence.units:ear=myapp.ear,unitName=myapp with dependencies: 17:59:14,937 INFO [JmxKernelAbstraction] jboss.jca:name=myappdb,service=DataSourceBinding 17:59:14,937 INFO [PersistenceUnitDeployment] Starting persistence unit persistence.units:ear=myapp.ear,unitName=myapp 17:59:14,953 INFO [Ejb3Configuration] found EJB3 Entity bean: de.mycompany.pms.Person 17:59:14,953 INFO [Ejb3Configuration] found EJB3 @MappedSuperclass: de.mycompany.persistence.AbstractEntity 17:59:14,953 INFO [Configuration] Reading mappings from resource : META-INF/orm.xml 17:59:14,953 INFO [Ejb3Configuration] [PersistenceUnit: myapp] META-INF/orm.xml found 17:59:14,953 INFO [QueryBinder] Binding Named query: ProcessInstancesWaitingForEvent => select processInstanceInfo.processInstanceId from ProcessInstanceInfo processInstanceInfo where :type in elements(processInstanceInfo.eventTypes) 17:59:14,953 INFO [AnnotationBinder] Binding entity from annotated class: de.mycompany.pms.Person 17:59:14,953 INFO [EntityBinder] Bind entity de.mycompany.pms.Person on table Person 17:59:14,953 INFO [ConnectionProviderFactory] Initializing connection provider: org.hibernate.ejb.connection.InjectedDataSourceConnectionProvider 17:59:14,953 INFO [InjectedDataSourceConnectionProvider] Using provided datasource 17:59:14,953 INFO [SettingsFactory] RDBMS: PostgreSQL, version: 8.3.7 17:59:14,953 INFO [SettingsFactory] JDBC driver: PostgreSQL Native Driver, version: PostgreSQL 8.1 JDBC3 with SSL (build 405) 17:59:14,953 INFO [Dialect] Using dialect: org.hibernate.dialect.PostgreSQLDialect 17:59:14,953 INFO [TransactionFactoryFactory] Transaction strategy: org.hibernate.ejb.transaction.JoinableCMTTransactionFactory 17:59:14,953 INFO [TransactionManagerLookupFactory] instantiating TransactionManagerLookup: org.hibernate.transaction.JBossTransactionManagerLookup 17:59:14,953 INFO [TransactionManagerLookupFactory] instantiated TransactionManagerLookup 17:59:14,953 INFO [SettingsFactory] Automatic flush during beforeCompletion(): disabled 17:59:14,953 INFO [SettingsFactory] Automatic session close at end of transaction: disabled 17:59:14,953 INFO [SettingsFactory] JDBC batch size: 15 17:59:14,953 INFO [SettingsFactory] JDBC batch updates for versioned data: disabled 17:59:14,953 INFO [SettingsFactory] Scrollable result sets: enabled 17:59:14,953 INFO [SettingsFactory] JDBC3 getGeneratedKeys(): disabled 17:59:14,953 INFO [SettingsFactory] Connection release mode: auto 17:59:14,953 INFO [SettingsFactory] Default batch fetch size: 1 17:59:14,953 INFO [SettingsFactory] Generate SQL with comments: disabled 17:59:14,968 INFO [SettingsFactory] Order SQL updates by primary key: disabled 17:59:14,968 INFO [SettingsFactory] Order SQL inserts for batching: disabled 17:59:14,968 INFO [SettingsFactory] Query translator: org.hibernate.hql.ast.ASTQueryTranslatorFactory 17:59:14,968 INFO [ASTQueryTranslatorFactory] Using ASTQueryTranslatorFactory 17:59:14,968 INFO [SettingsFactory] Query language substitutions: {} 17:59:14,968 INFO [SettingsFactory] JPA-QL strict compliance: enabled 17:59:14,968 INFO [SettingsFactory] Second-level cache: enabled 17:59:14,968 INFO [SettingsFactory] Query cache: disabled 17:59:14,968 INFO [SettingsFactory] Cache provider: org.hibernate.cache.HashtableCacheProvider 17:59:14,968 INFO [SettingsFactory] Optimize cache for minimal puts: disabled 17:59:14,968 INFO [SettingsFactory] Cache region prefix: myapp_ear,myapp 17:59:14,968 INFO [SettingsFactory] Structured second-level cache entries: disabled 17:59:14,968 INFO [SettingsFactory] Statistics: disabled 17:59:14,968 INFO [SettingsFactory] Deleted entity synthetic identifier rollback: disabled 17:59:14,968 INFO [SettingsFactory] Default entity-mode: pojo 17:59:14,968 INFO [SettingsFactory] Named query checking : enabled 17:59:14,968 INFO [SessionFactoryImpl] building session factory 17:59:14,968 INFO [SessionFactoryObjectFactory] Factory name: persistence.units:ear=myapp.ear,unitName=myapp 17:59:14,968 INFO [NamingHelper] JNDI InitialContext properties:{java.naming.factory.initial=org.jnp.interfaces.NamingContextFactory, java.naming.factory.url.pkgs=org.jboss.naming:org.jnp.interfaces} 17:59:14,968 INFO [SessionFactoryObjectFactory] Bound factory to JNDI name: persistence.units:ear=myapp.ear,unitName=myapp 17:59:14,968 WARN [SessionFactoryObjectFactory] InitialContext did not implement EventContext 17:59:14,968 INFO [SchemaUpdate] Running hbm2ddl schema update 17:59:14,968 INFO [SchemaUpdate] fetching database metadata 17:59:14,968 INFO [SchemaUpdate] updating schema 17:59:14,968 INFO [DatabaseMetadata] table not found: Person 17:59:14,984 INFO [DatabaseMetadata] table not found: Person 17:59:15,187 INFO [SchemaUpdate] schema update complete 17:59:15,187 INFO [NamingHelper] JNDI InitialContext properties:{java.naming.factory.initial=org.jnp.interfaces.NamingContextFactory, java.naming.factory.url.pkgs=org.jboss.naming:org.jnp.interfaces} 17:59:15,203 ERROR [SessionFactoryImpl] Error in named query: ProcessInstancesWaitingForEvent org.hibernate.hql.ast.QuerySyntaxException: ProcessInstanceInfo is not mapped [select processInstanceInfo.processInstanceId from ProcessInstanceInfo processInstanceInfo where :type in elements(processInstanceInfo.eventTypes)] at org.hibernate.hql.ast.util.SessionFactoryHelper.requireClassPersister(SessionFactoryHelper.java:158) at org.hibernate.hql.ast.tree.FromElementFactory.addFromElement(FromElementFactory.java:87) at org.hibernate.hql.ast.tree.FromClause.addFromElement(FromClause.java:70) at org.hibernate.hql.ast.HqlSqlWalker.createFromElement(HqlSqlWalker.java:255) at org.hibernate.hql.antlr.HqlSqlBaseWalker.fromElement(HqlSqlBaseWalker.java:3056) at org.hibernate.hql.antlr.HqlSqlBaseWalker.fromElementList(HqlSqlBaseWalker.java:2945) at org.hibernate.hql.antlr.HqlSqlBaseWalker.fromClause(HqlSqlBaseWalker.java:688) at org.hibernate.hql.antlr.HqlSqlBaseWalker.query(HqlSqlBaseWalker.java:544) at org.hibernate.hql.antlr.HqlSqlBaseWalker.selectStatement(HqlSqlBaseWalker.java:281) at org.hibernate.hql.antlr.HqlSqlBaseWalker.statement(HqlSqlBaseWalker.java:229) at org.hibernate.hql.ast.QueryTranslatorImpl.analyze(QueryTranslatorImpl.java:228) at org.hibernate.hql.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:160) at org.hibernate.hql.ast.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:111) at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:77) at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:56) at org.hibernate.engine.query.QueryPlanCache.getHQLQueryPlan(QueryPlanCache.java:72) at org.hibernate.impl.SessionFactoryImpl.checkNamedQueries(SessionFactoryImpl.java:402) at org.hibernate.impl.SessionFactoryImpl.<init>(SessionFactoryImpl.java:352) at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1294) at org.hibernate.ejb.Ejb3Configuration.buildEntityManagerFactory(Ejb3Configuration.java:713) at org.hibernate.ejb.HibernatePersistence.createContainerEntityManagerFactory(HibernatePersistence.java:127) at org.jboss.ejb3.entity.PersistenceUnitDeployment.start(PersistenceUnitDeployment.java:246) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.jboss.ejb3.ServiceDelegateWrapper.startService(ServiceDelegateWrapper.java:103) at org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:289) at org.jboss.system.ServiceMBeanSupport.jbossInternalLifecycle(ServiceMBeanSupport.java:245) at sun.reflect.GeneratedMethodAccessor3.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155) at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94) at org.jboss.mx.server.Invocation.invoke(Invocation.java:86) at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264) at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659) at org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:978) at $Proxy0.start(Unknown Source) at org.jboss.system.ServiceController.start(ServiceController.java:417) at sun.reflect.GeneratedMethodAccessor9.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155) at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94) at org.jboss.mx.server.Invocation.invoke(Invocation.java:86) at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264) at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659) at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210) at $Proxy145.start(Unknown Source) at org.jboss.ejb3.JmxKernelAbstraction.install(JmxKernelAbstraction.java:120) at org.jboss.ejb3.Ejb3Deployment.startPersistenceUnits(Ejb3Deployment.java:627) at org.jboss.ejb3.Ejb3Deployment.start(Ejb3Deployment.java:351) at org.jboss.ejb3.Ejb3Module.startService(Ejb3Module.java:91) at org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:289) at org.jboss.system.ServiceMBeanSupport.jbossInternalLifecycle(ServiceMBeanSupport.java:245) at sun.reflect.GeneratedMethodAccessor3.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155) at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94) at org.jboss.mx.server.Invocation.invoke(Invocation.java:86) at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264) at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659) at org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:978) at $Proxy0.start(Unknown Source) at org.jboss.system.ServiceController.start(ServiceController.java:417) at sun.reflect.GeneratedMethodAccessor9.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155) at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94) at org.jboss.mx.server.Invocation.invoke(Invocation.java:86) at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264) at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659) at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210) at $Proxy33.start(Unknown Source) at org.jboss.ejb3.EJB3Deployer.start(EJB3Deployer.java:512) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155) at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94) at org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractInterceptor.java:133) at org.jboss.mx.server.Invocation.invoke(Invocation.java:88) at org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelMBeanOperationInterceptor.java:142) at org.jboss.mx.interceptor.DynamicInterceptor.invoke(DynamicInterceptor.java:97) at org.jboss.system.InterceptorServiceMBeanSupport.invokeNext(InterceptorServiceMBeanSupport.java:238) at org.jboss.wsf.container.jboss42.DeployerInterceptor.start(DeployerInterceptor.java:87) at org.jboss.deployment.SubDeployerInterceptorSupport$XMBeanInterceptor.start(SubDeployerInterceptorSupport.java:188) at org.jboss.deployment.SubDeployerInterceptor.invoke(SubDeployerInterceptor.java:95) at org.jboss.mx.server.Invocation.invoke(Invocation.java:88) at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264) at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659) at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210) at $Proxy34.start(Unknown Source) at org.jboss.deployment.MainDeployer.start(MainDeployer.java:1025) at org.jboss.deployment.MainDeployer.start(MainDeployer.java:1015) at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:819) at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:782) at sun.reflect.GeneratedMethodAccessor21.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155) at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94) at org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractInterceptor.java:133) at org.jboss.mx.server.Invocation.invoke(Invocation.java:88) at org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelMBeanOperationInterceptor.java:142) at org.jboss.mx.server.Invocation.invoke(Invocation.java:88) at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264) at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659) at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210) at $Proxy9.deploy(Unknown Source) at org.jboss.deployment.scanner.URLDeploymentScanner.deploy(URLDeploymentScanner.java:421) at org.jboss.deployment.scanner.URLDeploymentScanner.scan(URLDeploymentScanner.java:634) at org.jboss.deployment.scanner.AbstractDeploymentScanner$ScannerThread.doScan(AbstractDeploymentScanner.java:263) at org.jboss.deployment.scanner.AbstractDeploymentScanner$ScannerThread.loop(AbstractDeploymentScanner.java:274) at org.jboss.deployment.scanner.AbstractDeploymentScanner$ScannerThread.run(AbstractDeploymentScanner.java:225) 17:59:15,203 WARN [ServiceController] Problem starting service persistence.units:ear=myapp.ear,unitName=myapp javax.persistence.PersistenceException: org.hibernate.HibernateException: Errors in named queries: ProcessInstancesWaitingForEvent at org.hibernate.ejb.Ejb3Configuration.buildEntityManagerFactory(Ejb3Configuration.java:720) at org.hibernate.ejb.HibernatePersistence.createContainerEntityManagerFactory(HibernatePersistence.java:127) at org.jboss.ejb3.entity.PersistenceUnitDeployment.start(PersistenceUnitDeployment.java:246) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.jboss.ejb3.ServiceDelegateWrapper.startService(ServiceDelegateWrapper.java:103) at org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:289) at org.jboss.system.ServiceMBeanSupport.jbossInternalLifecycle(ServiceMBeanSupport.java:245) at sun.reflect.GeneratedMethodAccessor3.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155) at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94) at org.jboss.mx.server.Invocation.invoke(Invocation.java:86) at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264) at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659) at org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:978) at $Proxy0.start(Unknown Source) at org.jboss.system.ServiceController.start(ServiceController.java:417) at sun.reflect.GeneratedMethodAccessor9.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155) at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94) at org.jboss.mx.server.Invocation.invoke(Invocation.java:86) at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264) at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659) at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210) at $Proxy145.start(Unknown Source) at org.jboss.ejb3.JmxKernelAbstraction.install(JmxKernelAbstraction.java:120) at org.jboss.ejb3.Ejb3Deployment.startPersistenceUnits(Ejb3Deployment.java:627) at org.jboss.ejb3.Ejb3Deployment.start(Ejb3Deployment.java:351) at org.jboss.ejb3.Ejb3Module.startService(Ejb3Module.java:91) at org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:289) at org.jboss.system.ServiceMBeanSupport.jbossInternalLifecycle(ServiceMBeanSupport.java:245) at sun.reflect.GeneratedMethodAccessor3.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155) at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94) at org.jboss.mx.server.Invocation.invoke(Invocation.java:86) at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264) at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659) at org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:978) at $Proxy0.start(Unknown Source) at org.jboss.system.ServiceController.start(ServiceController.java:417) at sun.reflect.GeneratedMethodAccessor9.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155) at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94) at org.jboss.mx.server.Invocation.invoke(Invocation.java:86) at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264) at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659) at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210) at $Proxy33.start(Unknown Source) at org.jboss.ejb3.EJB3Deployer.start(EJB3Deployer.java:512) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155) at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94) at org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractInterceptor.java:133) at org.jboss.mx.server.Invocation.invoke(Invocation.java:88) at org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelMBeanOperationInterceptor.java:142) at org.jboss.mx.interceptor.DynamicInterceptor.invoke(DynamicInterceptor.java:97) at org.jboss.system.InterceptorServiceMBeanSupport.invokeNext(InterceptorServiceMBeanSupport.java:238) at org.jboss.wsf.container.jboss42.DeployerInterceptor.start(DeployerInterceptor.java:87) at org.jboss.deployment.SubDeployerInterceptorSupport$XMBeanInterceptor.start(SubDeployerInterceptorSupport.java:188) at org.jboss.deployment.SubDeployerInterceptor.invoke(SubDeployerInterceptor.java:95) at org.jboss.mx.server.Invocation.invoke(Invocation.java:88) at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264) at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659) at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210) at $Proxy34.start(Unknown Source) at org.jboss.deployment.MainDeployer.start(MainDeployer.java:1025) at org.jboss.deployment.MainDeployer.start(MainDeployer.java:1015) at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:819) at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:782) at sun.reflect.GeneratedMethodAccessor21.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155) at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94) at org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractInterceptor.java:133) at org.jboss.mx.server.Invocation.invoke(Invocation.java:88) at org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelMBeanOperationInterceptor.java:142) at org.jboss.mx.server.Invocation.invoke(Invocation.java:88) at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264) at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659) at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210) at $Proxy9.deploy(Unknown Source) at org.jboss.deployment.scanner.URLDeploymentScanner.deploy(URLDeploymentScanner.java:421) at org.jboss.deployment.scanner.URLDeploymentScanner.scan(URLDeploymentScanner.java:634) at org.jboss.deployment.scanner.AbstractDeploymentScanner$ScannerThread.doScan(AbstractDeploymentScanner.java:263) at org.jboss.deployment.scanner.AbstractDeploymentScanner$ScannerThread.loop(AbstractDeploymentScanner.java:274) at org.jboss.deployment.scanner.AbstractDeploymentScanner$ScannerThread.run(AbstractDeploymentScanner.java:225) Caused by: org.hibernate.HibernateException: Errors in named queries: ProcessInstancesWaitingForEvent at org.hibernate.impl.SessionFactoryImpl.<init>(SessionFactoryImpl.java:365) at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1294) at org.hibernate.ejb.Ejb3Configuration.buildEntityManagerFactory(Ejb3Configuration.java:713) ... 99 more 17:59:15,203 INFO [EJB3Deployer] Deployed: file:/C:/jboss-4.2.3.GA/server/default/tmp/deploy/tmp6654267559961154785myapp.ear-contents/persistence.jar 17:59:15,203 INFO [EARDeployer] Started J2EE application: file:/C:/jboss-4.2.3.GA/server/default/deploy/myapp.ear 17:59:15,203 ERROR [URLDeploymentScanner] Incomplete Deployment listing: --- MBeans waiting for other MBeans --- ObjectName: persistence.units:ear=myapp.ear,unitName=myapp State: FAILED Reason: javax.persistence.PersistenceException: org.hibernate.HibernateException: Errors in named queries: ProcessInstancesWaitingForEvent I Depend On: jboss.jca:service=DataSourceBinding,name=myappdb --- MBEANS THAT ARE THE ROOT CAUSE OF THE PROBLEM --- ObjectName: persistence.units:ear=myapp.ear,unitName=myapp State: FAILED Reason: javax.persistence.PersistenceException: org.hibernate.HibernateException: Errors in named queries: ProcessInstancesWaitingForEvent I Depend On: jboss.jca:service=DataSourceBinding,name=myappdb
-
7. Re: ERROR [SessionFactoryImpl] Error in named query: Process
beve May 14, 2009 12:55 PM (in response to tashtego)Hi,
can you try to scope your deployment?
http://www.jboss.org/community/wiki/JBossESBDeploymentStrategies see the section "Scoping deployment".
Regards,
/Daniel -
8. Re: ERROR [SessionFactoryImpl] Error in named query: Process
tashtego May 15, 2009 4:45 AM (in response to tashtego)"It is possible to scope the deployment of an esb artifact, if necessary, by including a loader-repository element within the deployment.xml."
There is not yet any depoyment.xml or ESB archive. I only deploy one EAR including 2.. ejb jars and one jar containing persistence.xml. No esb yet. That will be the next step. -
9. Re: ERROR [SessionFactoryImpl] Error in named query: Process
beve May 15, 2009 4:48 AM (in response to tashtego)
I only deploy one EAR including 2.. ejb jars and one jar containing persistence.xml.
Then scope the EAR to see if that takes care of your issue. -
10. Re: ERROR [SessionFactoryImpl] Error in named query: Process
kconner May 18, 2009 4:52 AM (in response to tashtego)The only reference to that query that I can find is from drools, mentioned in their orm.xml file. Of course, I am assuming you do not have a query of the same name.
For some reason you are pulling in their configuration rather than your own but this should definitely not happen, the EJB deployer should be using the configuration from your deployment.
Scoping the ear, as Daniel says, should help you out but it sounds as if there is something more fundamental going wrong.
What do you get if you enable DEBUG for org.hibernate? Does it shed any light on the issue?
Kev -
11. Re: ERROR [SessionFactoryImpl] Error in named query: Process
tashtego May 18, 2009 7:39 AM (in response to tashtego)What do you get if you enable DEBUG for org.hibernate? Does it shed any light on the issue?
No really, I guess :( ->2009-05-18 13:28:33,371 INFO [org.hibernate.tool.hbm2ddl.SchemaUpdate] schema update complete 2009-05-18 13:28:33,371 DEBUG [org.hibernate.impl.SessionFactoryImpl] obtaining JTA TransactionManager 2009-05-18 13:28:33,371 INFO [org.hibernate.util.NamingHelper] JNDI InitialContext properties:{java.naming.factory.initial=org.jnp.interfaces.NamingContextFactory, java.naming.factory.url.pkgs=org.jboss.naming:org.jnp.interfaces} 2009-05-18 13:28:33,371 DEBUG [org.hibernate.impl.SessionFactoryImpl] Checking 1 named HQL queries 2009-05-18 13:28:33,371 DEBUG [org.hibernate.impl.SessionFactoryImpl] Checking named query: ProcessInstancesWaitingForEvent 2009-05-18 13:28:33,371 DEBUG [org.hibernate.hql.ast.QueryTranslatorImpl] parse() - HQL: select processInstanceInfo.processInstanceId from ProcessInstanceInfo processInstanceInfo where :type in elements(processInstanceInfo.eventTypes) 2009-05-18 13:28:33,386 DEBUG [org.hibernate.hql.ast.AST] --- HQL AST --- \-[QUERY] 'query' +-[SELECT_FROM] 'SELECT_FROM' | +-[FROM] 'from' | | \-[RANGE] 'RANGE' | | +-[IDENT] 'ProcessInstanceInfo' | | \-[ALIAS] 'processInstanceInfo' | \-[SELECT] 'select' | \-[DOT] '.' | +-[IDENT] 'processInstanceInfo' | \-[IDENT] 'processInstanceId' \-[WHERE] 'where' \-[IN] 'in' +-[COLON] ':' | \-[IDENT] 'type' \-[IN_LIST] 'inList' \-[ELEMENTS] 'elements' \-[DOT] '.' +-[IDENT] 'processInstanceInfo' \-[IDENT] 'eventTypes' 2009-05-18 13:28:33,386 DEBUG [org.hibernate.hql.ast.ErrorCounter] throwQueryException() : no errors 2009-05-18 13:28:33,386 DEBUG [org.hibernate.hql.antlr.HqlSqlBaseWalker] select << begin [level=1, statement=select] 2009-05-18 13:28:33,386 DEBUG [org.hibernate.impl.SessionFactoryImpl] Checking 0 named SQL queries 2009-05-18 13:28:33,386 ERROR [org.hibernate.impl.SessionFactoryImpl] Error in named query: ProcessInstancesWaitingForEvent org.hibernate.hql.ast.QuerySyntaxException: ProcessInstanceInfo is not mapped [select processInstanceInfo.processInstanceId from ProcessInstanceInfo processInstanceInfo where :type in elements(processInstanceInfo.eventTypes)] at org.hibernate.hql.ast.util.SessionFactoryHelper.requireClassPersister(SessionFactoryHelper.java:158) at org.hibernate.hql.ast.tree.FromElementFactory.addFromElement(FromElementFactory.java:87) at org.hibernate.hql.ast.tree.FromClause.addFromElement(FromClause.java:70) at org.hibernate.hql.ast.HqlSqlWalker.createFromElement(HqlSqlWalker.java:255) at org.hibernate.hql.antlr.HqlSqlBaseWalker.fromElement(HqlSqlBaseWalker.java:3056) at org.hibernate.hql.antlr.HqlSqlBaseWalker.fromElementList(HqlSqlBaseWalker.java:2945) at org.hibernate.hql.antlr.HqlSqlBaseWalker.fromClause(HqlSqlBaseWalker.java:688) at org.hibernate.hql.antlr.HqlSqlBaseWalker.query(HqlSqlBaseWalker.java:544) at org.hibernate.hql.antlr.HqlSqlBaseWalker.selectStatement(HqlSqlBaseWalker.java:281) at org.hibernate.hql.antlr.HqlSqlBaseWalker.statement(HqlSqlBaseWalker.java:229) at org.hibernate.hql.ast.QueryTranslatorImpl.analyze(QueryTranslatorImpl.java:228) at org.hibernate.hql.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:160) at org.hibernate.hql.ast.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:111)
-
12. Re: ERROR [SessionFactoryImpl] Error in named query: Process
tashtego May 18, 2009 8:27 AM (in response to tashtego)would it help to upload my ear? or send it at your mail adress, kevin?
-
13. Re: ERROR [SessionFactoryImpl] Error in named query: Process
tashtego May 18, 2009 4:32 PM (in response to tashtego)Well, besides of this hot deployment problem, I really love all that work that was done for JBoss and ESB. I am working on a prototype with my collegue here and our goal is to presentate this app including web services, ESB and all that nice stuff. It will have to beat out our concurrent .net - prototype. And I really hope that our management will decide to use JBoss in the future, its exiting. Right now we can live with the workaround to deploy and restart the ESB server. That works and gives us all possibilities to test our app. But of course it would be great to see that this JBoss bug will be fixed, too. Thanks for all your help.
-
14. Re: ERROR [SessionFactoryImpl] Error in named query: Process
vincentgr May 19, 2009 8:10 AM (in response to tashtego)I'm experiencing the very same problem, but unfortunately for me it happens every time : after server startup as well as when hot-deploying.
It seems really linked to JBossESB - I have a small test case that works fine withe the default JBoss 4.2.3 but not at all with JbossESB 4.5 on top of it.
My configuration is ultra basic: I am just deploying a single JAR with 2 (at)Entity beans. There is no EJB stuff.
BUT it seems to be definitely linked to hot deployment in conjunction with JBossESB. If I deploy with JBoss tools, I have the error, but if I put directly my .jar into the deploy folder of the server, it works perfectly !! Note however that doing this way the EJB is deployed before Drools.
Hope this helps. Should I post a bug in JIRA ? In which section ?
OK version (without JBoss ESB, or with JBossESB directly in the deploy folder):13:47:40,597 INFO [Ejb3Configuration] found EJB3 @Embeddable: entity.Address 13:47:40,612 INFO [Ejb3Configuration] found EJB3 Entity bean: entity.Company 13:47:40,612 INFO [Ejb3Configuration] found EJB3 Entity bean: entity.Person 13:47:40,925 INFO [Configuration] Reading mappings from resource : META-INF/orm.xml 13:47:40,925 INFO [Ejb3Configuration] [PersistenceUnit: custdb] no META-INF/orm.xml found 13:47:40,972 INFO [AnnotationBinder] Binding entity from annotated class: entity.Company 13:47:41,019 INFO [EntityBinder] Bind entity entity.Company on table Company 13:47:41,097 INFO [AnnotationBinder] Binding entity from annotated class: entity.Person 13:47:41,097 INFO [EntityBinder] Bind entity entity.Person on table Person 13:47:41,175 INFO [CollectionBinder] Mapping collection: entity.Company.employees -> Person
KO version (With Jboss ESB):14:02:52,228 INFO [Ejb3Configuration] found EJB3 @Embeddable: entity.Address 14:02:52,228 INFO [Ejb3Configuration] found EJB3 Entity bean: entity.Company 14:02:52,243 INFO [Ejb3Configuration] found EJB3 Entity bean: entity.Person 14:02:52,275 INFO [Configuration] Reading mappings from resource : META-INF/orm.xml 14:02:52,306 INFO [Ejb3Configuration] [PersistenceUnit: custdb] META-INF/orm.xml found 14:02:52,306 INFO [QueryBinder] Binding Named query: ProcessInstancesWaitingForEvent => select processInstanceInfo.processInstanceId from ProcessInstanceInfo processInstanceInfo where :type in elements(processInstanceInfo.eventTypes) 14:02:52,306 INFO [AnnotationBinder] Binding entity from annotated class: entity.Company 14:02:52,306 INFO [EntityBinder] Bind entity entity.Company on table Company 14:02:52,306 INFO [AnnotationBinder] Binding entity from annotated class: entity.Person 14:02:52,306 INFO [EntityBinder] Bind entity entity.Person on table Person 14:02:52,306 INFO [CollectionBinder] Mapping collection: entity.Company.employees -> Person