Hi Anjana, thanks. Tool: AS 4.1.2.
I follow your suggestion and create a DS with the postgreSQL driver postgresql-9.0-801.jdbc4.jar , with this simple configuration: <data name="transaccion1"> <config id="rr"> <property name="org.wso2.ws.dataservice.xa_datasource_class">org.postgresql.xa.PGXADat aSource</property> <property name="org.wso2.ws.dataservice.xa_datasource_properties"> <property name="URL">jdbc:postgresql://127.0.0.1:5432/pruebas</property> <property name="User">user</property> <property name="Password">pass</property> </property> </config> <query id="selecALL" useConfig="rr"> <sql>select * from estudiantes</sql> <result element="estudiantes" rowName="estudiante" defaultNamespace="http://estudiantes.cdae.uci.cu";> <element name="nombre" column="nombre" xsdType="xs:string" /> </result> </query> <operation name="SeleccionarTodos"> <call-query href="selecALL" /> </operation> </data> Is the AS I see this error after deploy the DS in the UI console: DS Fault Message: Cannot create XADataSource instance using the class: org.postgresql.xa.PGXADataSource DS Code: UNKNOWN_ERROR Source DataService:- Name: transaccion1 Location: \transaccion1.dbs Description: N/A Default Namespace: http://ws.wso2.org/dataservice Nested Exception:- DSFault Message: Setter method for property 'URL' cannot be found DS Code: UNKNOWN_ERROR at org.wso2.carbon.dataservices.core.description.xa.XADataSourceInfo.initXA(XAD ataSourceInfo.java:59) at org.wso2.carbon.dataservices.core.description.xa.XADataSourceInfo.(XADataSou rceInfo.java:50) at org.wso2.carbon.dataservices.core.description.config.RDBMSConfig.createXADat aSourceInfo(RDBMSConfig.java:83) at org.wso2.carbon.dataservices.core.description.config.RDBMSConfig.(RDBMSConfi g.java:49) at org.wso2.carbon.dataservices.core.description.config.ConfigFactory.getRDBMSC onfig(ConfigFactory.java:74) at org.wso2.carbon.dataservices.core.description.config.ConfigFactory.createCon fig(ConfigFactory.java:52) at org.wso2.carbon.dataservices.core.DataServiceFactory.createDataService(DataS erviceFactory.java:151) at org.wso2.carbon.dataservices.core.DBDeployer.createDBService(DBDeployer.java :717) at org.wso2.carbon.dataservices.core.DBDeployer.processService(DBDeployer.java: 1068) at org.wso2.carbon.dataservices.core.DBDeployer.deploy(DBDeployer.java:175) at org.apache.axis2.deployment.repository.util.DeploymentFileData.deploy(Deploy mentFileData.java:136) at org.apache.axis2.deployment.DeploymentEngine.doDeploy(DeploymentEngine.java: 813) at org.apache.axis2.deployment.repository.util.WSInfoList.update(WSInfoList.jav a:144) at org.apache.axis2.deployment.RepositoryListener.update(RepositoryListener.jav a:371) at org.apache.axis2.deployment.RepositoryListener.checkServices(RepositoryListe ner.java:254) at org.apache.axis2.deployment.RepositoryListener.startListener(RepositoryListe ner.java:365) at org.apache.axis2.deployment.scheduler.SchedulerTask.checkRepository(Schedule rTask.java:73) at org.apache.axis2.deployment.scheduler.SchedulerTask.run(SchedulerTask.java:9 4) at org.apache.axis2.deployment.scheduler.Scheduler$SchedulerTimerTask.run(Sched uler.java:93) at java.util.TimerThread.mainLoop(Timer.java:512) at java.util.TimerThread.run(Timer.java:462) Caused by: DS Fault Message: Setter method for property 'URL' cannot be found DS Code: UNKNOWN_ERROR at org.wso2.carbon.dataservices.core.description.xa.XADataSourceInfo.assignProp s(XADataSourceInfo.java:70) at org.wso2.carbon.dataservices.core.description.xa.XADataSourceInfo.initXA(XAD ataSourceInfo.java:57) ... 20 more In the AS console I have this: [2011-12-10 11:44:58,294] INFO {org.apache.axis2.deployment.DeploymentEngine} -org.apache.axis2.deployment.DeploymentException: The transaccion1.dbs service, which is not valid, caused {1} [2011-12-10 11:48:38,232] ERROR {org.wso2.carbon.dataservices.core.DBDeployer} - The transaccion1.dbs service, which is not valid, caused {1} DS Fault Message: Cannot create XADataSource instance using the class: org.postgresql.xa.PGXADataSource DS Code: UNKNOWN_ERROR Source Data Service:- Name: transaccion1 Location: \transaccion1.dbs Description: N/A Default Namespace: http://ws.wso2.org/dataservice Nested Exception:- DS Fault Message: Setter method for property 'URL' cannot be found DS Code: UNKNOWN_ERROR At org.wso2.carbon.dataservices.core.description.xa.XADataSourceInfo.initXA(XAD ataSourceInfo.java:59) at org.wso2.carbon.dataservices.core.description.xa.XADataSourceInfo.<init>(XAD ataSourceInfo.java:50) at org.wso2.carbon.dataservices.core.description.config.RDBMSConfig.createXADat aSourceInfo(RDBMSConfig.java:83) at org.wso2.carbon.dataservices.core.description.config.RDBMSConfig.<init>(RDBM SConfig.java:49) at org.wso2.carbon.dataservices.core.description.config.ConfigFactory.getRDBMSC onfig(ConfigFactory.java:74) at org.wso2.carbon.dataservices.core.description.config.ConfigFactory.createCon fig(ConfigFactory.java:52) at org.wso2.carbon.dataservices.core.DataServiceFactory.createDataService(DataS erviceFactory.java:151) at org.wso2.carbon.dataservices.core.DBDeployer.createDBService(DBDeployer.java :717) at org.wso2.carbon.dataservices.core.DBDeployer.processService(DBDeployer.java: 1068) at org.wso2.carbon.dataservices.core.DBDeployer.deploy(DBDeployer.java:175) at org.apache.axis2.deployment.repository.util.DeploymentFileData.deploy(Deploy mentFileData.java:136) at org.apache.axis2.deployment.DeploymentEngine.doDeploy(DeploymentEngine.java: 813) at org.apache.axis2.deployment.repository.util.WSInfoList.update(WSInfoList.jav a:144) at org.apache.axis2.deployment.RepositoryListener.update(RepositoryListener.jav a:371) at org.apache.axis2.deployment.RepositoryListener.checkServices(RepositoryListe ner.java:254) at org.apache.axis2.deployment.RepositoryListener.startListener(RepositoryListe ner.java:365) at org.apache.axis2.deployment.scheduler.SchedulerTask.checkRepository(Schedule rTask.java:73) at org.apache.axis2.deployment.scheduler.SchedulerTask.run(SchedulerTask.java:9 4) at org.apache.axis2.deployment.scheduler.Scheduler$SchedulerTimerTask.run(Sched uler.java:93) at java.util.TimerThread.mainLoop(Timer.java:512) at java.util.TimerThread.run(Timer.java:462) Caused by: DS Fault Message: Setter method for property 'URL' cannot be found DS Code: UNKNOWN_ERROR At org.wso2.carbon.dataservices.core.description.xa.XADataSourceInfo.assignProp s(XADataSourceInfo.java:70) at org.wso2.carbon.dataservices.core.description.xa.XADataSourceInfo.initXA(XAD ataSourceInfo.java:57) ... 20 more Any idea? Saludos, Ing. Jorge Infante Osorio. J´Dpto Soluciones SOA. CDAE. Fac. 5. UCI. De: Anjana Fernando [mailto:[email protected]] Enviado el: sábado, 10 de diciembre de 2011 7:17 Para: Jorge Infante Osorio Asunto: Re: XA Transactions Hi Jorge, You have to create the XADataSources from DSS. There in the data sources page, you can select the type a XA data source and create it. Cheers, Anjana. 2011/12/10 Jorge Infante Osorio <[email protected]> Hi Anjana. About your post: XA Transactions with Apache DBCP Where I need to put the XADataSource in carbon framework? Can you provide me an example of this config? Thanks, Saludos, Ing. Jorge Infante Osorio. J´Dpto Soluciones SOA. CDAE. Fac. 5. UCI. -- 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
