On Fri, Aug 19, 2011 at 7:33 AM, Guillaume Devianne <[email protected]>wrote:
> > well, my impression is that CS creates an XML that "triggers" that error. > > Looking into it. > 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 > > -- 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
