MySql Connection Issue

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • nickyeng
    Contributor
    • Nov 2006
    • 252

    MySql Connection Issue

    Hi all,

    I have a question. The situation is like this.

    I have website and allow user to login and check their details.
    Every pages are jsp file and contented connection to mysql database to retrieve information.

    Sometimes it can be accessed to mysql but sometimes cannot.
    and the error it give me is NullPointerExce ption.

    and i wonder why. Is it the connection to mysql is disconnected and when i try to call query again, it just BANG me with null pointer exception ? Can't mysql just automatically reconnect if found disconnected ? Is this going to be solution for my issue ?

    p/s: so everytime after hit the error, i need to restart tomcat, and the website continue to run well..(until it somehow hit the error again)


    any idea?
  • mwasif
    Recognized Expert Contributor
    • Jul 2006
    • 802

    #2
    NullPointerExce ption is not giving any useful information. What error is MySQL returning? Are you closing MySQL connections properly?

    Comment

    Working...