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 with 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 restarted, 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]>