org.oddjob.sql
Class SQLResultsSheet

java.lang.Object
  org.oddjob.sql.SQLResultsSheet

All Implemented Interfaces:

ArooaSessionAware, BusAware, Destination<Object>, SQLResultsProcessor

public class SQLResultsSheet
extends Object
implements SQLResultsProcessor, ArooaSessionAware, BusAware

Description

Writes SQL results to an output stream.

Example

A result sheet for multiple statements.

<oddjob>
	<job>
        <sql>
           	<connection>
	            <connection driver="org.hsqldb.jdbcDriver" url="jdbc:hsqldb:mem:test" 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.]
 
 

Author:

rob

Constructor Summary

SQLResultsSheet()

Method Summary

void	accept(Object bean)
OutputStream	getOutput()
boolean	isDataOnly()
void	setArooaSession(ArooaSession session)
void	setBus(BeanBus bus)
void	setDataOnly(boolean dataOnly)
void	setOutput(OutputStream output)

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

SQLResultsSheet

public SQLResultsSheet()

Method Detail

setArooaSession

public void setArooaSession(ArooaSession session)

Specified by:

setArooaSession in interface ArooaSessionAware

accept

public void accept(Object bean)
            throws BadBeanException

Specified by:

accept in interface Destination<Object>

Throws:

BadBeanException

getOutput

public OutputStream getOutput()

setOutput

public void setOutput(OutputStream output)

isDataOnly

public boolean isDataOnly()

setDataOnly

public void setDataOnly(boolean dataOnly)

setBus

public void setBus(BeanBus bus)

Specified by:

setBus in interface BusAware