Prev: max and min
Next: read certain number in a text file
From: the cyclist on 28 Jan 2010 16:30
Here is something that is a minor frustration.

Using the Database Toolbox, I connect to the database just fine. However, after a period of time, that connection seems to expire. (Doesn't seem to be a fixed period of time, but rather after a period of not using the connection for a while.)

If I try to execute a query after the connection has expired, MATLAB hangs, and I have to Force Quit. (I am on a Mac.)

Any way to stop this expiration of the session?

the cyclist
From: Tristram Scott on 29 Jan 2010 07:07
the cyclist <thecyclist(a)gmail.com> wrote:
> Here is something that is a minor frustration.
>
> Using the Database Toolbox, I connect to the database just fine.
However, after a period of time, that connection seems to expire. (Doesn't
seem to be a fixed period of time, but rather after a period of not using
the connection for a while.)
>
> If I try to execute a query after the connection has expired, MATLAB
hangs, and I have to Force Quit. (I am on a Mac.)
>
> Any way to stop this expiration of the session?
>
> the cyclist

What type of database are you using? Most will drop inactive connections
eventually, but you usually have some say oin the matter. For MySQL I
believe the parameters are interactive_timeout and wait_timeout.


--
Dr Tristram J. Scott
Energy Consultant
From: the cyclist on 29 Jan 2010 09:00
tristram.scott(a)ntlworld.com (Tristram Scott) wrote in message <ucA8n.125959$M86.89639(a)newsfe29.ams2>...
> the cyclist <thecyclist(a)gmail.com> wrote:
> > Here is something that is a minor frustration.
> >
> > Using the Database Toolbox, I connect to the database just fine.
> However, after a period of time, that connection seems to expire. (Doesn't
> seem to be a fixed period of time, but rather after a period of not using
> the connection for a while.)
> >
> > If I try to execute a query after the connection has expired, MATLAB
> hangs, and I have to Force Quit. (I am on a Mac.)
> >
> > Any way to stop this expiration of the session?
> >
> > the cyclist
>
> What type of database are you using? Most will drop inactive connections
> eventually, but you usually have some say oin the matter. For MySQL I
> believe the parameters are interactive_timeout and wait_timeout.
>
>
> --
> Dr Tristram J. Scott
> Energy Consultant

Thanks for the reply.

I'm using a postgresql database. In MATLAB I see there is a way to set the login timeout (i.e. the time to wait before giving up, if the connection cannot be made), but I don't see anything about expiration of the connection.

the cyclist
From: Tristram Scott on 29 Jan 2010 13:00
the cyclist <thecyclist(a)gmail.com> wrote:
[snip]
>
> I'm using a postgresql database. In MATLAB I see there is a way to set
the login timeout (i.e. the time to wait before giving up, if the
connection cannot be made), but I don't see anything about expiration of
the connection.

My reading of the PostgreSQL manual and sniffing around theeir website
suggests that the server side doesn't have a timeout.

http://archives.postgresql.org/pgsql-general/2009-03/msg01119.php

Perhaps this is something on the client side?

Which version of PostgreSQL are you using? Which version of MATLAB? How
do you make the connection?


--
Dr Tristram J. Scott
Energy Consultant
 | 
Pages: 1
Prev: max and min
Next: read certain number in a text file