Re: DBCP error

--0015174c1ab8896c4304a2fad427
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

Yeah, we have some of the SQL statements which are running more than 1
minutes. However, for small queries it's also throwing errors DBCP.


--
Regards,
Dhaval


On Fri, May 6, 2011 at 4:59 PM, Martin Gainty wrote:

> Id the execution delivers results in under a minute then adhere to Mr
> Woods advice
> If over a minute the other consideration is you might have a terribly
> long-executing SQL statement that needs to be tuned.
>
> if you can display your SQL statement and the relevant schemata we could
> suggest more expeditious means to acquire your data
>
> Martin
> ______________________________________________
> Verzicht und Vertraulichkeitanmerkung/Note de d=E9ni et de confidentialit=
=E9
>
> Diese Nachricht ist vertraulich. Sollten Sie nicht der vorgesehene
> Empfaenger sein, so bitten wir hoeflich um eine Mitteilung. Jede unbefugt=
e
> Weiterleitung oder Fertigung einer Kopie ist unzulaessig. Diese Nachricht
> dient lediglich dem Austausch von Informationen und entfaltet keine
> rechtliche Bindungswirkung. Aufgrund der leichten Manipulierbarkeit von
> E-Mails koennen wir keine Haftung fuer den Inhalt uebernehmen.
>
> Ce message est confidentiel et peut =EAtre privil=E9gi=E9. Si vous n'=EAt=
es pas le destinataire pr=E9vu, nous te demandons avec bont=E9 que pour sat=
isfaire informez l'exp=E9diteur. N'importe quelle diffusion non autoris=E9e=
ou la copie de ceci est interdite. Ce message sert =E0 l'information seule=
ment et n'aura pas n'importe quel effet l=E9galement obligatoire. =C9tant d=
onn=E9 que les email peuvent facilement =EAtre sujets =E0 la manipulation, =
nous ne pouvons accepter aucune responsabilit=E9 pour le contenu fourni.
>
>
>
>
>
>
> > Subject: Re: Fwd: DBCP error
> > From: nwood@plus.net
> > To: dhaval.jaiswal@via.com
> > CC: mysql@lists.mysql.com; shrinivas.devarkonda@via.com
> > Date: Fri, 6 May 2011 11:35:30 +0100
>
> >
> > On Fri, 2011-05-06 at 11:12 +0100, Dhaval Jaiswal wrote:
> > > Caused by: java.net.SocketException: Socket closed
> >
> > I'd suggest you look at server side timeout and maximum connection
> > settings in
> > http://dev.mysql.com/doc/refman/5.1/en/server-system-variabl es.html I'd
> > suspect wait_timeout is the setting you're interested in. You might als=
o
> > want to check the maximum TCP session/idle timeouts on firewalls,
> > routers and other network devices between the failing system and its
> > MySQL server.
> >
> > Hope that helps,
> > Nigel
> >
> >
> > --
> > MySQL General Mailing List
> > For list archives: http://lists.mysql.com/mysql
> > To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dmgainty@hotmail.co=
m
> >
>



--=20
Regards,
Dhaval Jaiswal

--0015174c1ab8896c4304a2fad427--