RE: getting exception when trying to close connection

[Christian J. Dechery]

ok... there you go:
 
  public DAOFundos(Esquema esq) {
 
  if( esq==null ) {
   esq = esquemaDefault;
  }
 
     try {
   Class.forName( esq.getDriver() );
      con = DriverManager.getConnection(esq.getUrl(), esq.getUser(), 
esq.getPassword());
     }
     catch(ClassNotFoundException cnf) {
      System.out.println ("Erro: driver nao encontrado! "+cnf.getMessage());
     }
     catch(SQLException sql) {
      System.out.println("Erro ao obter conex�o! "+sql.getMessage() );
     }
    }

this is the code for the default constructor... in this case the class Esquema 
contains info about: drivers, user, url and pwd.
the driver is always oracle.jdbc.driver.OracleDriver
 
thanks again
 
 
.:| Christian J. Dechery
.:| FINEP - Depto. de Sistemas
.:| [EMAIL PROTECTED]
.:| (21) 2555-0332

>>> [EMAIL PROTECTED] 11/06/02 16:03 >>> 
It would be halpful to see the declaration of con, and the type of driver 
you are using 


-----Original Message----- 
From: Christian J. Dechery [ mailto:[EMAIL PROTECTED]] 
Sent: Tuesday, June 11, 2002 11:41 AM 
To: [EMAIL PROTECTED] 
Subject: getting exception when trying to close connection 


I know my implementation isn't the best there is... take a look at this 
code: 

protected void finalize() { 
try { 
if( con!=null && !con.isClosed() && con.getAutoCommit() ) { 
con.close(); 
} 
} 
catch(SQLException sqle) { 
System.out.println("["+this.getClass().getName()+"] N�o foi poss�vel 
fechar a conex�o. "+sqle.toString()+"\n"); 
// sqle.printStackTrace(); 
} 
} 

that's what I use to TRY to close all connections... this code is in my DAO 
class. Sometimes I have up to four DAO classes instantiated in a single 
JSP... I debugged it... at least one always fails to close giving me this 
exception: "I/O error: socket closed" 

what does that mean? what socket? And why did all the other connections 
closed and this didn't? 

.:| Christian J. Dechery 
.:| FINEP - Depto. de Sistemas 
.:| [EMAIL PROTECTED] 
.:| (21) 2555-0332 



-- 
To unsubscribe, e-mail: < mailto:[EMAIL PROTECTED] > 
For additional commands, e-mail: < mailto:[EMAIL PROTECTED] >