> Where should I bind that variable? In a companion object to the
> Filter? Or should I still do it in my Filters class? Like:
> class DailyLifFilter extends ScalatraFilter with ScalateSupport with
> DatabaseInit {
>   val dlSession = new DynamicVariable[Session](null)

>   before {
>     dlSession.withValue(SessionFactory.newSession) {
>       dlSession.value.bindToCurrentThread
>     }
>   }

>   after {
>     dlSession.value.close
>     dlSession.value.unbindFromCurrentThread
>   }

> }

> On Apr 27, 9:12 am, Wille Faler <wille.fa...@gmail.com> wrote:

> > Hmm, making it an instance variable of your filter is not thread-safe, so
> > you should probably bind your session to a DynamicVariable/ThreadLocal
> > (DynamicVariable is Scala's equivalent of ThreadLocal)..

> > On 27 April 2011 15:10, Dustin Withers <fadedd...@gmail.com> wrote:

> > > Should something like the following work?

> > > class DailyLifFilter extends ScalatraFilter with ScalateSupport {
> > >  var dlSession:Session = null

> > >  before {
> > >    dlSession = SessionFactory.newSession
> > >    dlSession.bindToCurrentThread
> > >  }

> > >  after {
> > >    dlSession.close
> > >    dlSession.unbindFromCurrentThread
> > >  }
> > > ....

> > > Thanks,
> > > -dustin

> > > On Apr 27, 9:01 am, Wille Faler <wille.fa...@gmail.com> wrote:
> > > > You're probably leaking sessions and connections, as you are not closing
> > > > them or unbinding the session after a request:

> > > > session.close
> > > > session.unbindFromCurrentThread

> > > > On 27 April 2011 14:37, Dustin Withers <fadedd...@gmail.com> wrote:

> > > > > Hello all,

> > > > > I'm new to Scala and new to Scalatra, heck I'm kinda new to Java web
> > > > > development other than a bunch of Oracle work in another life. Anyhow,
> > > > > I'm having some trouble with MySQL and C3P0 connection pooling . The
> > > > > code can be seen here:
> > > > >https://gist.github.com/944244

> > > > > Originally I wasn't using any kind of connection pooling and I
> > > > > eventually exhausted my connections. Now instead of exhausting
> > > > > connections the app seems to run out of C3P0 connections and then
> > > > > locks up with no logging in the console and no CPU usage but the
> > > > > thread count goes up each time I request a page.

> > > > > I've played with all of C3P0's settings and I can stave off the
> > > > > failure by increasing MaxPoolSize but eventually after a enough page
> > > > > requests the app hangs.

> > > > > Any thoughts? Should I bother the people on the Squeryl mailing list?

> > > > > Thanks much for your time,
> > > > > -dustin