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. > > > > 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 > > > > -- > Anjana Fernando > Senior Software Engineer > WSO2 Inc. | http://wso2.com > lean . enterprise . middleware > > > > 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 > > > > -- > Anjana Fernando > Senior Software Engineer > WSO2 Inc. | http://wso2.com > lean . enterprise . middleware > > > > 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 > -- *Lakmali Baminiwatta * *Software Engineer * *WSO2, Inc.: http://wso2.com* *lean.enterprise.middleware* *mobile: +94 71 2335936* * *
_______________________________________________ Carbon-dev mailing list [email protected] http://mail.wso2.org/cgi-bin/mailman/listinfo/carbon-dev
