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] >