Re: Pool error connecting to database
Posted by: Mikel Lertxundi
Date: June 03, 2005 04:57AM

Hi Tetsuro,

This is what I get when a put the "System.out.println()":
---------------------------------------------------------------
\3537_JOMASIL_CAT_PENTAGONO_PORTADA.tpl
Connection established
connection closed
Connection established
connection closed
\3538_JOMISA_CAT_DHEMEN.tpl
Connection established
connection closed
Connection established
connection closed
\3539_JOSE_ACEDO_TARIFA.tpl
Connection established
connection closed
Connection established
connection closed
\3540_JOSE_IGNACIO.tpl
Connection established
connection closed
Connection established
connection closed
\3541_JOSE_INGNACIO.tpl
Connection established
connection closed
Connection established
connection closed
\3542_JOSE_MARI_DOMINGUEZ_SOBRE.tpl
Connection established
connection closed
Connection established
connection closed
---------------------------------------------------------

this is the aplications answer when everything goes well, before it crashes with the error I mentioned before. Like you see everytime I get connection with the DB I close it after making some inserts and queries. This is the code I use to close the connection

public void cerrarConexion(){
try{
conexionBD.close();
conexionBD = null;
System.out.println("connection closed");
}
catch (Exception ex){ex.printStackTrace();}
}

where this metod is part of the class that has the constructor I wrote. conexionBD is a Connection object.

Any idea?

Thanks for all.

Options: ReplyQuote




Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.