exacttly - the whole point of JdbcTemplate is that you do not need to do any connection management.
Spring 101. R On Sat, Aug 1, 2009 at 8:53 AM, Colin B-S<[email protected]> wrote: > > Keith is right, this is more likely to be your configuration in > WebSphere. > Also the JDBCTemplate will close your connection for you. If the > connection is configured as a pooled connection then the close() just > returns it to the pool. > > Colin. > > On Jul 31, 3:14 pm, Arulin of ACBL <[email protected]> wrote: >> Hello Java Posse, >> >> Our system Admin is tearing his hair out over JDBCtemplete, it is not >> closing threads that it opens between Websphere App Server and DB2, we >> are on an AS400/AIX based system. The system gets over 1000 threads >> that are just sitting there, I've searched the net for possible >> solutions with little luck. Is there a way of making the DAO close the >> threads safely so that JDBCTemplete isn't half doing it's job? >> >> I'll toss an example of our current the DAO... >> ******************************************************************************* >> package learntoplaybridge.jdbc.dao; >> >> import java.sql.SQLException; >> import java.util.List; >> >> import org.acbl.utility.Util; >> import org.apache.log4j.Logger; >> import org.springframework.jdbc.core.RowMapperResultReader; >> >> public class TableJdbcDao extends AbstractJdbcDao { >> private String sql; >> >> private Object[] params; >> >> private String db = (Util.getServer().equals("PROD")) ? "file.table" >> : "test.table"; >> >> public Table lookUpPrices(){ >> sql = "select MNEW$, MMEM$1 from {db} order by MYYMM desc"; >> sql = Util.replaceSubString(sql, "{db}", db); >> List l = getJdbcTemplate().query(sql, params, new >> RowMapperResultReader(new MEP022RowMapper())); >> return (l.size() > 0)? (MEP022)l.get(0) : null; >> } >> >> // Ensuring the data ccnnection is closed >> // This crashes each time we run it. >> public void isJDBCConnectionClosed(){ >> try { >> if(this.getDataSource().getConnection() != null && this.getDataSource >> ().getConnection().isClosed() != false) // Here dao is the Object >> reference >> { >> this.getDataSource().getConnection().close(); >> } >> } catch (SQLException e) { >> // TODO Auto-generated catch block >> e.printStackTrace(); >> } >> } >> >> >> >> }- Hide quoted text - >> >> - Show quoted text - > > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "The Java Posse" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/javaposse?hl=en -~----------~----~----~----~------~----~------~--~---
