MogDBMogDB Stack
生态工具
v3.0
文档目录
文档:v3.0
支持的版本:
其他版本:

java.sql.Connection

java.sql.Connection是数据库连接接口。

表 1 对java.sql.Connection接口的支持情况

方法名 返回值类型 支持JDBC 4
abort(Executor executor) void Yes
clearWarnings() void Yes
close() void Yes
commit() void Yes
createArrayOf(String typeName, Object[] elements) Array Yes
createBlob() Blob Yes
createClob() Clob Yes
createSQLXML() SQLXML Yes
createStatement() Statement Yes
createStatement(int resultSetType, int resultSetConcurrency) Statement Yes
createStatement(int resultSetType, int resultSetConcurrency, int resultSetHoldability) Statement Yes
getAutoCommit() Boolean Yes
getCatalog() String Yes
getClientInfo() Properties Yes
getClientInfo(String name) String Yes
getHoldability() int Yes
getMetaData() DatabaseMetaData Yes
getNetworkTimeout() int Yes
getSchema() String Yes
getTransactionIsolation() int Yes
getTypeMap() Map<String,Class<?>> Yes
getWarnings() SQLWarning Yes
isClosed() Boolean Yes
isReadOnly() Boolean Yes
isValid(int timeout) boolean Yes
nativeSQL(String sql) String Yes
prepareCall(String sql) CallableStatement Yes
prepareCall(String sql, int resultSetType, int resultSetConcurrency) CallableStatement Yes
prepareCall(String sql, int resultSetType, int resultSetConcurrency, int resultSetHoldability) CallableStatement Yes
prepareStatement(String sql) PreparedStatement Yes
prepareStatement(String sql, int autoGeneratedKeys) PreparedStatement Yes
prepareStatement(String sql, int[] columnIndexes) PreparedStatement Yes
prepareStatement(String sql, int resultSetType, int resultSetConcurrency) PreparedStatement Yes
prepareStatement(String sql, int resultSetType, int resultSetConcurrency, int resultSetHoldability) PreparedStatement Yes
prepareStatement(String sql, String[] columnNames) PreparedStatement Yes
releaseSavepoint(Savepoint savepoint) void Yes
rollback() void Yes
rollback(Savepoint savepoint) void Yes
setAutoCommit(boolean autoCommit) void Yes
setClientInfo(Properties properties) void Yes
setClientInfo(String name,String value) void Yes
setHoldability(int holdability) void Yes
setNetworkTimeout(Executor executor, int milliseconds) void Yes
setReadOnly(boolean readOnly) void Yes
setSavepoint() Savepoint Yes
setSavepoint(String name) Savepoint Yes
setSchema(String schema) void Yes
setTransactionIsolation(int level) void Yes
setTypeMap(Map<String,Class<?>> map) void Yes

img 须知: 接口内部默认使用自动提交模式,若通过setAutoCommit(false)关闭自动提交,将会导致后面执行的语句都受到显式事务包裹,数据库中不支持事务中执行的语句不能在此模式下执行。

数据库
基于openGauss开源数据库进行定制,推出的企业发行
Kubernetes上的MogDB自动运维系统
关于
云和恩墨社区
MogDB联系我们
管理工具
高可用管理
图形化管理
部署运维工具
Migrate to MogDB解决方案
异构数据库迁移
异构数据同步
兼容性分析
数据一致性校验
文档工具
参数对比