Is this correct approach for set connection timeout?This approach also not
working.Please help.
try:
eng_obj = create_engine(conn_str, echo=False,
connect_args={'timeout': 60}).connect()
except Exception as ex:
print(ex.__str__())
On Saturday, November 17, 2018 at 9:46:32 PM UTC+5:30,
[email protected] wrote:
>
> Oh.Ok.
> Thanks Mike.
> You mean to say pool_timeout is used for how long the pool will spend
> waiting for a connection to be
> available if all the connections in the pool are in use.
> Then which parameter should I use for connection timeout ? Could you
> please help me to modify below code for connection timeout ? Where I can
> specify connection timeout parameter. SqlAlchemy is new for me.
>
> def _dbconnect(self, connstr, ps=20, ds_timeout=3600):
> # simple sql alchemy connection.
> return create_engine(connstr, pool_size=ps, echo=False,
> poolclass=QueuePool, pool_timeout=ds_timeout)
>
> Please help.
>
>
> On Friday, November 16, 2018 at 8:18:37 PM UTC+5:30, Mike Bayer wrote:
>>
>> On Fri, Nov 16, 2018 at 8:20 AM <[email protected]> wrote:
>> >
>> > Hi,
>> > My connection timeout happening after 30 seconds even if I set the
>> pool_timeout=3600. My create engine code is written below
>> > I want set custom pool_timeout value. But its not working as per the
>> expectation. My create_engine code is written below
>> >
>> > def _dbconnect(self, connstr, ps=20, ds_timeout=3600):
>> > # simple sql alchemy connection.
>> > return create_engine(connstr, pool_size=ps, echo=False,
>> > poolclass=QueuePool, pool_timeout=ds_timeout)
>>
>> timeout is how long the pool will spend waiting for a connection to be
>> available if all the connections in the pool are in use. it seems
>> unusual you'd want to set this to 3600 seconds, are you confusing
>> "timeout" with pool_recycle ?
>>
>>
>>
>>
>> >
>> >
>> > Please help.
>> >
>> > --
>> > SQLAlchemy -
>> > The Python SQL Toolkit and Object Relational Mapper
>> >
>> > http://www.sqlalchemy.org/
>> >
>> > To post example code, please provide an MCVE: Minimal, Complete, and
>> Verifiable Example. See http://stackoverflow.com/help/mcve for a full
>> description.
>> > ---
>> > You received this message because you are subscribed to the Google
>> Groups "sqlalchemy" group.
>> > To unsubscribe from this group and stop receiving emails from it, send
>> an email to [email protected].
>> > To post to this group, send email to [email protected].
>> > Visit this group at https://groups.google.com/group/sqlalchemy.
>> > For more options, visit https://groups.google.com/d/optout.
>>
>
--
SQLAlchemy -
The Python SQL Toolkit and Object Relational Mapper
http://www.sqlalchemy.org/
To post example code, please provide an MCVE: Minimal, Complete, and Verifiable
Example. See http://stackoverflow.com/help/mcve for a full description.
---
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at https://groups.google.com/group/sqlalchemy.
For more options, visit https://groups.google.com/d/optout.
