Example usage for org.hibernate Query setReadOnly

Introduction

In this page you can find the example usage for org.hibernate Query setReadOnly.

Prototype

Query<R> setReadOnly(boolean readOnly);

Source Link

Document

Set the read-only/modifiable mode for entities and proxies loaded by this Query.

Usage

From source file:edu.ur.hibernate.ir.item.db.HbCopyrightStatementDAO.java

License:Apache License

/**
 * Get the copyright statements ordered by name.
 * /*from   www  . j av a  2  s . co  m*/
 * @see edu.ur.ir.item.ContentTypeDAO#getContentTypesOrderByName(int, int, String)
 */
@SuppressWarnings("unchecked")
public List<CopyrightStatement> getCopyrightStatementsOrderByName(final int rowStart,
        final int numberOfResultsToShow, final OrderType orderType) {
    List<CopyrightStatement> copyrightStatements = (List<CopyrightStatement>) hbCrudDAO.getHibernateTemplate()
            .execute(new HibernateCallback() {
                public Object doInHibernate(Session session) throws HibernateException, SQLException {

                    Query q = null;
                    if (orderType.equals(OrderType.ASCENDING_ORDER)) {
                        q = session.getNamedQuery("getCopyrightStatementByNameAsc");
                    } else {
                        q = session.getNamedQuery("getCopyrightStatementByNameDesc");
                    }

                    q.setFirstResult(rowStart);
                    q.setMaxResults(numberOfResultsToShow);
                    q.setReadOnly(true);
                    q.setFetchSize(numberOfResultsToShow);
                    return q.list();
                }

            });

    return copyrightStatements;
}

---

From source file:edu.ur.hibernate.ir.item.db.HbExtentTypeDAO.java

License:Apache License

/**
 * Get extent types./*w w  w .  j  a v  a 2s.com*/
 * 
 * @see edu.ur.ir.item.ExtentTypeDAO#getExtentTypesOrderByName(int, int, String)
 */
@SuppressWarnings("unchecked")
public List<ExtentType> getExtentTypesOrderByName(final int rowStart, final int numberOfResultsToShow,
        final String sortType) {
    List<ExtentType> extentTypes = (List<ExtentType>) hbCrudDAO.getHibernateTemplate()
            .execute(new HibernateCallback() {
                public Object doInHibernate(Session session) throws HibernateException, SQLException {
                    Query q = null;
                    if (sortType.equalsIgnoreCase("asc")) {
                        q = session.getNamedQuery("getExtentTypesOrderByNameAsc");
                    } else {
                        q = session.getNamedQuery("getExtentTypesOrderByNameDesc");
                    }

                    q.setFirstResult(rowStart);
                    q.setMaxResults(numberOfResultsToShow);
                    q.setReadOnly(true);
                    q.setFetchSize(numberOfResultsToShow);
                    return q.list();
                }
            });

    return extentTypes;
}

---

From source file:edu.ur.hibernate.ir.item.db.HbIdentifierTypeDAO.java

License:Apache License

/**
 * Get identifier types./*from  w  w  w . jav a 2 s. c o m*/
 * 
 * @see edu.ur.ir.item.IdentifierTypeDAO#getIdentifierTypesOrderByName( int, int, String)
 */
@SuppressWarnings("unchecked")
public List<IdentifierType> getIdentifierTypesOrderByName(final int rowStart, final int numberOfResultsToShow,
        final String sortType) {
    List<IdentifierType> identifierTypes = (List<IdentifierType>) hbCrudDAO.getHibernateTemplate()
            .execute(new HibernateCallback() {
                public Object doInHibernate(Session session) throws HibernateException, SQLException {
                    Query q = null;
                    if (sortType.equalsIgnoreCase("asc")) {
                        q = session.getNamedQuery("getIdentifierTypesOrderByNameAsc");
                    } else {
                        q = session.getNamedQuery("getIdentifierTypesOrderByNameDesc");
                    }

                    q.setFirstResult(rowStart);
                    q.setMaxResults(numberOfResultsToShow);
                    q.setReadOnly(true);
                    q.setFetchSize(numberOfResultsToShow);
                    return q.list();
                }
            });
    return identifierTypes;
}

