Package com.webmethods.portal.bizPolicy.biz.sql

Interface ISQLPolicy

All Superinterfaces:

IBizPolicy, IComponent, IInitializable, ISystemHandler

public interface ISQLPolicy
extends IBizPolicy

ISQLPolicy - Exposes basic functions to operate against SQL database

Method Summary

Modifier and Type	Method	Description
ResultSet	executeQuery(IContext context, String dsn, String query, Object[] params, Object[] macros)	Executes the specified sql query against the specified DSN.

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

executeQuery

ResultSet executeQuery(IContext context,
 String dsn,
 String query,
 Object[] params,
 Object[] macros)
                throws BizException

Executes the specified sql query against the specified DSN.

Parameters:

context - Context state information (current user, etc.).

dsn - DSN against which to execute the query

query - the SQL query to execute

params - 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

Returns:

ResultSet for the query

Throws:

BizException