/** * Print the SQL representation of the statement on a stream. */ public DatabaseCall buildCall(AbstractSession session) { return buildCall(session, null); }
/** * Print the SQL representation of the statement on a stream. */ @Override public DatabaseCall buildCall(AbstractSession session) { return buildCall(session, null); }
/** * Print the SQL representation of the statement on a stream. */ public DatabaseCall buildCall(AbstractSession session) { return buildCall(session, null); }
if(value instanceof SQLSelectStatement) { SQLSelectStatement selStatement = (SQLSelectStatement)value; SQLCall selCall = (SQLCall)selStatement.buildCall(getSession()); databaseFieldsToValuesCopy.put(field, selCall); if(databaseFieldsToTableAliases == null) {
if(value instanceof SQLSelectStatement) { SQLSelectStatement selStatement = (SQLSelectStatement)value; SQLCall selCall = (SQLCall)selStatement.buildCall(getSession()); databaseFieldsToValuesCopy.put(field, selCall); if(databaseFieldsToTableAliases == null) {
if(value instanceof SQLSelectStatement) { SQLSelectStatement selStatement = (SQLSelectStatement)value; SQLCall selCall = (SQLCall)selStatement.buildCall(getSession()); databaseFieldsToValuesCopy.put(field, selCall); if(databaseFieldsToTableAliases == null) {
protected SQLModifyStatement buildUpdateAllStatementForOracleAnonymousBlock(HashMap tables_databaseFieldsToValues, HashMap tablesToPrimaryKeyFields) { SQLSelectStatement selectStatement = createSQLSelectStatementForUpdateAllForOracleAnonymousBlock(tables_databaseFieldsToValues); SQLCall selectCall = (SQLCall)selectStatement.buildCall(getSession()); SQLUpdateAllStatementForOracleAnonymousBlock updateAllStatement = new SQLUpdateAllStatementForOracleAnonymousBlock(); updateAllStatement.setTranslationRow(getTranslationRow()); updateAllStatement.setSelectCall(selectCall); updateAllStatement.setTables_databaseFieldsToValues(tables_databaseFieldsToValues); updateAllStatement.setTablesToPrimaryKeyFields(tablesToPrimaryKeyFields); updateAllStatement.setTable(getDescriptor().getTables().firstElement()); return updateAllStatement; }
protected SQLModifyStatement buildUpdateAllStatementForOracleAnonymousBlock(HashMap tables_databaseFieldsToValues, HashMap tablesToPrimaryKeyFields) { SQLSelectStatement selectStatement = createSQLSelectStatementForUpdateAllForOracleAnonymousBlock(tables_databaseFieldsToValues); SQLCall selectCall = (SQLCall)selectStatement.buildCall(getSession()); SQLUpdateAllStatementForOracleAnonymousBlock updateAllStatement = new SQLUpdateAllStatementForOracleAnonymousBlock(); updateAllStatement.setTranslationRow(getTranslationRow()); updateAllStatement.setSelectCall(selectCall); updateAllStatement.setTables_databaseFieldsToValues(tables_databaseFieldsToValues); updateAllStatement.setTablesToPrimaryKeyFields(tablesToPrimaryKeyFields); updateAllStatement.setTable(getDescriptor().getTables().firstElement()); return updateAllStatement; }
protected SQLModifyStatement buildUpdateAllStatementForOracleAnonymousBlock(HashMap tables_databaseFieldsToValues, HashMap tablesToPrimaryKeyFields) { SQLSelectStatement selectStatement = createSQLSelectStatementForUpdateAllForOracleAnonymousBlock(tables_databaseFieldsToValues); SQLCall selectCall = (SQLCall)selectStatement.buildCall(getSession()); SQLUpdateAllStatementForOracleAnonymousBlock updateAllStatement = new SQLUpdateAllStatementForOracleAnonymousBlock(); updateAllStatement.setTranslationRow(getTranslationRow()); updateAllStatement.setSelectCall(selectCall); updateAllStatement.setTables_databaseFieldsToValues(tables_databaseFieldsToValues); updateAllStatement.setTablesToPrimaryKeyFields(tablesToPrimaryKeyFields); updateAllStatement.setTable(getDescriptor().getTables().firstElement()); return updateAllStatement; }
SQLCall selectCall = (SQLCall)selectStatement.buildCall(getSession(), getQuery()); SQLUpdateAllStatementForTempTable insertStatement = new SQLUpdateAllStatementForTempTable(); insertStatement.setMode(SQLModifyAllStatementForTempTable.INSERT_INTO_TEMP_TABLE);
SQLCall selectCall = (SQLCall)selectStatement.buildCall(getSession(), getQuery()); SQLUpdateAllStatementForTempTable insertStatement = new SQLUpdateAllStatementForTempTable(); insertStatement.setMode(SQLModifyAllStatementForTempTable.INSERT_INTO_TEMP_TABLE);
SQLCall selectCall = (SQLCall)selectStatement.buildCall(getSession(), getQuery()); SQLUpdateAllStatementForTempTable insertStatement = new SQLUpdateAllStatementForTempTable(); insertStatement.setMode(SQLModifyAllStatementForTempTable.INSERT_INTO_TEMP_TABLE);
selectCallForExist = (SQLCall)selectStatementForExist.buildCall(getSession());
/** * Build the sql call from the select statement for selecting the locator */ private DatabaseCall buildCallFromSelectStatementForLocator(SQLSelectStatement selectStatement, WriteObjectQuery writeQuery, DatabaseCall dbCall, AbstractSession session) { DatabaseCall call = selectStatement.buildCall(session); // Locator LOB must not be wrapped (WLS wraps LOBs). call.setIsNativeConnectionRequired(this.isNativeConnectionRequired); //the LOB context must be passed into the new call object call.setContexts(dbCall.getContexts()); //need to explicitly define one row return, otherwise, EL assumes multiple rows return and confuses the accessor call.returnOneRow(); //the query object has to be set in order to access to the platform and login objects call.setQuery(writeQuery); // prepare it call.prepare(session); //finally do the translation call.translate(writeQuery.getTranslationRow(), writeQuery.getModifyRow(), session); return call; }
SQLCall selectCall = (SQLCall)selectStatement.buildCall(getSession()); SQLDeleteAllStatementForTempTable insertStatement = new SQLDeleteAllStatementForTempTable(); insertStatement.setMode(SQLModifyAllStatementForTempTable.INSERT_INTO_TEMP_TABLE);
/** * Build the sql call from the select statement for selecting the locator */ private DatabaseCall buildCallFromSelectStatementForLocator(SQLSelectStatement selectStatement, WriteObjectQuery writeQuery, DatabaseCall dbCall, AbstractSession session) { DatabaseCall call = selectStatement.buildCall(session); // Locator LOB must not be wrapped (WLS wraps LOBs). call.setIsNativeConnectionRequired(this.isNativeConnectionRequired); //the LOB context must be passed into the new call object call.setContexts(dbCall.getContexts()); //need to explicitly define one row return, otherwise, EL assumes multiple rows return and confuses the accessor call.returnOneRow(); //the query object has to be set in order to access to the platform and login objects call.setQuery(writeQuery); // prepare it call.prepare(session); //finally do the translation call.translate(writeQuery.getTranslationRow(), writeQuery.getModifyRow(), session); return call; }
SQLCall selectCall = (SQLCall)selectStatement.buildCall(getSession()); SQLDeleteAllStatementForTempTable insertStatement = new SQLDeleteAllStatementForTempTable(); insertStatement.setMode(SQLModifyAllStatementForTempTable.INSERT_INTO_TEMP_TABLE);
/** * Build the sql call from the select statement for selecting the locator */ private DatabaseCall buildCallFromSelectStatementForLocator(SQLSelectStatement selectStatement, WriteObjectQuery writeQuery, DatabaseCall dbCall, AbstractSession session) { DatabaseCall call = selectStatement.buildCall(session); // Locator LOB must not be wrapped (WLS wraps LOBs). call.setIsNativeConnectionRequired(this.isNativeConnectionRequired); //the LOB context must be passed into the new call object call.setContexts(dbCall.getContexts()); //need to explicitly define one row return, otherwise, EL assumes multiple rows return and confuses the accessor call.returnOneRow(); //the query object has to be set in order to access to the platform and login objects call.setQuery(writeQuery); // prepare it call.prepare(session); //finally do the translation call.translate(writeQuery.getTranslationRow(), writeQuery.getModifyRow(), session); return call; }
SQLCall selectCall = (SQLCall)selectStatement.buildCall(getSession()); SQLDeleteAllStatementForTempTable insertStatement = new SQLDeleteAllStatementForTempTable(); insertStatement.setMode(SQLModifyAllStatementForTempTable.INSERT_INTO_TEMP_TABLE);
selectCallForNotExist = (SQLCall)selectStatementForNotExist.buildCall(getSession()); selectCallForExist = (SQLCall)selectStatementForExist.buildCall(getSession()); SQLCall inheritanceSelectCallForExist = (SQLCall)inheritanceSelectStatementForExist.buildCall(getSession()); selectCallForExist = (SQLCall)selectStatementForExist.buildCall(getSession());