Re: More on Wicket/Hibernate...
It's really very simple. I'm doing the same thing here. You simple use the HibernateUtil example that is in the Hibernate documentation. Then you simple create a custom RequestCycle by overriding this method in your application. With the request cycle you can open and close Hibernate seesion. Then with a custom RequestCycle you can get it from anywhere, it uses thread local, and us it to access your database. Here's some example code: ## @Override public RequestCycle newRequestCycle(Request request, Response response) { return new RequestCycleImpl(this, request, response); } ## public class RequestCycleImpl extends WebRequestCycle { private Session hibernateSession; public RequestCycleImpl(Application application, Request request, Response response) { super(application, (WebRequest) request, response); } @Override protected void onBeginRequest() { this.hibernateSession = HibernateUtil.getSessionFactory().openSession(); } @Override protected void onEndRequest() { if (this.hibernateSession != null) { this.hibernateSession.close(); } } public Session getHibernateSession() { return hibernateSession; } } ## public class AllDivisionModel extends LoadableDetachableModel { protected Object load() { Session session = ((RequestCycleImpl) RequestCycle.get()).getHibernateSession(); Transaction tx = session.beginTransaction(); try { @SuppressWarnings(value = "unchecked") List results = (List) session.createCriteria(Division.class) .addOrder(Order.asc("name")) .list(); tx.commit(); return results; } catch (Exception e) { Logger.getLogger(getClass()).error(e); tx.rollback(); } return new ArrayList(); } } ## private boolean isLoggedIn(String username, String password) { Session session = ((RequestCycleImpl) getRequestCycle()).getHibernateSession(); Transaction tx = session.beginTransaction(); try { SysUser user = (SysUser) session.createCriteria(SysUser.class) .add(Restrictions.eq("username", username)) .add(Restrictions.eq("password", password)) .uniqueResult(); if (!user.isLockout()) { return true; } tx.commit(); } catch (Exception e) { Logger.getLogger(getClass()).error(e); tx.rollback(); } return false; } ## All that said, I'm pretty new my self, so I'm sure it can be improved. This seems to work so far for me. Neil B. Cohen wrote: I suspect I'm biting off more than I can chew conveniently but maybe someone can push me in the right direction... I'm attempting to build a fairly simple web application with Wicket, and I'd like to use Hibernate to manage the database access (although other frameworks like Cayenne have been suggested and I'll look at them too...) I think I've figured out the basic application structure, and how to map my data to an html page. But I don't think I understand the relationships between web sessions, hibernate sessions, DAO objects etc. I need to open a mysql db, read a set of objects from a table, and display them in a (paged) table on the screen. I've looked at several examples but they are using in-memory databases, or Spring along with Hibernate and I can't get a handle on what needs to be done to whom and by whom Anyone have a really simple MySQL example like that? Or an online tutorial that I could follow? Much obliged, nbc - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] -- Justin Stanczak Stanczak Group 812-735-3600 "All that is necessary for the triumph of evil is that good men do nothing." Edmund Burke - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: More on Wicket/Hibernate...
Martijn Dashorst wrote: According to me you can use Hibernate's thread local session if you want (you still need the custom request cycle though!). This removes the need for all the casting and getting. Session.get().createCriteria(SysUser.class).add(.).uniqueResult(); Hibernate session, not Wicket's Martijn Thanks for the sample code - I'll see what I can do with it - you'll probably hear from me again :) nbc On 10/4/07, Stanczak Group <[EMAIL PROTECTED]> wrote: It's really very simple. I'm doing the same thing here. You simple use the HibernateUtil example that is in the Hibernate documentation. Then you simple create a custom RequestCycle by overriding this method in your application. With the request cycle you can open and close Hibernate seesion. Then with a custom RequestCycle you can get it from anywhere, it uses thread local, and us it to access your database. Here's some example code: ## @Override public RequestCycle newRequestCycle(Request request, Response response) { return new RequestCycleImpl(this, request, response); } ## public class RequestCycleImpl extends WebRequestCycle { private Session hibernateSession; public RequestCycleImpl(Application application, Request request, Response response) { super(application, (WebRequest) request, response); } @Override protected void onBeginRequest() { this.hibernateSession = HibernateUtil.getSessionFactory().openSession(); } @Override protected void onEndRequest() { if (this.hibernateSession != null) { this.hibernateSession.close(); } } public Session getHibernateSession() { return hibernateSession; } } ## public class AllDivisionModel extends LoadableDetachableModel { protected Object load() { Session session = ((RequestCycleImpl) RequestCycle.get()).getHibernateSession(); Transaction tx = session.beginTransaction(); try { @SuppressWarnings(value = "unchecked") List results = (List) session.createCriteria(Division.class) .addOrder(Order.asc("name")) .list(); tx.commit(); return results; } catch (Exception e) { Logger.getLogger(getClass()).error(e); tx.rollback(); } return new ArrayList(); } } ## private boolean isLoggedIn(String username, String password) { Session session = ((RequestCycleImpl) getRequestCycle()).getHibernateSession(); Transaction tx = session.beginTransaction(); try { SysUser user = (SysUser) session.createCriteria(SysUser.class) .add(Restrictions.eq("username", username)) .add(Restrictions.eq("password", password)) .uniqueResult(); if (!user.isLockout()) { return true; } tx.commit(); } catch (Exception e) { Logger.getLogger(getClass()).error(e); tx.rollback(); } return false; } ## All that said, I'm pretty new my self, so I'm sure it can be improved. This seems to work so far for me. Neil B. Cohen wrote: I suspect I'm biting off more than I can chew conveniently but maybe someone can push me in the right direction... I'm attempting to build a fairly simple web application with Wicket, and I'd like to use Hibernate to manage the database access (although other frameworks like Cayenne have been suggested and I'll look at them too...) I think I've figured out the basic application structure, and how to map my data to an html page. But I don't think I understand the relationships between web sessions, hibernate sessions, DAO objects etc. I need to open a mysql db, read a set of objects from a table, and display them in a (paged) table on the screen. I've looked at several examples but they are using in-memory databases, or Spring along with Hibernate and I can't get a handle on what needs to be done to whom and by whom Anyone have a really simple MySQL example like that? Or an online tutorial that I could follow? Much obliged, nbc - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] -- Justin Stanczak Stanczak Group 812-735-3600 "All that is necessary for the triumph of evil
Re: More on Wicket/Hibernate...
On 10/4/07, Neil B. Cohen <[EMAIL PROTECTED]> wrote: > Thanks for the sample code - I'll see what I can do with it - you'll > probably hear from me again :) thanks for the warning -igor > > nbc > > On 10/4/07, Stanczak Group <[EMAIL PROTECTED]> wrote: > > > >> It's really very simple. I'm doing the same thing here. You simple use > >> the HibernateUtil example that is in the Hibernate documentation. Then > >> you simple create a custom RequestCycle by overriding this method in > >> your application. With the request cycle you can open and close > >> Hibernate seesion. Then with a custom RequestCycle you can get it from > >> anywhere, it uses thread local, and us it to access your database. > >> Here's some example code: > >> ## > >> @Override > >> public RequestCycle newRequestCycle(Request request, Response > >> response) { > >> return new RequestCycleImpl(this, request, response); > >> } > >> ## > >> public class RequestCycleImpl extends WebRequestCycle { > >> > >> private Session hibernateSession; > >> > >> public RequestCycleImpl(Application application, Request request, > >> Response response) { > >> super(application, (WebRequest) request, response); > >> } > >> > >> @Override > >> protected void onBeginRequest() { > >> this.hibernateSession = > >> HibernateUtil.getSessionFactory().openSession(); > >> } > >> > >> @Override > >> protected void onEndRequest() { > >> if (this.hibernateSession != null) { > >> this.hibernateSession.close(); > >> } > >> } > >> > >> public Session getHibernateSession() { > >> return hibernateSession; > >> } > >> } > >> ## > >> public class AllDivisionModel extends LoadableDetachableModel { > >> > >> protected Object load() { > >> Session session = ((RequestCycleImpl) > >> RequestCycle.get()).getHibernateSession(); > >> Transaction tx = session.beginTransaction(); > >> try { > >> @SuppressWarnings(value = "unchecked") > >> List results = (List) > >> session.createCriteria(Division.class) > >> .addOrder(Order.asc("name")) > >> .list(); > >> tx.commit(); > >> return results; > >> } catch (Exception e) { > >> Logger.getLogger(getClass()).error(e); > >> tx.rollback(); > >> } > >> return new ArrayList(); > >> } > >> } > >> ## > >> private boolean isLoggedIn(String username, String password) { > >> Session session = ((RequestCycleImpl) > >> getRequestCycle()).getHibernateSession(); > >> Transaction tx = session.beginTransaction(); > >> try { > >> SysUser user = (SysUser) > >> session.createCriteria(SysUser.class) > >> .add(Restrictions.eq("username", username)) > >> .add(Restrictions.eq("password", password)) > >> .uniqueResult(); > >> if (!user.isLockout()) { > >> return true; > >> } > >> tx.commit(); > >> } catch (Exception e) { > >> Logger.getLogger(getClass()).error(e); > >> tx.rollback(); > >> } > >> return false; > >> } > >> ## > >> > >> All that said, I'm pretty new my self, so I'm sure it can be improved. > >> This seems to work so far for me. > >> > >> Neil B. Cohen wrote: > >> > >>> I suspect I'm biting off more than I can chew conveniently but maybe > >>> someone can push me in the right direction... > >>> > >>> I'm attempting to build a fairly simple web application with Wicket, > >>> and I'd like to use Hibernate to manage the database access (although > >>> other frameworks like Cayenne have been suggested and I'll look at > >>> them too...) > >>> > >>> I think I've figured out the basic application structure, and how to > >>> map my data to an html page. But I don't think I understand the > >>> relationships between web sessions, hibernate sessions, DAO objects > >>> etc. I need to open a mysql db, read a set of objects from a table, > >>> and display them in a (paged) table on the screen. I've looked at > >>> several examples but they are using in-memory databases, or Spring > >>> along with Hibernate and I can't get a handle on what needs to be done > >>> to whom and by whom > >>> > >>> Anyone have a really simple MySQL example like that? Or an online > >>> tutorial t
Re: More on Wicket/Hibernate...
According to me you can use Hibernate's thread local session if you want (you still need the custom request cycle though!). This removes the need for all the casting and getting. Session.get().createCriteria(SysUser.class).add(.).uniqueResult(); Hibernate session, not Wicket's Martijn On 10/4/07, Stanczak Group <[EMAIL PROTECTED]> wrote: > It's really very simple. I'm doing the same thing here. You simple use > the HibernateUtil example that is in the Hibernate documentation. Then > you simple create a custom RequestCycle by overriding this method in > your application. With the request cycle you can open and close > Hibernate seesion. Then with a custom RequestCycle you can get it from > anywhere, it uses thread local, and us it to access your database. > Here's some example code: > ## > @Override > public RequestCycle newRequestCycle(Request request, Response > response) { > return new RequestCycleImpl(this, request, response); > } > ## > public class RequestCycleImpl extends WebRequestCycle { > > private Session hibernateSession; > > public RequestCycleImpl(Application application, Request request, > Response response) { > super(application, (WebRequest) request, response); > } > > @Override > protected void onBeginRequest() { > this.hibernateSession = > HibernateUtil.getSessionFactory().openSession(); > } > > @Override > protected void onEndRequest() { > if (this.hibernateSession != null) { > this.hibernateSession.close(); > } > } > > public Session getHibernateSession() { > return hibernateSession; > } > } > ## > public class AllDivisionModel extends LoadableDetachableModel { > > protected Object load() { > Session session = ((RequestCycleImpl) > RequestCycle.get()).getHibernateSession(); > Transaction tx = session.beginTransaction(); > try { > @SuppressWarnings(value = "unchecked") > List results = (List) > session.createCriteria(Division.class) > .addOrder(Order.asc("name")) > .list(); > tx.commit(); > return results; > } catch (Exception e) { > Logger.getLogger(getClass()).error(e); > tx.rollback(); > } > return new ArrayList(); > } > } > ## > private boolean isLoggedIn(String username, String password) { > Session session = ((RequestCycleImpl) > getRequestCycle()).getHibernateSession(); > Transaction tx = session.beginTransaction(); > try { > SysUser user = (SysUser) > session.createCriteria(SysUser.class) > .add(Restrictions.eq("username", username)) > .add(Restrictions.eq("password", password)) > .uniqueResult(); > if (!user.isLockout()) { > return true; > } > tx.commit(); > } catch (Exception e) { > Logger.getLogger(getClass()).error(e); > tx.rollback(); > } > return false; > } > ## > > All that said, I'm pretty new my self, so I'm sure it can be improved. > This seems to work so far for me. > > Neil B. Cohen wrote: > > I suspect I'm biting off more than I can chew conveniently but maybe > > someone can push me in the right direction... > > > > I'm attempting to build a fairly simple web application with Wicket, > > and I'd like to use Hibernate to manage the database access (although > > other frameworks like Cayenne have been suggested and I'll look at > > them too...) > > > > I think I've figured out the basic application structure, and how to > > map my data to an html page. But I don't think I understand the > > relationships between web sessions, hibernate sessions, DAO objects > > etc. I need to open a mysql db, read a set of objects from a table, > > and display them in a (paged) table on the screen. I've looked at > > several examples but they are using in-memory databases, or Spring > > along with Hibernate and I can't get a handle on what needs to be done > > to whom and by whom > > > > Anyone have a really simple MySQL example like that? Or an online > > tutorial that I could follow? > > > > Much obliged, > > > > nbc > > > > - > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > For additional commands, e-mail:
Re: More on Wicket/Hibernate...
this can all be done independently of wicket using a servletcontextlistener for sessionfactory start/shutdown and a servlet filter for closing the session at the end of requests. go for the simplest things first :) -igor On 10/4/07, Stanczak Group <[EMAIL PROTECTED]> wrote: > Another piece I forgot to add is the config and shutting down of the > factory. I use this in the WebApplication: > > @Override > protected void init() { > try { > HibernateUtil.setSessionFactory(new > Configuration().configure().buildSessionFactory()); > } catch (Throwable e) { > Logger.getLogger(getClass()).error(e); > } > } > > @Override > protected void onDestroy() { > HibernateUtil.getSessionFactory().close(); > } > > Neil B. Cohen wrote: > > Martijn Dashorst wrote: > >> According to me you can use Hibernate's thread local session if you > >> want (you still need the custom request cycle though!). This removes > >> the need for all the casting and getting. > >> > >> Session.get().createCriteria(SysUser.class).add(.).uniqueResult(); > >> > >> Hibernate session, not Wicket's > >> > >> Martijn > >> > >> > >> > > > > > > - > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > For additional commands, e-mail: [EMAIL PROTECTED] > > > > > > -- > Justin Stanczak > Stanczak Group > 812-735-3600 > > "All that is necessary for the triumph of evil is that good men do nothing." > Edmund Burke > > > - > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: More on Wicket/Hibernate...
If you are using Spring, you may be interested in a Servlet Filter that supports opening/closing sessions on a per-request basis: http://static.springframework.org/spring/docs/2.0.x/api/org/springframework/orm/jpa/support/OpenEntityManagerInViewFilter.html Mike Neil B. Cohen wrote: I suspect I'm biting off more than I can chew conveniently but maybe someone can push me in the right direction... I'm attempting to build a fairly simple web application with Wicket, and I'd like to use Hibernate to manage the database access (although other frameworks like Cayenne have been suggested and I'll look at them too...) I think I've figured out the basic application structure, and how to map my data to an html page. But I don't think I understand the relationships between web sessions, hibernate sessions, DAO objects etc. I need to open a mysql db, read a set of objects from a table, and display them in a (paged) table on the screen. I've looked at several examples but they are using in-memory databases, or Spring along with Hibernate and I can't get a handle on what needs to be done to whom and by whom Anyone have a really simple MySQL example like that? Or an online tutorial that I could follow? Much obliged, nbc - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: More on Wicket/Hibernate...
Another piece I forgot to add is the config and shutting down of the factory. I use this in the WebApplication: @Override protected void init() { try { HibernateUtil.setSessionFactory(new Configuration().configure().buildSessionFactory()); } catch (Throwable e) { Logger.getLogger(getClass()).error(e); } } @Override protected void onDestroy() { HibernateUtil.getSessionFactory().close(); } Neil B. Cohen wrote: Martijn Dashorst wrote: According to me you can use Hibernate's thread local session if you want (you still need the custom request cycle though!). This removes the need for all the casting and getting. Session.get().createCriteria(SysUser.class).add(.).uniqueResult(); Hibernate session, not Wicket's Martijn - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] -- Justin Stanczak Stanczak Group 812-735-3600 "All that is necessary for the triumph of evil is that good men do nothing." Edmund Burke - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: More on Wicket/Hibernate...
Neil B. Cohen wrote: > Anyone have a really simple MySQL example like that? Or an online > tutorial that I could follow? We have one of those: http://databinder.net/site/show/baseball-players I don't know if you want to use Databinder or not, but you aren't going to find a lot of code or tutorials otherwise for what you're asking because most people are using Spring managed sessions and transactions. If you need any help that is particular to Databinder please register on the forum and send me an email immediately afterward, or else the registration will be lost among 300 spam registrations. Nathan - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: More on Wicket/Hibernate...
Michael Laccetti wrote: If you are using Spring, you may be interested in a Servlet Filter that supports opening/closing sessions on a per-request basis: http://static.springframework.org/spring/docs/2.0.x/api/org/springframework/orm/jpa/support/OpenEntityManagerInViewFilter.html Mike Thanks - at the moment, I'm not using Spring - I was trying to figure out if I need to use it - that would mean yet another framework to learn at the same time as Wicket and Hibernate nbc Neil B. Cohen wrote: I suspect I'm biting off more than I can chew conveniently but maybe someone can push me in the right direction... I'm attempting to build a fairly simple web application with Wicket, and I'd like to use Hibernate to manage the database access (although other frameworks like Cayenne have been suggested and I'll look at them too...) I think I've figured out the basic application structure, and how to map my data to an html page. But I don't think I understand the relationships between web sessions, hibernate sessions, DAO objects etc. I need to open a mysql db, read a set of objects from a table, and display them in a (paged) table on the screen. I've looked at several examples but they are using in-memory databases, or Spring along with Hibernate and I can't get a handle on what needs to be done to whom and by whom Anyone have a really simple MySQL example like that? Or an online tutorial that I could follow? Much obliged, nbc - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: More on Wicket/Hibernate...
I'm not sure if Spring is something that really requires much learning - More than anything it is a good way of tying together a bunch of disparate frameworks for use together. Neil B. Cohen wrote: Michael Laccetti wrote: > If you are using Spring, you may be interested in a Servlet Filter > that supports opening/closing sessions on a per-request basis: > http://static.springframework.org/spring/docs/2.0.x/api/org/springframework/orm/jpa/support/OpenEntityManagerInViewFilter.html > > > Mike Thanks - at the moment, I'm not using Spring - I was trying to figure out if I need to use it - that would mean yet another framework to learn at the same time as Wicket and Hibernate nbc - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]