private final static Logger s_logger = Logger.getLogger(GenericDaoBase.class);

protected final static TimeZone s_gmtTimeZone = TimeZone.getTimeZone("GMT");

protected final static Map<Class<?>, GenericDao<?, ? extends Serializable>> s_daoMaps = new ConcurrentHashMap<Class<?>, GenericDao<?, ? extends Serializable>>(71);

protected Class<T> _entityBeanType;

protected String _table;

protected String _tables;

protected Field[] _embeddedFields;

// This is private on purpose. Everyone should use createPartialSelectSql()

private final Pair<StringBuilder, Attribute[]> _partialSelectSql;

private final Pair<StringBuilder, Attribute[]> _partialQueryCacheSelectSql;

protected StringBuilder _discriminatorClause;

protected Map<String, Object> _discriminatorValues;

protected String _selectByIdSql;

protected String _count;

protected Field _idField;

protected List<Pair<String, Attribute[]>> _insertSqls;

protected Pair<String, Attribute> _removed;

protected Pair<String, Attribute[]> _removeSql;

protected List<Pair<String, Attribute[]>> _deleteSqls;

protected Map<String, Attribute[]> _idAttributes;

protected Map<String, TableGenerator> _tgs;

protected Map<String, Attribute> _allAttributes;

protected List<Attribute> _ecAttributes;

protected Map<Pair<String, String>, Attribute> _allColumns;

protected Enhancer _enhancer;

protected Factory _factory;

protected Enhancer _searchEnhancer;

protected int _timeoutSeconds;

protected final static CallbackFilter s_callbackFilter = new UpdateFilter();

protected static final String FOR_UPDATE_CLAUSE = " FOR UPDATE ";

protected static final String SHARE_MODE_CLAUSE = " LOCK IN SHARE MODE";

protected static final String SELECT_LAST_INSERT_ID_SQL = "SELECT LAST_INSERT_ID()";

protected static final SequenceFetcher s_seqFetcher = SequenceFetcher.getInstance();

public static <J> GenericDao<? extends J, ? extends Serializable> getDao(Class<J> entityType) {

@SuppressWarnings("unchecked")

GenericDao<? extends J, ? extends Serializable> dao = (GenericDao<? extends J, ? extends Serializable>)s_daoMaps.get(entityType);

assert dao != null : "Unable to find DAO for " + entityType + ". Are you sure you waited for the DAO to be initialized before asking for it?";

return dao;

}

@Override

@SuppressWarnings("unchecked") @DB(txn=false)

public <J> GenericSearchBuilder<T, J> createSearchBuilder(Class<J> resultType) {

final T entity = (T)_searchEnhancer.create();

final Factory factory = (Factory)entity;

GenericSearchBuilder<T, J> builder = new GenericSearchBuilder<T, J>(entity, resultType, _allAttributes);

factory.setCallback(0, builder);

return builder;

}

@Override

public Map<String, Attribute> getAllAttributes() {

return _allAttributes;

}

@SuppressWarnings("unchecked")

