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.