You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@tomcat.apache.org by "lauradiara@libero.it" <la...@libero.it> on 2002/10/02 18:07:18 UTC
Tomcat DataSource question
Hi all,
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").
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: <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>