Mailing-List: contact users-help@tomcat.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Tomcat Users List" <users@tomcat.apache.org>
Received-SPF: pass (nike.apache.org: domain of demablogia@gmail.com designates
 209.85.210.173 as permitted sender)
Received-SPF: pass (google.com: domain of demablogia@gmail.com designates
 10.50.181.199 as permitted sender) client-ip=10.50.181.199;
MIME-Version: 1.0
In-Reply-To: <4F552806.5040600@gmx.net>
References: <4F520F97.3050506@gmx.net> <4F5219AF.2050105@pidster.com>
 <4F55104B.4000703@gmx.net>
 <CABOBwRhg_8Bun5soj0NKzP1cWzuCZXjMod63j1oNs7QVPLJ+rA@mail.gmail.com>
 <4F552510.9060404@gmx.net>
 <CABOBwRhQnx5WxP0CXqpuTuF5s2yVTCCvZWmv1JBmqaCn-+HOmw@mail.gmail.com>
 <4F552806.5040600@gmx.net>
From: Chema <demablogia@gmail.com>
Date: Mon, 5 Mar 2012 22:06:22 +0100
Message-ID: 
 <CABOBwRh5Xarx5UxkZKk-pJ6_e06+DXkjCba5AU1n8t4VcpUZ5Q@mail.gmail.com>
Subject: Re: [Tomcat JDBC Pool] Close pooled connections via JMX
To: Tomcat Users List <users@tomcat.apache.org>
Content-Type: text/plain; charset=ISO-8859-1

> No if the connection has been reset by the instance. The query will result
> in a SQLException. You have to close the connection and open a new one. The
> query works on an open connection only. That's the point.
> See the second paragraph of this [1].
>

But the problem was when you restart the remote database , not the
local database.
In this case, SELECT 1 FROM DUAL works ( doesn't return a SQL exception ).
But , when you execute after the query "SELEC * FROM TABLE@remotedb",
then fails , was this the problem, right ?

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org