Hi Guillaume,
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 :
>
I've just spotted the fact that your DS was gone faulty. Well, the exception
you got there is just a warning and that doesn't actually make the
dataservice faulty. In fact, this is fixed for stored procedures in trunk
and 2.6.2 brunch. So, I believe the issue should be somewhere in the dbs
generated by the Carbon Studio. Please do the following modifications to
your faulty dbs and give it a try again.
*Remove the column attribute added as a parameter in the "call-query" tags
within the "operation" named "prc_return_key". and also change the value of
the "name" attribute that comes under the "with-param" tag to "i_email"
(Here I'm using the values u already have in your sample dbs)
<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>
So the configuration may look like the following.
<operation name="prc_return_key">
<call-query href="prc_return_key">
<with-param name="i_email" query-param="i_email"/>
</call-query>
</operation>
Regards,
>
> [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
