8 Replies Latest reply on Nov 7, 2007 3:44 PM by Leandro Severino

    My EJB don't access the database

    Leandro Severino Newbie

      When 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