org.mule.db.commons.internal.result.row

Class NonStreamingColumnNumberMapRowHandler

java.lang.Object

org.mule.db.commons.internal.result.row.AbstractMapRowHandler

org.mule.db.commons.internal.result.row.NonStreamingColumnNumberMapRowHandler

All Implemented Interfaces:

RowHandler

public class NonStreamingColumnNumberMapRowHandler
extends AbstractMapRowHandler

Maps a row using column numbers as keys instead of column names. This avoids the duplicate column label exception by using column indices. Non-streaming version that loads all data into memory.

Field Summary

Fields inherited from class org.mule.db.commons.internal.result.row.AbstractMapRowHandler

charset, dbConnection

Constructor Summary

Constructors

Constructor and Description
NonStreamingColumnNumberMapRowHandler(DbConnection dbConnection)
NonStreamingColumnNumberMapRowHandler(DbConnection dbConnection, Charset charset)

Method Summary

Modifier and Type	Method and Description
protected String	getColumnKey(ResultSetMetaData metaData, int columnIndex) Determines the key to use for a column.
protected org.mule.runtime.api.metadata.TypedValue<Object>	handleBlobType(Blob value)
protected org.mule.runtime.api.metadata.TypedValue<Object>	handleClobType(Clob value)
protected org.mule.runtime.api.metadata.TypedValue<Object>	handleSqlXmlType(SQLXML value)

Methods inherited from class org.mule.db.commons.internal.result.row.AbstractMapRowHandler

getMuleConsumableValue, process, validateResult

Methods inherited from class java.lang.Object

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

Constructor Detail

NonStreamingColumnNumberMapRowHandler

public NonStreamingColumnNumberMapRowHandler(DbConnection dbConnection)

NonStreamingColumnNumberMapRowHandler

public NonStreamingColumnNumberMapRowHandler(DbConnection dbConnection,
                                             Charset charset)

Method Detail

getColumnKey

protected String getColumnKey(ResultSetMetaData metaData,
                              int columnIndex)
                       throws SQLException

Description copied from class: AbstractMapRowHandler

Determines the key to use for a column. Subclasses can override this to use column names or numbers.

Specified by:

getColumnKey in class AbstractMapRowHandler

Parameters:

metaData - the ResultSetMetaData

columnIndex - the column index (1-based)

Returns:

the key to use for this column

Throws:

SQLException - if an error occurs

handleSqlXmlType

protected org.mule.runtime.api.metadata.TypedValue<Object> handleSqlXmlType(SQLXML value)
                                                                     throws SQLException

Overrides:

handleSqlXmlType in class AbstractMapRowHandler

Throws:

SQLException

handleBlobType

protected org.mule.runtime.api.metadata.TypedValue<Object> handleBlobType(Blob value)
                                                                   throws SQLException

Overrides:

handleBlobType in class AbstractMapRowHandler

Throws:

SQLException

handleClobType

protected org.mule.runtime.api.metadata.TypedValue<Object> handleClobType(Clob value)
                                                                   throws SQLException

Overrides:

handleClobType in class AbstractMapRowHandler

Throws:

SQLException