---

From source file:edu.ur.hibernate.ir.item.db.HbLanguageTypeDAO.java

License:Apache License

/**
 * Get the language types order by name.
 * /*  w w w . j a  v  a2  s.c o m*/
 * @see edu.ur.ir.item.LanguageTypeDAO#getLanguageTypesOrderByName(int, int, String)
 */
@SuppressWarnings("unchecked")
public List<LanguageType> getLanguageTypesOrderByName(final int rowStart, final int numberOfResultsToShow,
        final String sortType) {
    List<LanguageType> languageTypes = (List<LanguageType>) hbCrudDAO.getHibernateTemplate()
            .execute(new HibernateCallback() {
                public Object doInHibernate(Session session) throws HibernateException, SQLException {
                    Query q = null;
                    if (sortType.equalsIgnoreCase("asc")) {
                        q = session.getNamedQuery("getLanguageTypesOrderByNameAsc");
                    } else {
                        q = session.getNamedQuery("getLanguageTypesOrderByNameDesc");
                    }

                    q.setFirstResult(rowStart);
                    q.setMaxResults(numberOfResultsToShow);
                    q.setReadOnly(true);
                    q.setFetchSize(numberOfResultsToShow);
                    return q.list();
                }
            });

    return languageTypes;

}

---

From source file:edu.ur.hibernate.ir.item.db.HbPublisherDAO.java

License:Apache License

@SuppressWarnings("unchecked")
public List<Publisher> getPublishersOrderByName(final int rowStart, final int numberOfResultsToShow,
        final String sortType) {
    List<Publisher> publishers = (List<Publisher>) hbCrudDAO.getHibernateTemplate()
            .execute(new HibernateCallback() {
                public Object doInHibernate(Session session) throws HibernateException, SQLException {
                    Query q = null;
                    if (sortType.equalsIgnoreCase("asc")) {
                        q = session.getNamedQuery("getPublishersOrderByNameAsc");
                    } else {
                        q = session.getNamedQuery("getPublishersOrderByNameDesc");
                    }/*from  w  w w. j  av  a 2 s.c  om*/

                    q.setFirstResult(rowStart);
                    q.setMaxResults(numberOfResultsToShow);
                    q.setReadOnly(true);
                    q.setFetchSize(numberOfResultsToShow);
                    return q.list();
                }
            });
    return publishers;
}

---

From source file:edu.ur.hibernate.ir.item.db.HbSeriesDAO.java

License:Apache License

@SuppressWarnings("unchecked")
public List<Series> getSeriesOrderByName(final int rowStart, final int numberOfResultsToShow,
        final String sortType) {
    List<Series> series = (List<Series>) hbCrudDAO.getHibernateTemplate().execute(new HibernateCallback() {
        public Object doInHibernate(Session session) throws HibernateException, SQLException {
            Query q = null;
            if (sortType.equalsIgnoreCase("asc")) {
                q = session.getNamedQuery("getSeriesOrderByNameAsc");
            } else {
                q = session.getNamedQuery("getSeriesOrderByNameDesc");
            }//from   w  w w  . ja va 2 s  .  c  o m

            q.setFirstResult(rowStart);
            q.setMaxResults(numberOfResultsToShow);
            q.setReadOnly(true);
            q.setFetchSize(numberOfResultsToShow);
            return q.list();
        }
    });
    return series;
}

---

From source file:edu.ur.hibernate.ir.item.db.HbSponsorDAO.java

License:Apache License

@SuppressWarnings("unchecked")
public List<Sponsor> getSponsorsOrderByName(final int rowStart, final int numberOfResultsToShow,
        final OrderType orderType) {
    List<Sponsor> sponsors = (List<Sponsor>) hbCrudDAO.getHibernateTemplate().execute(new HibernateCallback() {
        public Object doInHibernate(Session session) throws HibernateException, SQLException {
            Query q = null;
            if (orderType.equals(OrderType.ASCENDING_ORDER)) {
                q = session.getNamedQuery("getSponsorsOrderByNameAsc");
            } else {
                q = session.getNamedQuery("getSponsorsOrderByNameDesc");
            }/*from   w w  w  .ja va2  s.co  m*/

            q.setFirstResult(rowStart);
            q.setMaxResults(numberOfResultsToShow);
            q.setReadOnly(true);
            q.setFetchSize(numberOfResultsToShow);
            return q.list();
        }
    });
    return sponsors;
}

