Re: spring hibernate simple dao JSP

From:

=?ISO-8859-1?Q?Arne_Vajh=F8j?= <arne@vajhoej.dk>

Newsgroups:

comp.lang.java.programmer

Date:

Tue, 08 Mar 2011 19:36:45 -0500

Message-ID:

<4d76cb95$0$23753$14726298@news.sunsite.dk>

On 07-03-2011 20:31, comp.lang.java.programmer wrote:

I'm looking for a simple way to open and close a transaction. (read-only report. spring mvc app)

I need to send the results to a JSP page. I don't need a transaction to span more than one dao.

I arrived at this piece of code:

    public List<XDto> load() {
        Session session = sessionFactory.openSession();

        List<XDto> list = crit.list();

        session.close();
        return list;

    }

And it seems to work!

The results appear correctly on the JSP page. I don't have any lazy loading issues.

The connections are closed because I can click indefinitely on the page.

Does it make sense? (I don't have any Transaction tx = session.beginTransaction()or commit(). )

Is it using non-lazy loading and that explains why the JSP always works?

Ideally I would also remove the sessionFactory.openSession()
and
session.close(). Maybe that's possible with AOP ?

Yes - you can do it via AOP.

Or you can use the well-known (but often debated)
session-per-request pattern.

Arne