protected GenericDaoBase() {

Type t = getClass().getGenericSuperclass();

if (t instanceof ParameterizedType) {

_entityBeanType = (Class<T>)((ParameterizedType)t).getActualTypeArguments()[0];

} else if (((Class<?>)t).getGenericSuperclass() instanceof ParameterizedType) {

_entityBeanType = (Class<T>)((ParameterizedType)((Class<?>)t).getGenericSuperclass()).getActualTypeArguments()[0];

} else {

_entityBeanType = (Class<T>)((ParameterizedType)

( (Class<?>)((Class<?>)t).getGenericSuperclass()).getGenericSuperclass()).getActualTypeArguments()[0];

}

s_daoMaps.put(_entityBeanType, this);

Class<?>[] interphaces = _entityBeanType.getInterfaces();

if (interphaces != null) {

for (Class<?> interphace : interphaces) {

s_daoMaps.put(interphace, this);

}

}

_table = DbUtil.getTableName(_entityBeanType);

final SqlGenerator generator = new SqlGenerator(_entityBeanType);

_partialSelectSql = generator.buildSelectSql(false);

_count = generator.buildCountSql();

_partialQueryCacheSelectSql = generator.buildSelectSql(true);

_embeddedFields = generator.getEmbeddedFields();

_insertSqls = generator.buildInsertSqls();

final Pair<StringBuilder, Map<String, Object>> dc = generator.buildDiscriminatorClause();

_discriminatorClause = dc.first().length() == 0 ? null : dc.first();

_discriminatorValues = dc.second();

_idAttributes = generator.getIdAttributes();

_idField = _idAttributes.get(_table).length > 0 ? _idAttributes.get(_table)[0].field : null;

_tables = generator.buildTableReferences();

_allAttributes = generator.getAllAttributes();

_allColumns = generator.getAllColumns();

_selectByIdSql = buildSelectByIdSql(createPartialSelectSql(null, true));

_removeSql = generator.buildRemoveSql();

_deleteSqls = generator.buildDeleteSqls();

_removed = generator.getRemovedAttribute();

_tgs = generator.getTableGenerators();

_ecAttributes = generator.getElementCollectionAttributes();

TableGenerator tg = this.getClass().getAnnotation(TableGenerator.class);

if (tg != null) {

_tgs.put(tg.name(), tg);

}

tg = this.getClass().getSuperclass().getAnnotation(TableGenerator.class);

if (tg != null) {

_tgs.put(tg.name(), tg);

}

Callback[] callbacks = new Callback[] { NoOp.INSTANCE, new UpdateBuilder(this) };

_enhancer = new Enhancer();

_enhancer.setSuperclass(_entityBeanType);

_enhancer.setCallbackFilter(s_callbackFilter);

_enhancer.setCallbacks(callbacks);

_factory = (Factory)_enhancer.create();

_searchEnhancer = new Enhancer();

_searchEnhancer.setSuperclass(_entityBeanType);

_searchEnhancer.setCallback(new UpdateBuilder(this));

if (s_logger.isTraceEnabled()) {

s_logger.trace("Select SQL: " + _partialSelectSql.first().toString());

s_logger.trace("Remove SQL: " + (_removeSql != null ? _removeSql.first() : "No remove sql"));

s_logger.trace("Select by Id SQL: " + _selectByIdSql);

s_logger.trace("Table References: " + _tables);

s_logger.trace("Insert SQLs:");

for (final Pair<String, Attribute[]> insertSql : _insertSqls) {

s_logger.trace(insertSql.first());

}

s_logger.trace("Delete SQLs");

for (final Pair<String, Attribute[]> deletSql : _deleteSqls) {

s_logger.trace(deletSql.first());

}

s_logger.trace("Collection SQLs");

for (Attribute attr : _ecAttributes) {

EcInfo info = (EcInfo)attr.attache;

s_logger.trace(info.insertSql);

s_logger.trace(info.selectSql);

}

}

setRunLevel(ComponentLifecycle.RUN_LEVEL_SYSTEM);

}

@Override @DB(txn=false)

@SuppressWarnings("unchecked")

public T createForUpdate(final ID id) {

final T entity = (T)_factory.newInstance(new Callback[] {NoOp.INSTANCE, new UpdateBuilder(this)});

if (id != null) {

try {

_idField.set(entity, id);

} catch (final IllegalArgumentException e) {

} catch (final IllegalAccessException e) {

}

}

return entity;

}

@Override @DB(txn=false)

public T createForUpdate() {

return createForUpdate(null);

}

@Override @DB(txn=false)

public <K> K getNextInSequence(final Class<K> clazz, final String name) {

final TableGenerator tg = _tgs.get(name);

assert (tg != null) : "Couldn't find Table generator using " + name;

return s_seqFetcher.getNextSequence(clazz, tg);

}

@Override @DB(txn=false)

public <K> K getRandomlyIncreasingNextInSequence(final Class<K> clazz, final String name) {

final TableGenerator tg = _tgs.get(name);

assert (tg != null) : "Couldn't find Table generator using " + name;

return s_seqFetcher.getRandomNextSequence(clazz, tg);

}

@Override @DB(txn=false)

public List<T> lockRows(final SearchCriteria<T> sc, final Filter filter, final boolean exclusive) {

return search(sc, filter, exclusive, false);

}

@Override @DB(txn=false)

public T lockOneRandomRow(final SearchCriteria<T> sc, final boolean exclusive) {

final Filter filter = new Filter(1);

final List<T> beans = search(sc, filter, exclusive, true);

return beans.isEmpty() ? null : beans.get(0);

}

