org.xmlecho.palomar.rdbms
Interface RDBMSService

public interface RDBMSService

Interface for RDBMS service classes, which accepts a user entered sql statement against a specified data source and returns an xml stream whose tags are the column names and whose values are the column values.

Field Summary

static int	DB_VENDOR_DB2
static int	DB_VENDOR_INFORMIX
static int	DB_VENDOR_MYSQL
static int	DB_VENDOR_ORACLE
static int	DB_VENDOR_SQLSERVER
static int	DB_VENDOR_SYBASE
static java.lang.String	MODE_ATTRIBUTE
static java.lang.String	MODE_COLNAME
static java.lang.String	MODE_ELEMENT
static java.lang.String	TYPE_MULTIPLE
static java.lang.String	TYPE_SELECT
static java.lang.String	TYPE_SHOW_PROCEDURES
static java.lang.String	TYPE_SHOW_TABLES
static java.lang.String	TYPE_SHOW_VIEWS
static java.lang.String	TYPE_STOR_PROC
static java.lang.String	TYPE_UPDATE

Method Summary

void

genXmlFromSql(org.xml.sax.ContentHandler target, java.lang.String dbName, java.lang.String rdbRequestMethod, Query[] queries, java.lang.String outputMode, int skipRows, int countRows, int timeout) Runs one or more SQL statement against a data source and returns an xml stream representing the results.

Field Detail

TYPE_SELECT

public static final java.lang.String TYPE_SELECT

See Also:

Constant Field Values

TYPE_UPDATE

public static final java.lang.String TYPE_UPDATE

See Also:

Constant Field Values

TYPE_STOR_PROC

public static final java.lang.String TYPE_STOR_PROC

See Also:

Constant Field Values

TYPE_SHOW_TABLES

public static final java.lang.String TYPE_SHOW_TABLES

See Also:

Constant Field Values

TYPE_SHOW_VIEWS

public static final java.lang.String TYPE_SHOW_VIEWS

See Also:

Constant Field Values

TYPE_SHOW_PROCEDURES

public static final java.lang.String TYPE_SHOW_PROCEDURES

See Also:

Constant Field Values

TYPE_MULTIPLE

public static final java.lang.String TYPE_MULTIPLE

See Also:

Constant Field Values

MODE_ATTRIBUTE

public static final java.lang.String MODE_ATTRIBUTE

See Also:

Constant Field Values

MODE_ELEMENT

public static final java.lang.String MODE_ELEMENT

See Also:

Constant Field Values

MODE_COLNAME

public static final java.lang.String MODE_COLNAME

See Also:

Constant Field Values

DB_VENDOR_MYSQL

public static final int DB_VENDOR_MYSQL

See Also:

Constant Field Values

DB_VENDOR_ORACLE

public static final int DB_VENDOR_ORACLE

See Also:

Constant Field Values

DB_VENDOR_SQLSERVER

public static final int DB_VENDOR_SQLSERVER

See Also:

Constant Field Values

DB_VENDOR_SYBASE

public static final int DB_VENDOR_SYBASE

See Also:

Constant Field Values

DB_VENDOR_INFORMIX

public static final int DB_VENDOR_INFORMIX

See Also:

Constant Field Values

DB_VENDOR_DB2

public static final int DB_VENDOR_DB2

See Also:

Constant Field Values

Method Detail

genXmlFromSql

public void genXmlFromSql(org.xml.sax.ContentHandler target,
                          java.lang.String dbName,
                          java.lang.String rdbRequestMethod,
                          Query[] queries,
                          java.lang.String outputMode,
                          int skipRows,
                          int countRows,
                          int timeout)
                   throws RDBMSException

Runs one or more SQL statement against a data source and returns an xml stream representing the results.

Parameters:

target - a SAX event sink, to which the XML stream is sent.

dbName - name of the data source (see connection pool).

rdbRequestMethod - "SELECT", "UPDATE", "STOR_PROC" if the sql statement is a select, update/insert/delete or name of the stored procedure to be executed respectively.

queries - one or more sql statements to execute

outputMode - "ATTRIBUTE", "ELEMENT", "COLNAME" for different output formats

skipRows - number of rows from result set to skip over

countRows - limit on number of rows to return

timeout - The maximum number of milliseconds to wait for a response.

Returns:

the xml stream

Throws:

RDBMSException