mo-jdbc-feature-list.md

JDBC supported features list in MatrixOne

Using JDBC to develop applications, MatrixOne supports the following classes and objects:

1. Connection (Class): Get the database connection object

Method of the Class

1. Obtain the executed Sql object Statement

   • Statement createStatement();
   • Statement prepareStatement(String sql);

2. Manage the transaction

   • Enable the transaction: setAutoCommit(boolean autoCommit), call this method to set the parameter to false, which enable the transaction
   • Commit the transaction: void commit()
   • Rollback the transaction: void rollback()

Methon of the connection interface	Supported(Y)/Not support(N)
createStatement()	Y
prepareStatement(String sql)	Y
prepareCall(String sql)	Y
nativeSQL(String sql)	Y
setAutoCommit(boolean autoCommit)	Y
getAutoCommit()	Y
commit()	Y
rollback()	Y
close()	Y
isClosed()	Y
getMetaData()	Y
setReadOnly(boolean readOnly)	Y
isReadOnly()	Y
setCatalog()	Y
getCatalog()	Y
setTransactionIsolation(int level)	N
getTransactionIsolation()	N
getWarnings()	N
clearWarnings()	N
createStatement(int resultSetType, int resultSetConcurrency)	Y
prepareStatement(String sql, int resultSetType, int resultSetConcurrency)	Y
prepareCall(String sql, int resultSetType, int resultSetConcurrency)	Y
getTypeMap()	N
setTypeMap(java.util.Map<String,Class<?>> map)	N
setHoldability(int holdability)	N
getHoldability()	N
setSavepoint()	N
setSavepoint(String name)	N
rollback(Savepoint savepoint)	N
releaseSavepoint(Savepoint savepoint)	N
createStatement(int resultSetType, int resultSetConcurrency, int resultSetHoldability)	Y
prepareStatement(String sql, int resultSetType, int resultSetConcurrency, int resultSetHoldability)	Y
prepareCall(String sql, int resultSetType, int resultSetConcurrency, int resultSetHoldability)	Y
prepareStatement(String sql, int autoGeneratedKeys)	Y
prepareStatement(String sql, int columnIndexes[])	Y
prepareStatement(String sql, String columnNames[])	Y
createClob()	N
createBlob()	N
createNClob()	N
createSQLXML()	N
isValid()	Y
setClientInfo(String name, String value)	N
setClientInfo(Properties properties)	N
getClientInfo(String name)	N
getClientInfo()	N
createArrayOf(String typeName, Object[] elements)	N
createStruct(String typeName, Object[] attributes)	N
setSchema(String schema)	N
getSchema()	N
abort(Executor executor)	N
setNetworkTimeout(Executor executor, int milliseconds)	Y
getNetworkTimeout()	Y

2. Method of the Statement class

Method of the Statement class	Supported(Y)/Not support(N)
executeQuery(String sql)	Y
executeUpdate(String sql)	Y
close()	Y
getMaxFieldSize()	Y
setMaxFieldSize()	Y
getMaxRows()	Y
setMaxRows()	Y
setEscapeProcessing()	N
getQueryTimeout()	Y
setQueryTimeout(int seconds)	Y
cancel()	Y
getWarnings()	N
clearWarnings()	N
setCursorName(String name)	N
execute(String sql)	Y
getResultSet()	Y
getUpdateCount()	Y
getMoreResults()	Y
setFetchDirection(int direction)	Y
getFetchDirection()	N
setFetchSize(int rows)	Y
getFetchSize()	Y
getResultSetConcurrency()	Y
getResultSetType()	Y
addBatch( String sql)	Y
clearBatch()	Y
executeBatch()	Y
getConnection()	Y
getMoreResults(int current)	Y
getGeneratedKeys()	Y
executeUpdate(String sql, int autoGeneratedKeys)	Y
executeUpdate(String sql, int columnIndexes[])	Y
executeUpdate(String sql, String columnNames[])	Y
execute(String sql, int autoGeneratedKeys)	Y
execute(String sql, int columnIndexes[])	Y
execute(String sql, String columnNames[])	Y
getResultSetHoldability()	Y
isClosed()	Y
setPoolable(boolean poolable)	N
isPoolable()	N
closeOnCompletion()	Y
isCloseOnCompletion()	Y

3. Method of the ResultSet class

Method of the ResultSet class	Supported(Y)/Not support(N)
next()	Y
close()	Y
wasNull()	Y
getString(int columnIndex)	Y
getBoolean(int columnIndex)	Y
getByte(int columnIndex)	Y
getShort(int columnIndex)	Y
getInt(int columnIndex)	Y
getLong(int columnIndex)	Y
getFloat(int columnIndex)	Y
getDouble(int columnIndex)	Y
getBigDecimal(int columnIndex, int scale)	Y
getBytes(int columnIndex)	Y
getDate(int columnIndex)	Y
getTime(int columnIndex)	Y
getTimestamp(int columnIndex)	Y
getAsciiStream(int columnIndex)	Y
getUnicodeStream(int columnIndex)	Y
getBinaryStream(int columnIndex)	Y
getWarnings()	N
clearWarnings()	N
getCursorName()	N
getMetaData()	Y
getObject()	N
findColumn()	Y
getCharacterStream()	Y
isBeforeFirst()	Y
isAfterLast()	Y
isFirst()	Y
isLast()	Y
beforeFirst()	Y
afterLast()	Y
first()	Y
last()	Y
getRow()	Y
absolute()	Y
relative()	Y
previous()	Y
setFetchDirection()	Y
getFetchDirection()	Y
setFetchSize()	Y
getFetchSize()	Y
getType()	Y
getConcurrency()	Y
rowUpdated()	Y
rowInserted()	Y
rowDeleted()	Y
update()(String of data types)	Y
updateNull()	Y

4. Method of the ResultSetMetaData

Method of the ResultSetMetaData	Supported(Y)/Not support(N)
getColumnCount()	Y
isAutoIncrement()	Y
isCaseSensitive()	Y
isSearchable()	Y
isCurrency()	Y
isNullable()	Y
isSigned()	Y
getColumnDisplaySize()	Y
getColumnLabel()	Y
getColumnName()	Y
getSchemaName()	N
getPrecision()	Y
getScale()	Y
getTableName()	Y
getCatalogName()	Y
getColumnType()	Y
getColumnTypeName()	Y
isReadOnly()	N
isWritable()	N
isDefinitelyWritable()	N
getColumnClassName()	Y

DisplaySize, Prec, and Scale statistics of Mysql data type

Data types	DisplaySize	Prec	Scale
TINYINT	4	4	0
SMALLINT	6	6	0
INT	11	11	0
BIGINT	20	20	0
TINYINT UNSIGNED	3	3	0
SMALLINT UNSIGNED	5	5	0
INT UNSIGNED	10	10	0
BIGINT UNSIGNED	20	20	0
DECIMAL64(according to the actual)	17	15	2
DECIMAL128(according to the actual)	23	21	3
FLOAT	12	12	31
DOUBLE	22	22	31
VARCHAR(according to the actual)	100	100	0
CHAR(according to the actual)	100	100	0
DATE	10	10	0
DATETIME	19	19	0
TIMESTAMP	19	19	0
JSON	2147483647	2147483647	0