org.pentaho.platform.plugin.action.sql

Class SQLBaseComponent

java.lang.Object

org.pentaho.platform.engine.core.system.PentahoBase

org.pentaho.platform.engine.services.PentahoMessenger

org.pentaho.platform.engine.services.solution.ComponentBase

org.pentaho.platform.plugin.action.sql.SQLBaseComponent

All Implemented Interfaces:

Serializable, org.pentaho.commons.connection.IDisposable, org.pentaho.platform.api.data.IDataComponent, org.pentaho.platform.api.data.IPreparedComponent, org.pentaho.platform.api.engine.IAuditable, org.pentaho.platform.api.engine.IComponent, org.pentaho.platform.api.engine.ILogger, org.pentaho.platform.api.engine.IParameterResolver

Direct Known Subclasses:

SQLLookupRule

public abstract class SQLBaseComponent
extends org.pentaho.platform.engine.services.solution.ComponentBase
implements org.pentaho.platform.api.data.IDataComponent, org.pentaho.platform.api.data.IPreparedComponent, org.pentaho.platform.api.engine.IParameterResolver

SQLBaseComponent is the base class for SQLExecute and SQLLookupRule. it does the majority of work when interacting with Pentaho's BI Platform, including implementing the necessary component features. It also implements IDataComponent and IPreparedComponent.

See Also:

SQLExecute, SQLLookupRule, Serialized Form

Field Summary

Fields

Modifier and Type	Field and Description
static String	PREPARE_PARAMETER_PREFIX

Fields inherited from class org.pentaho.platform.engine.services.solution.ComponentBase

COMPONENT_EXECUTE_FAIL, MISSING_SESSION

Fields inherited from class org.pentaho.platform.engine.core.system.PentahoBase

EMPTYLOGID, LOGID_MASK1, LOGID_MASK2, LOGID_SEPARATOR

Fields inherited from interface org.pentaho.platform.api.data.IPreparedComponent

PREPARE_LATER_INTER_PREFIX, PREPARE_LATER_PLACEHOLDER, PREPARE_LATER_PREFIX, PREPARED_COMPONENT_NAME, PREPARED_OUTPUT_TYPE

Fields inherited from interface org.pentaho.platform.api.engine.ILogger

ACTIVITY_LOG, DEBUG, ERROR, FATAL, INFO, INSTANCE_LOG, SESSION_LOG, SOLUTION_LOG, TRACE, UNKNOWN, WARN

Constructor Summary

Constructors

Constructor and Description
SQLBaseComponent()

Method Summary

Modifier and Type	Method and Description
void	dispose() dispose of the resultset, and if the owner, dispose of the connection.
void	done() nothing to do in done call from runtime context.
org.pentaho.commons.connection.IPentahoResultSet	doQuery(SQLConnection sqlConnection, String query, boolean forwardOnlyResultset)
org.pentaho.commons.connection.IPentahoResultSet	executePrepared(Map preparedParams) executes a prepared method that returns a result set executePrepared looks up any "PREPARELATER" params in the preparedParams map.
org.pentaho.commons.connection.IPentahoConnection	getDatasourceConnection() attempt to aquire a connection.
abstract org.apache.commons.logging.Log	getLogger()
int	getMaxRows()
String	getQuery()
int	getQueryTimeout()
boolean	getReadOnly()
abstract String	getResultOutputName()
org.pentaho.commons.connection.IPentahoResultSet	getResultSet() returns the result set object
boolean	init() nothing is done in the init function
int	resolveParameter(String template, String parameter, Matcher parameterMatcher, int copyStart, StringBuffer results) This method is called when TemplateUtil.applyTemplate() encounters a parameter.
void	setMaxRows(int value)
void	setQueryTimeout(int timeInSec)
void	setReadOnly(boolean value)
org.pentaho.commons.connection.IPentahoConnection	shareConnection() return this class's connection.
boolean	validateAction() validates the action.
abstract boolean	validateSystemSettings()

Methods inherited from class org.pentaho.platform.engine.services.solution.ComponentBase

createFeedbackParameter, createFeedbackParameter, createNewInstance, execute, getActionDefinition, getActionName, getActionTitle, getComponentDefinition, getComponentDefinition, getId, getInitFailMessage, getInitOk, getInstanceId, getLogId, getObjectName, getProcessId, getResourceAsString, getRuntimeContext, getSession, inputMissingError, outputMissingError, promptNeeded, promptNow, resourceComponentSettingError, resourceMissingError, setActionDefinition, setActionName, setComponentDefinition, setComponentDefinitionMap, setInstanceId, setProcessId, setRuntimeContext, setSession, validate

Methods inherited from class org.pentaho.platform.engine.services.PentahoMessenger

debug, debug, error, error, error, fatal, fatal, getMessages, getUserString, info, info, setMessages, trace, trace, warn, warn

Methods inherited from class org.pentaho.platform.engine.core.system.PentahoBase