@DB(txn=false)

protected List<T> search(SearchCriteria<T> sc, final Filter filter, final Boolean lock, final boolean cache) {

if (_removed != null) {

if (sc == null) {

sc = createSearchCriteria();

}

sc.addAnd(_removed.second().field.getName(), SearchCriteria.Op.NULL);

}

return searchIncludingRemoved(sc, filter, lock, cache);

}

@DB(txn=false)

protected List<T> search(SearchCriteria<T> sc, final Filter filter, final Boolean lock, final boolean cache, final boolean enable_query_cache) {

if (_removed != null) {

if (sc == null) {

sc = createSearchCriteria();

}

sc.addAnd(_removed.second().field.getName(), SearchCriteria.Op.NULL);

}

return searchIncludingRemoved(sc, filter, lock, cache, enable_query_cache);

}

@Override

public List<T> searchIncludingRemoved(SearchCriteria<T> sc, final Filter filter, final Boolean lock, final boolean cache) {

return searchIncludingRemoved(sc, filter, lock, cache, false) ;

}

@Override

public List<T> searchIncludingRemoved(SearchCriteria<T> sc, final Filter filter, final Boolean lock,

final boolean cache, final boolean enable_query_cache) {

String clause = sc != null ? sc.getWhereClause() : null;

if (clause != null && clause.length() == 0) {

clause = null;

}

final StringBuilder str = createPartialSelectSql(sc, clause != null, enable_query_cache);

if (clause != null) {

str.append(clause);

}

Collection<JoinBuilder<SearchCriteria<?>>> joins = null;

if (sc != null) {

joins = sc.getJoins();

if (joins != null) {

addJoins(str, joins);

}

}

List<Object> groupByValues = addGroupBy(str, sc);

addFilter(str, filter);

final Transaction txn = Transaction.currentTxn();

if (lock != null) {

assert (txn.dbTxnStarted() == true) : "As nice as I can here now....how do you lock when there's no DB transaction? Review your db 101 course from college.";

str.append(lock ? FOR_UPDATE_CLAUSE : SHARE_MODE_CLAUSE);

}

final String sql = str.toString();

PreparedStatement pstmt = null;

final List<T> result = new ArrayList<T>();

try {

pstmt = txn.prepareAutoCloseStatement(sql);

int i = 0;

if (clause != null) {

for (final Pair<Attribute, Object> value : sc.getValues()) {

prepareAttribute(++i, pstmt, value.first(), value.second());

}

}

if (joins != null) {

i = addJoinAttributes(i, pstmt, joins);

}

if (groupByValues != null) {

for (Object value : groupByValues) {

pstmt.setObject(i++, value);

}

}

if (s_logger.isDebugEnabled() && lock != null) {

txn.registerLock(pstmt.toString());

}

final ResultSet rs = pstmt.executeQuery();

while (rs.next()) {

result.add(toEntityBean(rs, cache));

}

return result;

} catch (final SQLException e) {

throw new CloudRuntimeException("DB Exception on: " + pstmt, e);

} catch (final Throwable e) {

throw new CloudRuntimeException("Caught: " + pstmt, e);

}

}

@Override @SuppressWarnings("unchecked")

public <M> List<M> customSearchIncludingRemoved(SearchCriteria<M> sc, final Filter filter) {

if (sc.isSelectAll()) {

return (List<M>)searchIncludingRemoved((SearchCriteria<T>)sc, filter, null, false);

}

String clause = sc != null ? sc.getWhereClause() : null;

if (clause != null && clause.length() == 0) {

clause = null;

}

final StringBuilder str = createPartialSelectSql(sc, clause != null);

if (clause != null) {

str.append(clause);

}

Collection<JoinBuilder<SearchCriteria<?>>> joins = null;

if (sc != null) {

joins = sc.getJoins();

if (joins != null) {

addJoins(str, joins);

}

}

List<Object> groupByValues = addGroupBy(str, sc);

addFilter(str, filter);

final String sql = str.toString();

final Transaction txn = Transaction.currentTxn();

PreparedStatement pstmt = null;

try {

pstmt = txn.prepareAutoCloseStatement(sql);

int i = 0;

if (clause != null) {

for (final Pair<Attribute, Object> value : sc.getValues()) {

prepareAttribute(++i, pstmt, value.first(), value.second());

}

}

if (joins != null) {

i = addJoinAttributes(i, pstmt, joins);

}

if (groupByValues != null) {

for (Object value : groupByValues) {

pstmt.setObject(i++, value);

}

}

ResultSet rs = pstmt.executeQuery();

SelectType st = sc.getSelectType();

ArrayList<M> results = new ArrayList<M>();

List<Field> fields = sc.getSelectFields();

while (rs.next()) {

if (st == SelectType.Entity) {

results.add((M)toEntityBean(rs, false));

} else if (st == SelectType.Fields || st == SelectType.Result) {

M m = sc.getResultType().newInstance();

for (int j = 1; j <= fields.size(); j++) {

setField(m, fields.get(j - 1), rs, j);

}

results.add(m);

} else if (st == SelectType.Single) {

results.add(getObject(sc.getResultType(), rs, 1));

}

}

return results;

} catch (final SQLException e) {

throw new CloudRuntimeException("DB Exception on: " + pstmt, e);

} catch (final Throwable e) {

throw new CloudRuntimeException("Caught: " + pstmt, e);

}

}

