org.exolab.castor.jdo.engine

Class SQLQuery

public final class SQLQuery extends Object implements PersistenceQuery

Since: 1.0

Version: $Revision: 6230 $ $Date: 2006-04-11 15:26:07 -0600 (Tue, 11 Apr 2006) $

Author: Assaf Arkin Thomas Yip Bruce Snyder Werner Guttmann Ralf Joachim

Constructor Summary
SQLQuery(SQLEngine engine, PersistenceFactory factory, String sql, Class[] types, boolean isCallSql)
Creates an instance of SQLQuery.
Method Summary
booleanabsolute(int row)
Move to an absolute position within a ResultSet. use the jdbc 2.0 method to move to an absolute position in the resultset.
voidclose()
voidexecute(Object conn, AccessMode accessMode, boolean scrollable)
Objectfetch(ProposedEntity proposedObject)
ClassgetResultType()
IdentitynextIdentity(Identity identity)
voidsetParameter(int index, Object value)
intsize()
Uses the underlying db's cursors to move to the last row in the result set, get the row number via getRow(), then move back to where ever the user was positioned in the resultset.

Constructor Detail

SQLQuery

SQLQuery(SQLEngine engine, PersistenceFactory factory, String sql, Class[] types, boolean isCallSql)
Creates an instance of SQLQuery.

Parameters: engine SQLEngine instance sql The SQL statement to execute types Types of the class used. isCallSql true if the SQL is issued as part of a CALL SQL statement.

Method Detail

absolute

public boolean absolute(int row)
Move to an absolute position within a ResultSet. use the jdbc 2.0 method to move to an absolute position in the resultset.

Parameters: row The row to move to

Returns: True if the move was successful.

Throws: PersistenceException Indicates a problem in moving to an absolute position.

close

public void close()

execute

public void execute(Object conn, AccessMode accessMode, boolean scrollable)

fetch

public Object fetch(ProposedEntity proposedObject)

See Also: PersistenceQuery

getResultType

public Class getResultType()

nextIdentity

public Identity nextIdentity(Identity identity)

setParameter

public void setParameter(int index, Object value)

size

public int size()
Uses the underlying db's cursors to move to the last row in the result set, get the row number via getRow(), then move back to where ever the user was positioned in the resultset.

Returns: The size of the current result set.

Throws: PersistenceException If the excution of this method failed.

Intalio Inc. (C) 1999-2006. All rights reserved http://www.intalio.com