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
All Methods Static Methods Instance Methods Concrete Methods Modifier and Type Method Description 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.-
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
-
-
-
-
Constructor Detail
-
CmsSqlManager
public CmsSqlManager()
- See Also:
CmsSqlManager()
-
-
Method Detail
-
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.- Parameters:
sqlManager
- the sql manager to usedbc
- the current database contextcon
- the JDBC connectionstmnt
- the statementres
- the result setcommit
- the additional statement for the 'commit' commandwasInTransaction
- if using transactions
-
getBytes
public byte[] getBytes(java.sql.ResultSet res, java.lang.String attributeName) throws java.sql.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 classCmsSqlManager
- Parameters:
res
- the result setattributeName
- the name of the table attribute- Returns:
- byte[] the column value; if the value is SQL NULL, the value returned is null
- Throws:
java.sql.SQLException
- if a database access error occurs- See Also:
CmsSqlManager.getBytes(java.sql.ResultSet, java.lang.String)
-
-