Path: csiph.com!x330-a1.tempe.blueboxinc.net!feeder1.hal-mli.net!nx02.iad01.newshosting.com!newshosting.com!news-out.readnews.com!transit3.readnews.com!news-out.news.tds.net!newsreading01.news.tds.net!86597e80!not-for-mail From: "Hakan" Subject: MySQL connection problems Message-ID: <1213985055.63@user.newsoffice.de> X-Comment-To: comp.lang.java.databases Newsgroups: comp.lang.java.databases Content-Type: text/plain; charset=IBM437 Content-Transfer-Encoding: 8bit X-Gateway: time.synchro.net [Synchronet 3.15a-Win32 NewsLink 1.92] Lines: 35 Date: Wed, 27 Apr 2011 15:22:16 GMT NNTP-Posting-Host: 96.60.20.240 X-Complaints-To: news@tds.net X-Trace: newsreading01.news.tds.net 1303917736 96.60.20.240 (Wed, 27 Apr 2011 10:22:16 CDT) NNTP-Posting-Date: Wed, 27 Apr 2011 10:22:16 CDT Organization: TDS.net Xref: x330-a1.tempe.blueboxinc.net comp.lang.java.databases:190 To: comp.lang.java.databases My web start application connects to a MySQL database through a servlet. The servlet accesses the database through a MySQL connector instance and returns the results the client if necessary. Everything is done through a Tomcat Linux web server. My problems seem to occur when I run the program through the servlet for the first time after a while, like the first time of the day or after not testing it on the server for some days. It can't fetch anything from the database, so the client just gets null objects back. Ultimately, a NullPointerException kills the application as it has nothing to work with. The solution is very simple. I shut down Tomcat and restart it, after which it again reads results from the database as it should. This is just not a sustainable way to deal with it. My employer wants to deploy it such that many different users will have an interest in accessing it from various places and not just people with system administrator privileges. Hence, crashes are liable to make them spurn the application. That would make quite a lot of work useless. Do you know the source of the mentioned problem? Regards. -- Newsoffice.de - Die Onlinesoftware zum Lesen und Schreiben im Usenet Die Signatur lE#t sich nach Belieben anpassen ;-) --- * Synchronet * The Whitehouse BBS --- whitehouse.hulds.com --- check it out free usenet! --- Synchronet 3.15a-Win32 NewsLink 1.92 Time Warp of the Future BBS - telnet://time.synchro.net:24