@Override @DB(txn=false)

public <M> List<M> customSearch(SearchCriteria<M> sc, final Filter filter) {

if (_removed != null) {

sc.addAnd(_removed.second().field.getName(), SearchCriteria.Op.NULL);

}

return customSearchIncludingRemoved(sc, filter);

}

@DB(txn=false)

protected void setField(Object entity, Field field, ResultSet rs, int index) throws SQLException {

try {

final Class<?> type = field.getType();

if (type == String.class) {

byte[] bytes = rs.getBytes(index);

if(bytes != null) {

try {

Encrypt encrypt = field.getAnnotation(Encrypt.class);

if (encrypt != null && encrypt.encrypt()){

field.set(entity, DBEncryptionUtil.decrypt(new String(bytes, "UTF-8")));

} else {

field.set(entity, new String(bytes, "UTF-8"));

}

} catch (IllegalArgumentException e) {

assert(false);

throw new CloudRuntimeException("IllegalArgumentException when converting UTF-8 data");

} catch (UnsupportedEncodingException e) {

assert(false);

throw new CloudRuntimeException("UnsupportedEncodingException when converting UTF-8 data");

}

} else {

field.set(entity, null);

}

} else if (type == long.class) {

field.setLong(entity, rs.getLong(index));

} else if (type == Long.class) {

if (rs.getObject(index) == null) {

field.set(entity, null);

} else {

field.set(entity, rs.getLong(index));

}

} else if (type.isEnum()) {

final Enumerated enumerated = field.getAnnotation(Enumerated.class);

final EnumType enumType = (enumerated == null) ? EnumType.STRING : enumerated.value();

final Enum<?>[] enums = (Enum<?>[])field.getType().getEnumConstants();

for (final Enum<?> e : enums) {

if ((enumType == EnumType.STRING && e.name().equalsIgnoreCase(rs.getString(index))) ||

(enumType == EnumType.ORDINAL && e.ordinal() == rs.getInt(index))) {

field.set(entity, e);

return;

}

}

} else if (type == int.class) {

field.set(entity, rs.getInt(index));

} else if (type == Integer.class) {

if (rs.getObject(index) == null) {

field.set(entity, null);

} else {

field.set(entity, rs.getInt(index));

}

} else if (type == Date.class) {

final Object data = rs.getDate(index);

if (data == null) {

field.set(entity, null);

return;

}

field.set(entity, DateUtil.parseDateString(s_gmtTimeZone, rs.getString(index)));

} else if (type == Calendar.class) {

final Object data = rs.getDate(index);

if (data == null) {

field.set(entity, null);

return;

}

final Calendar cal = Calendar.getInstance();

cal.setTime(DateUtil.parseDateString(s_gmtTimeZone, rs.getString(index)));

field.set(entity, cal);

} else if (type == boolean.class) {

field.setBoolean(entity, rs.getBoolean(index));

} else if (type == Boolean.class) {

if (rs.getObject(index) == null) {

field.set(entity, null);

} else {

field.set(entity, rs.getBoolean(index));

}

} else if (type == URI.class) {

try {

String str = rs.getString(index);

field.set(entity, str == null ? null : new URI(str));

} catch (URISyntaxException e) {

throw new CloudRuntimeException("Invalid URI: " + rs.getString(index), e);

}

} else if (type == URL.class) {

try {

String str = rs.getString(index);

field.set(entity, str != null ? new URL(str) : null);

} catch (MalformedURLException e) {

throw new CloudRuntimeException("Invalid URL: " + rs.getString(index), e);

}

} else if (type == Ip.class) {

final Enumerated enumerated = field.getAnnotation(Enumerated.class);

final EnumType enumType = (enumerated == null) ? EnumType.STRING : enumerated.value();

Ip ip = null;

if (enumType == EnumType.STRING) {

String s = rs.getString(index);

ip = s == null ? null : new Ip(NetUtils.ip2Long(s));

} else {

ip = new Ip(rs.getLong(index));

}

field.set(entity, ip);

} else if (type == short.class) {

field.setShort(entity, rs.getShort(index));

} else if (type == Short.class) {

if (rs.getObject(index) == null) {

field.set(entity, null);

} else {

field.set(entity, rs.getShort(index));

}

} else if (type == float.class) {

field.setFloat(entity, rs.getFloat(index));

} else if (type == Float.class) {

if (rs.getObject(index) == null) {

field.set(entity, null);

} else {

field.set(entity, rs.getFloat(index));

}

} else if (type == double.class) {

field.setDouble(entity, rs.getDouble(index));

} else if (type == Double.class) {

if (rs.getObject(index) == null) {

field.set(entity, null);

} else {

field.set(entity, rs.getDouble(index));

}

} else if (type == byte.class) {

field.setByte(entity, rs.getByte(index));

} else if (type == Byte.class) {

if (rs.getObject(index) == null) {

field.set(entity, null);

} else {

field.set(entity, rs.getByte(index));

}

} else if (type == byte[].class) {

field.set(entity, rs.getBytes(index));

} else {

field.set(entity, rs.getObject(index));

}

} catch (final IllegalAccessException e) {

throw new CloudRuntimeException("Yikes! ", e);

}

}

