[Index]

sql-results-sheet

Writes SQL results to an output stream.

Property Summary

dataOnly	Don't display headings.
name	The name of this component.
output	The output stream to write results to.
to	The next component in a bus.

Example Summary

Example 1

A result sheet for multiple statements.

Property Detail

dataOnly

Configured By	ATTRIBUTE
Access	READ_WRITE
Required	No. Defaults to showing headings.

Don't display headings.

name

Configured By	ATTRIBUTE
Access	READ_WRITE
Required	No.

The name of this component.

output

Configured By	ELEMENT
Access	READ_WRITE
Required	No. Defaults to stdout.

The output stream to write results to.

to

Configured By	ELEMENT
Access	READ_WRITE
Required	No.

The next component in a bus. Set automatically in a bus:bus.

Examples

Example 1

A result sheet for multiple statements.

<oddjob>
  <job>
    <sql>
      <connection>
        <connection driver="org.hsqldb.jdbcDriver" url="jdbc:hsqldb:mem:SQLResultsSheet_Example" username="sa" password=""/>
      </connection>
      <input>
        <buffer>
create table FRUIT(
  TYPE varchar(16),
  VARIETY varchar(16),
  COLOUR varchar(32),
  SIZE double);
insert into FRUIT values ('Apple', 'Cox', 'Red and Green', 7.6);
insert into FRUIT values ('Orange', 'Jaffa', 'Orange', 9.245);

select * from FRUIT;

shutdown;
        </buffer>
      </input>
      <results>
        <sql-results-sheet/>
      </results>
    </sql>
  </job>
</oddjob>

This writes the following to the console:

 [0 rows affected, 16 ms.]

 [1 rows affected, 0 ms.]

 [1 rows affected, 0 ms.]

 TYPE    VARIETY  COLOUR         SIZE
 ------  -------  -------------  -----
 Apple   Cox      Red and Green  7.6
 Orange  Jaffa    Orange         9.245

 [2 rows, 212 ms.]

 [0 rows affected, 0 ms.]