I setup a jdbc-jndi to informix in my webapp with tomcat 4.0.3. Then I restart the database, and retest my webapp, I am suprise to see that the connection pool is still work, here is my code to get connection whenever I need one: Context initCtx = new InitialContext(); Context envCtx = (Context) initCtx.lookup("java:comp/env"); DataSource ds = (DataSource)envCtx.lookup("jdbc/informix"); Connection con = ds.getConnection(); My questions: 1) Is a new connection pool created everytime I use the code above? If so, then that is why it works even I restart database. 2) If not, then is tomcat validate the connection object before return it out? (otherwise I will get error when I use the connection object) 3) If it do validate the connection, any info. about how it get validated? i.e. simple select...? Thanks. David
What are you doing? You are supposed to be reading this tiny ad!
the new thread boost feature brings a LOT of attention to your favorite threads