well, my impression is that CS creates an XML that "triggers" that error.
still guessing... that some param passed in that xml is diferent than the ones in the gui generated dbs. Guillaume Devianne 08-428.1651 On Thu, Aug 18, 2011 at 9:56 PM, Prabath Abeysekera <[email protected]>wrote: > > > On Fri, Aug 19, 2011 at 7:20 AM, Prabath Abeysekera <[email protected]>wrote: > >> 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 <[email protected] >> > 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. >>> >> > Also, please note that this occurs while calling stored procedures created > in oracle via dataservice layer, due to some recently made change into the > stored procedure handling functionality. Thus, the reported issue doesn't > have any relation with the 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 >>> [email protected] >>> http://mail.wso2.org/cgi-bin/mailman/listinfo/carbon-dev >>> >>> >> >> >> -- >> Prabath Abeysekara >> Software Engineer >> WSO2 Inc. >> Email: [email protected] <[email protected]> >> Mobile: +94774171471 >> >> <http://harshana05.blogspot.com/> >> >> > > > -- > Prabath Abeysekara > Software Engineer > WSO2 Inc. > Email: [email protected] <[email protected]> > Mobile: +94774171471 > > <http://harshana05.blogspot.com/> > > > _______________________________________________ > Carbon-dev mailing list > [email protected] > http://mail.wso2.org/cgi-bin/mailman/listinfo/carbon-dev > >
_______________________________________________ Carbon-dev mailing list [email protected] http://mail.wso2.org/cgi-bin/mailman/listinfo/carbon-dev
