• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Tim Cooke
  • paul wheaton
  • Paul Clapham
  • Ron McLeod
Sheriffs:
  • Jeanne Boyarsky
  • Liutauras Vilda
Saloon Keepers:
  • Tim Holloway
  • Carey Brown
  • Roland Mueller
  • Piet Souris
Bartenders:

Losing Network Connection

 
Ranch Hand
Posts: 455
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
I have a couple of applications that are connecting to a DB2 database. Every once in a while, we will lose our network connection to the PC that one of these apps is running on. When the network connection comes back, everything on the PC works fine, except the application. It's like it is not picking back up the network connection after it lost it. I have to stop and restart the application over again, to get it to work. Is there any way to make the application pick up the network connection after being lost without restarting it?

Thanks~
 
author & internet detective
Posts: 42165
937
Eclipse IDE VI Editor Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Jennifer,
We had a similar problem where trying to get the connection a second time helped. Not sure if it will work for you, but it's worth a shot.
 
Ranch Hand
Posts: 1143
1
Eclipse IDE Oracle Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Jennifer,
Once the network connection is gone, the database session is lost. When the network connection is restored, the database session is not restored. As Jeanne says, you need to create a new database session by re-connecting to your database.

Good Luck,
Avi.
 
Ranch Hand
Posts: 1683
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
If you use connection pooling, you may be able to get automatic reconnection from the pool to the database.
 
reply
    Bookmark Topic Watch Topic
  • New Topic