fetchResultSetSize
public int fetchResultSetSize(ResultSet rs)
throws SQLException
This calculates the size of a result set. If this feature is not supported
by a database or its jdbc driver, this method returns -1.
- fetchResultSetSize in interface RdbAdapter
- fetchResultSetSize in interface BasicRdbAdapter
rs
- the result set which the size must be returned
getChar
public char getChar(ResultSet rs,
int idx,
char nullValue)
throws SQLException
Get a char value from a ResultSet.
- getChar in interface ResultsetAdapter
- getChar in interface BasicRdbAdapter
rs
- is the result where to get the valueidx
- is the index of the value in the resultsetnullValue
- represents the nullvalue to return if the column is null
in the resultset
getCreateSequence
public String getCreateSequence(String seqName)
throws UnsupportedOperationException
- getCreateSequence in interface SequenceAdapter
- getCreateSequence in interface BasicRdbAdapter
seqName
- is the sequence name
- the SQL command to create a sequence
getCreateSequence
public String getCreateSequence(String seqName,
Integer startid,
Integer inc,
Integer cache)
- getCreateSequence in interface SequenceAdapter
- getCreateSequence in interface BasicRdbAdapter
seqName
- is the sequence namestartid
- is the initial value of the sequencecache
- is the size of the cache
- the SQL command to create a sequence
getDate
public Date getDate(ResultSet rs,
int idx,
String sqlColumnType,
Date nullValue)
throws SQLException
Get a Date value from a ResultSet.
- getDate in interface ResultsetAdapter
- getDate in interface BasicRdbAdapter
rs
- is the result where to get the valueidx
- is the index of the value in the resultsetnullValue
- represents the nullvalue to return if the column is null
in the resultset
getOchar
public Character getOchar(ResultSet rs,
int idx,
Character nullValue)
throws SQLException
Get a Character value from a ResultSet.
- getOchar in interface ResultsetAdapter
- getOchar in interface BasicRdbAdapter
rs
- is the result where to get the valueidx
- is the index of the value in the resultsetnullValue
- represents the nullvalue to return if the column is null
in the resultset
getSqlType
public String getSqlType(int typeCode,
boolean usedInPK,
int size,
int scale)
throws RdbAdapterException
This method returns the SQL type linked to the java type
- getSqlType in interface TypeAdapter
- getSqlType in interface BasicRdbAdapter
typeCode
- is the type code of the java typeusedInPK
- indicates if the type has to be used into a Primary keysize
- can indicates the expected size of the type. If it equals to
NO_SIZE that means no size is expected. This parameter can be used for
float, BigXXX numbers, String,...scale
- can indicates the expected scale of the type. If it equals to
NO_SIZE that means no scale is expected.
getSqlTypeCode
public int getSqlTypeCode(int typeCode,
String sqlColumnType)
throws RdbAdapterException
This method returns the SQL type code linked to the java type
specified in parameter.
- getSqlTypeCode in interface TypeAdapter
- getSqlTypeCode in interface BasicRdbAdapter
- An int constant defined in the java.sql.Types class
modifyWhereClauseWithRange
protected void modifyWhereClauseWithRange(StringBuffer sb,
String _where,
int rangeStart,
int rangeSize)
- modifyWhereClauseWithRange in interface BasicRdbAdapter
setDate
public void setDate(PreparedStatement ps,
int idx,
Date o,
String columnType)
throws SQLException
Assignes a value into a PreparedStatement
- setDate in interface PreparedStatementAdapter
- setDate in interface BasicRdbAdapter
ps
- is the PreparedStatementidx
- is the index of the the value in the PreparedStatemento
- is the value to assign
setVarcharSize
public void setVarcharSize(int s)
setVarcharSizeInPk
public void setVarcharSizeInPk(int s)