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
[email protected]
http://mail.wso2.org/cgi-bin/mailman/listinfo/carbon-dev
