list archives . users mailing list
 

Subject: tablename in parameter howto

Date view Thread view Subject view Author view Attachment view

From: Várdai Márk (taszilo@inf.elte.hu)
Date: Jun 11, 2003 23:18

Hello,

I tried request_synch.xml example of ogsa-dai 2.0 and I can't give the
tablename as a paramter. What is wrong? Because I get Error.

Here is my example:
----------
        <request name="requestsynch">
          <documentation>Select with data delivered with the response -
request stored</documentation>

          <parameter name="idname">
                <value name="idvalue">1</value>
          </parameter>

          <sqlQueryStatement name="statement">
<!--Here is the table name-->
            <sqlParameter position="1">SERVERLIST</sqlParameter>
            <sqlParameter position="2" from="idvalue"></sqlParameter>
            <dataResource>myDataResource</dataResource>
                <expression>select * from ? where Id=?</expression>
                <webRowSetStream name="statementresult"/>
          </sqlQueryStatement>

          <deliverToResponse name="d1">
                  <fromLocal from="statementresult"/>
          </deliverToResponse>
        </request>

        <execute name="executerequestsynch" requestName="requestsynch">
        </execute>

--------------------

Error:
AxisFault
 faultCode:
{http://schemas.xmlsoap.org/soap/envelope/}Server.generalException
 faultSubcode:
 faultString:
 faultActor:
 faultNode:
 faultDetail:
        {}uk.org.ogsadai.wsdlR2.faults.GridDataServiceSystemExceptionType:
     <description>&lt;?xml version=&quot;1.0&quot;
encoding=&quot;UTF-8&quot;?&gt;
&lt;gridDataServiceResponse&gt;
    &lt;response name=&quot;requestsynch&quot;&gt;
        &lt;result name=&quot;Engine&quot;&gt;GDS Engine - request
            &amp;quot;requestsynch&amp;quot; was stored
successfully&lt;/result&gt;
    &lt;/response&gt;
    &lt;response name=&quot;executerequestsynch&quot;&gt;
        &lt;result name=&quot;Engine&quot;&gt;statement -
ERROR&lt;/result&gt;
        &lt;result name=&quot;statement&quot;&gt;java.sql.SQLException:
Syntax error or
            access violation, message from server: &amp;quot;You have an
            error in your SQL syntax. Check the manual that corresponds
            to your MySQL server version for the right syntax to use
            near ''SERVERLIST' where Id='1'' at line
1&amp;quot;&lt;/result&gt;
        &lt;result name=&quot;d1&quot;&gt;COMPLETE&lt;/result&gt;
    &lt;/response&gt;
&lt;/gridDataServiceResponse&gt;
</description>

Date view Thread view Subject view Author view Attachment view