Well I use the default pool DataSource of tomcat 4.0.3. I get a initial connection (---> static block) and then I return that with getConnection() method. I suppose that when the db is restarted my connection becomes null, but I'm not sure. I'm planning to use DBCP: is it possible using it with Tomcat 4.0.3? How can I install it? Does DBCP resolve the problem of the DB restart? Thanks Laura >This depends on how you use the connection. If you use a db pool, then the > pool must reconnect. There're pools that do that and other that don't do. > > Regards. > > -----Mensaje original----- > > De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] > > Enviado el: jueves, 03 de octubre de 2002 9:47 > > Para: tomcat-user > > Asunto: Please help me!! > > > > Hi all, > > > > I can't find an answer to this question. Plese help me. > > > > I have an apache-tomcat(4.0.3) system installed. I use a connection > > DataSource with a Oracle database (I have a resource in server.xml w ith > > type="javax.sql.DataSource"). ---> Instruction in the JNDI Resources > > HOW-TO section of Tomcat 4.0.x. > > > > My question is this. If Oracle DB crashes and it has to been restart ed, > > does my web application,that uses DataSource, have to be restarted? > > > > I have a class with this static block: > > > > static { > > try { > > Context initCtx = new InitialContext(); > > Context envCtx = (Context) initCtx.lookup("java:comp/env"); > > DataSource ds = (DataSource) envCtx.lookup(dbName); > > con = ds.getConnection(); > > if (con == null) > > System.out.println("[ERROR] Connection null"); > > } catch (Exception ex) { > > System.out.println("[ERROR] Errore = " + ex.toString () + " \n" > > + ex.getMessage()); > > con = null; > > } > > } > > > > and I have a method: > > > > > > protected synchronized Connection getConnection() { > > while (conFree == false) { > > try { > > wait(); > > } catch (InterruptedException e) { > > System.out.println("[ERROR] Exception getConnection () = " > > + e.toString()); > > } > > } > > conFree = false; > > notify(); > > return con; > > } > > > > In the servlets of my web application I call getConnection() to take > > the connection: if db is restarted what happen? > > > > Thanks for your help > > > > Laura > > > > > > > > -- > > To unsubscribe, e-mail: > > <mailto:[EMAIL PROTECTED]> > > For additional commands, e-mail: > > <mailto:[EMAIL PROTECTED]> > > > > > > -- > > To unsubscribe, e-mail: > <mailto:[EMAIL PROTECTED]> > > For additional commands, e-mail: > <mailto:[EMAIL PROTECTED]> > > > >
-- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
