Using JDBC support classes in a non-spring environment

[nivek]

I am interested in incoporating Spring's support classes into a very large project which is primarily using plain JBDC for it's data access. What would be the best way to incorporate Spring's JDBC support for new code while still supporting the usage of traditional JDBC? Using JBoss 3.2.6 and JNDI lookup for Connection's. I would like to continue to use the container's transaction management unless both Spring and JBoss's transaction management could be used together. I have read through the documentation and see that it is supported just with little guidance.

Thanks for any help..

[garcima]

Hello Nivek, have you got any hints about your situation?

Regards,

Carlos Morales

[nivek]

Unforunately, no I have not had any responses.

[Dan Washusen]

I may be just stating the obvious so I apoligise if that's the case...

Isn't it as simple as:

JdbcTemplate template = new JdbcTemplate(myDataSource);

List myList = template.queryForList(sql);

Maybe I'm missing something... When you say your using the containers transaction managment it's a session bean? "It should just work" (tm) as if your using pure JDBC.