users@glassfish.java.net

RE: Re: SQLException does not drop JDBC connection from pool

From: Markus Karg <karg_at_quipsy.de>
Date: Wed, 15 Oct 2008 19:04:03 +0200

VARCHAR(200)

> -----Original Message-----
> From: Marina.Vatkina_at_Sun.COM [mailto:Marina.Vatkina_at_Sun.COM]
> Sent: Mittwoch, 15. Oktober 2008 18:40
> To: ejb_at_glassfish.dev.java.net
> Cc: users_at_glassfish.dev.java.net
> Subject: Re: SQLException does not drop JDBC connection from pool
>
> Markus,
>
> What is the column type of the 'Text' column?
>
> thanks,
> -marina
>
> Markus Karg wrote:
> > Jagadish,
> >
> > -660 is the code for exactly that text contained in the message. To
> > translation of that message is: "Connection was terminated." and
> means
> > that the server closed the connection already and one shall open a
> new
> > one (mostly due to idle timeout). It would be pretty strange that
the
> > validation on the table would work, but the normal SELECT just few
> > milliseconds later will fail...
> >
> > Regards
> > Markus
> >
> >
> >>-----Original Message-----
> >>From: Jagadish.Ramu_at_Sun.COM [mailto:Jagadish.Ramu_at_Sun.COM]
> >>Sent: Mittwoch, 15. Oktober 2008 15:33
> >>To: users_at_glassfish.dev.java.net
> >>Cc: ejb
> >>Subject: RE: RE: RE: Re: SQLException does not drop JDBC connection
> >>from pool
> >>
> >>Could you consult the jdbc-driver's documentation for the following
> >>error code ?
> >>Error Code: -660
> >>
> >>also, could you translate :
> >>Server 'FMEA': [Sybase][ODBC Driver][SQL Anywhere]Verbindung
> >>wurde beendet ?
> >>
> >>Validation is done before giving the connection from pool to the
> >>application. The exceptions show that application is using the
> >>connection and resultSet processing is failing.
> >>
> >>copying ejb_at_GF for help.
> >>
> >>Thanks,
> >>-Jagadish
> >>
> >>
> >>On Wed, 2008-10-15 at 14:11 +0200, Markus Karg wrote:
> >>
> >>>Error Code: -660
> >>
> >>
>
>>---------------------------------------------------------------------
> >>To unsubscribe, e-mail: users-unsubscribe_at_glassfish.dev.java.net
> >>For additional commands, e-mail: users-help_at_glassfish.dev.java.net
> >
> >
> >
> >
---------------------------------------------------------------------
> > To unsubscribe, e-mail: ejb-unsubscribe_at_glassfish.dev.java.net
> > For additional commands, e-mail: ejb-help_at_glassfish.dev.java.net
> >
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe_at_glassfish.dev.java.net
> For additional commands, e-mail: users-help_at_glassfish.dev.java.net