@DB(txn=false) @SuppressWarnings("unchecked")

protected <M> M getObject(Class<M> type, ResultSet rs, int index) throws SQLException {

if (type == String.class) {

byte[] bytes = rs.getBytes(index);

if(bytes != null) {

try {

return (M)new String(bytes, "UTF-8");

} catch (UnsupportedEncodingException e) {

throw new CloudRuntimeException("UnsupportedEncodingException exception while converting UTF-8 data");

}

} else {

return null;

}

} else if (type == int.class) {

return (M)new Integer(rs.getInt(index));

} else if (type == Integer.class) {

if (rs.getObject(index) == null) {

return null;

} else {

return (M)new Integer(rs.getInt(index));

}

} else if (type == long.class) {

return (M)new Long(rs.getLong(index));

} else if (type == Long.class) {

if (rs.getObject(index) == null) {

return null;

} else {

return (M)new Long(rs.getLong(index));

}

} else if (type == Date.class) {

final Object data = rs.getDate(index);

if (data == null) {

return null;

} else {

return (M)DateUtil.parseDateString(s_gmtTimeZone, rs.getString(index));

}

} else if (type == short.class) {

return (M)new Short(rs.getShort(index));

} else if (type == Short.class) {

if (rs.getObject(index) == null) {

return null;

} else {

return (M)new Short(rs.getShort(index));

}

} else if (type == boolean.class) {

return (M)new Boolean(rs.getBoolean(index));

} else if (type == Boolean.class) {

if (rs.getObject(index) == null) {

return null;

} else {

return (M)new Boolean(rs.getBoolean(index));

}

} else if (type == float.class) {

return (M)new Float(rs.getFloat(index));

} else if (type == Float.class) {

if (rs.getObject(index) == null) {

return null;

} else {

return (M)new Float(rs.getFloat(index));

}

} else if (type == double.class) {

return (M)new Double(rs.getDouble(index));

} else if (type == Double.class) {

if (rs.getObject(index) == null) {

return null;

} else {

return (M)new Double(rs.getDouble(index));

}

} else if (type == byte.class) {

return (M)new Byte(rs.getByte(index));

} else if (type == Byte.class) {

if (rs.getObject(index) == null) {

return null;

} else {

return (M)new Byte(rs.getByte(index));

}

} else if (type == Calendar.class) {

final Object data = rs.getDate(index);

if (data == null) {

return null;

} else {

final Calendar cal = Calendar.getInstance();

cal.setTime(DateUtil.parseDateString(s_gmtTimeZone, rs.getString(index)));

return (M)cal;

}

} else if (type == byte[].class) {

return (M)rs.getBytes(index);

} else {

return (M)rs.getObject(index);

}

}