---

From source file:edu.ur.hibernate.ir.item.db.HbSponsorDAO.java

License:Apache License

/**
 *  // w  w  w  .j a  va 2s .c  o  m
 * @see edu.ur.ir.item.SponsorDAO#getByNameFirstChar(int, int, char, edu.ur.order.OrderType)
 */
@SuppressWarnings("unchecked")
public List<Sponsor> getByNameFirstChar(final int rowStart, final int maxResults, final char firstChar,
        final OrderType orderType) {
    List<Sponsor> sponsors = (List<Sponsor>) hbCrudDAO.getHibernateTemplate().execute(new HibernateCallback() {
        public Object doInHibernate(Session session) throws HibernateException, SQLException {
            Query q = null;
            if (orderType.equals(OrderType.ASCENDING_ORDER)) {
                q = session.getNamedQuery("getSponsorsOrderByNameFirstCharAsc");
            } else {
                q = session.getNamedQuery("getSponsorsOrderByNameFirstCharDesc");
            }
            q.setCharacter("sponsorFirstChar", Character.toLowerCase(firstChar));
            q.setFirstResult(rowStart);
            q.setMaxResults(maxResults);
            q.setReadOnly(true);
            q.setFetchSize(maxResults);
            return q.list();
        }
    });
    return sponsors;
}

---

From source file:edu.ur.hibernate.ir.item.db.HbSponsorDAO.java

License:Apache License

/**
 * //  w  w w. j  a v  a 2s. c o m
 * @see edu.ur.ir.item.SponsorDAO#getSponsorsByNameBetweenChar(int, int, char, char, edu.ur.order.OrderType)
 */
@SuppressWarnings("unchecked")
public List<Sponsor> getSponsorsByNameBetweenChar(final int rowStart, final int maxResults,
        final char firstChar, final char lastChar, final OrderType orderType) {
    List<Sponsor> sponsors = (List<Sponsor>) hbCrudDAO.getHibernateTemplate().execute(new HibernateCallback() {
        public Object doInHibernate(Session session) throws HibernateException, SQLException {
            Query q = null;
            if (orderType.equals(OrderType.ASCENDING_ORDER)) {
                q = session.getNamedQuery("getSponsorsOrderByNameFirstCharRangeAsc");
            } else {
                q = session.getNamedQuery("getSponsorsOrderByNameFirstCharRangeDesc");
            }
            q.setCharacter("firstChar", Character.toLowerCase(firstChar));
            q.setCharacter("secondChar", Character.toLowerCase(lastChar));
            q.setFirstResult(rowStart);
            q.setMaxResults(maxResults);
            q.setReadOnly(true);
            q.setFetchSize(maxResults);
            return q.list();
        }
    });
    return sponsors;
}

---

From source file:edu.ur.hibernate.ir.news.db.HbNewsDAO.java

License:Apache License

@SuppressWarnings("unchecked")
public List<NewsItem> getNewsItems(final int rowStart, final int numberOfResultsToShow, final String sortType) {
    List<NewsItem> newsItems = (List<NewsItem>) hbCrudDAO.getHibernateTemplate()
            .execute(new HibernateCallback() {
                public Object doInHibernate(Session session) throws HibernateException, SQLException {
                    Query q = null;
                    if (sortType.equalsIgnoreCase("asc")) {
                        q = session.getNamedQuery("getNewsItemsOrderByNameAsc");
                    } else {
                        q = session.getNamedQuery("getNewsItemsOrderByNameDesc");
                    }//from  www .  j  a  v  a2 s.  c  o  m

                    q.setFirstResult(rowStart);
                    q.setMaxResults(numberOfResultsToShow);
                    q.setReadOnly(true);
                    q.setFetchSize(numberOfResultsToShow);
                    return q.list();
                }
            });

    return newsItems;
}

---

• «
• 1
• 2
• 3
• 4
• 5
• 6
• 7
• 8
• 9
• 10
• 11
• »