|
Oracle Fusion Middleware extensions for Logging and Diagnostic 11g Release 1 (11.1.1.6) E22565-06 |
|||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
java.lang.Object oracle.apps.fnd.appltest.diagfwk.engine.provider.dao.db.OADBBaseDAO
public abstract class OADBBaseDAO
Base class that all OADB specific DAO classes extend from.
This class provides from useful APIs for setting savepoints and rolling back transactions that can be used by all DAO objects.
Nested Class Summary |
---|
Nested classes/interfaces inherited from interface oracle.apps.fnd.appltest.diagfwk.engine.provider.dao.BaseDAO |
---|
BaseDAO.DBSessionInfo |
Field Summary | |
---|---|
protected java.lang.String |
langCode
|
Constructor Summary | |
---|---|
OADBBaseDAO()
|
Method Summary | |
---|---|
protected static void |
close(java.sql.ResultSet pRs)
This method closes the given ResultSet object and logs any SQLException that is thrown when attempting to close. |
protected static void |
close(java.sql.ResultSet pRs,
java.sql.Statement pStmt)
Helper method to close both a result set and a statement. |
protected static void |
close(java.sql.Statement pStmt)
This method closes the given Statement object and logs any SQLException that is thrown when attempting to close. |
java.lang.String |
createSysGuid()
Generates a new system GUID |
protected static java.sql.Clob |
getCLOB(java.sql.Connection pCon,
java.lang.String clobData)
This method uses temporary clob to create the CLOB object. |
protected static java.sql.Connection |
getConnection()
Returns a JDBC Connection to the database by calling the Connection provider. |
BaseDAO.DBSessionInfo |
getDBSessionInfo(DiagContextExtn context)
Retrieves the database session information for the connection encapsulated by the passed in context. |
protected int |
getJdbcBatchSize()
Returns the batch size when doing batch operations |
protected java.lang.String |
getLangCode()
|
static java.util.Date |
getSysDate()
Returns the system date |
static java.util.Date |
getSysDate(java.lang.String pRel)
Returns a date relative to sysdate as specified by pRel |
static java.lang.String |
getSysGuid()
Returns a system GUID |
protected static void |
populateWhoColumns(DiagBObj pObj,
java.sql.ResultSet pRs)
Populates the common WHO columns for the given diagnostic business object from the given SQL Result set. |
protected static void |
prepareWhoColumns(DiagBObj pObj)
Prepares the WHO column values for the given business object by calling the appropriate APIs from the SessionInfoProvider interface. |
java.lang.String[] |
queryNlsParameters(java.lang.String[] pNlsParameterNames)
Queries the values of the given NLS parameter names from the repository. |
java.util.Date |
querySysDate()
Queries the system date from the Applications database and returns it. |
java.util.Date |
querySysDate(java.lang.String pRel)
Returns a date relative to sysdate as specified by pRel |
protected static void |
returnConnection(java.sql.Connection pCon)
Returns the JDBC Connection back to the provider |
protected boolean |
rollBack(java.sql.Connection pCon,
java.sql.Savepoint pSvPt)
Rollsback to the given save point |
protected static void |
setFetchSize(java.sql.ResultSet pRs)
This method set the fetchsize for the given ResultSet object |
protected java.sql.Savepoint |
setSavepoint(java.sql.Connection pCon,
java.lang.String pSvPtName)
Sets a save point with the given name |
protected static int |
setWhoColumnsForInsert(DiagBObj pObj,
java.sql.PreparedStatement pStmt,
int pStartIndex)
Sets the WHO column values namely created_by, last_updated_by and last_update_login from the given business object into the given prepared statement. |
protected static int |
setWhoColumnsForUpdate(DiagBObj pObj,
java.sql.PreparedStatement pStmt,
int pStartIndex)
Sets the WHO column values namely last_updated_by and last_update_login from the given business object into the given prepared statement. |
Methods inherited from class java.lang.Object |
---|
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait |
Field Detail |
---|
protected java.lang.String langCode
Constructor Detail |
---|
public OADBBaseDAO()
Method Detail |
---|
protected java.lang.String getLangCode()
protected int getJdbcBatchSize()
protected java.sql.Savepoint setSavepoint(java.sql.Connection pCon, java.lang.String pSvPtName)
pCon
- pSvPtName
-
protected boolean rollBack(java.sql.Connection pCon, java.sql.Savepoint pSvPt)
pCon
- pSvPt
- protected static java.sql.Clob getCLOB(java.sql.Connection pCon, java.lang.String clobData)
protected static void close(java.sql.Statement pStmt)
pStmt
- Statement to close.protected static void close(java.sql.ResultSet pRs)
pRs
- ResultSet to close.protected static void close(java.sql.ResultSet pRs, java.sql.Statement pStmt)
pRs
- pStmt
- protected static void setFetchSize(java.sql.ResultSet pRs) throws java.sql.SQLException
pRs
- ResultSet for setting the fetch size.
java.sql.SQLException
protected static java.sql.Connection getConnection()
protected static void returnConnection(java.sql.Connection pCon)
pCon
- JDBC Connection to the databasepublic java.lang.String createSysGuid()
BaseDAO
createSysGuid
in interface BaseDAO
public static java.lang.String getSysGuid()
public static java.util.Date getSysDate()
public static java.util.Date getSysDate(java.lang.String pRel)
pRel
- a String such as "+1","-1" etc that indicates
a date relative to sysdate
public java.util.Date querySysDate()
BaseDAO
querySysDate
in interface BaseDAO
public java.util.Date querySysDate(java.lang.String pRel)
querySysDate
in interface BaseDAO
pRel
- a String such as "+1","-1" etc that indicates
a date relative to sysdate
public java.lang.String[] queryNlsParameters(java.lang.String[] pNlsParameterNames)
BaseDAO
queryNlsParameters
in interface BaseDAO
pNlsParameterNames
- The names of the NLS parameters to query
protected static void populateWhoColumns(DiagBObj pObj, java.sql.ResultSet pRs) throws java.sql.SQLException
pObj
- pRs
-
java.sql.SQLException
protected static int setWhoColumnsForInsert(DiagBObj pObj, java.sql.PreparedStatement pStmt, int pStartIndex) throws java.sql.SQLException
java.sql.SQLException
protected static int setWhoColumnsForUpdate(DiagBObj pObj, java.sql.PreparedStatement pStmt, int pStartIndex) throws java.sql.SQLException
java.sql.SQLException
protected static void prepareWhoColumns(DiagBObj pObj)
pObj
- the business object to populatepublic BaseDAO.DBSessionInfo getDBSessionInfo(DiagContextExtn context)
getDBSessionInfo
in interface BaseDAO
context
- a diag context object.
|
Oracle Fusion Middleware extensions for Logging and Diagnostic 11g Release 1 (11.1.1.6) E22565-06 |
|||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |