[jboss-user] [EJB 3.0] - JBoss 4.0.2 to JBoss 5.2.3.GA with PostgresSQL 7.4

rogeriogrando do-not-reply at jboss.com
Wed Oct 29 16:35:50 EDT 2008 

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 at 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

View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4185540#4185540

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4185540

More information about the jboss-user mailing list