RE: Hibernate Session to User Session
Hi, I m no expert in hibernate :-( , I got suggestions >From list and hibernate docs... If u check hibernate reference, it mentions somewhere why They suggest using ThreadLocal. If I remember correctly they say that proper use is to use One session (hibernate session) per request.. then I checked The Struts plugin for hibernate and hibernate samples.. Sorry for not being of any much help :-( Regards marco -Original Message- From: Riyad Kalla [mailto:[EMAIL PROTECTED] Sent: 08 June 2004 14:54 To: Struts Users Mailing List Subject: Re: Hibernate Session to User Session Marco, I believe that is what I am using now (it seems to be quite popular) but I don't quite understand the reasoning behind the ThreadLocal approach (I've actually never used 'ThreadLocal')... can you shed some light on this? What the mapping between Hibernate Sessions and Users (or Threads) becomes? Marco Mistroni wrote: >Hi, > On hibernate website, there's an example that associates >A session to a threadlocal. You can safely use that pattern (it's one >Of hibernate patterns)... >You could have a DAOFactory (plugin) which instantiates the >SessionFactory, >And each DAO will get its own session associated with its ThreadLocal.. > >Have a look at hibernate website for patterns on how to use Session > >Regards, marco > >-Original Message- >From: Riyad Kalla [mailto:[EMAIL PROTECTED] >Sent: 08 June 2004 00:14 >To: Struts Users Mailing List >Subject: OT: Hibernate Session to User Session > >I was reading in the Hibernate forums that when you have a WebApp > DAO > > >>Hibernate > DB design, and you open/close each Hibernate session at >> >> >every single DAO method call (what I do now) its actually quite >expensive, and is suggested that you attempt to maintain a Hibernate >Session in conjunction with a user Session to increase performance. > >I had a question for anyone that has done this (without using >SpringFramework). My gut-reaction to this was to add a >HttpSessionListener to my webapp that created and stored a Hibernate >session in the user's session, and then close it when the Session >expired... will this not work? Anyone else have a good solution for >this? > >TIA, >Riyad > > >- >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] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: Hibernate Session to User Session
Marco, I believe that is what I am using now (it seems to be quite popular) but I don't quite understand the reasoning behind the ThreadLocal approach (I've actually never used 'ThreadLocal')... can you shed some light on this? What the mapping between Hibernate Sessions and Users (or Threads) becomes? Marco Mistroni wrote: Hi, On hibernate website, there's an example that associates A session to a threadlocal. You can safely use that pattern (it's one Of hibernate patterns)... You could have a DAOFactory (plugin) which instantiates the SessionFactory, And each DAO will get its own session associated with its ThreadLocal.. Have a look at hibernate website for patterns on how to use Session Regards,marco -Original Message- From: Riyad Kalla [mailto:[EMAIL PROTECTED] Sent: 08 June 2004 00:14 To: Struts Users Mailing List Subject: OT: Hibernate Session to User Session I was reading in the Hibernate forums that when you have a WebApp > DAO Hibernate > DB design, and you open/close each Hibernate session at every single DAO method call (what I do now) its actually quite expensive, and is suggested that you attempt to maintain a Hibernate Session in conjunction with a user Session to increase performance. I had a question for anyone that has done this (without using SpringFramework). My gut-reaction to this was to add a HttpSessionListener to my webapp that created and stored a Hibernate session in the user's session, and then close it when the Session expired... will this not work? Anyone else have a good solution for this? TIA, Riyad - 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: Hibernate Session to User Session
Hi, On hibernate website, there's an example that associates A session to a threadlocal. You can safely use that pattern (it's one Of hibernate patterns)... You could have a DAOFactory (plugin) which instantiates the SessionFactory, And each DAO will get its own session associated with its ThreadLocal.. Have a look at hibernate website for patterns on how to use Session Regards,marco -Original Message- From: Riyad Kalla [mailto:[EMAIL PROTECTED] Sent: 08 June 2004 00:14 To: Struts Users Mailing List Subject: OT: Hibernate Session to User Session I was reading in the Hibernate forums that when you have a WebApp > DAO > Hibernate > DB design, and you open/close each Hibernate session at every single DAO method call (what I do now) its actually quite expensive, and is suggested that you attempt to maintain a Hibernate Session in conjunction with a user Session to increase performance. I had a question for anyone that has done this (without using SpringFramework). My gut-reaction to this was to add a HttpSessionListener to my webapp that created and stored a Hibernate session in the user's session, and then close it when the Session expired... will this not work? Anyone else have a good solution for this? TIA, Riyad - 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: Hibernate Session to User Session
It's not very process intensive if you are using a connection pool where it just hands you an already-open connection. Hibernate can use a few different connection pools including JCS, C3P0, OSCache, etc. Regards, David -Original Message- From: Riyad Kalla [mailto:[EMAIL PROTECTED] Sent: Monday, June 07, 2004 7:14 PM To: Struts Users Mailing List Subject: OT: Hibernate Session to User Session I was reading in the Hibernate forums that when you have a WebApp > DAO > Hibernate > DB design, and you open/close each Hibernate session at every single DAO method call (what I do now) its actually quite expensive, and is suggested that you attempt to maintain a Hibernate Session in conjunction with a user Session to increase performance. I had a question for anyone that has done this (without using SpringFramework). My gut-reaction to this was to add a HttpSessionListener to my webapp that created and stored a Hibernate session in the user's session, and then close it when the Session expired... will this not work? Anyone else have a good solution for this? TIA, Riyad - 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: Hibernate Session to User Session
Brian, I agree that sounds very expensive, I don't know how Hibernate works yet so I didn't know what a Hibernate Session really consists of to know if that was as resource intensive as it sounded. If this is the case, then I suppose using the HibernateUtil that I am using now from the Hibernate docs is probably the way to go (does the ThreadLocal business) Brian Alexander Lee wrote: Wouldn't that be pretty resource intensive since it would basically mean that you have a database connection for every user session in your app. Typically that is pretty bad and getting a new connection from a connection pool is usually pretty quick. I'm unfamiliar with how hibernate manges sessions and connections so let me know if I'm wrong. I'm looking at using Hibernate in my struts actions, but also in my ejbs so of course I wouldn't be able to tie hibernate sessions with http sessions. Thanks, BAL - Original Message - From: "Riyad Kalla" <[EMAIL PROTECTED]> To: "Struts Users Mailing List" <[EMAIL PROTECTED]> Sent: Monday, June 07, 2004 7:13 PM Subject: OT: Hibernate Session to User Session I was reading in the Hibernate forums that when you have a WebApp > DAO Hibernate > DB design, and you open/close each Hibernate session at every single DAO method call (what I do now) its actually quite expensive, and is suggested that you attempt to maintain a Hibernate Session in conjunction with a user Session to increase performance. I had a question for anyone that has done this (without using SpringFramework). My gut-reaction to this was to add a HttpSessionListener to my webapp that created and stored a Hibernate session in the user's session, and then close it when the Session expired... will this not work? Anyone else have a good solution for this? TIA, Riyad - 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: Hibernate Session to User Session
Wouldn't that be pretty resource intensive since it would basically mean that you have a database connection for every user session in your app. Typically that is pretty bad and getting a new connection from a connection pool is usually pretty quick. I'm unfamiliar with how hibernate manges sessions and connections so let me know if I'm wrong. I'm looking at using Hibernate in my struts actions, but also in my ejbs so of course I wouldn't be able to tie hibernate sessions with http sessions. Thanks, BAL - Original Message - From: "Riyad Kalla" <[EMAIL PROTECTED]> To: "Struts Users Mailing List" <[EMAIL PROTECTED]> Sent: Monday, June 07, 2004 7:13 PM Subject: OT: Hibernate Session to User Session > I was reading in the Hibernate forums that when you have a WebApp > DAO > > Hibernate > DB design, and you open/close each Hibernate session at > every single DAO method call (what I do now) its actually quite > expensive, and is suggested that you attempt to maintain a Hibernate > Session in conjunction with a user Session to increase performance. > > I had a question for anyone that has done this (without using > SpringFramework). My gut-reaction to this was to add a > HttpSessionListener to my webapp that created and stored a Hibernate > session in the user's session, and then close it when the Session > expired... will this not work? Anyone else have a good solution for > this? > > TIA, > Riyad > > > - > 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]
