The moose likes Servlets and the fly likes Error on Orion conecting sql Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Java » Servlets
Bookmark "Error on Orion conecting sql" Watch "Error on Orion conecting sql" New topic

Error on Orion conecting sql

flo binouz

Joined: Sep 19, 2003
Posts: 1
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 :

com.evermind[Orion/1.5.4 (build 10585)].server.rmi.OrionRemoteException: Error loading state: java.sql.SQLException: Communication link failure:
java.sql.SQLException: Communication link failure:
Could you hlp me ?�??
Jeroen Wenting
Ranch Hand

Joined: Oct 12, 2000
Posts: 5093
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).

I agree. Here's the link:
subject: Error on Orion conecting sql
It's not a secret anymore!