Hi, I have developed a Web Application. I am using Ibatis 2.3.0.677 with database PostgreSQL. While the Web Application is running, if I restart (stop and then start) the PostgreSQL server, now if open some page that is causing some query to run if get this error.
com.ibatis.common.jdbc.exception.NestedSQLException: --- The error occurred in eu/digitania/mobilecontentportal/ibatis/contenttype_SqlMap.xml. --- The error occurred while applying a parameter map. --- Check the contenttype.ibatorgenerated_selectByPrimaryKey-InlineParameterMap. --- Check the statement (query failed). --- Cause: org.postgresql.util.PSQLException: An I/O error occured while sending to the backend. The problem behind this is when I restart the server, its connection with the Web Application is lost. Now if there is some interaction with the database, this problem occurs. Is there any way with IBatis to handle this situation be auto-reconnecting to the database? Regards, Kashif -- View this message in context: http://www.nabble.com/Reconnect-to-a-lost-connection-tp24073199p24073199.html Sent from the iBATIS - User - Java mailing list archive at Nabble.com.
