|
||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
java.lang.Objectorg.apache.ddlutils.util.JdbcSupport
org.apache.ddlutils.platform.PlatformImplBase
org.apache.ddlutils.platform.sybase.SybasePlatform
The platform implementation for Sybase.
Field Summary | |
static String |
DATABASENAME
Database name of this platform. |
static String |
JDBC_DRIVER
The standard Sybase jdbc driver. |
static String |
JDBC_DRIVER_OLD
The old Sybase jdbc driver. |
static String |
JDBC_SUBPROTOCOL
The subprotocol used by the standard Sybase driver. |
static long |
MAX_TEXT_SIZE
The maximum size that text and binary columns can have. |
Fields inherited from class org.apache.ddlutils.platform.PlatformImplBase |
MODEL_DEFAULT_NAME |
Constructor Summary | |
SybasePlatform()
Creates a new platform instance. |
Method Summary | |
protected void |
afterInsert(Connection connection,
Table table)
Allows platforms to issue statements directly after rows have been inserted into the specified table. |
protected void |
afterUpdate(Connection connection,
Table table)
Allows platforms to issue statements directly after rows have been updated in the specified table. |
protected void |
beforeInsert(Connection connection,
Table table)
Allows platforms to issue statements directly before rows are inserted into the specified table. |
protected void |
beforeUpdate(Connection connection,
Table table)
Allows platforms to issue statements directly before rows are updated in the specified table. |
protected Object |
extractColumnValue(ResultSet resultSet,
String columnName,
int columnIdx,
int jdbcType)
This is the core method to retrieve a value for a column from a result set. Its primary purpose is to call the appropriate method on the result set, and to provide an extension point where database-specific implementations can change this behavior. |
List |
fetch(Database model,
String sql,
Collection parameters,
Table[] queryHints,
int start,
int end)
Queries for a list of dyna beans representing rows of the given query. In contrast to the Platform.query(Database, String, Collection, Table[])
method all beans will be materialized and the connection will be closed
before returning the beans. Also, the two int parameters specify which
rows of the result set to use. If there are more rows than desired, they
will be ignored (and not read from the database). |
List |
fetch(Database model,
String sql,
Table[] queryHints,
int start,
int end)
Queries for a list of dyna beans representing rows of the given query. In contrast to the Platform.query(Database, String, Table[]) method all
beans will be materialized and the connection will be closed before
returning the beans. Also, the two int parameters specify which rows of
the result set to use. If there are more rows than desired, they will be
ignored (and not read from the database). |
String |
getName()
Returns the name of the database that this platform is for. |
Iterator |
query(Database model,
String sql,
Collection parameters,
Table[] queryHints)
Performs the given parameterized SQL query returning an iterator over the results. |
Iterator |
query(Database model,
String sql,
Table[] queryHints)
Performs the given SQL query returning an iterator over the results. |
protected void |
setStatementParameterValue(PreparedStatement statement,
int sqlIndex,
int typeCode,
Object value)
This is the core method to set the parameter of a prepared statement to a given value. The primary purpose of this method is to call the appropriate method on the statement, and to give database-specific implementations the ability to change this behavior. |
Methods inherited from class org.apache.ddlutils.util.JdbcSupport |
borrowConnection, closeStatement, getDataSource, getPassword, getUsername, returnConnection, setDataSource, setPassword, setUsername |
Methods inherited from class java.lang.Object |
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait |
Methods inherited from interface org.apache.ddlutils.Platform |
borrowConnection, getDataSource, getPassword, getUsername, returnConnection, setDataSource, setPassword, setUsername |
Field Detail |
public static final String DATABASENAME
public static final String JDBC_DRIVER
public static final String JDBC_DRIVER_OLD
public static final String JDBC_SUBPROTOCOL
public static final long MAX_TEXT_SIZE
Constructor Detail |
public SybasePlatform()
Method Detail |
public String getName()
protected Object extractColumnValue(ResultSet resultSet, String columnName, int columnIdx, int jdbcType) throws DatabaseOperationException, SQLException
extractColumnValue
in class PlatformImplBase
resultSet
- The result set to extract the value fromcolumnName
- The name of the column; can be null
in which case the
columnIdx
will be used insteadcolumnIdx
- The index of the column's value in the result set; is only used if
columnName
is null
jdbcType
- The jdbc type to extract
SQLException
- If an error occurred while accessing the result set
DatabaseOperationException
protected void setStatementParameterValue(PreparedStatement statement, int sqlIndex, int typeCode, Object value) throws SQLException
setStatementParameterValue
in class PlatformImplBase
statement
- The statementsqlIndex
- The parameter indextypeCode
- The JDBC type codevalue
- The value
SQLException
- If an error occurred while setting the parameter valuepublic List fetch(Database model, String sql, Collection parameters, Table[] queryHints, int start, int end) throws DatabaseOperationException
Platform.query(Database, String, Collection, Table[])
method all beans will be materialized and the connection will be closed
before returning the beans. Also, the two int parameters specify which
rows of the result set to use. If there are more rows than desired, they
will be ignored (and not read from the database).
fetch
in interface Platform
fetch
in class PlatformImplBase
DatabaseOperationException
public List fetch(Database model, String sql, Table[] queryHints, int start, int end) throws DatabaseOperationException
Platform.query(Database, String, Table[])
method all
beans will be materialized and the connection will be closed before
returning the beans. Also, the two int parameters specify which rows of
the result set to use. If there are more rows than desired, they will be
ignored (and not read from the database).
fetch
in interface Platform
fetch
in class PlatformImplBase
DatabaseOperationException
public Iterator query(Database model, String sql, Collection parameters, Table[] queryHints) throws DatabaseOperationException
query
in interface Platform
query
in class PlatformImplBase
DatabaseOperationException
public Iterator query(Database model, String sql, Table[] queryHints) throws DatabaseOperationException
query
in interface Platform
query
in class PlatformImplBase
DatabaseOperationException
protected void beforeInsert(Connection connection, Table table) throws SQLException
beforeInsert
in class PlatformImplBase
connection
- The connection used for the insertiontable
- The table that the rows are inserted into
SQLException
protected void afterInsert(Connection connection, Table table) throws SQLException
afterInsert
in class PlatformImplBase
connection
- The connection used for the insertiontable
- The table that the rows have been inserted into
SQLException
protected void beforeUpdate(Connection connection, Table table) throws SQLException
beforeUpdate
in class PlatformImplBase
connection
- The connection used for the updatetable
- The table that the rows are updateed into
SQLException
protected void afterUpdate(Connection connection, Table table) throws SQLException
afterUpdate
in class PlatformImplBase
connection
- The connection used for the updatetable
- The table that the rows have been updateed into
SQLException
|
||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |