Error on Orion conecting sql

[flo binouz]

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.io.IOException
java.sql.SQLException: Communication link failure: java.io.IOException
Could you hlp me ?�??

[Jeroen Wenting]

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).