@DB(txn=false)

protected int addJoinAttributes(int count, PreparedStatement pstmt, Collection<JoinBuilder<SearchCriteria<?>>> joins) throws SQLException {

for (JoinBuilder<SearchCriteria<?>> join : joins) {

for (final Pair<Attribute, Object> value : join.getT().getValues()) {

prepareAttribute(++count, pstmt, value.first(), value.second());

}

}

for (JoinBuilder<SearchCriteria<?>> join : joins) {

if (join.getT().getJoins() != null) {

count = addJoinAttributes(count, pstmt, join.getT().getJoins());

}

}

if (s_logger.isTraceEnabled()) {

s_logger.trace("join search statement is " + pstmt);

}

return count;

}

protected int update(ID id, UpdateBuilder ub, T entity) {

if (_cache != null) {

_cache.remove(id);

}

SearchCriteria<T> sc = createSearchCriteria();

sc.addAnd(_idAttributes.get(_table)[0], SearchCriteria.Op.EQ, id);

Transaction txn = Transaction.currentTxn();

txn.start();

try {

if (ub.getCollectionChanges() != null) {

insertElementCollection(entity, _idAttributes.get(_table)[0], id, ub.getCollectionChanges());

}

} catch (SQLException e) {

throw new CloudRuntimeException("Unable to persist element collection", e);

}

int rowsUpdated = update(ub, sc, null);

txn.commit();

return rowsUpdated;

}

public int update(UpdateBuilder ub, final SearchCriteria<?> sc, Integer rows) {

StringBuilder sql = null;

PreparedStatement pstmt = null;

final Transaction txn = Transaction.currentTxn();

try {

final String searchClause = sc.getWhereClause();

sql = ub.toSql(_tables);

if (sql == null) {

return 0;

}

sql.append(searchClause);

if (rows != null) {

sql.append(" LIMIT ").append(rows);

}

txn.start();

pstmt = txn.prepareAutoCloseStatement(sql.toString());

Collection<Ternary<Attribute, Boolean, Object>> changes = ub.getChanges();

int i = 1;

for (final Ternary<Attribute, Boolean, Object> value : changes) {

prepareAttribute(i++, pstmt, value.first(), value.third());

}

for (Pair<Attribute, Object> value : sc.getValues()) {

prepareAttribute(i++, pstmt, value.first(), value.second());

}

int result = pstmt.executeUpdate();

txn.commit();

ub.clear();

return result;

} catch (final SQLException e) {

if (e.getSQLState().equals("23000") && e.getErrorCode() == 1062) {

throw new EntityExistsException("Entity already exists ", e);

}

throw new CloudRuntimeException("DB Exception on: " + pstmt, e);

}

}

@DB(txn=false)

protected Attribute findAttributeByFieldName(String name) {

return _allAttributes.get(name);

}

@DB(txn=false)

protected String buildSelectByIdSql(final StringBuilder sql) {

if (_idField == null) {

return null;

}

if (_idField.getAnnotation(EmbeddedId.class) == null) {

sql.append(_table).append(".").append(DbUtil.getColumnName(_idField, null)).append(" = ? ");

} else {

final Class<?> clazz = _idField.getClass();

final AttributeOverride[] overrides = DbUtil.getAttributeOverrides(_idField);

for (final Field field : clazz.getDeclaredFields()) {

sql.append(_table).append(".").append(DbUtil.getColumnName(field, overrides)).append(" = ? AND ");

}

sql.delete(sql.length() - 4, sql.length());

}

return sql.toString();

}

@DB(txn=false)

@Override

public Class<T> getEntityBeanType() {

return _entityBeanType;

}

@DB(txn=false)

protected T findOneIncludingRemovedBy(final SearchCriteria<T> sc) {

Filter filter = new Filter(1);

List<T> results = searchIncludingRemoved(sc, filter, null, false);

assert results.size() <= 1 : "Didn't the limiting worked?";

return results.size() == 0 ? null : results.get(0);

}

