list archives . users mailing list
 

Subject: DML Statements

Date view Thread view Subject view Author view Attachment view

From: Fabricio B. Teixeira (fabriciobt@yahoo.com.br)
Date: Apr 01, 2003 14:55

We´re trying to use a GDS to insert, delete and update
a table in mySQL and we observed that the statement
was processed by the Database but the GDS stopped the
execution. The file in this messages shows de error
message and the GDS-Script we´re executing. Could you
tell us what we are doing wrong?

Fabricio, Vivacqua.

_______________________________________________________________________
Yahoo! Mail
O melhor e-mail gratuito da internet: 6MB de espaço, antivírus, acesso POP3, filtro contra spam.
http://br.mail.yahoo.com/

THIS IS THE ERROR MESSAGE:

         faultCode: {http://xml.apache.org/axis/}Server.generalException faultString: faultActor: null faultDetail: uk.org.ogsadai.wsdl.GridDataServiceSystemException: <description>Exception reading in script or writing out results: null</description> exceptionName: uk.org.ogsadai.wsdl.GridDataServiceSystemException stackTrace: AxisFault faultCode: {http://xml.apache.org/axis/}Server.generalException faultString: faultActor: null faultDetail: exceptionName: uk.org.ogsadai.wsdl.GridDataServiceSystemException

THIS IS THE GDS-SCRIPT WE´RE TRYING TO EXECUTE:

<?xml version="1.0" encoding="UTF-8"?>
<!-- (c) International Business Machines Corporation, 2002, 2003. (c) University of Edinburgh 2002, 2003.-->
<!-- See OGSA-DAI-Licence.txt for licencing information.-->
<GridDataServiceScript xmlns="http://ogsadai.org.uk/P2R1/schemas/gdss">

 <Header>
    <ScriptName>Example 2</ScriptName>
    <Version>
            <Config>config</Config>
            <ScriptEnvironment>environment</ScriptEnvironment>
    </Version>
    <Originator>GSR of Originator</Originator>
  </Header>
  <Body>
          <Documentation>Update with data delivered in the script</Documentation>
        <Statement name="xyz" dataResource="MyDataResource">
                INSERT INTO teste1 VALUES(4, 'GG');
        </Statement>
        <Delivery name="delivery">
                <Mechanism type="bulk"/>
                <Mode type="full"/>
                <From>xyz</From>
                <To>response</To>
        </Delivery>
        <Execute name="execute">xyz</Execute>
  </Body>
</GridDataServiceScript>

Date view Thread view Subject view Author view Attachment view