public int update(String statement, Object parameters) { String updateStatement = dbSqlSessionFactory.mapStatement(statement); return getSqlSession().update(updateStatement, parameters); }
@Override public List<String> getDeploymentResourceNames(String deploymentId) { return getDbSqlSession().getSqlSession().selectList("selectResourceNamesByDeploymentId", deploymentId); }
@Override public void deleteEventLogEntry(long logNr) { getDbSqlSession().getSqlSession().delete("deleteEventLogEntry", logNr); }
@Override public ResultType execute(CommandContext commandContext) { Mapper mapper = commandContext.getDbSqlSession().getSqlSession().getMapper(mapperClass); return customSqlExecution.execute(mapper); }
public Session openSession(CommandContext commandContext) { DbSqlSession dbSqlSession = new DbSqlSession(this, commandContext.getEntityCache()); if (getDatabaseSchema() != null && getDatabaseSchema().length() > 0) { try { dbSqlSession.getSqlSession().getConnection().setSchema(getDatabaseSchema()); } catch (SQLException e) { throw new ActivitiException("Could not set database schema on connection", e); } } if (getDatabaseCatalog() != null && getDatabaseCatalog().length() > 0) { try { dbSqlSession.getSqlSession().getConnection().setCatalog(getDatabaseCatalog()); } catch (SQLException e) { throw new ActivitiException("Could not set database catalog on connection", e); } } return dbSqlSession; }
try { result.setTableName(tableName); DatabaseMetaData metaData = getDbSqlSession().getSqlSession().getConnection().getMetaData();
Connection connection = null; try { connection = getDbSqlSession().getSqlSession().getConnection(); DatabaseMetaData databaseMetaData = connection.getMetaData(); ResultSet tables = null;
@Override @SuppressWarnings("unchecked") public TablePage getTablePage(TablePageQueryImpl tablePageQuery, int firstResult, int maxResults) { TablePage tablePage = new TablePage(); @SuppressWarnings("rawtypes") List tableData = getDbSqlSession().getSqlSession().selectList("selectTableData", tablePageQuery, new RowBounds(firstResult, maxResults)); tablePage.setTableName(tablePageQuery.getTableName()); tablePage.setTotal(getTableCount(tablePageQuery.getTableName())); tablePage.setRows((List<Map<String, Object>>) tableData); tablePage.setFirstResult(firstResult); return tablePage; }
@Override @SuppressWarnings({ "unchecked", "rawtypes" }) public List<String> findUserInfoKeysByUserIdAndType(String userId, String type) { Map<String, String> parameters = new HashMap<String, String>(); parameters.put("userId", userId); parameters.put("type", type); return (List) getDbSqlSession().getSqlSession().selectList("selectIdentityInfoKeysByUserIdAndType", parameters); }
@SuppressWarnings("unchecked") public List<String> findUserInfoKeysByUserIdAndType(String userId, String type) { Map<String, String> parameters = new HashMap<String, String>(); parameters.put("userId", userId); parameters.put("type", type); return (List) getDbSqlSession().getSqlSession().selectList("selectIdentityInfoKeysByUserIdAndType", parameters); }
@SuppressWarnings("unchecked") public List<String> findUserInfoKeysByUserIdAndType(String userId, String type) { Map<String, String> parameters = new HashMap<String, String>(); parameters.put("userId", userId); parameters.put("type", type); return (List) getDbSqlSession().getSqlSession().selectList("selectIdentityInfoKeysByUserIdAndType", parameters); } }
@Override public List<IdentityInfoEntity> findIdentityInfoDetails(String identityInfoId) { return getDbSqlSession().getSqlSession().selectList("selectIdentityInfoDetails", identityInfoId); }
public int update(String statement, Object parameters) { String updateStatement = dbSqlSessionFactory.mapStatement(statement); return getSqlSession().update(updateStatement, parameters); }
@Override public void deleteEventLogEntry(long logNr) { getDbSqlSession().getSqlSession().delete("deleteEventLogEntry", logNr); }
protected List<IdentityInfoEntity> findIdentityInfoDetails(String identityInfoId) { return Context .getCommandContext() .getDbSqlSession() .getSqlSession() .selectList("selectIdentityInfoDetails", identityInfoId); }
@Override public ResultType execute(CommandContext commandContext) { Mapper mapper = commandContext.getDbSqlSession().getSqlSession().getMapper(mapperClass); return customSqlExecution.execute(mapper); }
@Override public ResultType execute(CommandContext commandContext) { Mapper mapper = commandContext.getDbSqlSession().getSqlSession().getMapper(mapperClass); return customSqlExecution.execute(mapper); }
@Override @SuppressWarnings("unchecked") public TablePage getTablePage(TablePageQueryImpl tablePageQuery, int firstResult, int maxResults) { TablePage tablePage = new TablePage(); @SuppressWarnings("rawtypes") List tableData = getDbSqlSession().getSqlSession().selectList("selectTableData", tablePageQuery, new RowBounds(firstResult, maxResults)); tablePage.setTableName(tablePageQuery.getTableName()); tablePage.setTotal(getTableCount(tablePageQuery.getTableName())); tablePage.setRows((List<Map<String, Object>>) tableData); tablePage.setFirstResult(firstResult); return tablePage; }
@SuppressWarnings("unchecked") public TablePage getTablePage(TablePageQueryImpl tablePageQuery, int firstResult, int maxResults) { TablePage tablePage = new TablePage(); @SuppressWarnings("rawtypes") List tableData = getDbSqlSession().getSqlSession() .selectList("selectTableData", tablePageQuery, new RowBounds(firstResult, maxResults)); tablePage.setTableName(tablePageQuery.getTableName()); tablePage.setTotal(getTableCount(tablePageQuery.getTableName())); tablePage.setRows((List<Map<String, Object>>) tableData); tablePage.setFirstResult(firstResult); return tablePage; }
@SuppressWarnings("unchecked") public TablePage getTablePage(TablePageQueryImpl tablePageQuery, int firstResult, int maxResults) { TablePage tablePage = new TablePage(); @SuppressWarnings("rawtypes") List tableData = getDbSqlSession().getSqlSession() .selectList("selectTableData", tablePageQuery, new RowBounds(firstResult, maxResults)); tablePage.setTableName(tablePageQuery.getTableName()); tablePage.setTotal(getTableCount(tablePageQuery.getTableName())); tablePage.setRows((List<Map<String,Object>>)tableData); tablePage.setFirstResult(firstResult); return tablePage; }