ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Nicholoz Koka Kiknadze <kikna...@gmail.com>
Subject Re: Some one can help me?
Date Wed, 15 Apr 2009 06:49:46 GMT
Follow Nathan's suggestion.

>Look up ping query in the developers manual.   It will validate the query
before it uses it

In fact it will validate connection, discard the old one if necessary and
opens/return fresh one.

On Tue, Apr 14, 2009 at 11:13 PM, yhliu <yhliu@cn.ufinity.com> wrote:

>  Thanks for your reply.
>
> okay, the reason of this iusse may be the end transaction method was called but there
is not any transaction started in my program, but there are too many classes to correct,
>
> it will be cost very high because this section is working with the production.
>
> So how can I release the connections when the DB server shut down and get new connection
to connecting DB server?
>
> 2009-04-15
> ------------------------------
>
>




On Tue, Apr 14, 2009 at 10:47 PM, Nathan Maves <nathan.maves@gmail.com>wrote:

> Look up ping query in the developers manual.   It will validate the query
> before it uses it.
>
> On Apr 14, 2009, at 8:27 PM, "yhliu" <yhliu@cn.ufinity.com> wrote:
>
>  I got a problem that the program will throw close connection exception
> when the DB server(oracle 10G) shut down and it is unforeseeable, the worse
> is it will not connect the DB server in a successful manner again when the
> DB server resurged. After discuss with my colleagues, the point is how can I
> reconnect the DB server or get new connection from Pool? and what the use's
> of SqlMapTransactionManager.setUserConnection(...) , Can I use this method
> to get new connection with DB server?
> Thx for any help!
>
> 2009-04-15
> ------------------------------
> yhliu
>
>

Mime
View raw message