This week's giveaway is in the EJB and other Java EE Technologies forum. We're giving away four copies of EJB 3 in Action and have Debu Panda, Reza Rahman, Ryan Cuprak, and Michael Remijan on-line! See this thread for details.
I've wroten an aplication with java and jsp with a sql DB, it runs perfectly, but during the night it is falling and I have to reiniciate the orion server to solve the error. I don't understand why it's not stable and why this error occurs :
I can see only 2 potential causes here. Either the network connection gets interrupted during the night for a period longer than the retry period Orion has OR the database goes down during the night for a considerable period. The latter is more likely especially if the database system has not been planned for use with internet applications. Many databases I worked with were set up to kick out all existing connections and refuse new ones for several hours during the night in order to facilitate backups. Why Orion fails to reconnect later without restarting the server I cannot say. Best try the Orion mailing lists or support for that (and report back with your findings of course so we may all profit).