Hi Guillaume, We already have an entry in the public jira created upon this issue at [1]. and we're currently in the middle of fixing it.
[1] https://wso2.org/jira/browse/CARBON-11034 Regards, On Fri, Aug 19, 2011 at 12:37 AM, Guillaume Devianne <gdevia...@gmail.com>wrote: > Hi, > > I have a Data Service in my AS 4.1.0 working fine. > > I removed the Dataservice and created it in Carbon Studio. > > When I deploy on a remote AS 4.1.0, it puts my DS as faulty with the > following error : > > > [2011-08-18 14:39:19,258] WARN > {org.wso2.carbon.dataservices.core.description.query.SQLQuery} - Error in > processing batch query support for query 'prc_return_key' batch query > support is disabled: DS Fault Message: Error in retrieving database metadata > DS Code: UNKNOWN_ERROR > Nested Exception:- > java.sql.SQLException: Operación no válida para el juego de resultados de > sólo reenvío : isLast > > DS Fault Message: Error in retrieving database metadata > DS Code: UNKNOWN_ERROR > Nested Exception:- > java.sql.SQLException: Operación no válida para el juego de resultados de > sólo reenvío : isLast > > at > org.wso2.carbon.dataservices.core.description.query.SQLQuery.calculateBatchQuerySupport(SQLQuery.java:268) > at > org.wso2.carbon.dataservices.core.description.query.SQLQuery.init(SQLQuery.java:176) > at > org.wso2.carbon.dataservices.core.description.query.SQLQuery.<init>(SQLQuery.java:152) > at > org.wso2.carbon.dataservices.core.description.query.QueryFactory.createSQLQuery(QueryFactory.java:301) > at > org.wso2.carbon.dataservices.core.description.query.QueryFactory.createQuery(QueryFactory.java:60) > at > org.wso2.carbon.dataservices.core.DataServiceFactory.createDataService(DataServiceFactory.java:164) > at > org.wso2.carbon.dataservices.core.DBDeployer.createDBService(DBDeployer.java:639) > at > org.wso2.carbon.dataservices.core.DBDeployer.processService(DBDeployer.java:990) > at > org.wso2.carbon.dataservices.core.DBDeployer.deploy(DBDeployer.java:168) > at > org.apache.axis2.deployment.repository.util.DeploymentFileData.deploy(DeploymentFileData.java:136) > at > org.apache.axis2.deployment.DeploymentEngine.doDeploy(DeploymentEngine.java:813) > at > org.apache.axis2.deployment.repository.util.WSInfoList.update(WSInfoList.java:144) > at > org.apache.axis2.deployment.RepositoryListener.update(RepositoryListener.java:371) > at > org.apache.axis2.deployment.RepositoryListener.checkServices(RepositoryListener.java:254) > at > org.apache.axis2.deployment.RepositoryListener.startListener(RepositoryListener.java:365) > at > org.apache.axis2.deployment.scheduler.SchedulerTask.checkRepository(SchedulerTask.java:73) > at > org.apache.axis2.deployment.scheduler.SchedulerTask.run(SchedulerTask.java:94) > at > org.apache.axis2.deployment.scheduler.Scheduler$SchedulerTimerTask.run(Scheduler.java:93) > at java.util.TimerThread.mainLoop(Timer.java:534) > at java.util.TimerThread.run(Timer.java:484) > Caused by: java.sql.SQLException: Operación no válida para el juego de > resultados de sólo reenvÃo : isLast > at > oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112) > at > oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146) > at > oracle.jdbc.driver.OracleResultSetImpl.isLast(OracleResultSetImpl.java:349) > at > org.apache.commons.dbcp.DelegatingResultSet.isLast(DelegatingResultSet.java:355) > at > org.wso2.carbon.dataservices.core.description.query.SQLQuery.getStoredProcFuncProps(SQLQuery.java:228) > at > org.wso2.carbon.dataservices.core.description.query.SQLQuery.calculateBatchQuerySupport(SQLQuery.java:238) > ... 19 more > [2011-08-18 14:39:19,275] INFO > {org.wso2.carbon.core.deployment.DeploymentInterceptor} - Deploying Axis2 > service: CAExistEjec {super-tenan > > > FAULTY DS: > <?xml version="1.0" encoding="UTF-8"?> > <data xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" > xsi:noNamespaceSchemaLocation="http:///org/wso2/carbonstudio/eclipse/ds" > name="CAExistEjec"> > <config id="BDC_SUBTEL_Prod"> > <property > name="org.wso2.ws.dataservice.driver">oracle.jdbc.pool.OracleDataSource</property> > <property name="org.wso2.ws.dataservice.protocol">xxx</property> > <property name="org.wso2.ws.dataservice.user">xx</property> > <property name="org.wso2.ws.dataservice.password">xx</property> > <property name="org.wso2.ws.dataservice.minpoolsize"></property> > <property name="org.wso2.ws.dataservice.maxpoolsize"></property> > <property name="org.wso2.ws.dataservice.validation_query"></property> > </config> > <query id="prc_return_key" useConfig="BDC_SUBTEL_Prod"> > <sql>call prc_return_key(?,?,?)</sql> > <properties> > <property name="org.wso2.ws.dataservice.query_timeout"></property> > <property name="org.wso2.ws.dataservice.fetch_direction"></property> > <property name="org.wso2.ws.dataservice.fetch_size"></property> > <property name="org.wso2.ws.dataservice.max_field_size"></property> > <property name="org.wso2.ws.dataservice.max_rows"></property> > </properties> > <result element="s" rowName="d" outputType="xml"> > <element name="o_llave" column="o_llave" query-param="" > xsdType="xs:string"/> > <element name="o_sistemas" column="o_sistemas" xsdType="xs:string"/> > </result> > <param name="i_email" type="IN" sqlType="STRING" defaultValue="" > paramType="SCALAR"/> > <param name="o_llave" type="OUT" sqlType="STRING" paramType="SCALAR"/> > <param name="o_sistemas" type="OUT" sqlType="STRING" > paramType="SCALAR"/> > </query> > <operation name="prc_return_key"> > <call-query href="prc_return_key"> > <with-param name="prc_return_key" column="i_email" > query-param="i_email"/> > </call-query> > </operation> > </data> > > > WORKING DS (through web GUI) > > <data name="CAExistEjec" enableBatchRequests="false" > enableBoxcarring="false" serviceStatus="active"> > <config id="BDC_SUBTEL_Prod"> > <property > name="org.wso2.ws.dataservice.driver">oracle.jdbc.pool.OracleDataSource</property> > > <property > name="org.wso2.ws.dataservice.protocol">xxxxxxxxxxxx</property> > > <property name="org.wso2.ws.dataservice.user">xx</property> > > <property name="org.wso2.ws.dataservice.password">xx</property> > > <property name="org.wso2.ws.dataservice.minpoolsize"></property> > > <property name="org.wso2.ws.dataservice.maxpoolsize"></property> > > <property name="org.wso2.ws.dataservice.autocommit">false</property> > > </config> > <query id="prc_devuelve_llave" useConfig="BDC_SUBTEL_Prod"> > > <sql>call prc_return_key(?,?,?)</sql> > <result element="s" rowName="d"> > <element name="o_llave" column="o_llave" xsdType="xs:string" /> > > <element name="o_sistemas" column="o_sistemas" xsdType="xs:string" > /> > </result> > <param name="i_email" paramType="SCALAR" sqlType="STRING" type="IN" > ordinal="1" /> > <param name="o_llave" paramType="SCALAR" sqlType="STRING" type="OUT" > ordinal="2" /> > <param name="o_sistemas" paramType="SCALAR" sqlType="STRING" > type="OUT" ordinal="3" /> > </query> > <operation name="prc_return_key"> > <description></description> > <call-query href="prc_return_key"> > <with-param name="i_email" query-param="i_email" /> > > </call-query> > </operation> > </data> > > > Guillaume > > _______________________________________________ > Carbon-dev mailing list > Carbon-dev@wso2.org > http://mail.wso2.org/cgi-bin/mailman/listinfo/carbon-dev > > -- Prabath Abeysekara Software Engineer WSO2 Inc. Email: praba...@wso2.com <harsha...@wso2.com> Mobile: +94774171471 <http://harshana05.blogspot.com/>
_______________________________________________ Carbon-dev mailing list Carbon-dev@wso2.org http://mail.wso2.org/cgi-bin/mailman/listinfo/carbon-dev