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

My EJB don't access the database

leandroseverino Nov 6, 2007 1:05 PM

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

1. Re: My EJB don't access the database

leandroseverino Nov 6, 2007 1:10 PM (in response to leandroseverino)

My persistence.xml:

<?xml version="1.0" encoding="UTF-8"?>
<persistence version="1.0" xmlns="http://java.sun.com/xml/ns/persistence" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://java.sun.com/xml/ns/persistence http://java.sun.com/xml/ns/persistence/persistence_1_0.xsd">
 <persistence-unit name="PU" transaction-type="JTA">
 <provider>org.hibernate.ejb.HibernatePersistence</provider>
 <jta-data-source>java:/maragato</jta-data-source>
 <properties>
 <property name="hibernate.dialect" value="org.hibernate.dialect.PostgreSQLDialect"/>
 </properties>
 </persistence-unit>
</persistence>

and my jboss-ds.xml:

<?xml version="1.0" encoding="UTF-8"?>
<datasources>
 <local-tx-datasource>
 <jndi-name>maragato</jndi-name>
 <connection-url>jdbc:postgresql://10.10.10.23:5432/maragato</connection-url>
 <driver-class>org.postgresql.Driver</driver-class>
 <user-name>postgres</user-name>
 <password>postgres</password>
 <min-pool-size>5</min-pool-size>
 <max-pool-size>20</max-pool-size>
 <idle-timeout-minutes>5</idle-timeout-minutes>
 <exception-sorter-class-name />

 <!-- sql to call when connection is created. Can be anything, select 1 is valid for PostgreSQL -->

 <new-connection-sql>select 1</new-connection-sql>

 <!-- sql to call on an existing pooled connection when it is obtained from pool. Can be anything, select 1 is valid for PostgreSQL -->

 <check-valid-connection-sql>select 1</check-valid-connection-sql>
 </local-tx-datasource>
</datasources>

2. Re: My EJB don't access the database

jaikiran Nov 6, 2007 1:45 PM (in response to leandroseverino)
em.createQuery("select object(o) from ElementoGerenciado as o").getResultList();

Does it work if you change the createQuery statement to

em.createQuery("select o from ElementoGerenciado o").getResultList();
Actions
3. Re: My EJB don't access the database

jaikiran Nov 6, 2007 1:59 PM (in response to leandroseverino)
Or this?

em.createQuery("select object(o) from ElementoGerenciado o").getResultList();

Note that i have removed 'as' from that query
Actions

4. Re: My EJB don't access the database

leandroseverino Nov 6, 2007 2:16 PM (in response to leandroseverino)

jaikiran,
Don't work.

Strange, but in the stacktrace show-me this lines:

 at $Proxy105.findAll(Unknown Source)

and

15:51:52,990 WARN [JDBCExceptionReporter] SQL Error: 0, SQLState: null

I make a test in a servlet:

 try {
 Context c = new InitialContext();
 DataSource ds = (DataSource) c.lookup("java:/maragato");
 try {
 Connection con = (Connection) ds.getConnection();
 System.out.println(con.isClosed());
 //Properties prop = con.getClientInfo();
 System.out.println(con.getCatalog());
 System.out.println(con.isReadOnly());
 } catch (SQLException ex) {
 ex.printStackTrace();
 }
 }
 catch(NamingException ne) {
 Logger.getLogger(getClass().getName()).log(Level.SEVERE,"exception caught" ,ne);
 throw new RuntimeException(ne);
 }

and the connection and the datasource is not null.

I think that the problem is between the JPA and local-tx-datasource, but what is the problem ?

5. Re: My EJB don't access the database

leandroseverino Nov 7, 2007 7:07 AM (in response to leandroseverino)

More information:

The structure of my project:

-App.EAR
--META-INF
---MANIFEST.MF
---application.xml
---jboss-app.xml
--Facade.jar (EJB)
---META-INF
----MANIFEST.MF
----jboss.xml
---com
----app
-----facade
------ElementFacade.class
------ElementFacadeLocal.class
--DAO.jar(EJB)
---META-INF
----MANIFEST.MF
----jboss.xml
----persistence.xml
---com
----app
-----model
------Entity.class
----app
-----dao
------IDAO.class
------IEntityDAO.class
------EntityDAOImpl.class
----app
-----ejb
------DAOFactory.class
------DAOFactoryImpl.class
--web.war(war)
---META-INF
----MANIFEST.MF
---WEB-INF
----jboss-web.xml
----web.xml
----classes
-----app
------web
-------ServletTest.class

6. Re: My EJB don't access the database

leandroseverino Nov 7, 2007 7:08 AM (in response to leandroseverino)

any idea ?
Actions
7. Re: My EJB don't access the database

leandroseverino Nov 7, 2007 7:19 AM (in response to leandroseverino)

The Project:
[img]http://www.flickr.com/photo_zoom.gne?id=1902418462&size=o[/img]

The FACADE:
[img]http://www.flickr.com/photo_zoom.gne?id=1902418496&size=o[/img]

The DAO:
[img]http://www.flickr.com/photo_zoom.gne?id=1902418490&size=o[/img]
Actions
8. Re: My EJB don't access the database

leandroseverino Nov 7, 2007 3:44 PM (in response to leandroseverino)

[Resolved]
The problem was the NetBeans. It don't work's fine in debug mode.
Actions

Go to original post