Package com.webmethods.portal.mech.sql

Interface ISQLMechanics

All Superinterfaces:

IComponent, IInitializable, IMechanics, ISystemHandler

public interface ISQLMechanics
extends IMechanics

Method Summary

Modifier and Type	Method	Description
boolean	canAccessDataSource(String dsn, IThingID userID)
void	checkAccessDataSource(String dsn, IThingID userID)
ResultSet	executeQuery(String dsn, String sql, Object[] parameters, Object[] macros)	Execute sql formatted with parameters and macros that return ResultSet

Methods inherited from interface com.webmethods.portal.system.IComponent

getComponentData, getComponentName, getComponentProvider, getURI, isInitialized, setComponentData, setComponentProvider

Methods inherited from interface com.webmethods.portal.system.init.IInitializable

init, shutdown

Method Details

canAccessDataSource

boolean canAccessDataSource(String dsn,
 IThingID userID)
                     throws PortalException

Throws:

PortalException

checkAccessDataSource

void checkAccessDataSource(String dsn,
 IThingID userID)
                    throws PortalException,
PortalAccessException

Throws:

PortalException

PortalAccessException

executeQuery

ResultSet executeQuery(String dsn,
 String sql,
 Object[] parameters,
 Object[] macros)
                throws PortalException

Execute sql formatted with parameters and macros that return ResultSet

Parameters:

sql - sql query to be executed

parameters - is an Object array of input parameters for query. May be null

macros - is an Object array of macros to be used to format original query text. May be null

Throws:

PortalException