private void populateSearchBuilderItem(ResultSet rst, SearchBuilderItemImpl sbi)
throws SQLException {
sbi.setName(rst.getString(1));
sbi.setContext(rst.getString(2));
sbi.setSearchaction(Integer.valueOf(rst.getInt(3)));
sbi.setSearchstate(Integer.valueOf(rst.getInt(4)));
sbi.setVersion(rst.getDate(5));
sbi.setItemscope(Integer.valueOf(rst.getInt(6)));
sbi.setId(rst.getString(7));
}
/**
* get the Instance Master
*
* @return
* @throws HibernateException
*/
private SearchBuilderItem getMasterItem(Connection connection) throws SQLException {
log.debug("get Master Items with " + connection); // $NON-NLS-1$
PreparedStatement pst = null;
ResultSet rst = null;
try {
pst =
connection.prepareStatement(
"select " //$NON-NLS-1$
+ SEARCH_BUILDER_ITEM_FIELDS
+ " from " //$NON-NLS-1$
+ SEARCH_BUILDER_ITEM_T
+ " where itemscope = ? "); //$NON-NLS-1$
pst.clearParameters();
pst.setInt(1, SearchBuilderItem.ITEM_GLOBAL_MASTER.intValue());
rst = pst.executeQuery();
SearchBuilderItemImpl sbi = new SearchBuilderItemImpl();
if (rst.next()) {
populateSearchBuilderItem(rst, sbi);
} else {
sbi.setName(SearchBuilderItem.INDEX_MASTER);
sbi.setContext(SearchBuilderItem.GLOBAL_CONTEXT);
sbi.setSearchaction(SearchBuilderItem.ACTION_UNKNOWN);
sbi.setSearchstate(SearchBuilderItem.STATE_UNKNOWN);
sbi.setItemscope(SearchBuilderItem.ITEM_GLOBAL_MASTER);
}
return sbi;
} finally {
try {
rst.close();
} catch (Exception ex) {
log.debug(ex);
}
try {
pst.close();
} catch (Exception ex) {
log.debug(ex);
}
}
}
