|
||||||||||
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
public class SybasePlatform
The platform implementation for Sybase.
Field Summary | |
---|---|
static java.lang.String |
DATABASENAME
Database name of this platform. |
static java.lang.String |
JDBC_DRIVER
The standard Sybase jdbc driver. |
static java.lang.String |
JDBC_DRIVER_OLD
The old Sybase jdbc driver. |
static java.lang.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(java.sql.Connection connection,
Table table)
Allows platforms to issue statements directly after rows have been inserted into the specified table. |
protected void |
afterUpdate(java.sql.Connection connection,
Table table)
Allows platforms to issue statements directly after rows have been updated in the specified table. |
protected void |
beforeInsert(java.sql.Connection connection,
Table table)
Allows platforms to issue statements directly before rows are inserted into the specified table. |
protected void |
beforeUpdate(java.sql.Connection connection,
Table table)
Allows platforms to issue statements directly before rows are updated in the specified table. |
protected java.lang.Object |
extractColumnValue(java.sql.ResultSet resultSet,
java.lang.String columnName,
int columnIdx,
int jdbcType)
This is the core method to retrieve a value for a column from a result set. |
java.util.List |
fetch(Database model,
java.lang.String sql,
java.util.Collection parameters,
Table[] queryHints,
int start,
int end)
Queries for a list of dyna beans representing rows of the given query. |
java.util.List |
fetch(Database model,
java.lang.String sql,
Table[] queryHints,
int start,
int end)
Queries for a list of dyna beans representing rows of the given query. |
java.lang.String |
getName()
Returns the name of the database that this platform is for. |
java.util.Iterator |
query(Database model,
java.lang.String sql,
java.util.Collection parameters,
Table[] queryHints)
Performs the given parameterized SQL query returning an iterator over the results. |
java.util.Iterator |
query(Database model,
java.lang.String sql,
Table[] queryHints)
Performs the given SQL query returning an iterator over the results. |
protected void |
setStatementParameterValue(java.sql.PreparedStatement statement,
int sqlIndex,
int typeCode,
java.lang.Object value)
This is the core method to set the parameter of a prepared statement to a given value. |
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 java.lang.String DATABASENAME
public static final java.lang.String JDBC_DRIVER
public static final java.lang.String JDBC_DRIVER_OLD
public static final java.lang.String JDBC_SUBPROTOCOL
public static final long MAX_TEXT_SIZE
Constructor Detail |
---|
public SybasePlatform()
Method Detail |
---|
public java.lang.String getName()
protected java.lang.Object extractColumnValue(java.sql.ResultSet resultSet, java.lang.String columnName, int columnIdx, int jdbcType) throws DatabaseOperationException, java.sql.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
java.sql.SQLException
- If an error occurred while accessing the result set
DatabaseOperationException
protected void setStatementParameterValue(java.sql.PreparedStatement statement, int sqlIndex, int typeCode, java.lang.Object value) throws java.sql.SQLException
setStatementParameterValue
in class PlatformImplBase
statement
- The statementsqlIndex
- The parameter indextypeCode
- The JDBC type codevalue
- The value
java.sql.SQLException
- If an error occurred while setting the parameter valuepublic java.util.List fetch(Database model, java.lang.String sql, java.util.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
model
- The database model to usesql
- The parameterized sql queryparameters
- The parameter valuesqueryHints
- The tables that are queried (optional)start
- Row number to start from (0 for first row)end
- Row number to stop at (inclusively; -1 for last row)
DatabaseOperationException
public java.util.List fetch(Database model, java.lang.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
model
- The database model to usesql
- The sql queryqueryHints
- The tables that are queried (optional)start
- Row number to start from (0 for first row)end
- Row number to stop at (inclusively; -1 for last row)
DatabaseOperationException
public java.util.Iterator query(Database model, java.lang.String sql, java.util.Collection parameters, Table[] queryHints) throws DatabaseOperationException
query
in interface Platform
query
in class PlatformImplBase
model
- The database model to usesql
- The sql query to performparameters
- The query parameter valuesqueryHints
- The tables that are queried (optional)
DatabaseOperationException
public java.util.Iterator query(Database model, java.lang.String sql, Table[] queryHints) throws DatabaseOperationException
query
in interface Platform
query
in class PlatformImplBase
model
- The database model to usesql
- The sql query to performqueryHints
- The tables that are queried (optional)
DatabaseOperationException
protected void beforeInsert(java.sql.Connection connection, Table table) throws java.sql.SQLException
beforeInsert
in class PlatformImplBase
connection
- The connection used for the insertiontable
- The table that the rows are inserted into
java.sql.SQLException
protected void afterInsert(java.sql.Connection connection, Table table) throws java.sql.SQLException
afterInsert
in class PlatformImplBase
connection
- The connection used for the insertiontable
- The table that the rows have been inserted into
java.sql.SQLException
protected void beforeUpdate(java.sql.Connection connection, Table table) throws java.sql.SQLException
beforeUpdate
in class PlatformImplBase
connection
- The connection used for the updatetable
- The table that the rows are updateed into
java.sql.SQLException
protected void afterUpdate(java.sql.Connection connection, Table table) throws java.sql.SQLException
afterUpdate
in class PlatformImplBase
connection
- The connection used for the updatetable
- The table that the rows have been updateed into
java.sql.SQLException
|
||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |