Package org.opencms.db.oracle

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

Since:

6.0.0

Field Summary

Fields inherited from class org.opencms.db.generic.CmsSqlManager

m_cachedQueries, m_driverType, m_poolUrl, m_queries, QUERY_PROJECT_SEARCH_PATTERN

Constructor Summary

Constructors

Constructor	Description
CmsSqlManager()

Method Summary

Modifier and Type	Method	Description
static void	closeAllInTransaction(CmsSqlManager sqlManager, CmsDbContext dbc, Connection con, PreparedStatement stmnt, ResultSet res, PreparedStatement commit, boolean wasInTransaction)	Attempts to close the connection, statement and result set after a statement has been executed.
byte[]	getBytes(ResultSet res, 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.

Methods inherited from class org.opencms.db.generic.CmsSqlManager

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

Methods inherited from class org.opencms.db.CmsSqlManager

getActiveConnections, getConnection, getConnectionByUrl, getDbPoolUrls, getDefaultDbPoolName, getIdleConnections

Methods inherited from class java.lang.Object

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

Constructor Details

CmsSqlManager

public CmsSqlManager()

See Also:

• CmsSqlManager()

Method Details

closeAllInTransaction

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

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

Parameters:

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(ResultSet res,
 String attributeName)
                throws SQLException

Description copied from class: 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.

Overrides:

getBytes in class CmsSqlManager

Parameters:

res - the result set

attributeName - the name of the table attribute

Returns:

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

Throws:

SQLException - if a database access error occurs

See Also:

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