net.java.ao.EntityManager Maven / Gradle / Ivy
Go to download
Show more of this group Show more artifacts with this name
Show all versions of activeobjects Show documentation
Show all versions of activeobjects Show documentation
This is the full Active Objects library, if you don't know which one to use, you probably want this one.
/*
* Copyright 2007 Daniel Spiewak
*
* Licensed under the Apache License, Version 2.0 (the "License");
* you may not use this file except in compliance with the License.
* You may obtain a copy of the License at
*
* http://www.apache.org/licenses/LICENSE-2.0
*
* Unless required by applicable law or agreed to in writing, software
* distributed under the License is distributed on an "AS IS" BASIS,
* WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
* See the License for the specific language governing permissions and
* limitations under the License.
*/
package net.java.ao;
import static com.google.common.base.Preconditions.checkNotNull;
import static net.java.ao.Common.preloadValue;
import static net.java.ao.sql.SqlUtils.closeQuietly;
import java.lang.ref.Reference;
import java.lang.ref.SoftReference;
import java.lang.ref.WeakReference;
import java.lang.reflect.Array;
import java.lang.reflect.Method;
import java.lang.reflect.Proxy;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.Arrays;
import java.util.HashMap;
import java.util.HashSet;
import java.util.LinkedList;
import java.util.List;
import java.util.Map;
import java.util.Map.Entry;
import java.util.Set;
import java.util.concurrent.locks.ReadWriteLock;
import java.util.concurrent.locks.ReentrantReadWriteLock;
import com.google.common.collect.Iterables;
import net.java.ao.cache.Cache;
import net.java.ao.cache.CacheLayer;
import net.java.ao.cache.RAMCache;
import net.java.ao.cache.RAMRelationsCache;
import net.java.ao.cache.RelationsCache;
import net.java.ao.schema.AutoIncrement;
import net.java.ao.schema.CachingNameConverters;
import net.java.ao.schema.FieldNameConverter;
import net.java.ao.schema.NameConverters;
import net.java.ao.schema.SchemaGenerator;
import net.java.ao.schema.TableNameConverter;
import net.java.ao.types.TypeInfo;
import net.java.ao.types.TypeManager;
import com.google.common.collect.MapMaker;
import net.java.ao.util.StringUtils;
/**
* The root control class for the entire ActiveObjects API. EntityManager
* is the source of all {@link RawEntity} objects, as well as the dispatch layer between the entities,
* the pluggable table name converters, and the database abstraction layers. This is the
* entry point for any use of the API.
*
* EntityManager is designed to be used in an instance fashion with each
* instance corresponding to a single database. Thus, rather than a singleton instance or a
* static factory method, EntityManager does have a proper constructor. Any
* static instance management is left up to the developer using the API.
*
* @author Daniel Spiewak
*/
public class EntityManager
{
private final DatabaseProvider provider;
private final EntityManagerConfiguration configuration;
private final SchemaConfiguration schemaConfiguration;
private final NameConverters nameConverters;
private Map, EntityProxy, ?>> proxies;
private final ReadWriteLock proxyLock = new ReentrantReadWriteLock(true);
private Map, Reference>> entityCache;
private final ReadWriteLock entityCacheLock = new ReentrantReadWriteLock(true);
private Cache cache;
private final ReadWriteLock cacheLock = new ReentrantReadWriteLock(true);
private PolymorphicTypeMapper typeMapper;
private final ReadWriteLock typeMapperLock = new ReentrantReadWriteLock(true);
private Map>, ValueGenerator> valGenCache;
private final ReadWriteLock valGenCacheLock = new ReentrantReadWriteLock(true);
private final RelationsCache relationsCache = new RAMRelationsCache();
/**
* Creates a new instance of EntityManager using the specified
* {@link DatabaseProvider}. This constructor initializes the entity and proxy
* caches based on the given boolean value. If true, the entities
* will be weakly cached, not maintaining a reference allowing for garbage
* collection. If false, then strong caching will be used, preventing
* garbage collection and ensuring the cache is logically complete. If you are
* concerned about memory, specify true. Otherwise, for
* maximum performance use false (highly recomended).
*
* @param provider the {@link DatabaseProvider} to use in all database operations.
* @param configuration the configuration for this entity manager
*/
public EntityManager(DatabaseProvider provider, EntityManagerConfiguration configuration)
{
this.provider = checkNotNull(provider);
this.configuration = checkNotNull(configuration);
if (configuration.useWeakCache())
{
proxies = new MapMaker().weakKeys().makeMap();
}
else
{
proxies = new MapMaker().softKeys().makeMap();
}
entityCache = new LRUMap, Reference>>(500);
cache = new RAMCache();
valGenCache = new HashMap>, ValueGenerator>();
// TODO: move caching out of there!
nameConverters = new CachingNameConverters(configuration.getNameConverters());
schemaConfiguration = checkNotNull(configuration.getSchemaConfiguration());
typeMapper = new DefaultPolymorphicTypeMapper(new HashMap>, String>());
}
/**
* Convenience method to create the schema for the specified entities
* using the current settings (table/field name converter and database provider).
*
* @param entities the "list" of entity classes to consider for migration.
* @see SchemaGenerator#migrate(DatabaseProvider, SchemaConfiguration, NameConverters, Class[])
*/
public void migrate(Class>... entities) throws SQLException {
SchemaGenerator.migrate(provider, schemaConfiguration, nameConverters, entities);
}
/**
* Flushes all value caches contained within entities controlled by this EntityManager
* instance. Rather, it simply dumps all of the field values cached within the entities
* themselves (with the exception of the primary key value). This should be used in the case
* of a complex process outside AO control which may have changed values in the database. If
* it is at all possible to determine precisely which rows have been changed, the {@link #flush(RawEntity[])} }
* method should be used instead.
*/
public void flushAll() {
List, EntityProxy, ?>>> toFlush = new LinkedList, EntityProxy, ?>>>();
proxyLock.readLock().lock();
try {
for (Map.Entry, EntityProxy, ?>> proxy : proxies.entrySet()) {
toFlush.add(proxy);
}
} finally {
proxyLock.readLock().unlock();
}
for (Map.Entry, EntityProxy, ?>> entry : toFlush) {
entry.getValue().flushCache(entry.getKey());
}
entityCacheLock.writeLock().lock();
try
{
entityCache.clear();
relationsCache.flush();
}
finally
{
entityCacheLock.writeLock().unlock();
}
}
/**
* Flushes the value caches of the specified entities along with all of the relevant
* relations cache entries. This should be called after a process outside of AO control
* may have modified the values in the specified rows. This does not actually remove
* the entity instances themselves from the instance cache. Rather, it just flushes all
* of their internally cached values (with the exception of the primary key).
*/
public void flush(RawEntity... entities) {
List>> types = new ArrayList>>(entities.length);
Map, EntityProxy> toFlush = new HashMap, EntityProxy>();
proxyLock.readLock().lock();
try {
for (RawEntity entity : entities) {
verify(entity);
types.add(entity.getEntityType());
toFlush.put(entity, proxies.get(entity));
}
} finally {
proxyLock.readLock().unlock();
}
for (Entry, EntityProxy> entry : toFlush.entrySet()) {
entry.getValue().flushCache(entry.getKey());
}
relationsCache.remove(types.toArray(new Class[types.size()]));
}
/**
* Returns an array of entities of the specified type corresponding to the
* varargs primary keys. If an in-memory reference already exists to a corresponding
* entity (of the specified type and key), it is returned rather than creating
* a new instance.
*
* If the entity is known to exist in the database, then no checks are performed
* and the method returns extremely quickly. However, for any key which has not
* already been verified, a query to the database is performed to determine whether
* or not the entity exists. If the entity does not exist, then null
* is returned.
*
* @param type The type of the entities to retrieve.
* @param keys The primary keys corresponding to the entities to retrieve. All
* keys must be typed according to the generic type parameter of the entity's
* {@link RawEntity} inheritence (if inheriting from {@link Entity}, this is Integer
* or int). Thus, the keys array is type-checked at compile
* time.
* @return An array of entities of the given type corresponding with the specified
* primary keys. Any entities which are non-existent will correspond to a null
* value in the resulting array.
*/
public final , K> T[] get(final Class type, K... keys) throws SQLException
{
final String primaryKeyField = Common.getPrimaryKeyField(type, getFieldNameConverter());
return getFromCache(type, findByPrimaryKey(type, primaryKeyField), keys);
}
private , K> Function findByPrimaryKey(final Class type, final String primaryKeyField)
{
return new Function()
{
@Override
public T invoke(K k) throws SQLException
{
final T[] ts = find(type, primaryKeyField + " = ?", k);
if (ts.length == 1)
{
return ts[0];
}
else if (ts.length == 0)
{
return null;
}
else
{
throw new ActiveObjectsException("Found more that one object of type '" + type.getName() + "' for key '" + k + "'");
}
}
};
}
protected , K> T[] peer(final Class type, K... keys) throws SQLException
{
return getFromCache(type, new Function() {
public T invoke(K key) {
return getAndInstantiate(type, key);
}
}, keys);
}
private , K> T[] getFromCache(Class type, Function create, K... keys) throws SQLException
{
T[] back = (T[]) Array.newInstance(type, keys.length);
int index = 0;
for (K key : keys) {
entityCacheLock.writeLock().lock();
try { // upcast to workaround bug in javac
Reference reference = entityCache.get(new CacheKey(key, type));
Reference ref = (Reference) reference;
T entity = (ref == null ? null : ref.get());
if (entity != null) {
back[index++] = entity;
} else {
back[index++] = create.invoke(key);
}
} finally {
entityCacheLock.writeLock().unlock();
}
}
return back;
}
/**
* Creates a new instance of the entity of the specified type corresponding to the
* given primary key. This is used by {@link #get(Class, Object[])}} to create the entity
* if the instance is not found already in the cache. This method should not be
* repurposed to perform any caching, since ActiveObjects already assumes that
* the caching has been performed.
*
* @param type The type of the entity to create.
* @param key The primary key corresponding to the entity instance required.
* @return An entity instance of the specified type and primary key.
*/
protected , K> T getAndInstantiate(Class type, K key) {
EntityProxy proxy = new EntityProxy(this, type, key);
T entity = type.cast(Proxy.newProxyInstance(type.getClassLoader(), new Class[] {type, EntityProxyAccessor.class}, proxy));
proxyLock.writeLock().lock();
try {
proxies.put(entity, proxy);
} finally {
proxyLock.writeLock().unlock();
}
entityCache.put(new CacheKey(key, type), createRef(entity));
return entity;
}
/**
* Cleverly overloaded method to return a single entity of the specified type
* rather than an array in the case where only one ID is passed. This method
* meerly delegates the call to the overloaded get method
* and functions as syntactical sugar.
*
* @param type The type of the entity instance to retrieve.
* @param key The primary key corresponding to the entity to be retrieved.
* @return An entity instance of the given type corresponding to the specified
* primary key, or null if the entity does not exist in the database.
* @see #get(Class, Object[])
*/
public , K> T get(Class type, K key) throws SQLException
{
return get(type, toArray(key))[0];
}
protected , K> T peer(Class type, K key) throws SQLException
{
return peer(type, toArray(key))[0];
}
@SuppressWarnings("unchecked")
private static K[] toArray(K key)
{
return (K[]) new Object[]{key};
}
/**
* Creates a new entity of the specified type with the optionally specified
* initial parameters. This method actually inserts a row into the table represented
* by the entity type and returns the entity instance which corresponds to that
* row.
*
* The {@link DBParam} object parameters are designed to allow the creation
* of entities which have non-null fields which have no defalut or auto-generated
* value. Insertion of a row without such field values would of course fail,
* thus the need for db params. The db params can also be used to set
* the values for any field in the row, leading to more compact code under
* certain circumstances.
*
* Unless within a transaction, this method will commit to the database
* immediately and exactly once per call. Thus, care should be taken in
* the creation of large numbers of entities. There doesn't seem to be a more
* efficient way to create large numbers of entities, however one should still
* be aware of the performance implications.
*
* This method delegates the action INSERT action to
* {@link DatabaseProvider#insertReturningKey(EntityManager, Connection, Class, String, boolean, String, DBParam...)}.
* This is necessary because not all databases support the JDBC RETURN_GENERATED_KEYS
* constant (e.g. PostgreSQL and HSQLDB). Thus, the database provider itself is
* responsible for handling INSERTion and retrieval of the correct primary key
* value.
*
* @param type The type of the entity to INSERT.
* @param params An optional varargs array of initial values for the fields in the row. These
* values will be passed to the database within the INSERT statement.
* @return The new entity instance corresponding to the INSERTed row.
* @see net.java.ao.DBParam
*/
public , K> T create(Class type, DBParam... params) throws SQLException {
T back = null;
final String table = nameConverters.getTableNameConverter().getName(type);
Set listParams = new HashSet();
listParams.addAll(Arrays.asList(params));
for (Method method : MethodFinder.getInstance().findAnnotatedMethods(Generator.class, type)) {
Generator genAnno = method.getAnnotation(Generator.class);
final String field = nameConverters.getFieldNameConverter().getName(method);
ValueGenerator generator;
valGenCacheLock.writeLock().lock();
try {
if (valGenCache.containsKey(genAnno.value())) {
generator = valGenCache.get(genAnno.value());
} else {
generator = genAnno.value().newInstance();
valGenCache.put(genAnno.value(), generator);
}
} catch (InstantiationException e) {
continue;
} catch (IllegalAccessException e) {
continue;
} finally {
valGenCacheLock.writeLock().unlock();
}
listParams.add(new DBParam(field, generator.generateValue(this)));
}
final Method pkMethod = Common.getPrimaryKeyMethod(type);
final String pkField = Common.getPrimaryKeyField(type, getFieldNameConverter());
final Set nonNullFields = Common.getNonNullFields(type, nameConverters.getFieldNameConverter());
final Set fieldsThatShouldBeSet = Common.getNonNullFieldsWithNoDefaultAndNotGenerated(type, nameConverters.getFieldNameConverter());
final Map valueFields = Common.getValueFields(provider.getTypeManager(), nameConverters.getFieldNameConverter(), type);
for (DBParam param : params)
{
if (param.getField().equals(pkField))
{
Common.validatePrimaryKey(provider.getTypeManager(),type,param.getValue());
}
else if (nonNullFields.contains(param.getField()) && param.getValue() == null)
{
throw new IllegalArgumentException("Cannot set non-null field " + param.getField() + " to null");
}
else if (nonNullFields.contains(param.getField()) && param.getValue() instanceof String && StringUtils.isBlank((String) param.getValue()))
{
throw new IllegalArgumentException("Cannot set non-null String field " + param.getField() + " to ''");
}
fieldsThatShouldBeSet.remove(param.getField());
final TypeInfo dbType = valueFields.get(param.getField());
if (dbType != null && param.getValue() != null)
{
dbType.getLogicalType().validate(param.getValue());
}
}
if (!fieldsThatShouldBeSet.isEmpty())
{
throw new IllegalArgumentException("There are some non-null fields that weren't set when trying to create entity '" + type.getName() + "', those fields are: " + nonNullFields);
}
Connection connection = null;
try
{
connection = provider.getConnection();
back = peer(type, provider.insertReturningKey(this, connection,
type,
Common.getPrimaryKeyClassType(type),
Common.getPrimaryKeyField(type, getFieldNameConverter()),
pkMethod.getAnnotation(AutoIncrement.class) != null, table, listParams.toArray(new DBParam[listParams.size()])));
}
finally
{
closeQuietly(connection);
}
relationsCache.remove(type);
back.init();
return back;
}
/**
* Creates and INSERTs a new entity of the specified type with the given map of
* parameters. This method merely delegates to the {@link #create(Class, DBParam...)}
* method. The idea behind having a separate convenience method taking a map is in
* circumstances with large numbers of parameters or for people familiar with the
* anonymous inner class constructor syntax who might be more comfortable with
* creating a map than with passing a number of objects.
*
* @param type The type of the entity to INSERT.
* @param params A map of parameters to pass to the INSERT.
* @return The new entity instance corresponding to the INSERTed row.
* @see #create(Class, DBParam...)
*/
public , K> T create(Class type, Map params) throws SQLException {
DBParam[] arrParams = new DBParam[params.size()];
int i = 0;
for (String key : params.keySet()) {
arrParams[i++] = new DBParam(key, params.get(key));
}
return create(type, arrParams);
}
/**
* Deletes the specified entities from the database. DELETE statements are
* called on the rows in the corresponding tables and the entities are removed
* from the instance cache. The entity instances themselves are not invalidated,
* but it doesn't even make sense to continue using the instance without a row
* with which it is paired.
*
* This method does attempt to group the DELETE statements on a per-type
* basis. Thus, if you pass 5 instances of EntityA and two
* instances of EntityB, the following SQL prepared statements
* will be invoked:
*
* DELETE FROM entityA WHERE id IN (?,?,?,?,?);
* DELETE FROM entityB WHERE id IN (?,?);
*
* Thus, this method scales very well for large numbers of entities grouped
* into types. However, the execution time increases linearly for each entity of
* unique type.
*
* @param entities A varargs array of entities to delete. Method returns immediately
* if length == 0.
*/
@SuppressWarnings("unchecked")
public void delete(RawEntity... entities) throws SQLException {
if (entities.length == 0) {
return;
}
Map>, List>> organizedEntities =
new HashMap>, List>>();
for (RawEntity entity : entities) {
verify(entity);
Class> type = getProxyForEntity(entity).getType();
if (!organizedEntities.containsKey(type)) {
organizedEntities.put(type, new LinkedList>());
}
organizedEntities.get(type).add(entity);
}
entityCacheLock.writeLock().lock();
try {
Connection conn = null;
PreparedStatement stmt = null;
try
{
conn = provider.getConnection();
for (Class> type : organizedEntities.keySet()) {
List> entityList = organizedEntities.get(type);
StringBuilder sql = new StringBuilder("DELETE FROM ");
sql.append(provider.withSchema(nameConverters.getTableNameConverter().getName(type)));
sql.append(" WHERE ").append(provider.processID(
Common.getPrimaryKeyField(type, getFieldNameConverter()))).append(" IN (?");
for (int i = 1; i < entityList.size(); i++) {
sql.append(",?");
}
sql.append(')');
stmt = provider.preparedStatement(conn, sql);
int index = 1;
for (RawEntity entity : entityList) {
TypeInfo typeInfo = provider.getTypeManager().getType(entity.getEntityType());
typeInfo.getLogicalType().putToDatabase(this, stmt, index++, entity, typeInfo.getJdbcWriteType());
}
relationsCache.remove(type);
stmt.executeUpdate();
}
}
finally
{
closeQuietly(stmt);
closeQuietly(conn);
}
for (RawEntity entity : entities) {
entityCache.remove(new CacheKey(Common.getPrimaryKeyValue(entity), entity.getEntityType()));
}
proxyLock.writeLock().lock();
try {
for (RawEntity entity : entities) {
proxies.remove(entity);
}
} finally {
proxyLock.writeLock().unlock();
}
} finally {
entityCacheLock.writeLock().unlock();
}
}
/**
* Returns all entities of the given type. This actually peers the call to
* the {@link #find(Class, Query)} method.
*
* @param type The type of entity to retrieve.
* @return An array of all entities which correspond to the given type.
*/
public , K> T[] find(Class type) throws SQLException {
return find(type, Query.select());
}
/**
* Convenience method to select all entities of the given type with the
* specified, parameterized criteria. The criteria String
* specified is appended to the SQL prepared statement immediately
* following the WHERE.
*
* Example:
*
* manager.find(Person.class, "name LIKE ? OR age > ?", "Joe", 9);
*
* This actually delegates the call to the {@link #find(Class, Query)}
* method, properly parameterizing the {@link Query} object.
*
* @param type The type of the entities to retrieve.
* @param criteria A parameterized WHERE statement used to determine the results.
* @param parameters A varargs array of parameters to be passed to the executed
* prepared statement. The length of this array must match the number of
* parameters (denoted by the '?' char) in the criteria.
* @return An array of entities of the given type which match the specified criteria.
*/
public final , K> T[] find(Class type, String criteria, Object... parameters) throws SQLException {
return find(type, Query.select().where(criteria, parameters));
}
/**
* Selects all entities matching the given type and {@link Query}. By default, the
* entities will be created based on the values within the primary key field for the
* specified type (this is usually the desired behavior).
*
* Example:
*
* manager.find(Person.class, Query.select().where("name LIKE ? OR age > ?", "Joe", 9).limit(10));
*
* This method delegates the call to {@link #find(Class, String, Query)}, passing the
* primary key field for the given type as the String parameter.
*
* @param type The type of the entities to retrieve.
* @param query The {@link Query} instance to be used to determine the results.
* @return An array of entities of the given type which match the specified query.
*/
public final , K> T[] find(Class type, Query query) throws SQLException {
String selectField = Common.getPrimaryKeyField(type, getFieldNameConverter());
query.resolveFields(type, getFieldNameConverter());
Iterable fields = query.getFields();
if (Iterables.size(fields) == 1) {
selectField = Iterables.get(fields, 0);
}
return find(type, selectField, query);
}
/**
* Selects all entities of the specified type which match the given
* Query. This method creates a PreparedStatement
* using the Query instance specified against the table
* represented by the given type. This query is then executed (with the
* parameters specified in the query). The method then iterates through
* the result set and extracts the specified field, mapping an entity
* of the given type to each row. This array of entities is returned.
*
* @param type The type of the entities to retrieve.
* @param field The field value to use in the creation of the entities. This is usually
* the primary key field of the corresponding table.
* @param query The {@link Query} instance to use in determining the results.
* @return An array of entities of the given type which match the specified query.
*/
public final , K> T[] find(Class type, String field, Query query) throws SQLException {
List back = new ArrayList();
query.resolveFields(type, getFieldNameConverter());
final Preload preloadAnnotation = type.getAnnotation(Preload.class);
if (preloadAnnotation != null) {
if (!Iterables.get(query.getFields(),0).equals("*") && query.getJoins().isEmpty()) {
Iterable oldFields = query.getFields();
List newFields = new ArrayList();
for (String newField : preloadValue(preloadAnnotation, nameConverters.getFieldNameConverter())) {
newField = newField.trim();
int fieldLoc = -1;
for (int i = 0; i < Iterables.size(oldFields); i++) {
if (Iterables.get(oldFields, i).equals(newField)) {
fieldLoc = i;
break;
}
}
if (fieldLoc < 0) {
newFields.add(newField);
} else {
newFields.add(Iterables.get(oldFields, fieldLoc));
}
}
if (!newFields.contains("*")) {
for (String oldField : oldFields) {
if (!newFields.contains(oldField)) {
newFields.add(oldField);
}
}
}
query.setFields(newFields.toArray(new String[newFields.size()]));
}
}
Connection conn = null;
PreparedStatement stmt = null;
ResultSet res = null;
try
{
conn = provider.getConnection();
final String sql = query.toSQL(type, provider, getTableNameConverter(), getFieldNameConverter(), false);
stmt = provider.preparedStatement(conn, sql, ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);
provider.setQueryStatementProperties(stmt, query);
query.setParameters(this, stmt);
res = stmt.executeQuery();
provider.setQueryResultSetProperties(res, query);
final TypeInfo primaryKeyType = Common.getPrimaryKeyType(provider.getTypeManager(), type);
final Class primaryKeyClassType = Common.getPrimaryKeyClassType(type);
final String[] canonicalFields = query.getCanonicalFields(provider, getFieldNameConverter(), type);
while (res.next())
{
final T entity = peer(type, primaryKeyType.getLogicalType().pullFromDatabase(this, res, primaryKeyClassType, field));
final CacheLayer cacheLayer = getProxyForEntity(entity).getCacheLayer(entity);
for (String cacheField : canonicalFields)
{
cacheLayer.put(cacheField, res.getObject(cacheField));
}
back.add(entity);
}
}
finally
{
closeQuietly(res, stmt, conn);
}
return back.toArray((T[]) Array.newInstance(type, back.size()));
}
/**
* Executes the specified SQL and extracts the given key field, wrapping each
* row into a instance of the specified type. The SQL itself is executed as
* a {@link PreparedStatement} with the given parameters.
*
* Example:
*
* manager.findWithSQL(Person.class, "personID", "SELECT personID FROM chairs WHERE position < ? LIMIT ?", 10, 5);
*
* The SQL is not parsed or modified in any way by ActiveObjects. As such, it is
* possible to execute database-specific queries using this method without realizing
* it. For example, the above query will not run on MS SQL Server or Oracle, due to
* the lack of a LIMIT clause in their SQL implementation. As such, be extremely
* careful about what SQL is executed using this method, or else be conscious of the
* fact that you may be locking yourself to a specific DBMS.
*
* @param type The type of the entities to retrieve.
* @param keyField The field value to use in the creation of the entities. This is usually
* the primary key field of the corresponding table.
* @param sql The SQL statement to execute.
* @param parameters A varargs array of parameters to be passed to the executed
* prepared statement. The length of this array must match the number of
* parameters (denoted by the '?' char) in the criteria.
* @return An array of entities of the given type which match the specified query.
*/
@SuppressWarnings("unchecked")
public , K> T[] findWithSQL(Class type, String keyField, String sql, Object... parameters) throws SQLException {
List back = new ArrayList();
Connection connection = null;
PreparedStatement stmt = null;
ResultSet res = null;
try
{
connection = provider.getConnection();
stmt = provider.preparedStatement(connection, sql);
final TypeManager manager = provider.getTypeManager();
for (int i = 0; i < parameters.length; i++) {
Class javaType = parameters[i].getClass();
if (parameters[i] instanceof RawEntity) {
javaType = ((RawEntity) parameters[i]).getEntityType();
}
TypeInfo © 2015 - 2025 Weber Informatics LLC | Privacy Policy