Package net.simplace.client.pipe.processors

Class HSSFWorkbook2DBProcessor

java.lang.Object

net.simplace.pipe.control.FWProcessor

net.simplace.client.pipe.processors.HSSFWorkbook2DBProcessor

Direct Known Subclasses:

JXLWorkbook2DBProcessor

public class HSSFWorkbook2DBProcessor
extends FWProcessor

This processor reads an XLS document into a HSSF workbook object. Example configuration: XLSdata jdbc:hsqldb:mem:test org.hsqldb.jdbcDrive sa initial//optional someKey

Parameter	Description
jdbc.connectionpool	name of the connectionpool - if exisiting in Pipeline url and driver are ignored
jdbc.driver	(optional) JDBC driver used for the communication to the database. Default: org.hsqldb.jdbcDriver
jdbc.url	(optional)URL for the given JDBC driver. Default: jdbc:hsqldb:mem
resultParamKey	Output parameter key where the connection is stored in
readsheet	(optional) default to initial

"readFile" can be a filename or a parameter containing a filename. Note: The value of "readFile" may not be "readFile"! "readSheet" can be a sheetname or excel jump marker (f.e. "data1!A1" for sheet "data1", column "A", row "1"), it's only "data1" used to open the sheet, the rest is ignored

Author:

Andreas Enders

Field Summary

Fields

Modifier and Type	Field	Description
protected String	iConnectionPoolName
protected String	iJdbcDriver
protected String	iJdbcUrl
protected boolean	iPrevAutoCommit
protected File	iSourceFile
protected static final String	JDBC_DRIVER_DEFAULT
protected static final String	JDBC_DRIVER_KEY	Instance for Category.
protected static final String	JDBC_URL_DEFAULT
protected static final String	JDBC_URL_KEY
protected static final String	POOL_NAME_DEFAULT
protected static final String	POOL_NAME_KEY

Fields inherited from class net.simplace.pipe.control.FWProcessor

iAllreadyLoopedCount, iContainer, iInObservable, iObservable, iProgressTasks

Constructor Summary

Constructors

Constructor	Description
HSSFWorkbook2DBProcessor()

Method Summary

Modifier and Type	Method	Description
boolean	checkInParameterMap()	Checks whether the in-channel contains all required parameters.
protected void	deleteTable(Connection tConnection, String tSheetName)
protected Connection	getConnection(String aOutParameter)
protected boolean	process()	Must be overridden to implement concrete pipe procedure.

Methods inherited from class net.simplace.pipe.control.FWProcessor

checkOutParameterMap, clone, containsParameter, createProcessor, createProcessor, fireTaskEvent, getAllStringInParameters, getConfiguration, getInitialParameters, getInParameter, getInParameter, getInParameters, getNewProgressTask, getOutParameter, getOutParameterKeys, getPipeLine, getProgressTask, getStringInParameter, getStringInParameter, getSystemID, hasConfiguration, isEndOfPipe, pipe, removeOutParameter, setConfiguration, setEndOfPipeFlag, setInitialParameters, setInParameterMap, setLoopedCount, setOutParameter, setStateOfTask, setStateProgressing, toXML

Methods inherited from class java.lang.Object

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

Field Details

JDBC_DRIVER_KEY

protected static final String JDBC_DRIVER_KEY

Instance for Category.

See Also:

• Constant Field Values

JDBC_URL_KEY

protected static final String JDBC_URL_KEY

See Also:

• Constant Field Values

POOL_NAME_KEY

protected static final String POOL_NAME_KEY

See Also:

• Constant Field Values

JDBC_DRIVER_DEFAULT

protected static final String JDBC_DRIVER_DEFAULT

See Also:

• Constant Field Values

JDBC_URL_DEFAULT

protected static final String JDBC_URL_DEFAULT

See Also:

• Constant Field Values

POOL_NAME_DEFAULT

protected static final String POOL_NAME_DEFAULT

See Also:

• Constant Field Values

iSourceFile

protected File iSourceFile

iJdbcDriver

protected String iJdbcDriver

iJdbcUrl

protected String iJdbcUrl

iConnectionPoolName

protected String iConnectionPoolName

iPrevAutoCommit

protected boolean iPrevAutoCommit

Constructor Details

HSSFWorkbook2DBProcessor

public HSSFWorkbook2DBProcessor()

Method Details

process

protected boolean process()
                   throws PipeLineException

Description copied from class: FWProcessor

Must be overridden to implement concrete pipe procedure.

Specified by:

process in class FWProcessor

Returns:

success

Throws:

PipeLineException

getConnection

protected Connection getConnection(String aOutParameter)
                            throws PipeLineException

Throws:

PipeLineException

checkInParameterMap

public boolean checkInParameterMap()

Checks whether the in-channel contains all required parameters.

Overrides:

checkInParameterMap in class FWProcessor

Returns:

true if not overridden by implementations

deleteTable

protected void deleteTable(Connection tConnection,
 String tSheetName)

Parameters:

tConnection -

tSheetName -