I have developed a web application required database both oracle and postgresql. my oracle works fine so far, but PostgreSQL got some problems. I am using Ibatis 2.3 with PostgreSQL 8.3 on glassfish v2. after the Web Application deployed, initially everything looks ok, but after a short time, always hit the below problem:
com.sph.newslink.service.UserManager - org.springframework.dao.DataAccessResourceFailureException: SqlMapClient operation; SQL []; --- The error occurred in com/sph/newslink/dao/ibatis/sqlmap/TOP_SQLMAP.xml. --- The error occurred while applying a parameter map. --- Check the TOP_SQLMAP.selectInitialSequence-InlineParameterMap. --- Check the statement (query failed). --- Cause: org.postgresql.util.PSQLException: An I/O error occured while sending to the backend.; nested exception is com.ibatis.common.jdbc.exception.NestedSQLException: the sql select statement very simple and should have no problem, I think it s due to lose of the connection to database, Is there any way with IBatis to handle this situation be auto-reconnecting to the database? Regards, Don :-(( -- View this message in context: http://www.nabble.com/connection-problem-using-ibatis2.3%2Bpostgresql8.3%2Bglassfish2-%28-An-I-O-error-occured-while-sending-to-the-backend.--nested-exception-is-com.ibatis.common.jdbc.exception.NestedSQLException%29-tp25394317p25394317.html Sent from the iBATIS - User - Java mailing list archive at Nabble.com. --------------------------------------------------------------------- To unsubscribe, e-mail: user-java-unsubscr...@ibatis.apache.org For additional commands, e-mail: user-java-h...@ibatis.apache.org
