My EJB don't access the database
leandroseverino Nov 6, 2007 1:05 PMWhen I execute this code in my EJB:
em.createQuery("select object(o) from ElementoGerenciado as o").getResultList();
I receive this errors:
The complete log of my JBoss:
========================================================================= JBoss Bootstrap Environment JBOSS_HOME: /home/leandro/javaapps/jboss-4.2.1.GA JAVA: /home/leandro/jdk1.6.0_03/bin/java JAVA_OPTS: -Dprogram.name=run.sh -server -classic -Xdebug -Xnoagent -Djava.compiler=NONE -Xrunjdwp:transport=dt_socket,address=8787,server=y,suspend=n -Djava.net.preferIPv4Stack=true CLASSPATH: /home/leandro/javaapps/jboss-4.2.1.GA/bin/run.jar:/home/leandro/jdk1.6.0_03/lib/tools.jar ========================================================================= Listening for transport dt_socket at address: 8787 15:48:24,671 INFO [Server] Starting JBoss (MX MicroKernel)... 15:48:24,673 INFO [Server] Release ID: JBoss [Trinity] 4.2.1.GA (build: SVNTag=JBoss_4_2_1_GA date=200707131605) 15:48:24,674 INFO [Server] Home Dir: /home/leandro/javaapps/jboss-4.2.1.GA 15:48:24,675 INFO [Server] Home URL: file:/home/leandro/javaapps/jboss-4.2.1.GA/ 15:48:24,676 INFO [Server] Patch URL: null 15:48:24,676 INFO [Server] Server Name: default 15:48:24,676 INFO [Server] Server Home Dir: /home/leandro/javaapps/jboss-4.2.1.GA/server/default 15:48:24,677 INFO [Server] Server Home URL: file:/home/leandro/javaapps/jboss-4.2.1.GA/server/default/ 15:48:24,677 INFO [Server] Server Log Dir: /home/leandro/javaapps/jboss-4.2.1.GA/server/default/log 15:48:24,677 INFO [Server] Server Temp Dir: /home/leandro/javaapps/jboss-4.2.1.GA/server/default/tmp 15:48:24,678 INFO [Server] Root Deployment Filename: jboss-service.xml 15:48:25,318 INFO [ServerInfo] Java version: 1.6.0_03,Sun Microsystems Inc. 15:48:25,318 INFO [ServerInfo] Java VM: Java HotSpot(TM) 64-Bit Server VM 1.6.0_03-b05,Sun Microsystems Inc. 15:48:25,319 INFO [ServerInfo] OS-System: Linux 2.6.22-2-amd64,amd64 15:48:26,553 INFO [Server] Core system initialized 15:48:30,068 INFO [WebService] Using RMI server codebase: http://127.0.0.1:8083/ 15:48:30,071 INFO [Log4jService$URLWatchTimerTask] Configuring from URL: resource:jboss-log4j.xml 15:48:31,040 INFO [TransactionManagerService] JBossTS Transaction Service (JTA version) - JBoss Inc. 15:48:31,040 INFO [TransactionManagerService] Setting up property manager MBean and JMX layer 15:48:31,416 INFO [TransactionManagerService] Starting recovery manager 15:48:32,076 INFO [TransactionManagerService] Recovery manager started 15:48:32,076 INFO [TransactionManagerService] Binding TransactionManager JNDI Reference 15:48:37,512 INFO [EJB3Deployer] Starting java:comp multiplexer 15:48:40,119 INFO [ServiceEndpointManager] jbossws-1.2.1.GA (build=200704151756) 15:48:42,591 INFO [AprLifecycleListener] The Apache Tomcat Native library which allows optimal performance in production environments was not found on the java.library.path: /home/leandro/jdk1.6.0_03/jre/lib/amd64/server:/home/leandro/jdk1.6.0_03/jre/lib/amd64:/home/leandro/jdk1.6.0_03/jre/../lib/amd64:/usr/java/packages/lib/amd64:/lib:/usr/lib 15:48:42,706 INFO [Http11Protocol] Initializing Coyote HTTP/1.1 on http-127.0.0.1-8080 15:48:42,708 INFO [AjpProtocol] Initializing Coyote AJP/1.3 on ajp-127.0.0.1-8009 15:48:42,709 INFO [Catalina] Initialization processed in 373 ms 15:48:42,710 INFO [StandardService] Starting service jboss.web 15:48:42,712 INFO [StandardEngine] Starting Servlet Engine: JBossWeb/2.0.0.GA 15:48:42,794 INFO [Catalina] Server startup in 84 ms 15:48:43,114 INFO [TomcatDeployer] deploy, ctxPath=/, warUrl=.../deploy/jboss-web.deployer/ROOT.war/ 15:48:44,418 INFO [TomcatDeployer] deploy, ctxPath=/invoker, warUrl=.../deploy/http-invoker.sar/invoker.war/ 15:48:44,722 INFO [TomcatDeployer] deploy, ctxPath=/jbossws, warUrl=.../tmp/deploy/tmp5352jbossws-context-exp.war/ 15:48:44,927 INFO [TomcatDeployer] deploy, ctxPath=/jbossmq-httpil, warUrl=.../deploy/jms/jbossmq-httpil.sar/jbossmq-httpil.war/ 15:48:46,461 INFO [TomcatDeployer] deploy, ctxPath=/web-console, warUrl=.../deploy/management/console-mgr.sar/web-console.war/ 15:48:47,590 INFO [MailService] Mail Service bound to java:/Mail 15:48:47,946 INFO [RARDeployment] Required license terms exist, view META-INF/ra.xml in .../deploy/jboss-ha-local-jdbc.rar 15:48:48,011 INFO [RARDeployment] Required license terms exist, view META-INF/ra.xml in .../deploy/jboss-ha-xa-jdbc.rar 15:48:48,053 INFO [RARDeployment] Required license terms exist, view META-INF/ra.xml in .../deploy/jboss-local-jdbc.rar 15:48:48,128 INFO [RARDeployment] Required license terms exist, view META-INF/ra.xml in .../deploy/jboss-xa-jdbc.rar 15:48:48,204 INFO [RARDeployment] Required license terms exist, view META-INF/ra.xml in .../deploy/jms/jms-ra.rar 15:48:48,239 INFO [RARDeployment] Required license terms exist, view META-INF/ra.xml in .../deploy/quartz-ra.rar 15:48:48,251 INFO [QuartzResourceAdapter] start quartz!!! 15:48:48,335 INFO [SimpleThreadPool] Job execution threads will use class loader of thread: main 15:48:48,366 INFO [QuartzScheduler] Quartz Scheduler v.1.5.2 created. 15:48:48,370 INFO [RAMJobStore] RAMJobStore initialized. 15:48:48,370 INFO [StdSchedulerFactory] Quartz scheduler 'DefaultQuartzScheduler' initialized from default resource file in Quartz package: 'quartz.properties' 15:48:48,370 INFO [StdSchedulerFactory] Quartz scheduler version: 1.5.2 15:48:48,371 INFO [QuartzScheduler] Scheduler DefaultQuartzScheduler_$_NON_CLUSTERED started. 15:48:49,863 INFO [ConnectionFactoryBindingService] Bound ConnectionManager 'jboss.jca:service=DataSourceBinding,name=DefaultDS' to JNDI name 'java:DefaultDS' 15:48:50,435 INFO [A] Bound to JNDI name: queue/A 15:48:50,437 INFO [B] Bound to JNDI name: queue/B 15:48:50,440 INFO [C] Bound to JNDI name: queue/C 15:48:50,444 INFO [D] Bound to JNDI name: queue/D 15:48:50,447 INFO [ex] Bound to JNDI name: queue/ex 15:48:50,476 INFO [testTopic] Bound to JNDI name: topic/testTopic 15:48:50,480 INFO [securedTopic] Bound to JNDI name: topic/securedTopic 15:48:50,483 INFO [testDurableTopic] Bound to JNDI name: topic/testDurableTopic 15:48:50,497 INFO [testQueue] Bound to JNDI name: queue/testQueue 15:48:50,554 INFO [UILServerILService] JBossMQ UIL service available at : /127.0.0.1:8093 15:48:50,627 INFO [DLQ] Bound to JNDI name: queue/DLQ 15:48:50,854 INFO [ConnectionFactoryBindingService] Bound ConnectionManager 'jboss.jca:service=DataSourceBinding,name=maragato' to JNDI name 'java:maragato' 15:48:51,137 INFO [ConnectionFactoryBindingService] Bound ConnectionManager 'jboss.jca:service=ConnectionFactoryBinding,name=JmsXA' to JNDI name 'java:JmsXA' 15:48:51,361 INFO [TomcatDeployer] deploy, ctxPath=/jmx-console, warUrl=.../deploy/jmx-console.war/ 15:48:51,864 INFO [EARDeployer] Init J2EE application: file:/home/leandro/javaapps/jboss-4.2.1.GA/server/default/deploy/MaragatoWeb.ear 15:48:52,828 INFO [JmxKernelAbstraction] creating wrapper delegate for: org.jboss.ejb3.entity.PersistenceUnitDeployment 15:48:52,835 INFO [JmxKernelAbstraction] installing MBean: persistence.units:ear=MaragatoWeb.ear,jar=DMS-DAO.jar,unitName=PU with dependencies: 15:48:52,835 INFO [JmxKernelAbstraction] jboss.jca:name=maragato,service=DataSourceBinding 15:48:52,839 INFO [PersistenceUnitDeployment] Starting persistence unit persistence.units:ear=MaragatoWeb.ear,jar=DMS-DAO.jar,unitName=PU 15:48:52,908 INFO [Version] Hibernate EntityManager 3.2.1.GA 15:48:52,948 INFO [Version] Hibernate Annotations 3.2.1.GA 15:48:52,968 INFO [Environment] Hibernate 3.2.4.sp1 15:48:52,990 INFO [Environment] hibernate.properties not found 15:48:52,993 INFO [Environment] Bytecode provider name : javassist 15:48:53,001 INFO [Environment] using JDK 1.4 java.sql.Timestamp handling 15:48:53,254 INFO [Ejb3Configuration] found EJB3 Entity bean: com.digitel.model.ElementoGerenciado 15:48:53,259 INFO [Ejb3Configuration] found EJB3 Entity bean: com.digitel.model.Imagem 15:48:53,267 INFO [Ejb3Configuration] found EJB3 Entity bean: com.digitel.model.Mapa 15:48:53,271 INFO [Ejb3Configuration] found EJB3 Entity bean: com.digitel.model.Usuario 15:48:53,319 INFO [Configuration] Reading mappings from resource : META-INF/orm.xml 15:48:53,322 INFO [Ejb3Configuration] [PersistenceUnit: PU] no META-INF/orm.xml found 15:48:53,996 INFO [AnnotationBinder] Binding entity from annotated class: com.digitel.model.ElementoGerenciado 15:48:54,014 INFO [QueryBinder] Binding Named query: ElementoGerenciado.findById => SELECT e FROM ElementoGerenciado e WHERE e.id = :id 15:48:54,015 INFO [QueryBinder] Binding Named query: ElementoGerenciado.findByIp => SELECT e FROM ElementoGerenciado e WHERE e.ip = :ip 15:48:54,015 INFO [QueryBinder] Binding Named query: ElementoGerenciado.findByComunidadeLeitura => SELECT e FROM ElementoGerenciado e WHERE e.comunidadeLeitura = :comunidadeLeitura 15:48:54,015 INFO [QueryBinder] Binding Named query: ElementoGerenciado.findByComunidadeEscrita => SELECT e FROM ElementoGerenciado e WHERE e.comunidadeEscrita = :comunidadeEscrita 15:48:54,015 INFO [QueryBinder] Binding Named query: ElementoGerenciado.findByPorta => SELECT e FROM ElementoGerenciado e WHERE e.porta = :porta 15:48:54,015 INFO [QueryBinder] Binding Named query: ElementoGerenciado.findByPosicaox => SELECT e FROM ElementoGerenciado e WHERE e.posicaox = :posicaox 15:48:54,015 INFO [QueryBinder] Binding Named query: ElementoGerenciado.findByPosicaoy => SELECT e FROM ElementoGerenciado e WHERE e.posicaoy = :posicaoy 15:48:54,015 INFO [QueryBinder] Binding Named query: ElementoGerenciado.findBySysObjectid => SELECT e FROM ElementoGerenciado e WHERE e.sysObjectid = :sysObjectid 15:48:54,015 INFO [QueryBinder] Binding Named query: ElementoGerenciado.findByEstacao => SELECT e FROM ElementoGerenciado e WHERE e.estacao = :estacao 15:48:54,016 INFO [QueryBinder] Binding Named query: ElementoGerenciado.findBySysContact => SELECT e FROM ElementoGerenciado e WHERE e.sysContact = :sysContact 15:48:54,016 INFO [QueryBinder] Binding Named query: ElementoGerenciado.findBySysDesc => SELECT e FROM ElementoGerenciado e WHERE e.sysDesc = :sysDesc 15:48:54,016 INFO [QueryBinder] Binding Named query: ElementoGerenciado.findBySysLocation => SELECT e FROM ElementoGerenciado e WHERE e.sysLocation = :sysLocation 15:48:54,016 INFO [QueryBinder] Binding Named query: ElementoGerenciado.findBySysName => SELECT e FROM ElementoGerenciado e WHERE e.sysName = :sysName 15:48:54,016 INFO [QueryBinder] Binding Named query: ElementoGerenciado.findByTimeout => SELECT e FROM ElementoGerenciado e WHERE e.timeout = :timeout 15:48:54,016 INFO [QueryBinder] Binding Named query: ElementoGerenciado.findByStatus => SELECT e FROM ElementoGerenciado e WHERE e.status = :status 15:48:54,086 INFO [EntityBinder] Bind entity com.digitel.model.ElementoGerenciado on table elemento_gerenciado 15:48:54,293 INFO [AnnotationBinder] Binding entity from annotated class: com.digitel.model.Imagem 15:48:54,294 INFO [QueryBinder] Binding Named query: Imagem.findById => SELECT i FROM Imagem i WHERE i.id = :id 15:48:54,294 INFO [QueryBinder] Binding Named query: Imagem.findByTipo => SELECT i FROM Imagem i WHERE i.tipo = :tipo 15:48:54,294 INFO [QueryBinder] Binding Named query: Imagem.findByTitulo => SELECT i FROM Imagem i WHERE i.titulo = :titulo 15:48:54,294 INFO [EntityBinder] Bind entity com.digitel.model.Imagem on table imagem 15:48:54,313 INFO [AnnotationBinder] Binding entity from annotated class: com.digitel.model.Mapa 15:48:54,313 INFO [QueryBinder] Binding Named query: Mapa.findById => SELECT m FROM Mapa m WHERE m.id = :id 15:48:54,313 INFO [QueryBinder] Binding Named query: Mapa.findByNome => SELECT m FROM Mapa m WHERE m.nome = :nome 15:48:54,313 INFO [QueryBinder] Binding Named query: Mapa.findByDescricao => SELECT m FROM Mapa m WHERE m.descricao = :descricao 15:48:54,313 INFO [QueryBinder] Binding Named query: Mapa.findBySeveridade => SELECT m FROM Mapa m WHERE m.severidade = :severidade 15:48:54,313 INFO [QueryBinder] Binding Named query: Mapa.findByColorr => SELECT m FROM Mapa m WHERE m.colorr = :colorr 15:48:54,313 INFO [QueryBinder] Binding Named query: Mapa.findByColorg => SELECT m FROM Mapa m WHERE m.colorg = :colorg 15:48:54,314 INFO [QueryBinder] Binding Named query: Mapa.findByColorb => SELECT m FROM Mapa m WHERE m.colorb = :colorb 15:48:54,314 INFO [QueryBinder] Binding Named query: Mapa.findByPosx => SELECT m FROM Mapa m WHERE m.posx = :posx 15:48:54,314 INFO [QueryBinder] Binding Named query: Mapa.findByPosy => SELECT m FROM Mapa m WHERE m.posy = :posy 15:48:54,314 INFO [QueryBinder] Binding Named query: Mapa.findByTipoLayout => SELECT m FROM Mapa m WHERE m.tipoLayout = :tipoLayout 15:48:54,314 INFO [EntityBinder] Bind entity com.digitel.model.Mapa on table mapa 15:48:54,332 INFO [AnnotationBinder] Binding entity from annotated class: com.digitel.model.Usuario 15:48:54,332 INFO [QueryBinder] Binding Named query: Usuario.findById => SELECT u FROM Usuario u WHERE u.id = :id 15:48:54,332 INFO [QueryBinder] Binding Named query: Usuario.findByNome => SELECT u FROM Usuario u WHERE u.nome = :nome 15:48:54,333 INFO [QueryBinder] Binding Named query: Usuario.findByDescricao => SELECT u FROM Usuario u WHERE u.descricao = :descricao 15:48:54,333 INFO [QueryBinder] Binding Named query: Usuario.findByNomeCompleto => SELECT u FROM Usuario u WHERE u.nomeCompleto = :nomeCompleto 15:48:54,333 INFO [QueryBinder] Binding Named query: Usuario.findBySenhaDigest => SELECT u FROM Usuario u WHERE u.senhaDigest = :senhaDigest 15:48:54,333 INFO [EntityBinder] Bind entity com.digitel.model.Usuario on table usuario 15:48:54,473 INFO [CollectionBinder] Mapping collection: com.digitel.model.ElementoGerenciado.elementoGerenciadoCollection -> elemento_gerenciado 15:48:54,478 INFO [CollectionBinder] Mapping collection: com.digitel.model.Imagem.mapaCollection -> mapa 15:48:54,478 INFO [CollectionBinder] Mapping collection: com.digitel.model.Imagem.mapaCollection1 -> mapa 15:48:54,479 INFO [CollectionBinder] Mapping collection: com.digitel.model.Mapa.elementoGerenciadoCollection -> elemento_gerenciado 15:48:54,479 INFO [CollectionBinder] Mapping collection: com.digitel.model.Mapa.mapaCollection -> mapa 15:48:54,480 INFO [CollectionBinder] Mapping collection: com.digitel.model.Usuario.elementoGerenciadoCollection -> elemento_gerenciado 15:48:54,628 INFO [ConnectionProviderFactory] Initializing connection provider: org.hibernate.ejb.connection.InjectedDataSourceConnectionProvider 15:48:54,633 INFO [InjectedDataSourceConnectionProvider] Using provided datasource 15:48:54,921 INFO [SettingsFactory] RDBMS: PostgreSQL, version: 8.1.4 15:48:54,922 INFO [SettingsFactory] JDBC driver: PostgreSQL Native Driver, version: PostgreSQL 8.0 JDBC3 with SSL (build 312) 15:48:54,978 INFO [Dialect] Using dialect: org.hibernate.dialect.PostgreSQLDialect 15:48:54,990 INFO [TransactionFactoryFactory] Transaction strategy: org.hibernate.ejb.transaction.JoinableCMTTransactionFactory 15:48:54,995 INFO [TransactionManagerLookupFactory] instantiating TransactionManagerLookup: org.hibernate.transaction.JBossTransactionManagerLookup 15:48:54,999 INFO [TransactionManagerLookupFactory] instantiated TransactionManagerLookup 15:48:54,999 INFO [SettingsFactory] Automatic flush during beforeCompletion(): disabled 15:48:54,999 INFO [SettingsFactory] Automatic session close at end of transaction: disabled 15:48:54,999 INFO [SettingsFactory] JDBC batch size: 15 15:48:54,999 INFO [SettingsFactory] JDBC batch updates for versioned data: disabled 15:48:55,001 INFO [SettingsFactory] Scrollable result sets: enabled 15:48:55,001 INFO [SettingsFactory] JDBC3 getGeneratedKeys(): disabled 15:48:55,001 INFO [SettingsFactory] Connection release mode: auto 15:48:55,002 INFO [SettingsFactory] Default batch fetch size: 1 15:48:55,003 INFO [SettingsFactory] Generate SQL with comments: disabled 15:48:55,003 INFO [SettingsFactory] Order SQL updates by primary key: disabled 15:48:55,003 INFO [SettingsFactory] Order SQL inserts for batching: disabled 15:48:55,003 INFO [SettingsFactory] Query translator: org.hibernate.hql.ast.ASTQueryTranslatorFactory 15:48:55,008 INFO [ASTQueryTranslatorFactory] Using ASTQueryTranslatorFactory 15:48:55,008 INFO [SettingsFactory] Query language substitutions: {} 15:48:55,009 INFO [SettingsFactory] JPA-QL strict compliance: enabled 15:48:55,009 INFO [SettingsFactory] Second-level cache: enabled 15:48:55,009 INFO [SettingsFactory] Query cache: disabled 15:48:55,009 INFO [SettingsFactory] Cache provider: org.hibernate.cache.HashtableCacheProvider 15:48:55,020 INFO [SettingsFactory] Optimize cache for minimal puts: disabled 15:48:55,020 INFO [SettingsFactory] Cache region prefix: MaragatoWeb_ear,DMS-DAO_jar,PU 15:48:55,020 INFO [SettingsFactory] Structured second-level cache entries: disabled 15:48:55,031 INFO [SettingsFactory] Statistics: disabled 15:48:55,031 INFO [SettingsFactory] Deleted entity synthetic identifier rollback: disabled 15:48:55,032 INFO [SettingsFactory] Default entity-mode: pojo 15:48:55,032 INFO [SettingsFactory] Named query checking : enabled 15:48:55,132 INFO [SessionFactoryImpl] building session factory 15:48:55,645 INFO [SessionFactoryObjectFactory] Factory name: persistence.units:ear=MaragatoWeb.ear,jar=DMS-DAO.jar,unitName=PU 15:48:55,648 INFO [NamingHelper] JNDI InitialContext properties:{java.naming.factory.initial=org.jnp.interfaces.NamingContextFactory, java.naming.factory.url.pkgs=org.jboss.naming:org.jnp.interfaces} 15:48:55,651 INFO [SessionFactoryObjectFactory] Bound factory to JNDI name: persistence.units:ear=MaragatoWeb.ear,jar=DMS-DAO.jar,unitName=PU 15:48:55,651 WARN [SessionFactoryObjectFactory] InitialContext did not implement EventContext 15:48:55,652 INFO [NamingHelper] JNDI InitialContext properties:{java.naming.factory.initial=org.jnp.interfaces.NamingContextFactory, java.naming.factory.url.pkgs=org.jboss.naming:org.jnp.interfaces} 15:48:56,911 INFO [JmxKernelAbstraction] creating wrapper delegate for: org.jboss.ejb3.stateless.StatelessContainer 15:48:56,919 INFO [JmxKernelAbstraction] installing MBean: jboss.j2ee:ear=MaragatoWeb.ear,jar=DMS-DAO.jar,name=DAOFactory,service=EJB3 with dependencies: 15:48:56,919 INFO [JmxKernelAbstraction] persistence.units:ear=MaragatoWeb.ear,jar=DMS-DAO.jar,unitName=PU 15:48:57,150 INFO [EJBContainer] STARTED EJB: com.digitel.ejb.DAOFactory ejbName: DAOFactory 15:48:57,227 INFO [EJB3Deployer] Deployed: file:/home/leandro/javaapps/jboss-4.2.1.GA/server/default/tmp/deploy/tmp5382MaragatoWeb.ear-contents/DMS-DAO.jar 15:48:57,235 INFO [JmxKernelAbstraction] creating wrapper delegate for: org.jboss.ejb3.stateless.StatelessContainer 15:48:57,235 INFO [JmxKernelAbstraction] installing MBean: jboss.j2ee:ear=MaragatoWeb.ear,jar=DMS-Facade.jar,name=ElementoGerenciadoFacade,service=EJB3 with dependencies: 15:48:57,235 INFO [JmxKernelAbstraction] jboss.j2ee:ear=MaragatoWeb.ear,jar=DMS-DAO.jar,name=DAOFactory,service=EJB3 15:48:57,260 INFO [EJBContainer] STARTED EJB: com.digitel.facade.ElementoGerenciadoFacade ejbName: ElementoGerenciadoFacade 15:48:57,274 INFO [EJB3Deployer] Deployed: file:/home/leandro/javaapps/jboss-4.2.1.GA/server/default/tmp/deploy/tmp5382MaragatoWeb.ear-contents/DMS-Facade.jar 15:48:57,283 INFO [TomcatDeployer] deploy, ctxPath=/DMS-Reports, warUrl=.../tmp/deploy/tmp5382MaragatoWeb.ear-contents/DMS-Reports-exp.war/ 15:48:57,545 INFO [EARDeployer] Started J2EE application: file:/home/leandro/javaapps/jboss-4.2.1.GA/server/default/deploy/MaragatoWeb.ear 15:48:57,762 INFO [Http11Protocol] Starting Coyote HTTP/1.1 on http-127.0.0.1-8080 15:48:57,796 INFO [AjpProtocol] Starting Coyote AJP/1.3 on ajp-127.0.0.1-8009 15:48:57,886 INFO [Server] JBoss (MX MicroKernel) [4.2.1.GA (build: SVNTag=JBoss_4_2_1_GA date=200707131605)] Started in 33s:206ms 15:49:02,926 INFO [TomcatDeployer] undeploy, ctxPath=/DMS-Reports, warUrl=.../tmp/deploy/tmp5382MaragatoWeb.ear-contents/DMS-Reports-exp.war/ 15:49:03,016 INFO [EJBContainer] STOPPED EJB: com.digitel.facade.ElementoGerenciadoFacade ejbName: ElementoGerenciadoFacade 15:49:03,027 WARN [JmxKernelAbstraction] jboss.j2ee:ear=MaragatoWeb.ear,jar=DMS-Facade.jar,name=ElementoGerenciadoFacade,service=EJB3 is not registered 15:49:03,041 INFO [EJBContainer] STOPPED EJB: com.digitel.ejb.DAOFactory ejbName: DAOFactory 15:49:03,044 WARN [JmxKernelAbstraction] jboss.j2ee:ear=MaragatoWeb.ear,jar=DMS-DAO.jar,name=DAOFactory,service=EJB3 is not registered 15:49:03,049 INFO [PersistenceUnitDeployment] Stopping persistence unit persistence.units:ear=MaragatoWeb.ear,jar=DMS-DAO.jar,unitName=PU 15:49:03,053 INFO [SessionFactoryImpl] closing 15:49:03,054 INFO [SessionFactoryObjectFactory] Unbinding factory from JNDI name: persistence.units:ear=MaragatoWeb.ear,jar=DMS-DAO.jar,unitName=PU 15:49:03,054 INFO [NamingHelper] JNDI InitialContext properties:{java.naming.factory.initial=org.jnp.interfaces.NamingContextFactory, java.naming.factory.url.pkgs=org.jboss.naming:org.jnp.interfaces} 15:49:03,056 INFO [SessionFactoryObjectFactory] Unbound factory from JNDI name: persistence.units:ear=MaragatoWeb.ear,jar=DMS-DAO.jar,unitName=PU 15:49:03,061 WARN [JmxKernelAbstraction] persistence.units:ear=MaragatoWeb.ear,jar=DMS-DAO.jar,unitName=PU is not registered 15:49:03,094 INFO [EARDeployer] Undeploying J2EE application, destroy step: file:/home/leandro/javaapps/jboss-4.2.1.GA/server/default/deploy/MaragatoWeb.ear 15:49:03,101 INFO [EARDeployer] Undeployed J2EE application: file:/home/leandro/javaapps/jboss-4.2.1.GA/server/default/deploy/MaragatoWeb.ear 15:49:03,140 INFO [EARDeployer] Init J2EE application: file:/home/leandro/javaapps/jboss-4.2.1.GA/server/default/deploy/MaragatoWeb.ear 15:49:04,358 INFO [JmxKernelAbstraction] creating wrapper delegate for: org.jboss.ejb3.entity.PersistenceUnitDeployment 15:49:04,358 INFO [JmxKernelAbstraction] installing MBean: persistence.units:ear=MaragatoWeb.ear,jar=DMS-DAO.jar,unitName=PU with dependencies: 15:49:04,359 INFO [JmxKernelAbstraction] jboss.jca:name=maragato,service=DataSourceBinding 15:49:04,380 INFO [PersistenceUnitDeployment] Starting persistence unit persistence.units:ear=MaragatoWeb.ear,jar=DMS-DAO.jar,unitName=PU 15:49:04,454 INFO [Ejb3Configuration] found EJB3 Entity bean: com.digitel.model.ElementoGerenciado 15:49:04,461 INFO [Ejb3Configuration] found EJB3 Entity bean: com.digitel.model.Imagem 15:49:04,485 INFO [Ejb3Configuration] found EJB3 Entity bean: com.digitel.model.Mapa 15:49:04,488 INFO [Ejb3Configuration] found EJB3 Entity bean: com.digitel.model.Usuario 15:49:04,494 INFO [Configuration] Reading mappings from resource : META-INF/orm.xml 15:49:04,495 INFO [Ejb3Configuration] [PersistenceUnit: PU] no META-INF/orm.xml found 15:49:04,517 INFO [AnnotationBinder] Binding entity from annotated class: com.digitel.model.ElementoGerenciado 15:49:04,517 INFO [QueryBinder] Binding Named query: ElementoGerenciado.findById => SELECT e FROM ElementoGerenciado e WHERE e.id = :id 15:49:04,517 INFO [QueryBinder] Binding Named query: ElementoGerenciado.findByIp => SELECT e FROM ElementoGerenciado e WHERE e.ip = :ip 15:49:04,517 INFO [QueryBinder] Binding Named query: ElementoGerenciado.findByComunidadeLeitura => SELECT e FROM ElementoGerenciado e WHERE e.comunidadeLeitura = :comunidadeLeitura 15:49:04,518 INFO [QueryBinder] Binding Named query: ElementoGerenciado.findByComunidadeEscrita => SELECT e FROM ElementoGerenciado e WHERE e.comunidadeEscrita = :comunidadeEscrita 15:49:04,518 INFO [QueryBinder] Binding Named query: ElementoGerenciado.findByPorta => SELECT e FROM ElementoGerenciado e WHERE e.porta = :porta 15:49:04,518 INFO [QueryBinder] Binding Named query: ElementoGerenciado.findByPosicaox => SELECT e FROM ElementoGerenciado e WHERE e.posicaox = :posicaox 15:49:04,518 INFO [QueryBinder] Binding Named query: ElementoGerenciado.findByPosicaoy => SELECT e FROM ElementoGerenciado e WHERE e.posicaoy = :posicaoy 15:49:04,518 INFO [QueryBinder] Binding Named query: ElementoGerenciado.findBySysObjectid => SELECT e FROM ElementoGerenciado e WHERE e.sysObjectid = :sysObjectid 15:49:04,518 INFO [QueryBinder] Binding Named query: ElementoGerenciado.findByEstacao => SELECT e FROM ElementoGerenciado e WHERE e.estacao = :estacao 15:49:04,518 INFO [QueryBinder] Binding Named query: ElementoGerenciado.findBySysContact => SELECT e FROM ElementoGerenciado e WHERE e.sysContact = :sysContact 15:49:04,518 INFO [QueryBinder] Binding Named query: ElementoGerenciado.findBySysDesc => SELECT e FROM ElementoGerenciado e WHERE e.sysDesc = :sysDesc 15:49:04,518 INFO [QueryBinder] Binding Named query: ElementoGerenciado.findBySysLocation => SELECT e FROM ElementoGerenciado e WHERE e.sysLocation = :sysLocation 15:49:04,518 INFO [QueryBinder] Binding Named query: ElementoGerenciado.findBySysName => SELECT e FROM ElementoGerenciado e WHERE e.sysName = :sysName 15:49:04,519 INFO [QueryBinder] Binding Named query: ElementoGerenciado.findByTimeout => SELECT e FROM ElementoGerenciado e WHERE e.timeout = :timeout 15:49:04,519 INFO [QueryBinder] Binding Named query: ElementoGerenciado.findByStatus => SELECT e FROM ElementoGerenciado e WHERE e.status = :status 15:49:04,519 INFO [EntityBinder] Bind entity com.digitel.model.ElementoGerenciado on table elemento_gerenciado 15:49:04,550 INFO [AnnotationBinder] Binding entity from annotated class: com.digitel.model.Imagem 15:49:04,550 INFO [QueryBinder] Binding Named query: Imagem.findById => SELECT i FROM Imagem i WHERE i.id = :id 15:49:04,551 INFO [QueryBinder] Binding Named query: Imagem.findByTipo => SELECT i FROM Imagem i WHERE i.tipo = :tipo 15:49:04,551 INFO [QueryBinder] Binding Named query: Imagem.findByTitulo => SELECT i FROM Imagem i WHERE i.titulo = :titulo 15:49:04,551 INFO [EntityBinder] Bind entity com.digitel.model.Imagem on table imagem 15:49:04,558 INFO [AnnotationBinder] Binding entity from annotated class: com.digitel.model.Mapa 15:49:04,558 INFO [QueryBinder] Binding Named query: Mapa.findById => SELECT m FROM Mapa m WHERE m.id = :id 15:49:04,558 INFO [QueryBinder] Binding Named query: Mapa.findByNome => SELECT m FROM Mapa m WHERE m.nome = :nome 15:49:04,558 INFO [QueryBinder] Binding Named query: Mapa.findByDescricao => SELECT m FROM Mapa m WHERE m.descricao = :descricao 15:49:04,558 INFO [QueryBinder] Binding Named query: Mapa.findBySeveridade => SELECT m FROM Mapa m WHERE m.severidade = :severidade 15:49:04,559 INFO [QueryBinder] Binding Named query: Mapa.findByColorr => SELECT m FROM Mapa m WHERE m.colorr = :colorr 15:49:04,559 INFO [QueryBinder] Binding Named query: Mapa.findByColorg => SELECT m FROM Mapa m WHERE m.colorg = :colorg 15:49:04,559 INFO [QueryBinder] Binding Named query: Mapa.findByColorb => SELECT m FROM Mapa m WHERE m.colorb = :colorb 15:49:04,559 INFO [QueryBinder] Binding Named query: Mapa.findByPosx => SELECT m FROM Mapa m WHERE m.posx = :posx 15:49:04,559 INFO [QueryBinder] Binding Named query: Mapa.findByPosy => SELECT m FROM Mapa m WHERE m.posy = :posy 15:49:04,559 INFO [QueryBinder] Binding Named query: Mapa.findByTipoLayout => SELECT m FROM Mapa m WHERE m.tipoLayout = :tipoLayout 15:49:04,559 INFO [EntityBinder] Bind entity com.digitel.model.Mapa on table mapa 15:49:04,589 INFO [AnnotationBinder] Binding entity from annotated class: com.digitel.model.Usuario 15:49:04,589 INFO [QueryBinder] Binding Named query: Usuario.findById => SELECT u FROM Usuario u WHERE u.id = :id 15:49:04,589 INFO [QueryBinder] Binding Named query: Usuario.findByNome => SELECT u FROM Usuario u WHERE u.nome = :nome 15:49:04,589 INFO [QueryBinder] Binding Named query: Usuario.findByDescricao => SELECT u FROM Usuario u WHERE u.descricao = :descricao 15:49:04,589 INFO [QueryBinder] Binding Named query: Usuario.findByNomeCompleto => SELECT u FROM Usuario u WHERE u.nomeCompleto = :nomeCompleto 15:49:04,589 INFO [QueryBinder] Binding Named query: Usuario.findBySenhaDigest => SELECT u FROM Usuario u WHERE u.senhaDigest = :senhaDigest 15:49:04,590 INFO [EntityBinder] Bind entity com.digitel.model.Usuario on table usuario 15:49:04,617 INFO [CollectionBinder] Mapping collection: com.digitel.model.ElementoGerenciado.elementoGerenciadoCollection -> elemento_gerenciado 15:49:04,617 INFO [CollectionBinder] Mapping collection: com.digitel.model.Imagem.mapaCollection -> mapa 15:49:04,618 INFO [CollectionBinder] Mapping collection: com.digitel.model.Imagem.mapaCollection1 -> mapa 15:49:04,618 INFO [CollectionBinder] Mapping collection: com.digitel.model.Mapa.elementoGerenciadoCollection -> elemento_gerenciado 15:49:04,619 INFO [CollectionBinder] Mapping collection: com.digitel.model.Mapa.mapaCollection -> mapa 15:49:04,619 INFO [CollectionBinder] Mapping collection: com.digitel.model.Usuario.elementoGerenciadoCollection -> elemento_gerenciado 15:49:04,687 INFO [ConnectionProviderFactory] Initializing connection provider: org.hibernate.ejb.connection.InjectedDataSourceConnectionProvider 15:49:04,690 INFO [InjectedDataSourceConnectionProvider] Using provided datasource 15:49:04,741 INFO [SettingsFactory] RDBMS: PostgreSQL, version: 8.1.4 15:49:04,742 INFO [SettingsFactory] JDBC driver: PostgreSQL Native Driver, version: PostgreSQL 8.0 JDBC3 with SSL (build 312) 15:49:04,742 INFO [Dialect] Using dialect: org.hibernate.dialect.PostgreSQLDialect 15:49:04,742 INFO [TransactionFactoryFactory] Transaction strategy: org.hibernate.ejb.transaction.JoinableCMTTransactionFactory 15:49:04,743 INFO [TransactionManagerLookupFactory] instantiating TransactionManagerLookup: org.hibernate.transaction.JBossTransactionManagerLookup 15:49:04,743 INFO [TransactionManagerLookupFactory] instantiated TransactionManagerLookup 15:49:04,743 INFO [SettingsFactory] Automatic flush during beforeCompletion(): disabled 15:49:04,743 INFO [SettingsFactory] Automatic session close at end of transaction: disabled 15:49:04,743 INFO [SettingsFactory] JDBC batch size: 15 15:49:04,743 INFO [SettingsFactory] JDBC batch updates for versioned data: disabled 15:49:04,743 INFO [SettingsFactory] Scrollable result sets: enabled 15:49:04,743 INFO [SettingsFactory] JDBC3 getGeneratedKeys(): disabled 15:49:04,743 INFO [SettingsFactory] Connection release mode: auto 15:49:04,743 INFO [SettingsFactory] Default batch fetch size: 1 15:49:04,845 INFO [SettingsFactory] Generate SQL with comments: disabled 15:49:04,845 INFO [SettingsFactory] Order SQL updates by primary key: disabled 15:49:04,845 INFO [SettingsFactory] Order SQL inserts for batching: disabled 15:49:04,845 INFO [SettingsFactory] Query translator: org.hibernate.hql.ast.ASTQueryTranslatorFactory 15:49:04,845 INFO [ASTQueryTranslatorFactory] Using ASTQueryTranslatorFactory 15:49:04,845 INFO [SettingsFactory] Query language substitutions: {} 15:49:04,845 INFO [SettingsFactory] JPA-QL strict compliance: enabled 15:49:04,845 INFO [SettingsFactory] Second-level cache: enabled 15:49:04,845 INFO [SettingsFactory] Query cache: disabled 15:49:04,846 INFO [SettingsFactory] Cache provider: org.hibernate.cache.HashtableCacheProvider 15:49:04,846 INFO [SettingsFactory] Optimize cache for minimal puts: disabled 15:49:04,846 INFO [SettingsFactory] Cache region prefix: MaragatoWeb_ear,DMS-DAO_jar,PU 15:49:04,846 INFO [SettingsFactory] Structured second-level cache entries: disabled 15:49:04,846 INFO [SettingsFactory] Statistics: disabled 15:49:04,846 INFO [SettingsFactory] Deleted entity synthetic identifier rollback: disabled 15:49:04,846 INFO [SettingsFactory] Default entity-mode: pojo 15:49:04,846 INFO [SettingsFactory] Named query checking : enabled 15:49:04,858 INFO [SessionFactoryImpl] building session factory 15:49:05,270 INFO [SessionFactoryObjectFactory] Factory name: persistence.units:ear=MaragatoWeb.ear,jar=DMS-DAO.jar,unitName=PU 15:49:05,270 INFO [NamingHelper] JNDI InitialContext properties:{java.naming.factory.initial=org.jnp.interfaces.NamingContextFactory, java.naming.factory.url.pkgs=org.jboss.naming:org.jnp.interfaces} 15:49:05,869 INFO [SessionFactoryObjectFactory] Bound factory to JNDI name: persistence.units:ear=MaragatoWeb.ear,jar=DMS-DAO.jar,unitName=PU 15:49:05,869 WARN [SessionFactoryObjectFactory] InitialContext did not implement EventContext 15:49:05,869 INFO [NamingHelper] JNDI InitialContext properties:{java.naming.factory.initial=org.jnp.interfaces.NamingContextFactory, java.naming.factory.url.pkgs=org.jboss.naming:org.jnp.interfaces} 15:49:06,444 INFO [JmxKernelAbstraction] creating wrapper delegate for: org.jboss.ejb3.stateless.StatelessContainer 15:49:06,444 INFO [JmxKernelAbstraction] installing MBean: jboss.j2ee:ear=MaragatoWeb.ear,jar=DMS-DAO.jar,name=DAOFactory,service=EJB3 with dependencies: 15:49:06,444 INFO [JmxKernelAbstraction] persistence.units:ear=MaragatoWeb.ear,jar=DMS-DAO.jar,unitName=PU 15:49:06,468 INFO [EJBContainer] STARTED EJB: com.digitel.ejb.DAOFactory ejbName: DAOFactory 15:49:06,603 INFO [EJB3Deployer] Deployed: file:/home/leandro/javaapps/jboss-4.2.1.GA/server/default/tmp/deploy/tmp5383MaragatoWeb.ear-contents/DMS-DAO.jar 15:49:06,606 INFO [JmxKernelAbstraction] creating wrapper delegate for: org.jboss.ejb3.stateless.StatelessContainer 15:49:06,607 INFO [JmxKernelAbstraction] installing MBean: jboss.j2ee:ear=MaragatoWeb.ear,jar=DMS-Facade.jar,name=ElementoGerenciadoFacade,service=EJB3 with dependencies: 15:49:06,607 INFO [JmxKernelAbstraction] jboss.j2ee:ear=MaragatoWeb.ear,jar=DMS-DAO.jar,name=DAOFactory,service=EJB3 15:49:06,630 INFO [EJBContainer] STARTED EJB: com.digitel.facade.ElementoGerenciadoFacade ejbName: ElementoGerenciadoFacade 15:49:06,644 INFO [EJB3Deployer] Deployed: file:/home/leandro/javaapps/jboss-4.2.1.GA/server/default/tmp/deploy/tmp5383MaragatoWeb.ear-contents/DMS-Facade.jar 15:49:06,691 INFO [TomcatDeployer] deploy, ctxPath=/DMS-Reports, warUrl=.../tmp/deploy/tmp5383MaragatoWeb.ear-contents/DMS-Reports-exp.war/ 15:49:06,906 INFO [EARDeployer] Started J2EE application: file:/home/leandro/javaapps/jboss-4.2.1.GA/server/default/deploy/MaragatoWeb.ear 15:50:12,193 INFO [TomcatDeployer] undeploy, ctxPath=/DMS-Reports, warUrl=.../tmp/deploy/tmp5383MaragatoWeb.ear-contents/DMS-Reports-exp.war/ 15:50:12,222 INFO [EJBContainer] STOPPED EJB: com.digitel.facade.ElementoGerenciadoFacade ejbName: ElementoGerenciadoFacade 15:50:12,228 WARN [JmxKernelAbstraction] jboss.j2ee:ear=MaragatoWeb.ear,jar=DMS-Facade.jar,name=ElementoGerenciadoFacade,service=EJB3 is not registered 15:50:12,233 INFO [EJBContainer] STOPPED EJB: com.digitel.ejb.DAOFactory ejbName: DAOFactory 15:50:12,234 WARN [JmxKernelAbstraction] jboss.j2ee:ear=MaragatoWeb.ear,jar=DMS-DAO.jar,name=DAOFactory,service=EJB3 is not registered 15:50:12,235 INFO [PersistenceUnitDeployment] Stopping persistence unit persistence.units:ear=MaragatoWeb.ear,jar=DMS-DAO.jar,unitName=PU 15:50:12,235 INFO [SessionFactoryImpl] closing 15:50:12,235 INFO [SessionFactoryObjectFactory] Unbinding factory from JNDI name: persistence.units:ear=MaragatoWeb.ear,jar=DMS-DAO.jar,unitName=PU 15:50:12,235 INFO [NamingHelper] JNDI InitialContext properties:{java.naming.factory.initial=org.jnp.interfaces.NamingContextFactory, java.naming.factory.url.pkgs=org.jboss.naming:org.jnp.interfaces} 15:50:12,235 INFO [SessionFactoryObjectFactory] Unbound factory from JNDI name: persistence.units:ear=MaragatoWeb.ear,jar=DMS-DAO.jar,unitName=PU 15:50:12,236 WARN [JmxKernelAbstraction] persistence.units:ear=MaragatoWeb.ear,jar=DMS-DAO.jar,unitName=PU is not registered 15:50:12,244 INFO [EARDeployer] Undeploying J2EE application, destroy step: file:/home/leandro/javaapps/jboss-4.2.1.GA/server/default/deploy/MaragatoWeb.ear 15:50:12,245 INFO [EARDeployer] Undeployed J2EE application: file:/home/leandro/javaapps/jboss-4.2.1.GA/server/default/deploy/MaragatoWeb.ear 15:50:12,257 INFO [EARDeployer] Init J2EE application: file:/home/leandro/javaapps/jboss-4.2.1.GA/server/default/deploy/MaragatoWeb.ear 15:50:12,485 INFO [JmxKernelAbstraction] creating wrapper delegate for: org.jboss.ejb3.entity.PersistenceUnitDeployment 15:50:12,485 INFO [JmxKernelAbstraction] installing MBean: persistence.units:ear=MaragatoWeb.ear,jar=DMS-DAO.jar,unitName=PU with dependencies: 15:50:12,486 INFO [JmxKernelAbstraction] jboss.jca:name=maragato,service=DataSourceBinding 15:50:12,489 INFO [PersistenceUnitDeployment] Starting persistence unit persistence.units:ear=MaragatoWeb.ear,jar=DMS-DAO.jar,unitName=PU 15:50:12,505 INFO [Ejb3Configuration] found EJB3 Entity bean: com.digitel.model.ElementoGerenciado 15:50:12,508 INFO [Ejb3Configuration] found EJB3 Entity bean: com.digitel.model.Imagem 15:50:12,514 INFO [Ejb3Configuration] found EJB3 Entity bean: com.digitel.model.Mapa 15:50:12,517 INFO [Ejb3Configuration] found EJB3 Entity bean: com.digitel.model.Usuario 15:50:12,523 INFO [Configuration] Reading mappings from resource : META-INF/orm.xml 15:50:12,524 INFO [Ejb3Configuration] [PersistenceUnit: PU] no META-INF/orm.xml found 15:50:12,529 INFO [AnnotationBinder] Binding entity from annotated class: com.digitel.model.ElementoGerenciado 15:50:12,529 INFO [QueryBinder] Binding Named query: ElementoGerenciado.findById => SELECT e FROM ElementoGerenciado e WHERE e.id = :id 15:50:12,529 INFO [QueryBinder] Binding Named query: ElementoGerenciado.findByIp => SELECT e FROM ElementoGerenciado e WHERE e.ip = :ip 15:50:12,529 INFO [QueryBinder] Binding Named query: ElementoGerenciado.findByComunidadeLeitura => SELECT e FROM ElementoGerenciado e WHERE e.comunidadeLeitura = :comunidadeLeitura 15:50:12,529 INFO [QueryBinder] Binding Named query: ElementoGerenciado.findByComunidadeEscrita => SELECT e FROM ElementoGerenciado e WHERE e.comunidadeEscrita = :comunidadeEscrita 15:50:12,530 INFO [QueryBinder] Binding Named query: ElementoGerenciado.findByPorta => SELECT e FROM ElementoGerenciado e WHERE e.porta = :porta 15:50:12,530 INFO [QueryBinder] Binding Named query: ElementoGerenciado.findByPosicaox => SELECT e FROM ElementoGerenciado e WHERE e.posicaox = :posicaox 15:50:12,530 INFO [QueryBinder] Binding Named query: ElementoGerenciado.findByPosicaoy => SELECT e FROM ElementoGerenciado e WHERE e.posicaoy = :posicaoy 15:50:12,530 INFO [QueryBinder] Binding Named query: ElementoGerenciado.findBySysObjectid => SELECT e FROM ElementoGerenciado e WHERE e.sysObjectid = :sysObjectid 15:50:12,530 INFO [QueryBinder] Binding Named query: ElementoGerenciado.findByEstacao => SELECT e FROM ElementoGerenciado e WHERE e.estacao = :estacao 15:50:12,530 INFO [QueryBinder] Binding Named query: ElementoGerenciado.findBySysContact => SELECT e FROM ElementoGerenciado e WHERE e.sysContact = :sysContact 15:50:12,530 INFO [QueryBinder] Binding Named query: ElementoGerenciado.findBySysDesc => SELECT e FROM ElementoGerenciado e WHERE e.sysDesc = :sysDesc 15:50:12,530 INFO [QueryBinder] Binding Named query: ElementoGerenciado.findBySysLocation => SELECT e FROM ElementoGerenciado e WHERE e.sysLocation = :sysLocation 15:50:12,530 INFO [QueryBinder] Binding Named query: ElementoGerenciado.findBySysName => SELECT e FROM ElementoGerenciado e WHERE e.sysName = :sysName 15:50:12,530 INFO [QueryBinder] Binding Named query: ElementoGerenciado.findByTimeout => SELECT e FROM ElementoGerenciado e WHERE e.timeout = :timeout 15:50:12,531 INFO [QueryBinder] Binding Named query: ElementoGerenciado.findByStatus => SELECT e FROM ElementoGerenciado e WHERE e.status = :status 15:50:12,531 INFO [EntityBinder] Bind entity com.digitel.model.ElementoGerenciado on table elemento_gerenciado 15:50:12,565 INFO [AnnotationBinder] Binding entity from annotated class: com.digitel.model.Imagem 15:50:12,565 INFO [QueryBinder] Binding Named query: Imagem.findById => SELECT i FROM Imagem i WHERE i.id = :id 15:50:12,565 INFO [QueryBinder] Binding Named query: Imagem.findByTipo => SELECT i FROM Imagem i WHERE i.tipo = :tipo 15:50:12,566 INFO [QueryBinder] Binding Named query: Imagem.findByTitulo => SELECT i FROM Imagem i WHERE i.titulo = :titulo 15:50:12,566 INFO [EntityBinder] Bind entity com.digitel.model.Imagem on table imagem 15:50:12,573 INFO [AnnotationBinder] Binding entity from annotated class: com.digitel.model.Mapa 15:50:12,573 INFO [QueryBinder] Binding Named query: Mapa.findById => SELECT m FROM Mapa m WHERE m.id = :id 15:50:12,573 INFO [QueryBinder] Binding Named query: Mapa.findByNome => SELECT m FROM Mapa m WHERE m.nome = :nome 15:50:12,573 INFO [QueryBinder] Binding Named query: Mapa.findByDescricao => SELECT m FROM Mapa m WHERE m.descricao = :descricao 15:50:12,573 INFO [QueryBinder] Binding Named query: Mapa.findBySeveridade => SELECT m FROM Mapa m WHERE m.severidade = :severidade 15:50:12,573 INFO [QueryBinder] Binding Named query: Mapa.findByColorr => SELECT m FROM Mapa m WHERE m.colorr = :colorr 15:50:12,573 INFO [QueryBinder] Binding Named query: Mapa.findByColorg => SELECT m FROM Mapa m WHERE m.colorg = :colorg 15:50:12,573 INFO [QueryBinder] Binding Named query: Mapa.findByColorb => SELECT m FROM Mapa m WHERE m.colorb = :colorb 15:50:12,574 INFO [QueryBinder] Binding Named query: Mapa.findByPosx => SELECT m FROM Mapa m WHERE m.posx = :posx 15:50:12,574 INFO [QueryBinder] Binding Named query: Mapa.findByPosy => SELECT m FROM Mapa m WHERE m.posy = :posy 15:50:12,574 INFO [QueryBinder] Binding Named query: Mapa.findByTipoLayout => SELECT m FROM Mapa m WHERE m.tipoLayout = :tipoLayout 15:50:12,574 INFO [EntityBinder] Bind entity com.digitel.model.Mapa on table mapa 15:50:12,589 INFO [AnnotationBinder] Binding entity from annotated class: com.digitel.model.Usuario 15:50:12,589 INFO [QueryBinder] Binding Named query: Usuario.findById => SELECT u FROM Usuario u WHERE u.id = :id 15:50:12,589 INFO [QueryBinder] Binding Named query: Usuario.findByNome => SELECT u FROM Usuario u WHERE u.nome = :nome 15:50:12,589 INFO [QueryBinder] Binding Named query: Usuario.findByDescricao => SELECT u FROM Usuario u WHERE u.descricao = :descricao 15:50:12,589 INFO [QueryBinder] Binding Named query: Usuario.findByNomeCompleto => SELECT u FROM Usuario u WHERE u.nomeCompleto = :nomeCompleto 15:50:12,589 INFO [QueryBinder] Binding Named query: Usuario.findBySenhaDigest => SELECT u FROM Usuario u WHERE u.senhaDigest = :senhaDigest 15:50:12,590 INFO [EntityBinder] Bind entity com.digitel.model.Usuario on table usuario 15:50:12,596 INFO [CollectionBinder] Mapping collection: com.digitel.model.ElementoGerenciado.elementoGerenciadoCollection -> elemento_gerenciado 15:50:12,597 INFO [CollectionBinder] Mapping collection: com.digitel.model.Imagem.mapaCollection -> mapa 15:50:12,597 INFO [CollectionBinder] Mapping collection: com.digitel.model.Imagem.mapaCollection1 -> mapa 15:50:12,598 INFO [CollectionBinder] Mapping collection: com.digitel.model.Mapa.elementoGerenciadoCollection -> elemento_gerenciado 15:50:12,598 INFO [CollectionBinder] Mapping collection: com.digitel.model.Mapa.mapaCollection -> mapa 15:50:12,598 INFO [CollectionBinder] Mapping collection: com.digitel.model.Usuario.elementoGerenciadoCollection -> elemento_gerenciado 15:50:12,634 INFO [ConnectionProviderFactory] Initializing connection provider: org.hibernate.ejb.connection.InjectedDataSourceConnectionProvider 15:50:12,637 INFO [InjectedDataSourceConnectionProvider] Using provided datasource 15:50:12,638 INFO [SettingsFactory] RDBMS: PostgreSQL, version: 8.1.4 15:50:12,639 INFO [SettingsFactory] JDBC driver: PostgreSQL Native Driver, version: PostgreSQL 8.0 JDBC3 with SSL (build 312) 15:50:12,639 INFO [Dialect] Using dialect: org.hibernate.dialect.PostgreSQLDialect 15:50:12,639 INFO [TransactionFactoryFactory] Transaction strategy: org.hibernate.ejb.transaction.JoinableCMTTransactionFactory 15:50:12,640 INFO [TransactionManagerLookupFactory] instantiating TransactionManagerLookup: org.hibernate.transaction.JBossTransactionManagerLookup 15:50:12,640 INFO [TransactionManagerLookupFactory] instantiated TransactionManagerLookup 15:50:12,640 INFO [SettingsFactory] Automatic flush during beforeCompletion(): disabled 15:50:12,640 INFO [SettingsFactory] Automatic session close at end of transaction: disabled 15:50:12,640 INFO [SettingsFactory] JDBC batch size: 15 15:50:12,640 INFO [SettingsFactory] JDBC batch updates for versioned data: disabled 15:50:12,640 INFO [SettingsFactory] Scrollable result sets: enabled 15:50:12,640 INFO [SettingsFactory] JDBC3 getGeneratedKeys(): disabled 15:50:12,640 INFO [SettingsFactory] Connection release mode: auto 15:50:12,640 INFO [SettingsFactory] Default batch fetch size: 1 15:50:12,640 INFO [SettingsFactory] Generate SQL with comments: disabled 15:50:12,640 INFO [SettingsFactory] Order SQL updates by primary key: disabled 15:50:12,640 INFO [SettingsFactory] Order SQL inserts for batching: disabled 15:50:12,640 INFO [SettingsFactory] Query translator: org.hibernate.hql.ast.ASTQueryTranslatorFactory 15:50:12,641 INFO [ASTQueryTranslatorFactory] Using ASTQueryTranslatorFactory 15:50:12,641 INFO [SettingsFactory] Query language substitutions: {} 15:50:12,641 INFO [SettingsFactory] JPA-QL strict compliance: enabled 15:50:12,641 INFO [SettingsFactory] Second-level cache: enabled 15:50:12,641 INFO [SettingsFactory] Query cache: disabled 15:50:12,641 INFO [SettingsFactory] Cache provider: org.hibernate.cache.HashtableCacheProvider 15:50:12,641 INFO [SettingsFactory] Optimize cache for minimal puts: disabled 15:50:12,641 INFO [SettingsFactory] Cache region prefix: MaragatoWeb_ear,DMS-DAO_jar,PU 15:50:12,641 INFO [SettingsFactory] Structured second-level cache entries: disabled 15:50:12,641 INFO [SettingsFactory] Statistics: disabled 15:50:12,641 INFO [SettingsFactory] Deleted entity synthetic identifier rollback: disabled 15:50:12,641 INFO [SettingsFactory] Default entity-mode: pojo 15:50:12,641 INFO [SettingsFactory] Named query checking : enabled 15:50:12,657 INFO [SessionFactoryImpl] building session factory 15:50:12,747 INFO [SessionFactoryObjectFactory] Factory name: persistence.units:ear=MaragatoWeb.ear,jar=DMS-DAO.jar,unitName=PU 15:50:12,748 INFO [NamingHelper] JNDI InitialContext properties:{java.naming.factory.initial=org.jnp.interfaces.NamingContextFactory, java.naming.factory.url.pkgs=org.jboss.naming:org.jnp.interfaces} 15:50:12,750 INFO [SessionFactoryObjectFactory] Bound factory to JNDI name: persistence.units:ear=MaragatoWeb.ear,jar=DMS-DAO.jar,unitName=PU 15:50:12,750 WARN [SessionFactoryObjectFactory] InitialContext did not implement EventContext 15:50:12,750 INFO [NamingHelper] JNDI InitialContext properties:{java.naming.factory.initial=org.jnp.interfaces.NamingContextFactory, java.naming.factory.url.pkgs=org.jboss.naming:org.jnp.interfaces} 15:50:12,998 INFO [JmxKernelAbstraction] creating wrapper delegate for: org.jboss.ejb3.stateless.StatelessContainer 15:50:12,998 INFO [JmxKernelAbstraction] installing MBean: jboss.j2ee:ear=MaragatoWeb.ear,jar=DMS-DAO.jar,name=DAOFactory,service=EJB3 with dependencies: 15:50:12,998 INFO [JmxKernelAbstraction] persistence.units:ear=MaragatoWeb.ear,jar=DMS-DAO.jar,unitName=PU 15:50:13,015 INFO [EJBContainer] STARTED EJB: com.digitel.ejb.DAOFactory ejbName: DAOFactory 15:50:13,029 INFO [EJB3Deployer] Deployed: file:/home/leandro/javaapps/jboss-4.2.1.GA/server/default/tmp/deploy/tmp5384MaragatoWeb.ear-contents/DMS-DAO.jar 15:50:13,040 INFO [JmxKernelAbstraction] creating wrapper delegate for: org.jboss.ejb3.stateless.StatelessContainer 15:50:13,040 INFO [JmxKernelAbstraction] installing MBean: jboss.j2ee:ear=MaragatoWeb.ear,jar=DMS-Facade.jar,name=ElementoGerenciadoFacade,service=EJB3 with dependencies: 15:50:13,040 INFO [JmxKernelAbstraction] jboss.j2ee:ear=MaragatoWeb.ear,jar=DMS-DAO.jar,name=DAOFactory,service=EJB3 15:50:13,067 INFO [EJBContainer] STARTED EJB: com.digitel.facade.ElementoGerenciadoFacade ejbName: ElementoGerenciadoFacade 15:50:13,084 INFO [EJB3Deployer] Deployed: file:/home/leandro/javaapps/jboss-4.2.1.GA/server/default/tmp/deploy/tmp5384MaragatoWeb.ear-contents/DMS-Facade.jar 15:50:13,089 INFO [TomcatDeployer] deploy, ctxPath=/DMS-Reports, warUrl=.../tmp/deploy/tmp5384MaragatoWeb.ear-contents/DMS-Reports-exp.war/ 15:50:13,211 INFO [EARDeployer] Started J2EE application: file:/home/leandro/javaapps/jboss-4.2.1.GA/server/default/deploy/MaragatoWeb.ear 15:51:52,851 WARN [TxConnectionManager] Connection error occured: org.jboss.resource.connectionmanager.TxConnectionManager$TxConnectionEventListener@c6a21b2[state=NORMAL mc=org.jboss.resource.adapter.jdbc.local.LocalManagedConnection@530a40cd handles=1 lastUse=1194371412639 permit=true trackByTx=true mcp=org.jboss.resource.connectionmanager.JBossManagedConnectionPool$OnePool@46247d52 context=org.jboss.resource.connectionmanager.InternalManagedConnectionPool@59fb678 xaResource=org.jboss.resource.connectionmanager.TxConnectionManager$LocalXAResource@326de99b txSync=null] java.lang.NullPointerException at org.jboss.mx.loading.RepositoryClassLoader.findClass(RepositoryClassLoader.java:623) at java.lang.ClassLoader.loadClass(ClassLoader.java:306) at org.jboss.mx.loading.RepositoryClassLoader.loadClassImpl(RepositoryClassLoader.java:467) at org.jboss.mx.loading.RepositoryClassLoader.loadClass(RepositoryClassLoader.java:408) at java.lang.ClassLoader.loadClass(ClassLoader.java:251) at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:319) at org.postgresql.jdbc3.Jdbc3Connection.prepareStatement(Jdbc3Connection.java:37) at org.postgresql.jdbc3.AbstractJdbc3Connection.prepareStatement(AbstractJdbc3Connection.java:266) at org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.doPrepareStatement(BaseWrapperManagedConnection.java:349) at org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.prepareStatement(BaseWrapperManagedConnection.java:344) at org.jboss.resource.adapter.jdbc.WrappedConnection.prepareStatement(WrappedConnection.java:187) at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:505) at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:423) at org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:139) at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1547) at org.hibernate.loader.Loader.doQuery(Loader.java:673) at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:236) at org.hibernate.loader.Loader.doList(Loader.java:2220) at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2104) at org.hibernate.loader.Loader.list(Loader.java:2099) at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:378) at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:338) at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:172) at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1121) at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79) at org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:64) at com.digitel.dao.ElementoGerenciadoDAOImpl.findAll(ElementoGerenciadoDAOImpl.java:40) at com.digitel.facade.ElementoGerenciadoFacade.findAll(ElementoGerenciadoFacade.java:52) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:112) at org.jboss.ejb3.interceptor.InvocationContextImpl.proceed(InvocationContextImpl.java:166) at org.jboss.ejb3.interceptor.EJB3InterceptorsInterceptor.invoke(EJB3InterceptorsInterceptor.java:63) at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101) at org.jboss.ejb3.entity.TransactionScopedEntityManagerInterceptor.invoke(TransactionScopedEntityManagerInterceptor.java:54) at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101) at org.jboss.ejb3.AllowedOperationsInterceptor.invoke(AllowedOperationsInterceptor.java:47) at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101) at org.jboss.aspects.tx.TxPolicy.invokeInOurTx(TxPolicy.java:79) at org.jboss.aspects.tx.TxInterceptor$Required.invoke(TxInterceptor.java:191) at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101) at org.jboss.aspects.tx.TxPropagationInterceptor.invoke(TxPropagationInterceptor.java:76) at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101) at org.jboss.ejb3.stateless.StatelessInstanceInterceptor.invoke(StatelessInstanceInterceptor.java:62) at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101) at org.jboss.aspects.security.AuthenticationInterceptor.invoke(AuthenticationInterceptor.java:77) at org.jboss.ejb3.security.Ejb3AuthenticationInterceptor.invoke(Ejb3AuthenticationInterceptor.java:106) at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101) at org.jboss.ejb3.ENCPropagationInterceptor.invoke(ENCPropagationInterceptor.java:46) at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101) at org.jboss.ejb3.asynchronous.AsynchronousInterceptor.invoke(AsynchronousInterceptor.java:106) at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101) at org.jboss.ejb3.stateless.StatelessContainer.localInvoke(StatelessContainer.java:214) at org.jboss.ejb3.stateless.StatelessContainer.localInvoke(StatelessContainer.java:184) at org.jboss.ejb3.stateless.StatelessLocalProxy.invoke(StatelessLocalProxy.java:81) at $Proxy105.findAll(Unknown Source) at com.digitel.web.ListarElementos.processRequest(ListarElementos.java:48) at com.digitel.web.ListarElementos.doGet(ListarElementos.java:73) at javax.servlet.http.HttpServlet.service(HttpServlet.java:690) at javax.servlet.http.HttpServlet.service(HttpServlet.java:803) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:230) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175) at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:179) at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:84) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:104) at org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:157) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:241) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:580) at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447) at java.lang.Thread.run(Thread.java:619) 15:51:52,990 WARN [JDBCExceptionReporter] SQL Error: 0, SQLState: null 15:51:52,991 ERROR [JDBCExceptionReporter] Error; - nested throwable: (java.lang.NullPointerException) 15:51:54,215 ERROR [[ListarElementos]] Servlet.service() for servlet ListarElementos threw exception javax.ejb.EJBException: javax.persistence.PersistenceException: org.hibernate.exception.GenericJDBCException: could not execute query at org.jboss.ejb3.tx.Ejb3TxPolicy.handleExceptionInOurTx(Ejb3TxPolicy.java:63) at org.jboss.aspects.tx.TxPolicy.invokeInOurTx(TxPolicy.java:83) at org.jboss.aspects.tx.TxInterceptor$Required.invoke(TxInterceptor.java:191) at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101) at org.jboss.aspects.tx.TxPropagationInterceptor.invoke(TxPropagationInterceptor.java:76) at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101) at org.jboss.ejb3.stateless.StatelessInstanceInterceptor.invoke(StatelessInstanceInterceptor.java:62) at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101) at org.jboss.aspects.security.AuthenticationInterceptor.invoke(AuthenticationInterceptor.java:77) at org.jboss.ejb3.security.Ejb3AuthenticationInterceptor.invoke(Ejb3AuthenticationInterceptor.java:106) at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101) at org.jboss.ejb3.ENCPropagationInterceptor.invoke(ENCPropagationInterceptor.java:46) at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101) at org.jboss.ejb3.asynchronous.AsynchronousInterceptor.invoke(AsynchronousInterceptor.java:106) at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101) at org.jboss.ejb3.stateless.StatelessContainer.localInvoke(StatelessContainer.java:214) at org.jboss.ejb3.stateless.StatelessContainer.localInvoke(StatelessContainer.java:184) at org.jboss.ejb3.stateless.StatelessLocalProxy.invoke(StatelessLocalProxy.java:81) at $Proxy105.findAll(Unknown Source) at com.digitel.web.ListarElementos.processRequest(ListarElementos.java:48) at com.digitel.web.ListarElementos.doGet(ListarElementos.java:73) at javax.servlet.http.HttpServlet.service(HttpServlet.java:690) at javax.servlet.http.HttpServlet.service(HttpServlet.java:803) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:230) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175) at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:179) at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:84) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:104) at org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:157) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:241) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:580) at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447) at java.lang.Thread.run(Thread.java:619) Caused by: javax.persistence.PersistenceException: org.hibernate.exception.GenericJDBCException: could not execute query at org.hibernate.ejb.AbstractEntityManagerImpl.throwPersistenceException(AbstractEntityManagerImpl.java:629) at org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:73) at com.digitel.dao.ElementoGerenciadoDAOImpl.findAll(ElementoGerenciadoDAOImpl.java:40) at com.digitel.facade.ElementoGerenciadoFacade.findAll(ElementoGerenciadoFacade.java:52) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:112) at org.jboss.ejb3.interceptor.InvocationContextImpl.proceed(InvocationContextImpl.java:166) at org.jboss.ejb3.interceptor.EJB3InterceptorsInterceptor.invoke(EJB3InterceptorsInterceptor.java:63) at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101) at org.jboss.ejb3.entity.TransactionScopedEntityManagerInterceptor.invoke(TransactionScopedEntityManagerInterceptor.java:54) at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101) at org.jboss.ejb3.AllowedOperationsInterceptor.invoke(AllowedOperationsInterceptor.java:47) at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101) at org.jboss.aspects.tx.TxPolicy.invokeInOurTx(TxPolicy.java:79) ... 39 more Caused by: org.hibernate.exception.GenericJDBCException: could not execute query at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:103) at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:91) at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43) at org.hibernate.loader.Loader.doList(Loader.java:2223) at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2104) at org.hibernate.loader.Loader.list(Loader.java:2099) at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:378) at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:338) at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:172) at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1121) at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79) at org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:64) ... 54 more Caused by: org.jboss.util.NestedSQLException: Error; - nested throwable: (java.lang.NullPointerException) at org.jboss.resource.adapter.jdbc.WrappedConnection.checkException(WrappedConnection.java:557) at org.jboss.resource.adapter.jdbc.WrappedConnection.prepareStatement(WrappedConnection.java:191) at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:505) at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:423) at org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:139) at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1547) at org.hibernate.loader.Loader.doQuery(Loader.java:673) at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:236) at org.hibernate.loader.Loader.doList(Loader.java:2220) ... 62 more Caused by: java.lang.NullPointerException at org.jboss.mx.loading.RepositoryClassLoader.findClass(RepositoryClassLoader.java:623) at java.lang.ClassLoader.loadClass(ClassLoader.java:306) at org.jboss.mx.loading.RepositoryClassLoader.loadClassImpl(RepositoryClassLoader.java:467) at org.jboss.mx.loading.RepositoryClassLoader.loadClass(RepositoryClassLoader.java:408) at java.lang.ClassLoader.loadClass(ClassLoader.java:251) at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:319) at org.postgresql.jdbc3.Jdbc3Connection.prepareStatement(Jdbc3Connection.java:37) at org.postgresql.jdbc3.AbstractJdbc3Connection.prepareStatement(AbstractJdbc3Connection.java:266) at org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.doPre