DB Connection Timeouts

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
.

Relevant Pages

  • Re: Deployment and debugging of apps from VS2005 via ActiveSync &
    ... Paul T. ... "From the command prompt on the device, ... to make your debugging connection: ... Does anybody know of a way of deploying and debugging Pocket PC apps ...
    (microsoft.public.pocketpc.activesync)
  • Re: Weird connection to ads.forbes.com:8081
    ... log of all allowed connections to determine what apps are connecting where). ... Then let your machine run for a bit, open up the firewall interface and look ... tries to make an outgoing connection and you can allow ... exactly what apps have been seen by Outpost, ...
    (comp.security.firewalls)
  • Re: Dual WAN Cable/DSL configuration question
    ... residential DSL services) run a mail server, webserver, etc over Residential ... You're second broadband connection needs to be static and business class. ... You said you rely on web-based apps, I hope you don't mean running on your ...
    (microsoft.public.windows.server.sbs)
  • Re: DNS Errors ?
    ... domain admin acct. ... The apps start every 15 minutes and attempt to download from the same web ... ** InnerException System.Net.Sockets.SocketException: A connection attempt ... Socket s4, Socket s6, Socket& socket, IPAddress& address, ...
    (microsoft.public.dotnet.general)
  • Re: db2 - persistent connection
    ... middle with a persistant connection rather than directly talking to DB2 :-) ... you have n apps connecting to DB2, ... If that proxy is on another machine, ... Perl-based stored procedures, so you'd also have to rewrite them. ...
    (perl.dbi.users)