#java.sql.Connection

Connection接口用于建立JDBC客户端到数据库的连接,通过DriverManager.getConnection(url, user, password) 方法获取。

YashanDB JDBC驱动对connection接口已支持功能(单机部署/共享集群/分布式集群部署):

返回类型 方法 备注
Statement createStatement() -
Clob createClob() -
Blob createBlob() -
Statement createStatement(int resultSetType, int resultSetConcurrency) -
Statement createStatement(int resultSetType, int resultSetConcurrency, int resultSetHoldability) -
PreparedStatement prepareStatement(String sql, int resultSetType, int resultSetConcurrency, int resultSetHoldability) -
PreparedStatement prepareStatement(String sql) -
PreparedStatement prepareStatement(String sql, int resultSetType,int resultSetConcurrency) -
PreparedStatement prepareStatement(String sql, int autoGeneratedKeys) -
PreparedStatement PreparedStatement prepareStatement(String sql, int columnIndexes[]) -
PreparedStatement PreparedStatement prepareStatement(String sql, String columnNames[]) -
Properties getClientInfo() -
CallableStatement prepareCall(String sql) -
void setAutoCommit(boolean autoCommit) -
boolean getAutoCommit() -
void commit() -
void rollback() -
void close() -
void setClientInfo(String name, String value)
void setClientInfo(Properties properties)
String getClientInfo(String name)
boolean isClosed() -
DatabaseMetaData getMetaData() -
boolean isReadOnly() -
void setTransactionIsolation(int level) 支持以下三个值:
Connection.TRANSACTION_READ_COMMITTED = 2
Connection.TRANSACTION_SERIALIZABLE = 8
YasConnection.TRANSACTION_READ_CURRENT_COMMITTED = 3
int getTransactionIsolation() -
java.util.Map<String,Class<?>> getTypeMap() -
void setTypeMap(java.util.Map<String,Class<?>> map) -
int getHoldability() -
Savepoint setSavepoint() -
Savepoint setSavepoint(String name) -
Struct createStruct(String typeName, Object[] attributes) -
void rollback(Savepoint savepoint) -
boolean isValid(int timeout) -
void setSchema(String schema) -
String getSchema() -
Struct createStruct(String typeName, Object[] attributes) -
void abort(Executor executor) -
void setNetworkTimeout(Executor executor, int milliseconds) -
int getNetworkTimeout() -
CallableStatement prepareCall(String sql, int resultSetType, int resultSetConcurrency) -
CallableStatement prepareCall(String sql, int resultSetType, int resultSetConcurrency,int resultSetHoldability) -
SQLXML createSQLXML() -
void releaseSavepoint(Savepoint savepoint) -

YashanDB JDBC驱动对connection接口已支持功能(存算一体分布式集群部署):

返回类型 方法 备注
Statement createStatement() -
Statement createStatement(int resultSetType, int resultSetConcurrency) -
Statement createStatement(int resultSetType, int resultSetConcurrency, int resultSetHoldability) -
PreparedStatement prepareStatement(String sql, int resultSetType, int resultSetConcurrency, int resultSetHoldability) -
CallableStatement prepareCall(String sql) -
CallableStatement prepareCall(String sql, int resultSetType, int resultSetConcurrency) -
CallableStatement prepareCall(String sql, int resultSetType, int resultSetConcurrency,int resultSetHoldability) -
PreparedStatement prepareStatement(String sql, int resultSetType,int resultSetConcurrency) -
PreparedStatement prepareStatement(String sql) -
Properties getClientInfo() -
void setAutoCommit(boolean autoCommit) -
boolean getAutoCommit() -
void commit() -
void rollback() -
void close() -
void setClientInfo(String name, String value) -
void setClientInfo(Properties properties) -
String getClientInfo(String name) -
boolean isClosed() -
DatabaseMetaData getMetaData() -
boolean isReadOnly() -
java.util.Map<String,Class<?>> getTypeMap() -
void setTypeMap(java.util.Map<String,Class<?>> map) -
int getHoldability() -
boolean isValid(int timeout) -
void setSchema(String schema) -
String getSchema() -
void abort(Executor executor) -
void setNetworkTimeout(Executor executor, int milliseconds) -
int getNetworkTimeout() -
Clob createClob() -
Blob createBlob() -
Savepoint setSavepoint() -
Savepoint setSavepoint(String name) -
Struct createStruct(String typeName, Object[] attributes) -
void rollback(Savepoint savepoint) -
SQLXML createSQLXML() -
void setHoldability(int holdability) -
void setTransactionIsolation(int level) 只支持一个取值:Connection.TRANSACTION_READ_COMMITTED = 2
int getTransactionIsolation() -
void releaseSavepoint(Savepoint savepoint) -

未支持功能(单机部署/共享集群/分布式集群部署):

返回类型 方法
String nativeSQL(String sql)
void setReadOnly(boolean readOnly)
SQLWarning getWarnings()
void clearWarnings()
void setHoldability(int holdability)
NClob createNClob()
Array createArrayOf(String typeName, Object[] elements)
void setCatalog(String catalog)
String getCatalog()

未支持功能(存算一体分布式集群部署):

返回类型 方法
void setReadOnly(boolean readOnly)
String nativeSQL(String sql)
SQLWarning getWarnings()
void clearWarnings()
PreparedStatement prepareStatement(String sql, int autoGeneratedKeys)
PreparedStatement prepareStatement(String sql, int columnIndexes[])
PreparedStatement prepareStatement(String sql, String columnNames[])
NClob createNClob()
Array createArrayOf(String typeName, Object[] elements)
void setCatalog(String catalog)
String getCatalog()

YashanDB JDBC驱动YasConnection扩展接口功能:

返回类型 方法 说明
void setClientPrepare(boolean clientPrepare) 表示对于绑定参数执行场景,是否开启直接执行;默认不开启,JDBC客户端会先向服务端发送prepare命令然后发送绑定参数执行;若开启,则会将prepareStatement的SQL语句和要绑定的参数一次性发给服务端,减少交互次数。
示例:
Connection conn = getConnection("sales", "sales");
((YasConnection)conn).setClientPrepare(true);
void registerTAFCallback(YasFailover yasFailover, Object ctxt) 注册TAF回调函数的实现类,如果注册了回调函数,failoverRetries和failoverDelay参数不生效,TAF链接失败时不会尝试进行重连。详细见TAF相关接口
Array createArray(String typeName, Object[] elements) 根据Array的Name创建Array对象,用来替代createArrayOf接口
boolean getClientPrepare(); 是否开启直接执行。
int getDefaultFetchSize() -
void setDefaultFetchSize(int fetchSize) -
string getSessionTimeZoneOffset() 获取当前连接的时区偏移量。
void setSessionTimeZoneOffset(String timeZone) 设置当前连接的时区偏移量。
pdf-btn 下载文档 copy-btn 复制链接
edit-icon
反馈
coperate-icon
coperate
合作
communication-icon
communicate
交流