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<Division> results = (List<Division>)
> >> 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]
> >>
> >>
> >>
> >
> >
> >
>
>
> ---------------------------------------------------------------------
> 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]
