org.objectweb.jorm.mapper.rdb.adapter
Class SapdbAdapter
- PreparedStatementAdapter, RdbAdapter, RdbAdapter, ResultsetAdapter, SequenceAdapter, TypeAdapter, ValueAsSQLStringAdapter
public class SapdbAdapter
This class is a sql adapter for the SapDB relational database.
SapDB 7.4 beta
result of the jdbc driver test:
===============================
FAIL: BIT: create table: [-3002] (at 31): Invalid datatype
FAIL: TINYINT: create table: [-4006] (at 28): Unknown domain name:TINYINT
FAIL: SMALLINT: select value 0 with getObject
FAIL: SMALLINT: select value 1 with getObject
FAIL: SMALLINT: select value 254 with getObject
FAIL: INTEGER: select value 0 with getObject
FAIL: INTEGER: select value 1 with getObject
FAIL: INTEGER: select value 254 with getObject
FAIL: BIGINT: create table: [-4006] (at 28): Unknown domain name:BIGINT
FAIL: REAL: select value 0.0 with getObject
FAIL: REAL: select value 1.0 with getObject
FAIL: REAL: select value 254.0 with getObject
FAIL: DOUBLE: create table: [-3002] (at 30): Invalid datatype
- S.Chassande-Barrioz
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 , TYPE_NAMES |
escapeFunctionClose , escapeFunctionOpen , existRelation , existSequence , existTable , existView , fetchResultSetSize , getBigDecimal , getBigInteger , getBoolean , getByte , getByteArray , getCACHEkeyWord , getChar , getCharArray , getCharArray , getCharArray , getColumnAliasExpr , getConcatExpression , getCreateSequence , getCreateSequence , getDate , getDate , getDouble , getFirstLocateExpression , getFloat , getFromClause , getFromClause , getINCREMENTkeyWord , getIndexedLocateExpression , getInt , getLengthOperator , getLong , getName , getNextValInSequence , getOboolean , getObyte , getOchar , getOdouble , getOfloat , getOint , getOlong , getOshort , getQuery , getSTARTkeyWord , getSerialized , getShort , getSqlType , getSqlTypeCode , getSqlTypeCode , getString , getSubqueryAlias , getValueAsSQLString , getValueAsSQLString , getValueAsSQLString , getValueAsSQLString , getValueAsSQLString , getValueAsSQLString , getValueAsSQLString , getValueAsSQLString , getValueAsSQLString , getWhereClause , handleOrderBy , modifySelectClauseWithRange , modifyWhereClauseWithRange , setBigDecimal , setBigInteger , setBoolean , setByte , setByteArray , setChar , setCharArray , setDate , setDouble , setFloat , setInt , setLong , setNull , setOboolean , setObyte , setOchar , setOdouble , setOfloat , setOint , setOlong , setOshort , setSerialized , setShort , setString , sqldate2date , supportBatchPreparedStatement , time2date , timestamp2date , writeColumnAlias , writeTableAlias |
SapdbAdapter
public SapdbAdapter()
getNextValInSequence
public String getNextValInSequence(String seqName)
- getNextValInSequence in interface SequenceAdapter
- getNextValInSequence in interface BasicRdbAdapter
seqName
- is the sequence name
- the SQL command to gett a new value in a SQL
sequence which the name is given in parameter.
writeTableAlias
public void writeTableAlias(String alias,
StringBuffer sb)
Append a table alias to an SQL expression. To be used when constructing
the string expression of a from clause.
For example, most database recognize the syntax
'select ... from R as ALIAS_FOR_R, S as ALIAS_FOR_S ... '
whereas Orabcle accepts the following syntax :
'select ... from R ALIAS_FOR_R, S ALIAS_FOR_S ... '
- writeTableAlias in interface RdbAdapter
- writeTableAlias in interface BasicRdbAdapter
alias
- The table aliassb
- The StringBuffer into which to write the alias.