genLogIdFromInfo, genLogIdFromInfo, genLogIdFromSession, getLoggingLevel, setLoggingLevel, setLogId

Methods inherited from class java.lang.Object

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

Methods inherited from interface org.pentaho.platform.api.engine.IComponent

execute, getActionDefinition, getActionName, getComponentDefinition, getInstanceId, getMessages, getProcessId, getRuntimeContext, getSession, setActionDefinition, setActionName, setComponentDefinition, setComponentDefinitionMap, setInstanceId, setMessages, setProcessId, setRuntimeContext, setSession, validate

Methods inherited from interface org.pentaho.platform.api.engine.IAuditable

getId, getObjectName

Methods inherited from interface org.pentaho.platform.api.engine.ILogger

debug, debug, error, error, fatal, fatal, getLoggingLevel, info, info, setLoggingLevel, trace, trace, warn, warn

Field Detail

PREPARE_PARAMETER_PREFIX

public static final String PREPARE_PARAMETER_PREFIX

See Also:

Constant Field Values

Constructor Detail

SQLBaseComponent

public SQLBaseComponent()

Method Detail

validateSystemSettings

public abstract boolean validateSystemSettings()

Specified by:

validateSystemSettings in class org.pentaho.platform.engine.services.solution.ComponentBase

getResultOutputName

public abstract String getResultOutputName()

getLogger

public abstract org.apache.commons.logging.Log getLogger()

Specified by:

getLogger in class org.pentaho.platform.engine.core.system.PentahoBase

getResultSet

public org.pentaho.commons.connection.IPentahoResultSet getResultSet()

returns the result set object

Specified by:

getResultSet in interface org.pentaho.platform.api.data.IDataComponent

Returns:

pentaho result set

validateAction

public boolean validateAction()

validates the action. checks to verify inputs are available to execute - verify query is available - verify connection is available, via jndi, connection string, or prepared component - verify output is specified

Specified by:

validateAction in class org.pentaho.platform.engine.services.solution.ComponentBase

done

public void done()

nothing to do in done call from runtime context.

Specified by:

done in interface org.pentaho.platform.api.engine.IComponent

Specified by:

done in class org.pentaho.platform.engine.services.solution.ComponentBase

executePrepared

public org.pentaho.commons.connection.IPentahoResultSet executePrepared(Map preparedParams)

executes a prepared method that returns a result set executePrepared looks up any "PREPARELATER" params in the preparedParams map.

Specified by:

executePrepared in interface org.pentaho.platform.api.data.IPreparedComponent

Parameters:

preparedParams - a map of possible parameters.

Returns:

result set

doQuery

public org.pentaho.commons.connection.IPentahoResultSet doQuery(SQLConnection sqlConnection,
                                                                String query,
                                                                boolean forwardOnlyResultset)
                                                         throws Exception

Throws:

Exception

dispose

public void dispose()

dispose of the resultset, and if the owner, dispose of the connection.

Specified by:

dispose in interface org.pentaho.commons.connection.IDisposable

Specified by:

dispose in interface org.pentaho.platform.api.data.IDataComponent

Specified by:

dispose in interface org.pentaho.platform.api.data.IPreparedComponent

resolveParameter

public int resolveParameter(String template,
                            String parameter,
                            Matcher parameterMatcher,
                            int copyStart,
                            StringBuffer results)

This method is called when TemplateUtil.applyTemplate() encounters a parameter. TemplateUtil.applyTemplate is called when someone makes a call to applyInputsToFormat() In this class it is called in the above "runQuery()" method.

Specified by:

resolveParameter in interface org.pentaho.platform.api.engine.IParameterResolver

Overrides:

resolveParameter in class org.pentaho.platform.engine.services.solution.ComponentBase

Parameters:

template - the source string

parameter - the parameter value

parameterMatcher - the regex parameter matcher

copyStart - the start of the copy

results - the output result

Returns:

the next copystart

getDatasourceConnection

public org.pentaho.commons.connection.IPentahoConnection getDatasourceConnection()

attempt to aquire a connection. if connection isn't available, wait a certain period of time before trying again.

Returns:

connection

shareConnection

public org.pentaho.commons.connection.IPentahoConnection shareConnection()

return this class's connection. This implements the IPreparedComponent interface, which may share its connection with others.

Specified by:

shareConnection in interface org.pentaho.platform.api.data.IPreparedComponent

Returns:

connection object

init

public boolean init()

nothing is done in the init function

Specified by:

init in interface org.pentaho.platform.api.engine.IComponent

Specified by:

init in class org.pentaho.platform.engine.services.solution.ComponentBase

Returns:

true always

getQueryTimeout

public int getQueryTimeout()

setQueryTimeout

public void setQueryTimeout(int timeInSec)

getMaxRows

public int getMaxRows()

setMaxRows

public void setMaxRows(int value)

getQuery

public String getQuery()

setReadOnly

public void setReadOnly(boolean value)

getReadOnly

public boolean getReadOnly()