Versions Compared

Old Version 5

changes.mady.by.user Luciano Resende

Saved on

compared with

New Version Current

changes.mady.by.user Luciano Resende

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Migrated to Confluence 5.3

Explicit ResultSet shape definition

The RDB DAS provides the ability to specify format(shape) of the ResultSet. This is necessary when the JDBC driver in use does not provide adequate support for ResultSetMetaData. Also, we expect that specifying the result set shape will increase the performance. The following is the provision in RDB DAS config to specify result set shape:

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>