@Test
public void testPersistEntity_EntityWithArray() {
System.out.println("\nTestPersistenceManager.testPersistEntity_EntityWithArray()");
System.out.println("------------------------------------------------------------");
Filter filter = new Filter();
List<String> values = new ArrayList<String>();
values.add("Value1");
values.add("Value2");
filter.setValues(values);
String[] simpleArray = new String[] {"Kayal", "Vizhi"};
filter.setSimpleArray(simpleArray);
Tuple[] complexArray = new Tuple[] {new Tuple("a", "A"), new Tuple("b", "B")};
filter.setComplexArray(complexArray);
persistenceManager.persistEntity(filter);
List<Filter> filters = persistenceManager.getEntities(Filter.class);
assertNotNull(filters);
assertEquals(1, filters.size());
Filter retrievedFilter = filters.get(0);
assertNotNull(retrievedFilter.getId());
assertEquals(filter.getValues(), retrievedFilter.getValues());
assertEquals(complexArray.length, retrievedFilter.getComplexArray().length);
for (int i = 0; i < complexArray.length; i++) {
assertEquals(complexArray[i], retrievedFilter.getComplexArray()[i]);
}
}
public static InstanceStateMachine_c getOneSM_ISMOnR518(
ModelRoot modelRoot, ModelClass_c target, ClassQueryInterface_c test, boolean loadComponent) {
InstanceStateMachine_c result = null;
result = find_getOneSM_ISMOnR518(modelRoot, target, test);
if (result == null && (loadComponent)) {
// Containment Relation
List comps =
PersistenceManager.findAllChildComponents(
target.getPersistableComponent(), modelRoot, InstanceStateMachine_c.class);
for (int i = 0; i < comps.size(); i++) {
PersistableModelComponent component = (PersistableModelComponent) comps.get(i);
if (!component.isLoaded()) {
try {
component.load(new NullProgressMonitor());
result = find_getOneSM_ISMOnR518(modelRoot, target, test);
if (result != null) return result;
} catch (Exception e) {
CorePlugin.logError("Error Loading component", e);
}
}
}
}
return result;
}
public static Localidad findByFields(String nombreProvincia, String nombreLocalidad) {
EntityManager entityManager = PersistenceManager.getEntityManager();
Localidad localidad = null;
try {
TypedQuery<Localidad> query =
entityManager.createNamedQuery("Localidad.findByFields", Localidad.class);
query.setParameter("localidad", nombreLocalidad);
query.setParameter("provincia", nombreProvincia);
if (!query.getResultList().isEmpty() && query.getResultList().size() < 2) {
localidad = query.getResultList().get(0);
}
} catch (Exception ex) {
ex.printStackTrace();
} finally {
entityManager.close();
}
return localidad;
}
/**
* @param maxResults no of URLs to pull
* @return Pulls any URLs that have get_authority_data = TRUE
*/
@SuppressWarnings("unchecked")
public List<URL> getUnProccessedAuthorityData(Integer maxResults) {
log.info("Entering getUnProccessedAuthorityData()");
List<URL> urls = null;
EntityManagerFactory emf = PersistenceManager.getInstance().getEntityManagerFactory();
EntityManager mgr = emf.createEntityManager();
try {
urls =
(List<URL>)
mgr.createQuery("SELECT u FROM URL u WHERE u.get_authority_data = TRUE")
.setMaxResults(maxResults)
.getResultList();
} catch (Exception e) {
String msg = "Exception thrown. URLDBService: getUnProccessedAuthorityData";
log.severe(msg + e.getMessage());
} finally {
mgr.close();
}
return urls;
}
public Integer getNoOfUnProccessedTUrls() {
log.info("Entering getNoOfUnProccessedTUrls");
Integer result = null;
EntityManagerFactory emf = PersistenceManager.getInstance().getEntityManagerFactory();
EntityManager mgr = emf.createEntityManager();
try {
result =
((Number)
mgr.createQuery(
"SELECT COUNT(u) FROM URL u WHERE u.get_backlinks = TRUE and u.backlinks_got = false")
.getSingleResult())
.intValue();
} catch (Exception e) {
log.severe(e.getMessage());
} finally {
mgr.close();
}
return result;
}
public List<URL> getURLsFromIDs(List<Integer> idList) {
log.info("Entering getURLsFromIDs");
List<URL> urls = new ArrayList<URL>(); // used if we use option 2.
EntityManagerFactory emf = PersistenceManager.getInstance().getEntityManagerFactory();
EntityManager mgr = emf.createEntityManager();
// TODO: decide: 2 options: - need to check in optimization....
// 1: one call to DB and search list for idList
// get list of all urls and then use java selection process to retrieve urls from this list
// that are in idList
// 2: multiple calls to DB:
// loop through all idList and make repeat calls to DB retrieving URL for each.
try {
// 2:
for (int i = 0; i < idList.size(); i++) {
urls.add(mgr.find(URL.class, idList.get(i)));
}
} catch (Exception e) {
String msg = "Exception thrown. URLService: getURLsFromIDs";
log.severe(msg + e.getMessage());
} finally {
mgr.close();
}
return urls;
}
/**
* Updates record with url address with new page authority (pa) & domain authority (da) data
*
* @param urlAddress - target url
* @param pa - Page Authority
* @param da - Domain Authority
* @param domainName - Domain name of url.
*/
public void updateBackLinksGot(URL url, boolean backLinksGot) {
EntityManagerFactory emf = PersistenceManager.getInstance().getEntityManagerFactory();
EntityManager mgr = emf.createEntityManager();
int url_id;
try {
url_id = url.getId();
mgr.getTransaction().begin();
URL urlDB = mgr.find(URL.class, url_id);
urlDB.setBacklinks_got(backLinksGot);
mgr.merge(urlDB);
mgr.getTransaction().commit();
} catch (Exception e) {
String msg = "Exception thrown. URLService: updateURLData";
log.severe(msg + e.getMessage());
} finally {
mgr.close();
}
}
public void updateSocialFrequencyData(URL url) {
log.info("Entering URLService::updateSocialFrequencyData");
EntityManagerFactory emf = PersistenceManager.getInstance().getEntityManagerFactory();
EntityManager mgr = emf.createEntityManager();
try {
mgr.getTransaction().begin();
URL urlDB = mgr.find(URL.class, url.getId());
urlDB.setSocial_data_freq(url.getSocial_data_freq());
urlDB.setSocial_data_date(url.getSocial_data_date());
mgr.merge(urlDB);
// mgr.flush();
mgr.getTransaction().commit();
} catch (Exception e) {
String msg = "Exception thrown. URLService: updateSocialFrequencyData";
log.severe(msg + e.getMessage());
} finally {
mgr.close();
}
}
/**
* @param links list of links that we want the urls
* @return - list of urls that are the source urls in the list of links passed
*/
@SuppressWarnings("unchecked")
public List<URL> getBackLinkURLs(List<Integer> sourceIDs) {
log.info("Entering getBackLinkURLs - list of links version");
List<URL> result = null;
EntityManagerFactory emf = PersistenceManager.getInstance().getEntityManagerFactory();
EntityManager mgr = emf.createEntityManager();
Query query =
mgr.createQuery("SELECT u FROM URL u WHERE u.url_id IN :sourceIDs ORDER BY u.url_id")
.setParameter("sourceIDs", sourceIDs);
try {
result = query.getResultList();
} catch (Exception e) {
String msg = "Exception thrown. URLService: getBackLinkURLs (Link List version) ";
log.severe(msg + e.getMessage());
} finally {
mgr.close();
}
return result;
}
// see: http://en.wikibooks.org/wiki/Java_Persistence/Querying#Pagination.2C_Max.2FFirst_Results
// for limiting results... and ordering correclty...
@SuppressWarnings("unchecked")
public List<URL> getBackLinkURLs(int targetURLId, int limitStart, Integer limitEnd) {
log.info(
"Entering getBackLinkURLs: Start = "
+ Integer.toString(limitStart)
+ ". End = "
+ Integer.toString(limitEnd));
List<URL> result = null;
EntityManagerFactory emf = PersistenceManager.getInstance().getEntityManagerFactory();
EntityManager mgr = emf.createEntityManager();
Query query =
mgr.createQuery(
"SELECT u FROM URL u WHERE u.url_id = ANY (SELECT l.source_id FROM Link l WHERE l.target_id = :id) ORDER BY u.url_id");
query.setParameter("id", targetURLId);
query.setFirstResult(limitStart);
query.setMaxResults(limitEnd);
try {
result = query.getResultList();
log.info("getBackLinkURLs: No Of Results: " + Integer.toString(result.size()));
} catch (Exception e) {
String msg = "Exception thrown. URLService: getBackLinkURLs. ";
log.severe(msg + e.getMessage());
} finally {
mgr.close();
}
return result;
}
/**
* @return all URLs that have their social_data date set for today or before, ordered by url_id
* max ever pulled: GoFetchConstants.MAX_NO_OF_SOCIAL_URLS
* @throws Exception
*/
@SuppressWarnings("unchecked")
public List<URL> getAllTodaysSocialCrawlURLs() throws Exception {
log.info("Entering getTodaysSocialCrawlURLs");
List<URL> result = null;
Date date = DateUtil.getTodaysDate();
EntityManagerFactory emf = PersistenceManager.getInstance().getEntityManagerFactory();
EntityManager mgr = emf.createEntityManager();
try {
result =
(List<URL>)
mgr.createQuery(
"SELECT u FROM URL u WHERE u.get_social_data = true AND u.social_data_date <= :date ORDER BY u.url_id")
.setParameter("date", date, TemporalType.DATE)
.setMaxResults(GoFetchConstants.MAX_NO_OF_SOCIAL_URLS)
.getResultList();
} catch (Exception e) {
log.severe("Error: getAllTodaysSocialCrawlURLs " + e.getMessage());
throw (e);
} finally {
mgr.close();
}
if (result == null) {
log.warning("No URLs returned");
}
return result;
}
@SuppressWarnings("unchecked")
public List<URL> getTodaysSocialCrawlURLs(int noOfResults) {
log.info("Entering getTodaysSocialCrawlURLs");
List<URL> result = null;
Date date = DateUtil.getTodaysDate();
EntityManagerFactory emf = PersistenceManager.getInstance().getEntityManagerFactory();
EntityManager mgr = emf.createEntityManager();
try {
result =
(List<URL>)
mgr.createQuery(
"SELECT u FROM URL u WHERE u.get_social_data = true AND u.social_data_date <= :date ORDER BY u.social_data_date")
.setParameter("date", date, TemporalType.DATE)
.setMaxResults(noOfResults)
.getResultList();
} catch (Exception e) {
String msg = "Exception thrown. URLService: getURLs";
log.severe(msg + e.getMessage());
} finally {
mgr.close();
}
if (result == null) {
log.warning("No URLs returned");
}
return result;
}
@SuppressWarnings("unchecked")
public List<String> getURLAddressesStartingWith(String query, int noOfResults) {
// log.info("Entering getURLAddresses");
List<String> result = null;
EntityManagerFactory emf = PersistenceManager.getInstance().getEntityManagerFactory();
EntityManager mgr = emf.createEntityManager();
try {
result =
(List<String>)
mgr.createQuery("SELECT u.url_address FROM URL u where u.url_address LIKE :query")
.setMaxResults(noOfResults)
.setParameter("query", query + "%")
.getResultList();
} catch (Exception e) {
String msg = "Exception thrown. URLService: getURLAddresses";
log.severe(msg + e.getMessage());
} finally {
mgr.close();
}
return result;
}
// updates the corresponding URL in the DB with the client and campaign data passed as a parameter
// and sets client_target_url = true.
public void updateURLClientAndCampaign(URL targetURLDB) {
EntityManagerFactory emf = PersistenceManager.getInstance().getEntityManagerFactory();
EntityManager mgr = emf.createEntityManager();
try {
mgr.getTransaction().begin();
URL url = mgr.find(URL.class, targetURLDB.getId());
url.setClient_category_id(targetURLDB.getClient_category_id());
url.setUsers_user_id(targetURLDB.getUsers_user_id());
url.setClient_target_url(true);
mgr.merge(url);
mgr.getTransaction().commit();
} catch (Exception e) {
String msg = "Exception thrown: URLDBService: updateURLClientAndCampaign";
log.severe(msg + e.getMessage());
} finally {
mgr.close();
}
}
public static InstanceStateMachine_c[] getManySM_ISMsOnR518(
ModelClass_c[] targets, ClassQueryInterface_c test, boolean loadComponent) {
if (targets == null || targets.length == 0 || targets[0] == null)
return new InstanceStateMachine_c[0];
ModelRoot modelRoot = targets[0].getModelRoot();
if (loadComponent) {
// Containment Relation
PersistableModelComponent[] pmcs = new PersistableModelComponent[targets.length];
for (int i = 0; i < targets.length; i++) {
pmcs[i] = targets[i].getPersistableComponent();
}
PersistenceManager.ensureAllChildInstancesLoaded(
pmcs, modelRoot, InstanceStateMachine_c.class);
}
InstanceList instances = modelRoot.getInstanceList(InstanceStateMachine_c.class);
Vector matches = new Vector();
for (int i = 0; i < targets.length; i++) {
InstanceStateMachine_c source =
(InstanceStateMachine_c) targets[i].backPointer_InstanceStateMachine_R518;
if (source != null && (test == null || test.evaluate(source))) {
matches.add(source);
}
}
if (matches.size() > 0) {
InstanceStateMachine_c[] ret_set = new InstanceStateMachine_c[matches.size()];
matches.copyInto(ret_set);
return ret_set;
} else {
return new InstanceStateMachine_c[0];
}
}
/**
* Updates record with url address with new page authority (pa), domain authority (da), docTitle
* data Then sets URL's get_authority_data to false.
*
* @param urlAddress - target url
* @param pa - Page Authority
* @param da - Domain Authority
* @param domainName - Domain name of url.
*/
public void updateURLData(String urlAddress, Integer pa, Integer da, String docTitle) {
log.info("Entering updateURLData(...) for: " + urlAddress);
EntityManagerFactory emf = PersistenceManager.getInstance().getEntityManagerFactory();
EntityManager mgr = emf.createEntityManager();
int url_id;
try {
url_id = getURLIDFromAddress(urlAddress);
mgr.getTransaction().begin();
URL url = mgr.find(URL.class, url_id);
url.setPage_authority(pa);
url.setDomain_authority(da);
url.setDoc_title(docTitle);
url.setGet_authority_data(false);
mgr.merge(url);
mgr.getTransaction().commit();
} catch (Exception e) {
String msg = "Exception thrown. URLService: updateURLData";
log.severe(msg + e.getMessage());
} finally {
mgr.close();
}
}
/**
* @param targetURL
* @return list of URLs that point to this target
*/
@SuppressWarnings("unchecked")
public List<URL> getBackLinkURLs(Integer targetURLid) {
log.info("Entering getBackLinkURLs");
List<URL> result = null;
EntityManagerFactory emf = PersistenceManager.getInstance().getEntityManagerFactory();
EntityManager mgr = emf.createEntityManager();
// SQL: this works: select * from url u where u.url_id IN (select l.source_id from links l where
// l.target_id = id);
try {
result =
(List<URL>)
mgr.createQuery(
"SELECT u FROM URL u WHERE u.url_id = ANY (SELECT l.source_id FROM Link l WHERE l.target_id = :id)")
.setParameter("id", targetURLid)
.getResultList();
} catch (Exception e) {
String msg = "Exception thrown. URLService: getBackLinkURLs. ";
log.severe(msg + e.getMessage());
} finally {
mgr.close();
}
return result;
}
public Integer noOfClientURLs(Integer clientID) {
EntityManagerFactory emf = PersistenceManager.getInstance().getEntityManagerFactory();
EntityManager mgr = emf.createEntityManager();
Integer result = null;
try {
result =
(Integer)
mgr.createQuery("SELECT COUNT(u) FROM URL u WHERE u.users_user_id = :clientID")
.setParameter("clientID", clientID)
.getSingleResult();
} catch (Exception e) {
String msg = "Exception thrown: URLService: noOfClientURLs";
log.severe(msg + e.getMessage());
} finally {
mgr.close();
}
return result;
}
public void updateDomainNames(List<URL> urls) {
EntityManagerFactory emf = PersistenceManager.getInstance().getEntityManagerFactory();
EntityManager mgr = emf.createEntityManager();
try {
for (URL currentURL : urls) {
mgr.getTransaction().begin();
URL url = mgr.find(URL.class, currentURL.getId());
url.setDomain(currentURL.getDomain());
mgr.merge(url);
mgr.getTransaction().commit();
}
} catch (Exception e) {
String msg = "Exception thrown. URLService: updateDomainNames";
log.severe(msg + e.getMessage());
} finally {
mgr.close();
}
}
@SuppressWarnings("unchecked")
public List<String> getURLAddresses() {
log.info("Entering getURLAddresses");
List<String> result = null;
EntityManagerFactory emf = PersistenceManager.getInstance().getEntityManagerFactory();
EntityManager mgr = emf.createEntityManager();
try {
result = (List<String>) mgr.createQuery("SELECT u.url_address FROM URL u").getResultList();
} catch (Exception e) {
String msg = "Exception thrown. URLService: getURLAddresses";
log.severe(msg + e.getMessage());
} finally {
mgr.close();
}
if (result == null) {
log.warning("No URLs returned");
}
return result;
}
/*
* Returns a list of URLs that are to be monitored for social data...
*/
@SuppressWarnings("unchecked")
public List<URL> getSociallyTrackedURLs() {
log.info("Entering getSociallyTrackedURLs");
List<URL> result = null;
EntityManagerFactory emf = PersistenceManager.getInstance().getEntityManagerFactory();
EntityManager mgr = emf.createEntityManager();
try {
result =
(List<URL>)
mgr.createQuery("SELECT u FROM URL u WHERE u.get_social_data = TRUE").getResultList();
} catch (Exception e) {
String msg = "Exception thrown. URLService: getSociallyTrackedURLs";
log.severe(msg + e.getMessage());
} finally {
mgr.close();
}
if (result == null) {
log.warning("No SociallyTracked URLs returned");
}
return result;
}
/**
* Gets a URL given an ID
*
* @param id
* @return URL
*/
@SuppressWarnings("unchecked")
public URL getURL(String address) {
log.info("Entering getURL[" + address + "]");
List<URL> url = null;
EntityManagerFactory emf = PersistenceManager.getInstance().getEntityManagerFactory();
EntityManager mgr = emf.createEntityManager();
try {
url =
(List<URL>)
mgr.createQuery("SELECT u FROM URL u WHERE u.url_address = :address")
.setParameter("address", address)
.getResultList();
} catch (Exception e) {
String msg = "Exception thrown getting URL: " + address + "URLService: getURL";
log.severe(msg + e.getMessage());
} finally {
mgr.close();
}
if ((null == url) || (url.isEmpty())) return null;
else return url.get(0);
}
public void deleteURL(int url_id) {
log.info("Entering deleteURL. Deleting " + url_id);
EntityManagerFactory emf = PersistenceManager.getInstance().getEntityManagerFactory();
EntityManager mgr = emf.createEntityManager();
try {
mgr.getTransaction().begin();
mgr.createQuery("DELETE FROM URL u WHERE u.url_id = :url_id")
.setParameter("url_id", url_id)
.executeUpdate();
mgr.getTransaction().commit();
} catch (Exception e) {
String msg = "Exception thrown deleting: " + url_id + ". URLService: deleteURL";
// logger.logp(Level.SEVERE, "URLService", "deleteURL",msg ,e);
log.severe(msg + e.getMessage());
} finally {
mgr.close();
}
}
/*
* Returns a list of URLs that were added to the database today.
*/
@SuppressWarnings("unchecked")
public List<URL> getTargetURLsFrom(Date date) {
log.info("Entering getTargetURLsFrom");
List<URL> result = null;
EntityManagerFactory emf = PersistenceManager.getInstance().getEntityManagerFactory();
EntityManager mgr = emf.createEntityManager();
try {
result =
(List<URL>)
mgr.createQuery("SELECT u FROM URL u WHERE u.date = :date AND u.get_backlinks = TRUE")
.setParameter("date", date, TemporalType.DATE)
.getResultList();
} catch (Exception e) {
String msg = "Exception thrown. URLService: getTargetURLsFrom";
log.severe(msg + e.getMessage());
} finally {
mgr.close();
}
if (result == null) {
log.warning("No URLs returned");
}
return result;
}
/*
* Returns list of urls that have had their get_backlinks flag checked, but have not yet got their backlink data eg: from SEOMoz
*/
@SuppressWarnings("unchecked")
public List<URL> getUnproccessedTargetURLs(Integer limit) {
log.info("Entering getUnproccessedTargetURLs");
List<URL> urls = null;
EntityManagerFactory emf = PersistenceManager.getInstance().getEntityManagerFactory();
EntityManager mgr = emf.createEntityManager();
try {
urls =
(List<URL>)
mgr.createQuery(
"SELECT u FROM URL u WHERE u.get_backlinks = TRUE and u.backlinks_got = false")
.setMaxResults(limit)
.getResultList();
} catch (Exception e) {
String msg = "Exception thrown. URLDBService: getUnproccessedTargetURLs";
log.severe(msg + e.getMessage());
} finally {
mgr.close();
}
return urls;
}
/*
* Returns a list of URLs that were added between the 2 dates
*/
@SuppressWarnings("unchecked")
public List<URL> getURLsBetween(Date startDate, Date endDate) {
log.info("Entering getURLsBetween");
List<URL> result = null;
EntityManagerFactory emf = PersistenceManager.getInstance().getEntityManagerFactory();
EntityManager mgr = emf.createEntityManager();
try {
result =
(List<URL>)
mgr.createQuery("SELECT u FROM URL u WHERE u.date BETWEEN :startDate AND :endDate")
.setParameter("startDate", startDate, TemporalType.DATE)
.setParameter("endDate", endDate, TemporalType.DATE)
.getResultList();
} catch (Exception e) {
String msg = "Exception thrown: URLService: getURLsBetween";
log.severe(msg + e.getMessage());
} finally {
mgr.close();
}
if (result == null) {
log.warning("No URLs returned");
}
return result;
}
/**
* @param url
* @return the SEOMoz metric: Domain Authority, if there's already a URL in the DB from that
* domain, - this saves hitting the SEOMoz server unnec. IF there's no url's with domain with
* the DB, then returns null
*/
public Integer getDomainAuthorityForThisDomain(String domainName) {
Integer result = null;
// String domain = "http://";
// domain += TextUtil.returnDomainName(url);
EntityManagerFactory emf = PersistenceManager.getInstance().getEntityManagerFactory();
EntityManager mgr = emf.createEntityManager();
try {
result =
(Integer)
mgr.createQuery(
"SELECT u.domain_authority FROM URL u WHERE u.domain_authority > 0 AND u.url_address LIKE :query")
.setMaxResults(1)
.setParameter("query", "%" + domainName + "%")
.getSingleResult();
} catch (Exception e) {
String msg = "Exception thrown. URLService: getDomainAuthorityForThisDomain";
log.info(msg + e.getMessage());
} finally {
mgr.close();
}
return result;
}
@SuppressWarnings("unchecked")
public Integer getURLIDFromAddress(String urlAddress) {
log.info("Entering getURLIDFromAddress()");
Integer url_id;
List<URL> result = null;
EntityManagerFactory emf = PersistenceManager.getInstance().getEntityManagerFactory();
EntityManager mgr = emf.createEntityManager();
try {
result =
(List<URL>)
mgr.createQuery("SELECT u FROM URL u WHERE u.url_address = :urlAddress")
.setParameter("urlAddress", urlAddress)
.getResultList();
} catch (Exception e) {
String msg = "Exception thrown: URLService: getURLIDFromAddress";
log.severe(msg + e.getMessage());
} finally {
mgr.close();
}
if (result == null || result.isEmpty()) {
log.info("Could not find URL: " + urlAddress);
return 0;
}
url_id = result.get(0).getId();
log.info("url_id: " + url_id);
return url_id;
}
public static void create(Localidad localidad) {
EntityManager entityManager = PersistenceManager.getEntityManager();
EntityTransaction tr = entityManager.getTransaction();
tr.begin();
try {
entityManager.persist(localidad);
tr.commit();
System.out.println(
"Creación de localidad:"
+ localidad.getNombre()
+ ", de la prov: "
+ localidad.getProvincia().getNombre()
+ " exitosa");
} catch (Exception ex) {
tr.rollback();
System.err.println(
"Error en LibroDAO.create"
+ "("
+ Thread.currentThread().getStackTrace()[1].getLineNumber()
+ "):"
+ ex.getLocalizedMessage());
} finally {
entityManager.close();
}
}
@SuppressWarnings("unchecked")
public String getURLAddressFromID(Integer urlID) {
String address;
List<URL> result = null;
EntityManagerFactory emf = PersistenceManager.getInstance().getEntityManagerFactory();
EntityManager mgr = emf.createEntityManager();
try {
result =
(List<URL>)
mgr.createQuery("SELECT u FROM URL u WHERE u.url_id = :urlID")
.setParameter("urlID", urlID)
.getResultList();
} catch (Exception e) {
String msg = "Exception thrown: URLService: getURLIDFromAddress";
log.severe(msg + e.getMessage());
} finally {
mgr.close();
}
if (result == null || result.isEmpty()) {
return null;
}
address = result.get(0).getUrl_address();
return address;
}