I intermittently get the following error message when my gadgets are using my custom data sources:
"The last packet successfully received from the server was 36,727,995 milliseconds ago. The last packet sent successfully to the server was 36,733,072 milliseconds ago. is longer than the server configured value of 'wait_timeout'. You should consider either expiring and/or testing connection validity before use in your application, increasing the server configured values for client timeouts, or using the Connector/J connection property 'autoReconnect=true' to avoid this problem." The errors most frequently occur the first time someone comes back and accesses a web page after a long delay. (it's very common to have them happen first thing in the morning after the website has been idle overnight). After refreshing the page or resubmitting a form once or twice, the error message tends to go away. The timeout of the gadgets is currently being set to 120. I know I could try to bump it up but I'd like to understand the cause of this error before I arbirarily start changing code. I also read somewhere that suggests getting rid of the timeout completely but if the query takes an inordinate amout of time, I'd like to display some kind of message to the user (or maybe I should try to handle the timeout in my datasource instead of haiving the gadget manage it?). Any comments or suggestions would be much appreciated. -- You received this message because you are subscribed to the Google Groups "Google Visualization API" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/google-visualization-api?hl=en.
