org.apache.cocoon.components.language.markup.xsp
Class SybaseEsqlQuery

java.lang.Object
  org.apache.avalon.framework.logger.AbstractLogEnabled
      org.apache.cocoon.components.language.markup.xsp.AbstractEsqlQuery
          org.apache.cocoon.components.language.markup.xsp.SybaseEsqlQuery

All Implemented Interfaces:

LogEnabled

public final class SybaseEsqlQuery
extends AbstractEsqlQuery

Database specific EsqlQuery

Version:

CVS $Id: SybaseEsqlQuery.html 1304258 2012-03-23 10:09:27Z ilgrosso $

Author:

Torsten Curdt

Constructor Summary

SybaseEsqlQuery(Connection connection, String query)

Method Summary

String	getQueryString() Return the query string ("select * from bla") NOTE: Might want to be overridden by indiviual EsqlQuery implementations e.g. for database specific LIMIT features.
void	getResultRows() Move to the first row.
AbstractEsqlQuery	newInstance(ResultSet resultSet) Create a EsqlQuery of the same type
CallableStatement	prepareCall() NOTE: Might want to be overridden by indiviual EsqlQuery implementations
PreparedStatement	prepareStatement() NOTE: Might want to be overridden by indiviual EsqlQuery implementations

Methods inherited from class org.apache.cocoon.components.language.markup.xsp.AbstractEsqlQuery

cleanUp, decGroupLevel, execute, execute, executeQuery, getCallableStatement, getConnection, getCurrentRow, getMaxRows, getMoreResults, getPreparedStatement, getQueryResultsCount, getResultSet, getResultSetMetaData, getRowCount, getSkipRows, getUpdateCount, getUpdateResultsCount, groupLevelExists, hasGroupingVarChanged, hasResultSet, incGroupLevel, keepGoing, nextRow, setGroupingVar, setKeepGoing, setMaxRows, setPosition, setPreparedStatement, setSkipRows

Methods inherited from class org.apache.avalon.framework.logger.AbstractLogEnabled

enableLogging, getLogger, setupLogger, setupLogger, setupLogger

Methods inherited from class java.lang.Object

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

Constructor Detail

SybaseEsqlQuery

public SybaseEsqlQuery(Connection connection,
                       String query)

Method Detail

newInstance

public AbstractEsqlQuery newInstance(ResultSet resultSet)

Create a EsqlQuery of the same type

Specified by:

newInstance in class AbstractEsqlQuery

Parameters:

resultSet -

getQueryString

public String getQueryString()
                      throws SQLException

Description copied from class: AbstractEsqlQuery

Return the query string ("select * from bla") NOTE: Might want to be overridden by indiviual EsqlQuery implementations e.g. for database specific LIMIT features. Be aware that there a two different limit approaches:

 retrieve                   query
 time                       time
 +---------+                ...........
 |JDBC     |                :         :
 |ResultSet|                :         :
 |.........|-+              :_________:_
 |         | | skip/max+1   |JDBC     | | skip/max+1
 |         | | window       |ResultSet| | window
 |.........| |              |_________| |
 |         |-+              :         :_|
 |         |                :         :
 +---------+                :.........:
  

With the "retrieve time" limit the JDBC ResultSet includes ALL of the rows of the query. With the "query time" limit only a small window of rows are in the actuall JDBC ResultSet. In order to know whether there are more rows available (without an additional query) we need to have at least one more row in the JDBC ResultSet. So we ask for getMaxRows()+1

Overrides:

getQueryString in class AbstractEsqlQuery

Throws:

SQLException

prepareStatement

public PreparedStatement prepareStatement()
                                   throws SQLException

Description copied from class: AbstractEsqlQuery

NOTE: Might want to be overridden by indiviual EsqlQuery implementations

Overrides:

prepareStatement in class AbstractEsqlQuery

Throws:

SQLException

prepareCall

public CallableStatement prepareCall()
                              throws SQLException

Description copied from class: AbstractEsqlQuery

NOTE: Might want to be overridden by indiviual EsqlQuery implementations

Overrides:

prepareCall in class AbstractEsqlQuery

Throws:

SQLException

getResultRows

public void getResultRows()
                   throws SQLException

Description copied from class: AbstractEsqlQuery

Move to the first row. NOTE: Might want to be overridden by indiviual EsqlQuery implementations

Overrides:

getResultRows in class AbstractEsqlQuery

Throws:

SQLException