This week's book giveaway is in the Performance forum.
We're giving away four copies of The Java Performance Companion and have Charlie Hunt, Monica Beckwith, Poonam Parhar, & Bengt Rutisson on-line!
See this thread for details.
Win a copy of The Java Performance Companion this week in the Performance 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