Versions Compared

Old Version 2

changes.mady.by.user Amita Vadhavkar

Saved on

compared with

New Version 3

changes.mady.by.user Adriano Crestani

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

No Format
<xsd:complexType name="Command">
   <xsd:sequence>
     ....
      <xsd:element  maxOccurs="unbounded" minOccurs="0"
            name="ResultDescriptor"  type="config:ResultDescriptor"/>      
   </xsd:sequence>
   ....
</xsd:complexType>

<xsd:complexType name="ResultDescriptor">
  <xsd:attribute name="columnName" type="xsd:string"/>      
  <xsd:attribute name="tableName" type="xsd:string"/>
  <xsd:attribute name="columnType" type="xsd:string"/>
</xsd:complexType>
...

The following is an example config file that defines a result set shape: :

No Format
<Config xmlns="http:///org.apache.tuscany.das.rdb/config.xsd">  
  <Command name="literal" SQL="Select 99, 'Roosevelt', '1600 Pennsylvania Avenue' from customer" kind="Select">
 	
    <ResultDescriptor columnName="ID" tableName="CUSTOMER"
   
      columnType="commonj.sdo.Long"/>
   		
  <ResultDescriptor columnName="LASTNAME" tableName="CUSTOMER"
 
        columnType="commonj.sdo.String"/>
   		
  <ResultDescriptor columnName="ADDRESS" tableName="CUSTOMER"
  
      columnType="commonj.sdo.String"/>
 	
 </Command>
   
<Table tableName="CUSTOMER"> 
        <Column columnName="ID" converterClassName="org.apache.tuscany.das.rdb.test.mappings.StringToLongConverter"/>
   
</Table>	
</Config>