I've got WebWork2 and Spring's JDBC stuff working great. Thanks to some help from Thomas, I'm even pulling MetaData through Spring.

I love it.

Now some questions about best-practices when using these two together...

1) Where in WebWork2 should I create my datasource object? Should I create one at session start and store it in WebWork's session object? Or maybe application-start and store it in WebWork's application object? Can I share Spring datasources among WebWorks action invocations like that?

2) I'm using DriverManagerDataSource to create my datasource. I'm a little unclear about whether this is really what I want.

I don't need/want JNDI for finding datasources (at least I don't think so) and I don't need transactions (at the moment). But am I missing out on something else important or, perhaps, shooting myself in the foot by going this route?

3) Am I getting pooled connections when asking for datasources from DriverManagerDataSource? Or do I have to do something else?

Thanks!

- Gary