|
||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
public interface RdbAdapter
This interface permits to adapte the use of a JDBC driver and the SQL type for the non conformance of a Database.
Field Summary | |
---|---|
static int |
NOSIZE
|
static int |
RANGEATEND
|
static int |
RANGEATSTART
|
static int |
RANGEUNSUPPORTED
|
Fields inherited from interface org.objectweb.jorm.mapper.rdb.adapter.api.TypeAdapter |
---|
TYPE_NAMES, TYPECODE_ARRAY, TYPECODE_BIGDECIMAL, TYPECODE_BIGINTEGER, TYPECODE_BOOLEAN, TYPECODE_BYTE, TYPECODE_BYTEARRAY, TYPECODE_CHAR, TYPECODE_CHARARRAY, TYPECODE_DATE, TYPECODE_DOUBLE, TYPECODE_FLOAT, TYPECODE_INT, TYPECODE_LONG, TYPECODE_OBJBOOLEAN, TYPECODE_OBJBYTE, TYPECODE_OBJCHAR, TYPECODE_OBJDOUBLE, TYPECODE_OBJFLOAT, TYPECODE_OBJINT, TYPECODE_OBJLONG, TYPECODE_OBJSHORT, TYPECODE_SERIALIZED, TYPECODE_SHORT, TYPECODE_STRING |
Method Summary | |
---|---|
void |
escapeFunctionClose(java.lang.StringBuffer function)
Modifies the end of a function expression for the escape syntax. |
void |
escapeFunctionOpen(java.lang.StringBuffer function)
Modifies the start of a function expression for the escape syntax. |
boolean |
existTable(java.sql.Connection connection,
java.lang.String tableName)
checks the table existence |
boolean |
existView(java.sql.Connection connection,
java.lang.String viewName)
checks the view existence |
int |
fetchResultSetSize(java.sql.ResultSet rs)
This method calculates the size of a result set window. |
java.lang.String |
getColumnAliasExpr(java.lang.String aliasName)
Returns a column alias expression. |
java.lang.String |
getConcatExpression(java.lang.String op1,
java.lang.String op2)
|
java.lang.String |
getFirstLocateExpression(java.lang.String substring,
java.lang.String instring)
Returns the expression for searching the position of the first occurrence of a substring in a string. |
java.lang.String |
getFromClause(java.util.List jts)
Builds a from clause from a list of JoinedTable objects. |
java.lang.String |
getIndexedLocateExpression(java.lang.String inputString,
java.lang.String substring,
java.lang.String fromIndex)
Returns the expression for searching the position of the first occurrence of a substring in a string starting from a given index. |
java.lang.String |
getLengthOperator()
|
java.lang.String |
getName()
|
java.lang.String |
getQuery(java.lang.String selectClause,
java.util.List jts,
java.lang.String whereClause,
boolean rangeFrom,
boolean rangeSize)
Builds a query with join and table alias. |
java.lang.String |
getQuery(java.lang.String selectClause,
java.lang.String fromClause,
java.lang.String whereClause,
java.lang.String orderBy,
java.lang.String groupBy,
boolean rangeStart,
boolean rangeSize)
Builds a query with join and table alias. |
int |
getRangeParametersAtStart()
Indicates whether parameters corresponding to range queries (range start and size) are positioned at the start or at the end of the SQL query. |
java.lang.String |
getSubqueryAlias()
In the case the subquery needs to be aliased (Postgres), returns a string to be appended to the subquery. |
java.lang.String |
handleOrderBy(java.lang.String query)
|
void |
setLogger(Logger logger)
Sets the corresponding Monolog logger. |
boolean |
supportBatchPreparedStatement()
Indicates if the driver supports the batch of PreparedStatement |
void |
writeColumnAlias(java.lang.String alias,
java.lang.StringBuffer sb)
Append a column alias to an SQL expression. |
void |
writeTableAlias(java.lang.String alias,
java.lang.StringBuffer sb)
Append a table alias to an SQL expression. |
Methods inherited from interface org.objectweb.jorm.mapper.rdb.adapter.api.TypeAdapter |
---|
getSqlType, getSqlTypeCode, getSqlTypeCode, supportArray |
Methods inherited from interface org.objectweb.jorm.mapper.rdb.adapter.api.ResultsetAdapter |
---|
getArray, getBigDecimal, getBigInteger, getBoolean, getByte, getByteArray, getChar, getCharArray, getDate, getDate, getDouble, getFloat, getInt, getLong, getOboolean, getObyte, getOchar, getOdouble, getOfloat, getOint, getOlong, getOshort, getSerialized, getShort, getString |
Methods inherited from interface org.objectweb.jorm.mapper.rdb.adapter.api.PreparedStatementAdapter |
---|
getArrayToString, setArray, setBigDecimal, setBigInteger, setBoolean, setByte, setByteArray, setChar, setCharArray, setDate, setDouble, setFloat, setInt, setLong, setNull, setOboolean, setObyte, setOchar, setOdouble, setOfloat, setOint, setOlong, setOshort, setSerialized, setShort, setString |
Methods inherited from interface org.objectweb.jorm.mapper.rdb.adapter.api.ValueAsSQLStringAdapter |
---|
getValueAsSQLString, getValueAsSQLString, getValueAsSQLString, getValueAsSQLString, getValueAsSQLString, getValueAsSQLString, getValueAsSQLString, getValueAsSQLString, getValueAsSQLString |
Methods inherited from interface org.objectweb.jorm.mapper.rdb.adapter.api.SequenceAdapter |
---|
existSequence, getCreateSequence, getCreateSequence, getManyNextValInSequence, getNextValInSequence |
Field Detail |
---|
static final int RANGEATSTART
static final int RANGEATEND
static final int RANGEUNSUPPORTED
static final int NOSIZE
Method Detail |
---|
java.lang.String getName()
boolean supportBatchPreparedStatement()
int fetchResultSetSize(java.sql.ResultSet rs) throws java.sql.SQLException
rs
- the result set which the size must be returned
java.sql.SQLException
void escapeFunctionOpen(java.lang.StringBuffer function)
The JDBC standard syntax is "fn{function}".
function
- the function expression to be escapedvoid escapeFunctionClose(java.lang.StringBuffer function)
The JDBC standard syntax is "fn{function}".
function
- the function expression to be escapedjava.lang.String getConcatExpression(java.lang.String op1, java.lang.String op2)
java.lang.String getFirstLocateExpression(java.lang.String substring, java.lang.String instring) throws RdbAdapterException
Three main syntaxes are found: position(substr in str), locate(substr, srt) and instr(str, substr).
substring
- The substring searchedinstring
- The string in which to search the substring
RdbAdapterException
java.lang.String getIndexedLocateExpression(java.lang.String inputString, java.lang.String substring, java.lang.String fromIndex) throws RdbAdapterException
Two main syntaxes are found: instr() and locate()
inputString
- The string in which to search the substringsubstring
- The substring searchedfromIndex
- The index from which to start searching
RdbAdapterException
java.lang.String getLengthOperator() throws RdbAdapterException
RdbAdapterException
java.lang.String getQuery(java.lang.String selectClause, java.util.List jts, java.lang.String whereClause, boolean rangeFrom, boolean rangeSize)
selectClause
- is a string representation of the select clausejts
- is the tables with their joinwhereClause
- is a string representation of the where clauserangeFrom
- is the rank of the first row to be returned in case of
a range limit, starting at 0rangeSize
- is the number of rows to be returned in case of a range
limit. The convention is that Integer.MAX_VALUE means no range limit.java.lang.String getQuery(java.lang.String selectClause, java.lang.String fromClause, java.lang.String whereClause, java.lang.String orderBy, java.lang.String groupBy, boolean rangeStart, boolean rangeSize)
selectClause
- is a string representation of the select clausejts
- is the tables with their joinwhereClause
- is a string representation of the where clauseorderBy
- is a string representation of the order by clausegroupBy
- is a string representation of the group by clauserangeStart
- is the rank of the first row to be returned in case of
a range limit, starting at 0rangeSize
- is the number of rows to be returned in case of a range
limit. The convention is that Integer.MAX_VALUE means no range limit.java.lang.String getFromClause(java.util.List jts)
void writeTableAlias(java.lang.String alias, java.lang.StringBuffer sb)
alias
- The table aliassb
- The StringBuffer into which to write the alias.void writeColumnAlias(java.lang.String alias, java.lang.StringBuffer sb)
alias
- the column aliassb
- The StringBuffer into which to write the alias.java.lang.String getColumnAliasExpr(java.lang.String aliasName)
aliasName
- the column aliasjava.lang.String handleOrderBy(java.lang.String query)
boolean existTable(java.sql.Connection connection, java.lang.String tableName) throws java.sql.SQLException
connection
- is the JDBC connection to usetableName
- is the name of the table
java.sql.SQLException
boolean existView(java.sql.Connection connection, java.lang.String viewName) throws java.sql.SQLException
connection
- is the JDBC connection to useviewName
- is the name of the view
java.sql.SQLException
java.lang.String getSubqueryAlias()
int getRangeParametersAtStart()
Indeed, depending on the database, the SQL syntax may vary, and the parameters can either be put at the front or at the end.
void setLogger(Logger logger)
logger
- the Monolog logger attached to the RdbAdapter
|
||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |