Option 2 if you want your application to scale.
-----Original Message-----
From: Dino Cherian [mailto:inimss@yahoo.com]
Sent: Friday, November 23, 2001 4:12 AM
To: pgsql-jdbc@postgresql.org
Subject: [JDBC] Where should I connect to the database?
Hi all,
I would like to know which one is the best method of
managing database connection in Java 1.3 (with
PostgreSQL 7.1.2 JDBC).
Option 1:
Connect to the database in the "main" function and
disconnect on program exit. Use it throughout the life
of the application. "Connect once and use for ever".
Option 2:
Connect to the database near the code that uses it
and disconnect after that block of code. "Use and
throw away".
Please help me.
Thanks
Dino
__________________________________________________
Do You Yahoo!?
Yahoo! GeoCities - quick and easy web site hosting, just $8.95/month.
http://geocities.yahoo.com/ps/info1
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