@Override

@DB(txn=false)

public T findOneBy(final SearchCriteria<T> sc) {

if (_removed != null) {

sc.addAnd(_removed.second().field.getName(), SearchCriteria.Op.NULL);

}

return findOneIncludingRemovedBy(sc);

}

@DB(txn=false)

protected List<T> listBy(final SearchCriteria<T> sc, final Filter filter) {

if (_removed != null) {

sc.addAnd(_removed.second().field.getName(), SearchCriteria.Op.NULL);

}

return listIncludingRemovedBy(sc, filter);

}

@DB(txn=false)

protected List<T> listBy(final SearchCriteria<T> sc, final Filter filter, final boolean enable_query_cache) {

if (_removed != null) {

sc.addAnd(_removed.second().field.getName(), SearchCriteria.Op.NULL);

}

return listIncludingRemovedBy(sc, filter, enable_query_cache);

}

@DB(txn=false)

protected List<T> listBy(final SearchCriteria<T> sc) {

return listBy(sc, null);

}

@DB(txn=false)

protected List<T> listIncludingRemovedBy(final SearchCriteria<T> sc, final Filter filter, final boolean enable_query_cache) {

return searchIncludingRemoved(sc, filter, null, false, enable_query_cache);

}

@DB(txn=false)

protected List<T> listIncludingRemovedBy(final SearchCriteria<T> sc, final Filter filter) {

return searchIncludingRemoved(sc, filter, null, false);

}

@DB(txn=false)

protected List<T> listIncludingRemovedBy(final SearchCriteria<T> sc) {

return listIncludingRemovedBy(sc, null);

}

@Override @DB(txn=false)

@SuppressWarnings("unchecked")

public T findById(final ID id) {

if (_cache != null) {

final Element element = _cache.get(id);

return element == null ? lockRow(id, null) : (T)element.getObjectValue();

} else {

return lockRow(id, null);

}

}

@Override @DB(txn=false)

@SuppressWarnings("unchecked")

public T findByUuid(final String uuid) {

SearchCriteria<T> sc = createSearchCriteria();

sc.addAnd("uuid", SearchCriteria.Op.EQ, uuid);

return findOneBy(sc);

}

@Override @DB(txn=false)

@SuppressWarnings("unchecked")

public T findByUuidIncludingRemoved(final String uuid) {

SearchCriteria<T> sc = createSearchCriteria();

sc.addAnd("uuid", SearchCriteria.Op.EQ, uuid);

return findOneIncludingRemovedBy(sc);

}

@Override @DB(txn=false)

public T findByIdIncludingRemoved(ID id) {

return findById(id, true, null);

}

@Override @DB(txn=false)

public T findById(final ID id, boolean fresh) {

if(!fresh) {

return findById(id);

}

if (_cache != null) {

_cache.remove(id);

}

return lockRow(id, null);

}

@Override @DB(txn=false)

public T lockRow(ID id, Boolean lock) {

return findById(id, false, lock);

}

protected T findById(ID id, boolean removed, Boolean lock) {

StringBuilder sql = new StringBuilder(_selectByIdSql);

if (!removed && _removed != null) {

sql.append(" AND ").append(_removed.first());

}

if (lock != null) {

sql.append(lock ? FOR_UPDATE_CLAUSE : SHARE_MODE_CLAUSE);

}

Transaction txn = Transaction.currentTxn();

PreparedStatement pstmt = null;

try {

pstmt = txn.prepareAutoCloseStatement(sql.toString());

if (_idField.getAnnotation(EmbeddedId.class) == null) {

prepareAttribute(1, pstmt, _idAttributes.get(_table)[0], id);

}

ResultSet rs = pstmt.executeQuery();

return rs.next() ? toEntityBean(rs, true) : null;

} catch (SQLException e) {

throw new CloudRuntimeException("DB Exception on: " + pstmt, e);

}

}

@Override @DB(txn=false)

public T acquireInLockTable(ID id) {

return acquireInLockTable(id, _timeoutSeconds);

}

@Override

public T acquireInLockTable(final ID id, int seconds) {

Transaction txn = Transaction.currentTxn();

T t = null;

boolean locked = false;

try {

if (!txn.lock(_table + id.toString(), seconds)) {

return null;

}