Package de.businesscode.bcdui.upload.data.steps

Class UploadToRowCol

java.lang.Object

de.businesscode.bcdui.upload.data.steps.UploadToRowCol

All Implemented Interfaces:

IUploadStep

public class UploadToRowCol
extends Object
implements IUploadStep

Base class for inserting a file available as BLOB column- and cell wise to bcd_dataupload_rowcol

Field Summary

Fields

Modifier and Type	Field	Description
static final int	NON_DATA_COLUMNS
static String	STEP_ID
protected final UploadControl	uc
protected final String	uploadId
protected final String	userId

Constructor Summary

Constructors

Constructor	Description
UploadToRowCol(UploadControl uc, String userId)	Open the file with the given uploaId, split it into columns and write it to bcd_dataupload_staging We remove any previous data for uploadId from bcd_dataupload_rowcol

Method Summary

Modifier and Type	Method	Description
void	endFile()	Data fully parsed
void	endLine()	Ends a line, adds possible missing trailing cells
void	nextCell(String value)	Expects consecutive cells, null is allowed for value
void	process()	Parse the file in blob an load it cell-wise to bcd_dataupload_rowcol
void	startLine()	Starts a new line

Methods inherited from class java.lang.Object

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

Methods inherited from interface de.businesscode.bcdui.upload.data.steps.IUploadStep

setParams

Field Details

STEP_ID

public static String STEP_ID

NON_DATA_COLUMNS

public static final int NON_DATA_COLUMNS

See Also:

• Constant Field Values

uc

protected final UploadControl uc

uploadId

protected final String uploadId

userId

protected final String userId

Constructor Details

UploadToRowCol

public UploadToRowCol(UploadControl uc,
 String userId)
               throws Exception

Open the file with the given uploaId, split it into columns and write it to bcd_dataupload_staging We remove any previous data for uploadId from bcd_dataupload_rowcol

Parameters:

uc - UploadControl

Throws:

Exception

Method Details

process

public void process()
             throws UploadException,
SQLException

Parse the file in blob an load it cell-wise to bcd_dataupload_rowcol

Specified by:

process in interface IUploadStep

Throws:

Exception

UploadException

SQLException

nextCell

public void nextCell(String value)
              throws SQLException

Expects consecutive cells, null is allowed for value

Parameters:

value -

Throws:

SQLException

startLine

public void startLine()
               throws SQLException

Starts a new line

Throws:

SQLException

endLine

public void endLine()
             throws Exception

Ends a line, adds possible missing trailing cells

Throws:

Exception

endFile

public void endFile()
             throws Exception

Data fully parsed

Throws:

SQLException

Exception