Problema na conexão com postgres no JBOSS

0 respostas
T

Bom dia galera, venho aqui solicitar ajuda a vcs.
É o seguinte eu tenho uma aplicação que rodo no tom cat , e gostaria de passar para JBOSS.
primeira duvida o que preciso fazer inicialmente para pode passar do tom cat pro jboss.
Pelo que li dizem que é so gerar um .war da aplicação e criar um nome-ds.xml para conexão.
fiz isso e aparece o seguinte.

10:38:16,640 INFO  [ConnectionFactoryBindingService] Bound ConnectionManager 'jboss.jca:service=DataSourceBinding,name=cpad' to JNDI name 'java:cpad'

10:38:19,437 INFO  [TomcatDeployer] deploy, ctxPath=/fluxusDesenvolv, warUrl=.../deploy/fluxusDesenvolv.war/

10:39:48,328 ERROR [STDERR] Exceção de contexto:
10:39:48,328 ERROR [STDERR] jdbc not bound
10:39:48,328 ERROR [STDERR] Exceção gerada ao obter lista:
10:39:48,328 ERROR [STDERR] null
10:39:48,328 ERROR [STDERR] Exceção de contexto:
10:39:48,328 ERROR [STDERR] jdbc not bound
10:39:48,328 ERROR [STDERR] Exceção gerada ao obter lista:
10:39:48,328 ERROR [STDERR] null
10:39:48,328 ERROR [STDERR] Erro ao selecionar: null
10:39:48,390 ERROR [[jsp]] Servlet.service() for servlet jsp threw exception
java.lang.NullPointerException
	at br.gov.jfce.commons.Consultas.selecionar(Consultas.java:371)
	at br.gov.jfce.cpad.Orgaos.selecionar(Orgaos.java:71)
	at org.apache.jsp.index_jsp._jspService(index_jsp.java:136)
	at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
	at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:373)
	at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:336)
	at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:265)
	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:127)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
	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:262)
	at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
	at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
	at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:446)
	at java.lang.Thread.run(Thread.java:619)
Segundo como configurar a conexao com o banco , estou fazerndo o seguinte: cpad-ds.xml
<?xml version="1.0" encoding="UTF-8"?>
<datasources>
  <local-tx-datasource>
    <jndi-name>cpad</jndi-name>
    <connection-url>jdbc:postgresql://172.16.0.654/cpad</connection-url>
    <driver-class>org.postgresql.Driver</driver-class>
    <user-name>teste</user-name>
    <password>teste</password>
        <!-- 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>
        -->

      <!-- corresponding type-mapping in the standardjbosscmp-jdbc.xml -->
      <metadata>
         <type-mapping>PostgreSQL 8</type-mapping>
      </metadata>
  </local-tx-datasource>

</datasources>
Criado 27 de março de 2008
Respostas 0
Participantes 1