Hi Prabath, any progress in this issue? Saludos, Ing. Jorge Infante Osorio. J´Dpto Soluciones SOA. CDAE. Fac. 5. UCI.
De: carbon-dev-boun...@wso2.org [mailto:carbon-dev-boun...@wso2.org] En nombre de Prabath Abeysekera Enviado el: domingo, 15 de enero de 2012 8:28 Para: carbon-...@wso2.org Asunto: Re: [Carbon-dev] XA Transactions If we further dig into this issue, each datasource implementation would have its own set of properties having different names to be populated when establishing a connection. Therefore, it's obvious that we come across this sort of issues while dealing with all those types. So we're planning to improve the current implementation to enhance the support for several different datasource types. Not only that, with the proposed enhancements to Carbon datasource implementation, it is planned to provide the ability to globally define XA datasources so that the user can re-use those datasources in non-DSS related activities as well. On Sun, Jan 15, 2012 at 6:29 PM, Prabath Abeysekera <praba...@wso2.com> wrote: Hi, This issue is something specific to PostgreSQL and actually occurs while trying to populate bean properties of PGXADataSource instances during the initialization of XA datasources. To further explain the context of the issue, in dataservices core implementation we use java reflection to extract out the setter methods of the PGXADataSource class to dynamically populate properties, username, password and URL that are required to establish datasource connections upon the given configurations. Although most of the other XA datasource implementations such as Mysql, Oracle, H2, etc provide setter methods to directly populate value of the property named URL, PGXADataSource does not seem to provide that particular utility. As a result of it, the process of initializing PostgreSQL related XA datasources fails. I'll look into this. Regards, Prabath On Mon, Jan 9, 2012 at 6:58 AM, Jorge Infante Osorio <jorg...@uci.cu> wrote: Hi Lakmali, any advance on this? Saludos, Ing. Jorge Infante Osorio. J´Dpto Soluciones SOA. CDAE. Fac. 5. UCI. De: carbon-dev-boun...@wso2.org [mailto:carbon-dev-boun...@wso2.org] En nombre de Lakmali Baminiwatta Enviado el: viernes, 16 de diciembre de 2011 4:51 Para: carbon-...@wso2.org Asunto: Re: [Carbon-dev] XA Transactions Hi Jorge, We are looking into this. Thanks, Lakmali On Fri, Dec 16, 2011 at 3:16 AM, Jorge Infante Osorio <jorg...@uci.cu> wrote: Hi Anjana. I know you guys are very busy in this days.. it´s ok :-D I made some work around but I´m facing some problems. This is my config: In context.xml: <Resource name="jdbc/pruebas" auth="Container" type="com.atomikos.jdbc.AtomikosDataSourceBean" factory="org.wso2.carbon.atomikos.TransactionFactory" uniqueResourceName="jdbc/pruebas" xaDataSourceClassName="org.postgresql.xa.PGXADataSource" xaProperties.databaseName="pruebas" xaProperties.serverName="127.0.0.1" xaProperties.portNumber="5432" xaProperties.user="postgres" xaProperties.password="descarga*22" /> And this is the pool in my dbreport mediator config: <pool> <password>pass</password> <user>postgres</user> <dsName>java:comp/env/jdbc/pruebas</dsName> <url>jdbc:postgresql://127.0.0.1:5432/pruebas2</url> <icClass>org.apache.naming.java.javaURLContextFactory</icClass> </pool> I don´t know if the icClass value it´s right.!!! The error: [2011-12-15 16:44:27,209] ERROR - DataSourceFinder DataSource : java:comp/env/jdbc/pruebas not found when looking up using JNDI properties : {java.naming.factory.initial=org.apache .naming.java.javaURLContextFactory, java.naming.factory.url.pkgs=org.apache.naming, jmx.remote.authenticator=org.wso2.carbon.core.security.CarbonJMXAuthenticato r@b88745} [2011-12-15 16:44:27,209] FATAL - ServiceBusInitializer Couldn't initialize the ESB... org.apache.synapse.commons.SynapseCommonsException: DataSource : java:comp/env/jdbc/pruebas not found when looking up using JNDI properties : {java.naming.factory.initial=org.apach e.naming.java.javaURLContextFactory, java.naming.factory.url.pkgs=org.apache.naming, jmx.remote.authenticator=org.wso2.carbon.core.security.CarbonJMXAuthenticato r@b88745} at org.apache.synapse.commons.datasource.DataSourceFinder.find(DataSourceFinder .java:71) at org.apache.synapse.commons.datasource.DataSourceFinder.find(DataSourceFinder .java:49) at org.apache.synapse.mediators.db.AbstractDBMediator.lookupDataSource(Abstract DBMediator.java:423) at org.apache.synapse.mediators.db.AbstractDBMediator.init(AbstractDBMediator.j ava:79) at org.apache.synapse.mediators.AbstractListMediator.init(AbstractListMediator. java:106) at org.apache.synapse.mediators.base.SequenceMediator.init(SequenceMediator.jav a:189) at org.apache.synapse.config.SynapseConfiguration.init(SynapseConfiguration.jav a:1314) at org.apache.synapse.Axis2SynapseController.createSynapseEnvironment(Axis2Syna pseController.java:422) at org.apache.synapse.ServerManager.start(ServerManager.java:181) at org.wso2.carbon.mediation.initializer.ServiceBusInitializer.initESB(ServiceB usInitializer.java:408) at org.wso2.carbon.mediation.initializer.ServiceBusInitializer.activate(Service BusInitializer.java:170) 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.eclipse.equinox.internal.ds.model.ServiceComponent.activate(ServiceCompo nent.java:230) at org.eclipse.equinox.internal.ds.model.ServiceComponentProp.activate(ServiceC omponentProp.java:140) at org.eclipse.equinox.internal.ds.model.ServiceComponentProp.build(ServiceComp onentProp.java:330) at org.eclipse.equinox.internal.ds.InstanceProcess.buildComponent(InstanceProce ss.java:560) at org.eclipse.equinox.internal.ds.InstanceProcess.buildComponents(InstanceProc ess.java:182) at org.eclipse.equinox.internal.ds.Resolver.getEligible(Resolver.java:292) at org.eclipse.equinox.internal.ds.SCRManager.serviceChanged(SCRManager.java:22 6) at org.eclipse.osgi.internal.serviceregistry.FilteredServiceListener.serviceCha nged(FilteredServiceListener.java:124) at org.eclipse.osgi.framework.internal.core.BundleContextImpl.dispatchEvent(Bun dleContextImpl.java:930) at org.eclipse.osgi.framework.eventmgr.EventManager.dispatchEvent(EventManager. java:220) at org.eclipse.osgi.framework.eventmgr.ListenerQueue.dispatchEventSynchronous(L istenerQueue.java:149) at org.eclipse.osgi.internal.serviceregistry.ServiceRegistry.publishServiceEven tPrivileged(ServiceRegistry.java:757) at org.eclipse.osgi.internal.serviceregistry.ServiceRegistry.publishServiceEven t(ServiceRegistry.java:712) at org.eclipse.osgi.internal.serviceregistry.ServiceRegistrationImpl.register(S erviceRegistrationImpl.java:129) at org.eclipse.osgi.internal.serviceregistry.ServiceRegistry.registerService(Se rviceRegistry.java:206) at org.eclipse.osgi.framework.internal.core.BundleContextImpl.registerService(B undleContextImpl.java:506) at org.eclipse.osgi.framework.internal.core.BundleContextImpl.registerService(B undleContextImpl.java:524) at org.wso2.carbon.event.core.internal.builder.EventBrokerBuilderDS.activate(Ev entBrokerBuilderDS.java:71) 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.eclipse.equinox.internal.ds.model.ServiceComponent.activate(ServiceCompo nent.java:230) at org.eclipse.equinox.internal.ds.model.ServiceComponentProp.activate(ServiceC omponentProp.java:140) at org.eclipse.equinox.internal.ds.model.ServiceComponentProp.build(ServiceComp onentProp.java:330) at org.eclipse.equinox.internal.ds.InstanceProcess.buildComponent(InstanceProce ss.java:560) at org.eclipse.equinox.internal.ds.InstanceProcess.buildComponents(InstanceProc ess.java:182) at org.eclipse.equinox.internal.ds.Resolver.getEligible(Resolver.java:292) at org.eclipse.equinox.internal.ds.SCRManager.serviceChanged(SCRManager.java:22 6) at org.eclipse.osgi.internal.serviceregistry.FilteredServiceListener.serviceCha nged(FilteredServiceListener.java:124) at org.eclipse.osgi.framework.internal.core.BundleContextImpl.dispatchEvent(Bun dleContextImpl.java:930) at org.eclipse.osgi.framework.eventmgr.EventManager.dispatchEvent(EventManager. java:220) at org.eclipse.osgi.framework.eventmgr.ListenerQueue.dispatchEventSynchronous(L istenerQueue.java:149) at org.eclipse.osgi.internal.serviceregistry.ServiceRegistry.publishServiceEven tPrivileged(ServiceRegistry.java:757) at org.eclipse.osgi.internal.serviceregistry.ServiceRegistry.publishServiceEven t(ServiceRegistry.java:712) at org.eclipse.osgi.internal.serviceregistry.ServiceRegistrationImpl.register(S erviceRegistrationImpl.java:129) at org.eclipse.osgi.internal.serviceregistry.ServiceRegistry.registerService(Se rviceRegistry.java:206) at org.eclipse.osgi.framework.internal.core.BundleContextImpl.registerService(B undleContextImpl.java:506) at org.eclipse.osgi.framework.internal.core.BundleContextImpl.registerService(B undleContextImpl.java:524) at org.wso2.carbon.qpid.internal.QpidServiceComponent.activate(QpidServiceCompo nent.java:134) 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.eclipse.equinox.internal.ds.model.ServiceComponent.activate(ServiceCompo nent.java:230) at org.eclipse.equinox.internal.ds.model.ServiceComponentProp.activate(ServiceC omponentProp.java:140) at org.eclipse.equinox.internal.ds.model.ServiceComponentProp.build(ServiceComp onentProp.java:330) at org.eclipse.equinox.internal.ds.InstanceProcess.buildComponent(InstanceProce ss.java:560) at org.eclipse.equinox.internal.ds.InstanceProcess.buildComponents(InstanceProc ess.java:182) at org.eclipse.equinox.internal.ds.Resolver.getEligible(Resolver.java:292) at org.eclipse.equinox.internal.ds.SCRManager.serviceChanged(SCRManager.java:22 6) at org.eclipse.osgi.internal.serviceregistry.FilteredServiceListener.serviceCha nged(FilteredServiceListener.java:124) at org.eclipse.osgi.framework.internal.core.BundleContextImpl.dispatchEvent(Bun dleContextImpl.java:930) at org.eclipse.osgi.framework.eventmgr.EventManager.dispatchEvent(EventManager. java:220) at org.eclipse.osgi.framework.eventmgr.ListenerQueue.dispatchEventSynchronous(L istenerQueue.java:149) at org.eclipse.osgi.internal.serviceregistry.ServiceRegistry.publishServiceEven tPrivileged(ServiceRegistry.java:757) at org.eclipse.osgi.internal.serviceregistry.ServiceRegistry.publishServiceEven t(ServiceRegistry.java:712) at org.eclipse.osgi.internal.serviceregistry.ServiceRegistrationImpl.register(S erviceRegistrationImpl.java:129) at org.eclipse.osgi.internal.serviceregistry.ServiceRegistry.registerService(Se rviceRegistry.java:206) at org.eclipse.osgi.framework.internal.core.BundleContextImpl.registerService(B undleContextImpl.java:506) at org.eclipse.osgi.framework.internal.core.BundleContextImpl.registerService(B undleContextImpl.java:524) at org.wso2.carbon.core.services.internal.CarbonServicesServiceComponent.activa te(CarbonServicesServiceComponent.java:72) 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.eclipse.equinox.internal.ds.model.ServiceComponent.activate(ServiceCompo nent.java:230) at org.eclipse.equinox.internal.ds.model.ServiceComponentProp.activate(ServiceC omponentProp.java:140) at org.eclipse.equinox.internal.ds.model.ServiceComponentProp.build(ServiceComp onentProp.java:330) at org.eclipse.equinox.internal.ds.InstanceProcess.buildComponent(InstanceProce ss.java:560) at org.eclipse.equinox.internal.ds.InstanceProcess.buildComponents(InstanceProc ess.java:182) at org.eclipse.equinox.internal.ds.Resolver.getEligible(Resolver.java:292) at org.eclipse.equinox.internal.ds.SCRManager.serviceChanged(SCRManager.java:22 6) at org.eclipse.osgi.internal.serviceregistry.FilteredServiceListener.serviceCha nged(FilteredServiceListener.java:124) at org.eclipse.osgi.framework.internal.core.BundleContextImpl.dispatchEvent(Bun dleContextImpl.java:930) at org.eclipse.osgi.framework.eventmgr.EventManager.dispatchEvent(EventManager. java:220) at org.eclipse.osgi.framework.eventmgr.ListenerQueue.dispatchEventSynchronous(L istenerQueue.java:149) at org.eclipse.osgi.internal.serviceregistry.ServiceRegistry.publishServiceEven tPrivileged(ServiceRegistry.java:757) at org.eclipse.osgi.internal.serviceregistry.ServiceRegistry.publishServiceEven t(ServiceRegistry.java:712) at org.eclipse.osgi.internal.serviceregistry.ServiceRegistrationImpl.register(S erviceRegistrationImpl.java:129) at org.eclipse.osgi.internal.serviceregistry.ServiceRegistry.registerService(Se rviceRegistry.java:206) at org.eclipse.osgi.framework.internal.core.BundleContextImpl.registerService(B undleContextImpl.java:506) at org.eclipse.osgi.framework.internal.core.BundleContextImpl.registerService(B undleContextImpl.java:524) at org.wso2.carbon.core.init.CarbonServerManager.initializeCarbon(CarbonServerM anager.java:471) at org.wso2.carbon.core.init.CarbonServerManager.removePendingItem(CarbonServer Manager.java:273) at org.wso2.carbon.core.init.PreAxis2ConfigItemListener.bundleChanged(PreAxis2C onfigItemListener.java:117) at org.eclipse.osgi.framework.internal.core.BundleContextImpl.dispatchEvent(Bun dleContextImpl.java:916) at org.eclipse.osgi.framework.eventmgr.EventManager.dispatchEvent(EventManager. java:220) at org.eclipse.osgi.framework.eventmgr.EventManager$EventThread.run(EventManage r.java:330) [2011-12-15 16:44:27,225] INFO - EventBrokerBuilderDS Successfully registered the event broker Saludos, Ing. Jorge Infante Osorio. J´Dpto Soluciones SOA. CDAE. Fac. 5. UCI. De: Anjana Fernando [mailto:anj...@wso2.com] Enviado el: lunes, 12 de diciembre de 2011 4:22 Para: Jorge Infante Osorio CC: carbon-...@wso2.org Asunto: Re: XA Transactions Hi Jorge, I'm a bit busy with some work now, I will check it out later, but I've done this in some way earlier, maybe we'd the server.xml in earlier Carbon versions, I'm not totally sure, you can google around a bit and find the possibilities of adding a data source in Tomcat. In case I find the solution first, I will give an update. Cheers, Anjana. On Mon, Dec 12, 2011 at 12:12 AM, Jorge Infante Osorio <jorg...@uci.cu> wrote: Hi Anjana. To work with transactions in Tomcat, I need to work with the server.xml and context.xml files. I found context.xml under [CARBON_HOME]\lib\tomcat\conf\ but I don´t find server.xml. Following an Afkham message, I see that carbon don't support server.xml config yet. What can I do in the case I cannot use server.xml? Another idea: deploy ESB inside Apache Tomcat?? For me it´s not so good because I want to use ESB standalone. Thanks Saludos, Ing. Jorge Infante Osorio. J´Dpto Soluciones SOA. CDAE. Fac. 5. UCI. De: Anjana Fernando [mailto:anj...@wso2.com] Enviado el: domingo, 11 de diciembre de 2011 2:38 Para: Jorge Infante Osorio CC: carbon-...@wso2.org Asunto: Re: XA Transactions Hi Jorge, On Sun, Dec 11, 2011 at 12:53 PM, Jorge Infante Osorio <jorg...@uci.cu> wrote: My bad. I forgot to check that option :-D thanks, it work now. Can I do the same config with the DBReport in ESB? I´m try to figure out how to do a transaction between 3 DBReport mediators. Good to hear it works! .. as for DBReport, I'm afraid you can't use the same configuration, for this, you may have to dig into the Tomcat configurations and create an XA data source there. I haven't personally tested that scenario that much. But we are also planning to add the XA data source support to the data sources component we have, so we can create global XA data sources from there, which can be used by anywhere. Cheers, Anjana. Saludos, Ing. Jorge Infante Osorio. J´Dpto Soluciones SOA. CDAE. Fac. 5. UCI. De: Anjana Fernando [mailto:anj...@wso2.com] Enviado el: domingo, 11 de diciembre de 2011 1:36 Para: Jorge Infante Osorio; carbon-dev Asunto: Re: XA Transactions Hi, For the error you just mentioned, as the error message mentions, distributed transactions must be enabled in the data service to allow usage of XA data sources. This settings is there in the first page of the wizard, where you can check "Enable Distributed Transactions" check box, or else in XML edit, in the initial "data" XML element, you can set the attribute, enableDTP to true, e.g. <data name="transaccion1" enableDTP="true" > ... Cheers, Anjana. -- Lakmali Baminiwatta Software Engineer WSO2, Inc.: http://wso2.com lean.enterprise.middleware mobile: +94 71 2335936 Fin a la injusticia, LIBERTAD AHORA A NUESTROS CINCO COMPATRIOTAS QUE SE ENCUENTRAN INJUSTAMENTE EN PRISIONES DE LOS EEUU! http://www.antiterroristas.cu http://justiciaparaloscinco.wordpress.com _______________________________________________ Carbon-dev mailing list carbon-...@wso2.org http://mail.wso2.org/cgi-bin/mailman/listinfo/carbon-dev -- Prabath Abeysekara Software Engineer WSO2 Inc. Email: praba...@wso2.com Mobile: +94774171471 -- Prabath Abeysekara Software Engineer WSO2 Inc. Email: praba...@wso2.com Mobile: +94774171471 10mo. ANIVERSARIO DE LA CREACION DE LA UNIVERSIDAD DE LAS CIENCIAS INFORMATICAS... CONECTADOS AL FUTURO, CONECTADOS A LA REVOLUCION http://www.uci.cu http://www.facebook.com/universidad.uci http://www.flickr.com/photos/universidad_uci _______________________________________________ Dev mailing list Dev@wso2.org http://wso2.org/cgi-bin/mailman/listinfo/dev