|
|||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
java.lang.Objectorg.objectweb.jorm.mapper.rdb.adapter.BasicRdbAdapter
org.objectweb.jorm.mapper.rdb.adapter.MysqlAdapter
MySql 4.0.12
Field Summary | |
private static java.lang.String |
MYSQLINDEXEDLOCATE
|
int |
varbinarySize
|
int |
varbinarySizeInPk
|
private int |
varcharSize
|
private int |
varcharSizeInPk
|
Fields inherited from class org.objectweb.jorm.mapper.rdb.adapter.BasicRdbAdapter |
logger, name |
Fields inherited from interface org.objectweb.jorm.mapper.rdb.adapter.api.RdbAdapter |
NOSIZE, RANGEATEND, RANGEATSTART, 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 |
Constructor Summary | |
MysqlAdapter()
|
Method Summary | |
int |
fetchResultSetSize(java.sql.ResultSet rs)
This calculates the size of a result set. |
java.lang.Object |
getArray(java.sql.ResultSet rs,
int idx,
java.lang.Object nullValue,
int typeCode)
Get an array value from a ResultSet. |
java.lang.String |
getArrayValueAsSQLString(java.lang.Object array,
int typeCode,
java.lang.String begin,
java.lang.String realsep,
java.lang.String end)
|
char |
getChar(java.sql.ResultSet rs,
int idx,
char nullValue)
Get a char value from a ResultSet. |
java.lang.String |
getCreateSequence(java.lang.String seqName)
|
java.lang.String |
getCreateSequence(java.lang.String seqName,
java.lang.Integer startid,
java.lang.Integer inc,
java.lang.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 ] |
java.util.Date |
getDate(java.sql.ResultSet rs,
int idx,
java.lang.String sqlColumnType,
java.util.Date nullValue)
Get a Date value from a ResultSet. |
java.lang.String |
getIndexedLocateExpression(java.lang.String instring,
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.Character |
getOchar(java.sql.ResultSet rs,
int idx,
java.lang.Character nullValue)
Get a Character value from a ResultSet. |
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 |
getSqlType(int typeCode,
boolean usedInPK,
int size,
int scale)
This method returns the SQL type linked to the java type |
int |
getSqlTypeCode(int typeCode,
java.lang.String sqlColumnType)
This methods return the SQL type code linked to the java type specified in parameter. |
protected void |
modifyQueryWithRange(java.lang.StringBuffer sb,
boolean rangeStart,
boolean rangeSize)
|
protected void |
modifySelectClauseWithRange(java.lang.StringBuffer sb,
boolean rangeStart,
boolean rangeSize)
|
void |
setDate(java.sql.PreparedStatement ps,
int idx,
java.util.Date o,
java.lang.String columnType)
Assignes a String value into a PreparedStatement |
void |
setVarcharSize(int s)
|
void |
setVarcharSizeInPk(int s)
|
boolean |
supportArray(int elemTypeCode)
|
boolean |
supportBatchPreparedStatement()
Indicates if the driver supports the batch of PreparedStatement |
Methods inherited from class java.lang.Object |
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait |
Field Detail |
private static final java.lang.String MYSQLINDEXEDLOCATE
private int varcharSize
private int varcharSizeInPk
public int varbinarySize
public int varbinarySizeInPk
Constructor Detail |
public MysqlAdapter()
Method Detail |
public boolean supportBatchPreparedStatement()
RdbAdapter
supportBatchPreparedStatement
in interface RdbAdapter
supportBatchPreparedStatement
in class BasicRdbAdapter
public int fetchResultSetSize(java.sql.ResultSet rs) throws java.sql.SQLException
fetchResultSetSize
in interface RdbAdapter
fetchResultSetSize
in class BasicRdbAdapter
rs
- the result set which the size must be returned
java.sql.SQLException
public void setVarcharSize(int s)
public void setVarcharSizeInPk(int s)
public java.lang.String getSqlType(int typeCode, boolean usedInPK, int size, int scale) throws RdbAdapterException
TypeAdapter
getSqlType
in interface TypeAdapter
getSqlType
in class BasicRdbAdapter
RdbAdapterException
public int getSqlTypeCode(int typeCode, java.lang.String sqlColumnType) throws RdbAdapterException
BasicRdbAdapter
getSqlTypeCode
in interface TypeAdapter
getSqlTypeCode
in class BasicRdbAdapter
RdbAdapterException
public char getChar(java.sql.ResultSet rs, int idx, char nullValue) throws java.sql.SQLException
ResultsetAdapter
getChar
in interface ResultsetAdapter
getChar
in class BasicRdbAdapter
java.sql.SQLException
public java.lang.Character getOchar(java.sql.ResultSet rs, int idx, java.lang.Character nullValue) throws java.sql.SQLException
ResultsetAdapter
getOchar
in interface ResultsetAdapter
getOchar
in class BasicRdbAdapter
java.sql.SQLException
public java.util.Date getDate(java.sql.ResultSet rs, int idx, java.lang.String sqlColumnType, java.util.Date nullValue) throws java.sql.SQLException
ResultsetAdapter
getDate
in interface ResultsetAdapter
getDate
in class BasicRdbAdapter
java.sql.SQLException
public java.lang.String getIndexedLocateExpression(java.lang.String instring, java.lang.String substring, java.lang.String fromIndex)
RdbAdapter
Two main syntaxes are found: instr() and locate()
getIndexedLocateExpression
in interface RdbAdapter
getIndexedLocateExpression
in class BasicRdbAdapter
public void setDate(java.sql.PreparedStatement ps, int idx, java.util.Date o, java.lang.String columnType) throws java.sql.SQLException
PreparedStatementAdapter
setDate
in interface PreparedStatementAdapter
setDate
in class BasicRdbAdapter
java.sql.SQLException
public java.lang.String getCreateSequence(java.lang.String seqName) throws java.lang.UnsupportedOperationException
getCreateSequence
in interface SequenceAdapter
getCreateSequence
in class BasicRdbAdapter
java.lang.UnsupportedOperationException
public java.lang.String getCreateSequence(java.lang.String seqName, java.lang.Integer startid, java.lang.Integer inc, java.lang.Integer cache)
BasicRdbAdapter
getCreateSequence
in interface SequenceAdapter
getCreateSequence
in class BasicRdbAdapter
seqName
- startid
- inc
- protected void modifySelectClauseWithRange(java.lang.StringBuffer sb, boolean rangeStart, boolean rangeSize)
modifySelectClauseWithRange
in class BasicRdbAdapter
protected void modifyQueryWithRange(java.lang.StringBuffer sb, boolean rangeStart, boolean rangeSize)
modifyQueryWithRange
in class BasicRdbAdapter
public int getRangeParametersAtStart()
RdbAdapter
Indeed, depending on the database, the SQL syntax may vary, and the parameters can either be put at the front or at the end.
getRangeParametersAtStart
in interface RdbAdapter
getRangeParametersAtStart
in class BasicRdbAdapter
public java.lang.Object getArray(java.sql.ResultSet rs, int idx, java.lang.Object nullValue, int typeCode) throws java.sql.SQLException
ResultsetAdapter
getArray
in interface ResultsetAdapter
getArray
in class BasicRdbAdapter
java.sql.SQLException
public java.lang.String getArrayValueAsSQLString(java.lang.Object array, int typeCode, java.lang.String begin, java.lang.String realsep, java.lang.String end)
getArrayValueAsSQLString
in class BasicRdbAdapter
public boolean supportArray(int elemTypeCode)
supportArray
in interface TypeAdapter
supportArray
in class BasicRdbAdapter
|
|||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |