private long[] queryForMinMax(String sql, Object... params) { long[] minMax = sqlTemplate.queryForObject(sql, new ISqlRowMapper<long[]>() { public long[] mapRow(Row rs) { return new long[] { rs.getLong("min_id"), rs.getLong("max_id") }; } }, params); return minMax; }
public String getDefaultSchema() { if (StringUtils.isBlank(defaultSchema)) { defaultSchema = (String) getSqlTemplate().queryForObject("select SCHEMA()", String.class); } return defaultSchema; }
public String getDefaultCatalog() { if (StringUtils.isBlank(defaultCatalog)) { defaultCatalog = (String) getSqlTemplate().queryForObject("select DATABASE()", String.class); } return defaultCatalog; }
public String getDefaultSchema() { if (StringUtils.isBlank(defaultSchema)) { defaultSchema = (String) getSqlTemplate().queryForObject("select USER_NAME()", String.class); } return defaultSchema; }
public String getDefaultSchema() { if (StringUtils.isBlank(defaultSchema)) { defaultSchema = (String) getSqlTemplate().queryForObject("select current_schema()", String.class); } return defaultSchema; }
public String getDefaultCatalog() { if (StringUtils.isBlank(defaultCatalog)) { defaultCatalog = getSqlTemplate().queryForObject("select DB_NAME()", String.class); } return defaultCatalog; }
public String getDefaultSchema() { if (StringUtils.isBlank(defaultSchema)) { defaultSchema = (String) getSqlTemplate().queryForObject("select SCHEMA_NAME()", String.class); } return defaultSchema; }
public String getDefaultSchema() { if (StringUtils.isBlank(defaultSchema)) { defaultSchema = (String) getSqlTemplate().queryForObject("select USER_NAME()", String.class); } return defaultSchema; }
public String getDefaultSchema() { if (StringUtils.isBlank(defaultSchema)) { defaultSchema = (String) getSqlTemplate().queryForObject("values CURRENT SCHEMA", String.class); } return defaultSchema; }
public String getDefaultCatalog() { if (StringUtils.isBlank(defaultCatalog)) { defaultCatalog = getSqlTemplate().queryForObject("select database()", String.class); } return defaultCatalog; }
public String getDefaultSchema() { if (StringUtils.isBlank(defaultSchema)) { defaultSchema = (String) getSqlTemplate().queryForObject("values CURRENT SCHEMA", String.class); } return defaultSchema; }
public String getDefaultSchema() { if (StringUtils.isBlank(defaultSchema)) { defaultSchema = (String) getSqlTemplate().queryForObject( "SELECT sys_context('USERENV', 'CURRENT_SCHEMA') FROM dual", String.class); } return defaultSchema; }
public String getDefaultCatalog() { if (StringUtils.isBlank(defaultCatalog)) { defaultCatalog = getSqlTemplate().queryForObject("select DB_NAME()", String.class); } return defaultCatalog; }
public String getDefaultCatalog() { if (defaultCatalog == null) { defaultCatalog = (String) getSqlTemplate() .queryForObject( "select value from INFORMATION_SCHEMA.SYSTEM_SESSIONINFO where key='CURRENT SCHEMA'", String.class); } return defaultCatalog; }
public String getDefaultSchema() { if (StringUtils.isBlank(defaultSchema)) { defaultSchema = getSqlTemplate().queryForObject("select trim(user) from sysmaster:sysdual", String.class); } return defaultSchema; }
public TriggerHistory getTriggerHistory(int histId) { TriggerHistory history = historyMap.get(histId); if (history == null && histId >= 0) { history = (TriggerHistory) sqlTemplate.queryForObject(getSql("triggerHistSql"), new TriggerHistoryMapper(), histId); historyMap.put(histId, history); } return history; }
public FileTriggerRouter getFileTriggerRouter(String triggerId, String routerId) { return sqlTemplate.queryForObject( getSql("selectFileTriggerRoutersSql", "whereTriggerRouterId"), new FileTriggerRouterMapper(), triggerId, routerId); }
public IncomingBatch findIncomingBatch(long batchId, String nodeId) { return sqlTemplate.queryForObject( getSql("selectIncomingBatchPrefixSql", "findIncomingBatchSql"), new IncomingBatchMapper(), batchId, nodeId); }
public FileTrigger getFileTrigger(String triggerId) { return sqlTemplate.queryForObject(getSql("selectFileTriggersSql", "triggerIdWhere"), new FileTriggerMapper(), triggerId); }
public NodeCommunication find(String nodeId, CommunicationType communicationType) { NodeCommunication lock = sqlTemplate.queryForObject( getSql("selectNodeCommunicationByNodeIdSql"), new NodeCommunicationMapper(), nodeId, communicationType.name()); if (lock == null) { lock = new NodeCommunication(); lock.setNodeId(nodeId); lock.setCommunicationType(communicationType); save(lock); } return lock; }