Hi Lakmali, any advance on this? Saludos, Ing. Jorge Infante Osorio. J´Dpto Soluciones SOA. CDAE. Fac. 5. UCI.
De: [email protected] [mailto:[email protected]] En nombre de Lakmali Baminiwatta Enviado el: viernes, 16 de diciembre de 2011 4:51 Para: [email protected] 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 <[email protected]> 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:[email protected]] Enviado el: lunes, 12 de diciembre de 2011 4:22 Para: Jorge Infante Osorio CC: [email protected] 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 <[email protected]> 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:[email protected]] Enviado el: domingo, 11 de diciembre de 2011 2:38 Para: Jorge Infante Osorio CC: [email protected] Asunto: Re: XA Transactions Hi Jorge, On Sun, Dec 11, 2011 at 12:53 PM, Jorge Infante Osorio <[email protected]> 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:[email protected]] 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 [email protected] http://mail.wso2.org/cgi-bin/mailman/listinfo/carbon-dev
