com.wm.app.tn.db
Class QueryResult

java.lang.Object
  com.wm.app.tn.db.QueryResult

All Implemented Interfaces:

java.lang.Runnable

public class QueryResult
extends java.lang.Object
implements java.lang.Runnable

Field Summary

static java.lang.String	PROP_DEBUG
long	totalRows

Constructor Summary

QueryResult()

QueryResult(java.sql.PreparedStatement preparedStatement, java.lang.String[] keys, boolean paging, int page_sz, int maxR, int qryT, int threshold, java.lang.String queryId, boolean readUnCommitted)

QueryResult(java.lang.String sql, java.lang.String[] keys, boolean paging, int page_sz, int maxR, int qryT, int threshold, java.lang.String queryId, boolean readUnCommitted)

Method Summary

static java.util.Vector	addError(java.lang.String rPath, EXMLException e)
static java.util.Vector	addError(java.lang.String rPath, java.lang.Throwable t)
static int	findLastPageNumber(java.lang.String repoPath)
static com.wm.app.tn.cache.ICache	getCache()
static boolean	getDebug()
static java.util.Vector	getErrors(java.lang.String rPath)
static com.wm.data.IData	getPage(java.lang.String repoPath, int pageNum)
static int	getPagesRead(java.lang.String rPath)
static long	getRowsRead(java.lang.String rPath)
static int	getThresPages(java.lang.String rPath)
static int	getTotalPages(java.lang.String rPath)
static long	getTotalRows(java.lang.String rPath)
static boolean	isQueryCancelled(java.lang.String rPath)
static boolean	isThreadRunning(java.lang.String rPath)
static int	removeAllQueryResults()
void	run()
static com.wm.data.IData	RunQuery(java.sql.PreparedStatement preparedStatement, java.lang.String[] keys, int pageSize, int maxR, int qryT, int threshold, java.lang.String queryId, boolean readUnCommitted)
static com.wm.data.IData	RunQuery(java.lang.String sql, java.lang.String[] keys, int pageSize)
static com.wm.data.IData	RunQuery(java.lang.String sql, java.lang.String[] keys, int pageSize, int maxR, int qryT, int threshold, java.lang.String queryId)
static com.wm.data.IData	RunQuery(java.lang.String sql, java.lang.String[] keys, int pageSize, int maxR, int qryT, int threshold, java.lang.String queryId, boolean readUnCommitted)
static void	setDebug(java.lang.String flag)
static void	setQueryCancelled(java.lang.String rPath)
static void	unregister(java.lang.String repoPath)

Methods inherited from class java.lang.Object

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

Field Detail

PROP_DEBUG

public static final java.lang.String PROP_DEBUG

See Also:

Constant Field Values

totalRows

public long totalRows

Constructor Detail

QueryResult

public QueryResult()

QueryResult

public QueryResult(java.lang.String sql,
                   java.lang.String[] keys,
                   boolean paging,
                   int page_sz,
                   int maxR,
                   int qryT,
                   int threshold,
                   java.lang.String queryId,
                   boolean readUnCommitted)
            throws java.sql.SQLException,
                   com.wm.app.b2b.server.ServiceException

Throws:

java.sql.SQLException

com.wm.app.b2b.server.ServiceException

QueryResult

public QueryResult(java.sql.PreparedStatement preparedStatement,
                   java.lang.String[] keys,
                   boolean paging,
                   int page_sz,
                   int maxR,
                   int qryT,
                   int threshold,
                   java.lang.String queryId,
                   boolean readUnCommitted)
            throws com.wm.app.b2b.server.ServiceException,
                   java.sql.SQLException

Throws:

com.wm.app.b2b.server.ServiceException

java.sql.SQLException

Method Detail

RunQuery

public static com.wm.data.IData RunQuery(java.lang.String sql,
                                         java.lang.String[] keys,
                                         int pageSize)
                                  throws java.sql.SQLException,
                                         java.io.IOException,
                                         com.wm.app.b2b.server.ServiceException

Throws:

java.sql.SQLException

java.io.IOException

com.wm.app.b2b.server.ServiceException

RunQuery

public static com.wm.data.IData RunQuery(java.lang.String sql,
                                         java.lang.String[] keys,
                                         int pageSize,
                                         int maxR,
                                         int qryT,
                                         int threshold,
                                         java.lang.String queryId)
                                  throws java.sql.SQLException,
                                         java.io.IOException,
                                         com.wm.app.b2b.server.ServiceException

Throws:

java.sql.SQLException

java.io.IOException

com.wm.app.b2b.server.ServiceException

RunQuery

public static com.wm.data.IData RunQuery(java.lang.String sql,
                                         java.lang.String[] keys,
                                         int pageSize,
                                         int maxR,
                                         int qryT,
                                         int threshold,
                                         java.lang.String queryId,
                                         boolean readUnCommitted)
                                  throws java.sql.SQLException,
                                         java.io.IOException,
                                         com.wm.app.b2b.server.ServiceException

Throws:

java.sql.SQLException

java.io.IOException

com.wm.app.b2b.server.ServiceException

RunQuery

public static com.wm.data.IData RunQuery(java.sql.PreparedStatement preparedStatement,
                                         java.lang.String[] keys,
                                         int pageSize,
                                         int maxR,
                                         int qryT,
                                         int threshold,
                                         java.lang.String queryId,
                                         boolean readUnCommitted)
                                  throws java.sql.SQLException,
                                         java.io.IOException,
                                         com.wm.app.b2b.server.ServiceException

Throws:

java.sql.SQLException

java.io.IOException

com.wm.app.b2b.server.ServiceException

getPage

public static com.wm.data.IData getPage(java.lang.String repoPath,
                                        int pageNum)
                                 throws java.io.IOException,
                                        com.wm.app.b2b.server.ServiceException

Throws:

java.io.IOException

com.wm.app.b2b.server.ServiceException

isQueryCancelled

public static boolean isQueryCancelled(java.lang.String rPath)
                                throws com.wm.app.b2b.server.ServiceException

Throws:

com.wm.app.b2b.server.ServiceException

setQueryCancelled

public static void setQueryCancelled(java.lang.String rPath)

isThreadRunning

public static boolean isThreadRunning(java.lang.String rPath)

getThresPages

public static int getThresPages(java.lang.String rPath)

getPagesRead

public static int getPagesRead(java.lang.String rPath)

getRowsRead

public static long getRowsRead(java.lang.String rPath)

getTotalPages

public static int getTotalPages(java.lang.String rPath)

getTotalRows

public static long getTotalRows(java.lang.String rPath)

getErrors

public static java.util.Vector getErrors(java.lang.String rPath)

addError

public static java.util.Vector addError(java.lang.String rPath,
                                        EXMLException e)

addError

public static java.util.Vector addError(java.lang.String rPath,
                                        java.lang.Throwable t)

unregister

public static void unregister(java.lang.String repoPath)

removeAllQueryResults

public static int removeAllQueryResults()

run

public void run()

Specified by:

run in interface java.lang.Runnable

findLastPageNumber

public static int findLastPageNumber(java.lang.String repoPath)
                              throws EXMLException,
                                     com.wm.app.b2b.server.ServiceException

Throws:

EXMLException

com.wm.app.b2b.server.ServiceException

getCache

public static com.wm.app.tn.cache.ICache getCache()

setDebug

public static void setDebug(java.lang.String flag)

getDebug

public static boolean getDebug()