org.objectweb.jorm.mapper.rdb.adapter
Class ProgressAdapter
- PreparedStatementAdapter, RdbAdapter, ResultsetAdapter, SequenceAdapter, TypeAdapter, ValueAsSQLStringAdapter
public class ProgressAdapter
Adapter for the database Progress 9.1D server
- Pascal Gos
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 |
boolean | existSequence(Connection connection, String seqName) - checks the sequence existence
|
String | getCreateSequence(String seqName)
|
String | getCreateSequence(String seqName, Integer startid, Integer inc, Integer cache) - CREATE [ TEMPORARY | TEMP ] SEQUENCE name [ INCREMENT [ BY ] increment ] [
MINVALUE minvalue | NO MINVALUE ] [ MAXVALUE maxvalue | NO MAXVALUE ] [
START [ WITH ] start ] [ CACHE cache ] [ [ NO ] CYCLE ]
|
String | getSqlType(int typeCode, boolean usedInPK, int size, int scale) - This method returns the SQL type linked to the java type
|
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 |
DEFAULT_VARCHAR_SIZE
private static int DEFAULT_VARCHAR_SIZE
ProgressAdapter
public ProgressAdapter()
existSequence
public boolean existSequence(Connection connection,
String seqName)
throws SQLException
checks the sequence existence
- existSequence in interface SequenceAdapter
- existSequence in interface BasicRdbAdapter
connection
- is the JDBC connection to useseqName
- is the sequence of the table
- true if the table exists, otherwise false.
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)
throws UnsupportedOperationException
CREATE [ TEMPORARY | TEMP ] SEQUENCE name [ INCREMENT [ BY ] increment ] [
MINVALUE minvalue | NO MINVALUE ] [ MAXVALUE maxvalue | NO MAXVALUE ] [
START [ WITH ] start ] [ CACHE cache ] [ [ NO ] CYCLE ]
- getCreateSequence in interface SequenceAdapter
- getCreateSequence in interface BasicRdbAdapter
seqName
- startid
- inc
-
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.