Re: [Springframework-developer] WebSphere + JdbcTemplate + startup

[Juergen H. <ju...@in...>]

That behavior of WebSphere's connection pool and transaction coordinator is
quite odd... It implictly marks a connection pool as non-global based on
non-transactional access??

I've added a "lazyInit" bean property to JdbcAccessor, allowing to enforce
lazy initialization of the SQLExceptionTranslator. This will be part of
Spring 1.1.4, scheduled for Monday (provided that SourceForge manages to fix
its file release facility, which has been broken for a week now).

Juergen


-----Original Message-----
From: spr...@li...
[mailto:spr...@li...]On Behalf Of
Andrew
Sent: Friday, January 21, 2005 3:14 PM
To: spr...@li...
Subject: [Springframework-developer] WebSphere + JdbcTemplate + startup


We have little problem running Spring under WebSphere AS 5.0 (precisely,
we use spring framework (with mvc) under the WS Portal).

The problem relates to WS transactions implementation and JdbcTemplate
(precisely, JdbcAccessor). WS starts LTC (Local Transaction Containment)
for J2EE components (EJB or servlet) when we first time accessing DB
without global transaction (UserTransaction). We don`t use EJBs at all, so
WS creates only one LTC - for our servlet (portlet). But LTC can`t
coexists with global transaction (we cant use the following sequence
during request dispatching: get Conn -> access DB -> close Conn -> start
UserTransaction <- BUG).

In all of our DAO beans we`v used global transactions
(JtaTransactionManager + AOP) with XA resources. All works just fine, but
the application startup. When spring is loaded and instantiates
JdbcTemplate, it calls JdbcTemplate.afterPropertiesSet(). This method
initialize ExcpetionTranslator which access DB meta data. So, WS starts
LTC! In following request processing we tray to start UserTransaction and
faced the exception.

So, it would be nice to add support for lazy ExcpetionTranslator
initialization in JdbcTemplate (JdbcAccessor)...

Thanks.



-------------------------------------------------------
This SF.Net email is sponsored by: IntelliVIEW -- Interactive Reporting
Tool for open source databases. Create drag-&-drop reports. Save time
by over 75%! Publish reports on the web. Export to DOC, XLS, RTF, etc.
Download a FREE copy at http://www.intelliview.com/go/osdn_nl
_______________________________________________
Springframework-developer mailing list
Spr...@li...
https://lists.sourceforge.net/lists/listinfo/springframework-developer