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

  1. Get the Statement of the Execution Sql object

    • Statement createStatement();

    • Statement prepareStatement(String sql);

  2. 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