Emanuel Freitas wrote:
> I'm running a server that receives approximately 300 requests per
> second. For each request I need to do some operations in a database. So,
> when I receive a request i [sic] check if there is any active connection to
> the database and if not i [sic] create one. The code for create the connection
> is something like this:
>
> private Connection initConn() {
>
> try {
> Class.forName("org.postgresql.Driver");
You only need to load the driver class once. Load it in a static initializer
block.
> } catch (ClassNotFoundException cnfe) {
> System.err.println("Error on Driver");
Consider using a logging framework like log4j or java.util.logging.
> return null;
Consider stopping the application for this particular exception.
> }
>
> try {
>
> Connection db =
> DriverManager.getConnection("jdbc:postgresql://192.168.1.2:5432/test?loginTimeout=3
> http://192.168.1.2:5432/test?loginTimeout=3", "test", "1234");
Consider externalizing the connection details. Try persistence.xml,
context.xml or an application server's setup script/screen to create a data
source.
> return db;
>
> } catch (SQLException sqle) {
> System.err.println("Error on Connection");
> return null;
You might want to log more details (again, using a logger) to troubleshoot
this scenario. One candidate detail is the SQLState.
> }
> }
--
Lew
