Hi All,

I'm quite new to j2se apps but have started doing one using swing for
the gui. Anyway my previous work has been mainly J2EE apps where I
always create a new connection to the DB using jdbc/connection pooling.

I've taken the same approach in my desktop application, each time I need
to perform a query/update etc I create a new connection, do the work,
then close it.

I was wondering if there really is any need to create a new connection
everytime.. Since I'm using a local database to the app anyway (hsqldb),
would it be wiser to create one connection when my app starts and just
use that each time.. Or would there still be a chance of it timing out.

Thanks for any responses in advance.

Dave