You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user-java@ibatis.apache.org by Donmis <do...@gmail.com> on 2009/09/11 05:00:39 UTC
connection problem using ibatis2.3+postgresql8.3+glassfish2 ( An
I/O error occured while sending to the backend.; nested exception is
com.ibatis.common.jdbc.exception.NestedSQLException)
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-unsubscribe@ibatis.apache.org
For additional commands, e-mail: user-java-help@ibatis.apache.org
Re: connection problem using ibatis2.3+postgresql8.3+glassfish2 ( An
I/O error occured while sending to the backend.; nested exception is
com.ibatis.common.jdbc.exception.NestedSQLException)
Posted by Larry Meadors <la...@gmail.com>.
Probably a stale connection.
Google for "org.postgresql.util.PSQLException: An I/O error occured
while sending to the backend"
Larry
On Thu, Sep 10, 2009 at 8:01 PM, Donmis <do...@gmail.com> wrote:
>
> HELP HELP!!!
> :,(
> --
> 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-tp25394317p25394320.html
> Sent from the iBATIS - User - Java mailing list archive at Nabble.com.
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-java-unsubscribe@ibatis.apache.org
> For additional commands, e-mail: user-java-help@ibatis.apache.org
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: user-java-unsubscribe@ibatis.apache.org
For additional commands, e-mail: user-java-help@ibatis.apache.org
Re: connection problem using ibatis2.3+postgresql8.3+glassfish2 (
An I/O error occured while sending to the backend.; nested exception is
com.ibatis.common.jdbc.exception.NestedSQLException)
Posted by Donmis <do...@gmail.com>.
HELP HELP!!!
:,(
--
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-tp25394317p25394320.html
Sent from the iBATIS - User - Java mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: user-java-unsubscribe@ibatis.apache.org
For additional commands, e-mail: user-java-help@ibatis.apache.org