Win a copy of Programmer's Guide to Java SE 8 Oracle Certified Associate (OCA) this week in the OCAJP forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Error on Orion conecting sql

 
flo binouz
Greenhorn
Posts: 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Ranch Hand
Posts: 5093
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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).
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic