Oct 14th, 2004, 10:00 PM
Integrating Spring JDBC and WebWork2
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?