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. On Sun, Dec 11, 2011 at 11:46 AM, Jorge Infante Osorio <[email protected]>wrote: > Hi Anjana, this is my DS config now: > > <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="user">user</property> > <property name="password">pass</property> > <property name="serverName">127.0.0.1</property> > <property name="portNumber">5432</property> > <property name="databaseName">pruebas</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> > > > I have another error: > > [2011-12-11 00:39:13,866] ERROR > {org.wso2.carbon.dataservices.core.DBDeployer} - The transaccion1.dbs > service, which is not valid, caused {1} > DS Fault Message: Error occured connecting to database using connection > pooling manager > 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: Error occured while creating datasource. > DS Code: UNKNOWN_ERROR > Nested Exception:- > DS Fault Message: Internal XADataSource: XA transaction support must be > enabled to use XADataSources > DS Code: UNKNOWN_ERROR > at > > org.wso2.carbon.dataservices.core.DBCPConnectionManager.<init>(DBCPConnectio > nManager.java:95) > at > > org.wso2.carbon.dataservices.core.DBCPConnectionManager.<init>(DBCPConnectio > nManager.java:81) > at > > org.wso2.carbon.dataservices.core.description.config.RDBMSConfig.<init>(RDBM > SConfig.java:54) > 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: Error occured while creating datasource. > DS Code: UNKNOWN_ERROR > Nested Exception:- > DS Fault Message: Internal XADataSource: XA transaction support must be > enabled to use XADataSources > DS Code: UNKNOWN_ERROR > > > at > > org.wso2.carbon.dataservices.core.DBCPConnectionManager.connectToDB(DBCPConn > ectionManager.java:123) > at > > org.wso2.carbon.dataservices.core.DBCPConnectionManager.<init>(DBCPConnectio > nManager.java:93) > ... 19 more > Caused by: DS Fault Message: Internal XADataSource: XA transaction support > must be enabled to use XADataSources > DS Code: UNKNOWN_ERROR > > at > > org.wso2.carbon.dataservices.core.DBCPConnectionManager.setupDataSource(DBCP > ConnectionManager.java:233) > at > > org.wso2.carbon.dataservices.core.DBCPConnectionManager.connectToDB(DBCPConn > ectionManager.java:121) > ... 20 more > [2011-12-11 00:39:13,866] INFO > {org.apache.axis2.deployment.DeploymentEngine} - > org.apache.axis2.deployment.DeploymentException: The transaccion1.dbs > service, which is not valid, > caused {1} > > > 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 22:41 > Para: Jorge Infante Osorio > CC: [email protected] > Asunto: Re: XA Transactions > > Hi Jorge, > > The root cause here is this, > > 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) > > Which means, the XADataSource property "URL" is not available. That means, > simply, there should be a setter named "setURL" in Postgres XADataSource > implementation. But as I just checked here [1], there's no such thing. > Seems > this is a bug in our wizard, where we auto-populate some well known > properties like "URL", "username" and "password" properties. We've made an > assumption that all XADataSource implementations will contain those three > properties in any possible names like, some will have "user" and another > "username" and so on, we've made the presets like that, but obviously we > got > it wrong with Postgres, where it doesn't really have the URL property in > anyway. So what we have to do is, we have to give the properties: > "serverName", "databaseName", "portNumber" as mentioned here [1], to get > the > similar functionality. Normally you can add them from the XADataSource page > in the wizard, but because of the URL property, you will have to add these > from the XML edit view, and remove the URL property also. > > And please create an issue for this in Carbon JIRA under data services UI > component. > > [1] > > http://jdbc.postgresql.org/development/privateapi/org/postgresql/ds/common/B > aseDataSource.html#setServerName(java.lang.String) > > Cheers, > Anjana. > On Sun, Dec 11, 2011 at 8:45 AM, Jorge Infante Osorio <[email protected]> > wrote: > 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 > > > > -- > 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
_______________________________________________ Carbon-dev mailing list [email protected] http://mail.wso2.org/cgi-bin/mailman/listinfo/carbon-dev
