1 Reply Latest reply on Oct 30, 2008 3:31 AM by jaikiran

    JBoss 4.0.2 to JBoss 5.2.3.GA with PostgresSQL 7.4

    rogeriogrando

      Hi all;

      I have an application using JBoss 4.0.2 connecting with PostgreSQL 7.4 running smoothly.
      We're migrating from the JBoss 4.0.2 to 5.2.3, and the following errors are occurring.

      WARN [PortComponentMetaData] <wsdl-port> element in webservices.xml not namespace qualified: WSPlaninPort
      INFO [DefaultEndpointRegistry] register: jboss.ws:context=WSPlanin,endpoint=WSPlanin
      INFO [TomcatDeployer] deploy, ctxPath=/WSPlanin, warUrl=.../tmp/deploy/tmp25172WSPlanin-exp.war/
      WARN [WSDL11Reader] Encoding style 'http://schemas.xmlsoap.org/soap/encoding/' not supported for: {http://planin/com/br}ExecuteSQL
      WARN [WSDL11Reader] Encoding style 'http://schemas.xmlsoap.org/soap/encoding/' not supported for: {http://planin/com/br}InformServ
      WARN [WSDL11Reader] Encoding style 'http://schemas.xmlsoap.org/soap/encoding/' not supported for: {http://planin/com/br}Select
      WARN [WSDL11Reader] Encoding style 'http://schemas.xmlsoap.org/soap/encoding/' not supported for: {http://planin/com/br}SelectConsultaPadrao
      WARN [WSDL11Reader] Encoding style 'http://schemas.xmlsoap.org/soap/encoding/' not supported for: {http://planin/com/br}SelectDMD
      WARN [JAXRPCServerMetaDataBuilder] Adding wsdl targetNamespace to: {http://planin/com/br}WSPlaninPort
      INFO [WSDLFilePublisher] WSDL published to: file:/C:/Arquivos de programas/Planin/Java/jboss-4.2.3.GA/server/default/data/wsdl/WSPlanin.war/WSPlaninService.wsdl
      INFO [TomcatDeployer] deploy, ctxPath=/jmx-console, warUrl=.../deploy/jmx-console.war/
      INFO [Http11Protocol] Starting Coyote HTTP/1.1 on http-127.0.0.1-8080
      INFO [AjpProtocol] Starting Coyote AJP/1.3 on ajp-127.0.0.1-8009
      INFO [Server] JBoss (MX MicroKernel) [4.2.3.GA (build: SVNTag=JBoss_4_2_3_GA date=200807181417)] Started in 45s:94ms
      WARN [loggerI18N] [com.arjuna.ats.internal.jta.resources.arjunacore.norecoveryxa] [com.arjuna.ats.internal.jta.resources.arjunacore.norecoveryxa] Could not find new XAResource to use for recovering non-serializable XAResource < 131075, 27, 25, 1--3f57b2f4:c86:490893db:33-3f57b2f4:c86:490893db:35 >
      WARN [loggerI18N] [com.arjuna.ats.internal.jta.resources.arjunacore.norecoveryxa] [com.arjuna.ats.internal.jta.resources.arjunacore.norecoveryxa] Could not find new XAResource to use for recovering non-serializable XAResource < 131075, 27, 25, 1--3f57b2f4:bb3:49088ccc:32-3f57b2f4:bb3:49088ccc:34 >
      WARN [loggerI18N] [com.arjuna.ats.internal.jta.resources.arjunacore.norecoveryxa] [com.arjuna.ats.internal.jta.resources.arjunacore.norecoveryxa] Could not find new XAResource to use for recovering non-serializable XAResource < 131075, 27, 25, 1--3f57b2f4:ab4:49087d44:31-3f57b2f4:ab4:49087d44:33 >
      INFO [STDOUT] Iniciando Sessao
      INFO [STDOUT] Obtendo o DataSource
      INFO [STDOUT] Obtendo o DataSource
      WARN [loggerI18N] [com.arjuna.ats.internal.jta.transaction.arjunacore.lastResource.disallow] [com.arjuna.ats.internal.jta.transaction.arjunacore.lastResource.disallow] Adding multiple last resources is disallowed. Current resource is org.jboss.resource.connectionmanager.TxConnectionManager$LocalXAResource@ff665a
      INFO [STDOUT] ds Could not enlist in transaction on entering meta-aware object!; - nested throwable: (javax.transaction.SystemException: java.lang.Throwable: Unabled to enlist resource, see the previous warnings. tx=TransactionImple < ac, BasicAction: -3f57b2f4:10f3:4908c39a:34 status: ActionStatus.ABORT_ONLY >); - nested throwable: (org.jboss.resource.JBossResourceException: Could n
      transaction on entering meta-aware object!; - nested throwable: (javax.transaction.SystemException: java.lang.Throwable: Unabled to enlist resource, see the previous warnings. tx=TransactionImple < ac, BasicAction: -3f57b2f4:10f3:4908c39a:34 status: ActionStatus.ABORT_ONLY >))
      ERROR [DAOException] Erro no acesso a dados: Could not enlist in transaction on entering meta-aware object!; - nested throwable: (javax.transaction.SystemException: java.lang.Throwable: Unabled to enlist resource, see the previous warnings. tx=TransactionImple < ac, BasicAction: -3f57b2f4:10f3:4908c39a:34 status: ActionStatus.ABORT_ONLY >); - nested throwable: (org.jboss.resource.JBos
      sResourceException: Could not enlist in transaction on entering meta-aware object!; - nested throwable: (javax.transaction.SystemException: java.lang.Throwable: Unabled to enlist resource, see the previous warnings. tx=TransactionImple < ac, BasicAction: -3f57b2f4:10f3:4908c39a:34 status: ActionStatus.ABORT_ONLY >)). Falha na abertura da conexÒo com BD.
      ERROR [STDERR] br.com.planin.dao.DAOException: Erro no acesso a dados: Could not enlist in transaction on entering meta-aware object!; - nested throwable: (javax.transaction.SystemException: java.lang.Throwable: Unabled to enlist resource, see the previous warnings. tx=TransactionImple < ac, BasicAction: -3f57b2f4:10f3:4908c39a:34 status: ActionStatus.ABORT_ONLY >); - nested throwable
      : (org.jboss.resource.JBossResourceException: Could not enlist in transaction on entering meta-aware object!; - nested throwable: (javax.transaction.SystemException: java.lang.Throwable: Unabled to enlist resource, see the previous warnings. tx=TransactionImple < ac, BasicAction: -3f57b2f4:10f3:4908c39a:34 status: ActionStatus.ABORT_ONLY >)). Falha na abertura da conexÒo com BD.
      ERROR [STDERR] at br.com.planin.dao.DAOFactory.getConnection(DAOFactory.java:71)
      ERROR [STDERR] at br.com.planin.dao.DAOFactory.Conectar(DAOFactory.java:38)
      ERROR [STDERR] at br.com.planin.ejb.PlaninBean.setSessionContext(PlaninBean.java:58)


      My Datasources Configuration


      <local-tx-datasource>
      <jndi-name>ERP</jndi-name>
      <connection-url>jdbc:postgresql://192.168.77.254:5432/infra_rg_ini</connection-url>
      <driver-class>org.postgresql.Driver</driver-class>
      <user-name>postgres</user-name>
      planin

      <!--pooling parameters-->
      <min-pool-size>10</min-pool-size>
      <max-pool-size>50</max-pool-size>
      <blocking-timeout-millis>5000</blocking-timeout-millis>
      <idle-timeout-minutes>15</idle-timeout-minutes>
      <track-statements>false</track-statements>
      <set-tx-query-timeout>3000</set-tx-query-timeout>
      <query-timeout>3000</query-timeout>

      <!-- sql to call when connection is created
      <new-connection-sql>some arbitrary sql</new-connection-sql>
      -->

      <!-- sql to call on an existing pooled connection when it is obtained from pool
      <check-valid-connection-sql>some arbitrary sql</check-valid-connection-sql>
      -->

      </local-tx-datasource>

      <local-tx-datasource>
      <jndi-name>DMD</jndi-name>
      <connection-url>jdbc:postgresql://192.168.77.254:5432/infra_rg_ini</connection-url>
      <driver-class>org.postgresql.Driver</driver-class>
      <user-name>postgres</user-name>
      planin

      <!--pooling parameters-->
      <min-pool-size>10</min-pool-size>
      <max-pool-size>50</max-pool-size>
      <blocking-timeout-millis>5000</blocking-timeout-millis>
      <idle-timeout-minutes>15</idle-timeout-minutes>
      <track-statements>false</track-statements>
      <set-tx-query-timeout>3000</set-tx-query-timeout>
      <query-timeout>3000</query-timeout>

      <!-- sql to call when connection is created
      <new-connection-sql>some arbitrary sql</new-connection-sql>
      -->

      <!-- sql to call on an existing pooled connection when it is obtained from pool
      <check-valid-connection-sql>some arbitrary sql</check-valid-connection-sql>
      -->

      </local-tx-datasource>


      Could somebody help me?
      Sorry for my Englesh.

      Thank

        • 1. Re: JBoss 4.0.2 to JBoss 5.2.3.GA with PostgresSQL 7.4
          jaikiran

           

          We're migrating from the JBoss 4.0.2 to 5.2.3


          I assume that's a typo. You are migrating to JBoss-4.2.3 GA, right?

          com.arjuna.ats.internal.jta.transaction.arjunacore.lastResource.disallow] Adding multiple last resources is disallowed. Current resource is org.jboss.resource.connectionmanager.TxConnectionManager$LocalXAResource@ff665a


          I think you are using multiple transactional resources in a single transaction. And the datasource that you are using is not XA. See this for details http://www.jboss.org/community/docs/DOC-11443