MatrixOne's JDBC feature support list
Using JDBC to develop applications, MatrixOne supports the following classes and objects:
1. Connection (class): Get the database connection object
Methods in class
-
Get the Statement of the Execution Sql object
- Statement createStatement();
- Statement prepareStatement(String sql);
-
Manage transactions
- Open transaction: setAutoCommit(boolean autoCommit): Call this method to set the parameter to false, that is, start the transaction
- Submit transaction: void commit()
- Rollback transaction: void rollback()
| Methods in connection interface | Support (Y)/Not (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 million seconds) | Y |
| getNetworkTimeout() | Y |
2. Methods in Statement class
| Methods in Statement class | Support (Y)/Not (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. Methods in ResultSet interface
| Methods in ResultSet class | Support (Y)/Not (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 |
| First () | Y |
| Last () | Y |
| Getrow () | Y |
| Absolute () | Y |
| Relative () | Y |
| Previous () | Y |
| Setfetchdirection () | Y |
| GetFetchDirection () | Y |
| setfetchsize () | Y |
| GetFetchSize () | Y |
| GetTTYPE () | Y |
| GetConCurrency () | Y |
| ROWUPDATED () | Y |
| rowinserty () | Y |
| Rowdeleted () | Y |
| Update () (Serial data type Serial data type) | Y |
| Updatenull () | Y |
4. Methods in Resistemetadata
| Methods in ResutsTemetadata class | Supported (Y) / Not supported (N) |
|---|---|
| GetColumNcount () | Y |
| isautoincrement () | Y |
| Iscasesensitive () | Y |
| issearchable () | Y |
| Iscurrency () | Y |
| isnullable () | Y |
| ISSIGNED () | Y |
| getcolumndiskey () | Y |
| GetColumnlabel () | Y |
| getcolumname () | Y |
| Getschemaname () | N |
| GetPrecision () | Y |
| Getscale () | Y |
| Gettabblename () | Y |
| Getcatalogname () | Y |
| GetColumntype () | Y |
| GetColumNtypename () | Y |
| Isreadonly () | N |
| ISWRITABLE () | N |
| isdefinitywritable () | N |
| GetColumnClassname () | Y |
MySQL data types DISPLLSSize, Prec, Scale statistics
| Data type | 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 (depending on the actual situation) | 17 | 15 | 2 |
| Decimal128 (depending on the actual situation) | 23 | 21 | 3 |
| Float | 12 | 12 | 31 |
| Double | 22 | 22 | 31 |
| Varchar (depending on the actual situation) | 100 | 100 | 0 |
| Char (depending on the actual situation) | 100 | 100 | 0 |
| Date | 10 | 10 | 0 |
| DATETIME | 19 | 19 | 0 |
| Timestamp | 19 | 19 | 0 |
| JSON | 2147483647 | 2147483647 | 0 |