Can I have hibernate load complete table

ajaygautam · **Joined:** Wed May 24, 2006 4:40 pm **Posts:** 10

How would I do this without a DAO:

Code:

public class Currencies {
    private Collection<Currency> currencies;
    // getter and setter
}

@Entity @Table(name="currency_data")
public class Currency {
    @Id @Column private Integer number;
    @Column private String name;
    // getters and setters
}

Is there a setup, using which hibernate can load all currencies on: "new Currencies().getCurrencies()".
A JPA solution would be good to have, but not a requirement.

I have this currently working as (using DAO):

Code:

    public Currencies loadTable() {
        final EntityManager em = PersistenceHelper.getEntityManager();
        EntityTransaction tx = em.getTransaction();
        tx.begin();
        try {
            Collection<Currency> cs = em.createQuery("from Currency").getResultList();
            return new Currencies(cs);
        }
        finally {
            tx.rollback(); // read-only
        }
    }

Hibernate version: 3.2
Mapping documents: annotations 3.3.1 / hibernate entity manager 3.3.2

Requirement:
We use Coherence caching solution. This data needs to be in cache as a single object (Collection of all currencies).
I am trying to setup cache configuration to use JPA so that whenever it needs something from the database, cache can itself use JPA to get it.

Any help / pointers would be greatly appreciated.

Ajay

sanne.grinovero · **Posted:** Fri May 16, 2008 2:08 pm

what is it that you don't like in your DAO exactly?

ajaygautam · **Joined:** Wed May 24, 2006 4:40 pm **Posts:** 10

I love the DAO. Nothing wrong with it. The point here is to see if we can do this without a DAO.

I am in a a situation where the DAO will not be called: The deployment is: hibernate as a plugin to another product (Oracle's coherence). There is no way to specify that the other product should call a DAO (or atleast I couldn't find one).

Wondering if there is a way in hibernate to do this.

Does any of this makes sense?

Ajay