org.opencms.db.oracle

类 CmsSqlManager

java.lang.Object

org.opencms.db.CmsSqlManager

org.opencms.db.generic.CmsSqlManager

org.opencms.db.oracle.CmsSqlManager

public class CmsSqlManager
extends CmsSqlManager

Oracle implementation of the SQL manager.

从以下版本开始:

6.0.0

字段概要

从类继承的字段 org.opencms.db.generic.CmsSqlManager

m_cachedQueries, m_driverType, m_poolUrl, m_queries, QUERY_PROJECT_SEARCH_PATTERN

构造器概要

构造器

构造器和说明
CmsSqlManager()

方法概要

方法

限定符和类型	方法和说明
static void	closeAllInTransaction(CmsSqlManager sqlManager, CmsDbContext dbc, java.sql.Connection con, java.sql.PreparedStatement stmnt, java.sql.ResultSet res, java.sql.PreparedStatement commit, boolean wasInTransaction) Attempts to close the connection, statement and result set after a statement has been executed.
byte[]	getBytes(java.sql.ResultSet res, java.lang.String attributeName) Retrieves the value of the designated column in the current row of this ResultSet object as a byte array in the Java programming language.

从类继承的方法 org.opencms.db.generic.CmsSqlManager

closeAll, getConnection, getInstance, getPreparedStatement, getPreparedStatement, getPreparedStatement, getPreparedStatementForSql, init, loadQueryProperties, readQuery, readQuery, readQuery, replaceProjectPattern, replaceQuerySearchPatterns, setBytes, validateEmpty

从类继承的方法 org.opencms.db.CmsSqlManager

getActiveConnections, getConnection, getConnectionByUrl, getDbPoolUrls, getDefaultDbPoolName, getIdleConnections

从类继承的方法 java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

构造器详细资料

CmsSqlManager

public CmsSqlManager()

另请参阅:

CmsSqlManager.CmsSqlManager()

方法详细资料

closeAllInTransaction

public static void closeAllInTransaction(CmsSqlManager sqlManager,
                         CmsDbContext dbc,
                         java.sql.Connection con,
                         java.sql.PreparedStatement stmnt,
                         java.sql.ResultSet res,
                         java.sql.PreparedStatement commit,
                         boolean wasInTransaction)

Attempts to close the connection, statement and result set after a statement has been executed.

参数:

sqlManager - the sql manager to use

dbc - the current database context

con - the JDBC connection

stmnt - the statement

res - the result set

commit - the additional statement for the 'commit' command

wasInTransaction - if using transactions

getBytes

public byte[] getBytes(java.sql.ResultSet res,
              java.lang.String attributeName)
                throws java.sql.SQLException

从类复制的说明: CmsSqlManager

Retrieves the value of the designated column in the current row of this ResultSet object as a byte array in the Java programming language.

The bytes represent the raw values returned by the driver. Overwrite this method if another database server requires a different handling of byte attributes in tables.

覆盖:

getBytes 在类中 CmsSqlManager

参数:

res - the result set

attributeName - the name of the table attribute

返回:

byte[] the column value; if the value is SQL NULL, the value returned is null

抛出:

java.sql.SQLException - if a database access error occurs

另请参阅:

CmsSqlManager.getBytes(java.sql.ResultSet, java.lang.String)