Skip to content

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