Re: [sqlalchemy] pyodbc and is_disconnect

Fantastic, thanks so much for the help, Mike. Kind regards, David Moore Support Technical Lead j5 Software South Africa Skype: Phone: Email: Web: davidm.j5int +27 21 762 1440 dav...@j5int.com <em...@j5int.com> www.j5int.com [image: j5InternationalLogo_sma

[sqlalchemy] pyodbc and is_disconnect

a full sqlalchemy upgrade testing cycle? Kind regards, David Moore Support Technical Lead j5 Software South Africa Skype: Phone: Email: Web: davidm.j5int +27 21 762 1440 dav...@j5int.com <em...@j5int.com> www.j5int.com [image: j5InternationalLogo_sma

[sqlalchemy] Sequences in Oracle RAC out of order

Hello, I just chased down a bug in our application while using SQLAlchemy 1.0.6 in an Oracle RAC environment, which should probably be in SQLAlchemy documentation somewhere, and possibly motivate a change to the options for sequence creation on Oracle. Basically, our application assumes a

Re: [sqlalchemy] Support for Oracle 12c auto increment (IDENTITY) columns?

- Original Message - From: "Piotr Dobrogost" To: "sqlalchemy" Sent: Wednesday, April 13, 2016 1:50:19 PM Subject: Re: [sqlalchemy] Support for Oracle 12c auto increment (IDENTITY) columns? Mike, Thanks

Re: [sqlalchemy] Full table scan using Oracle String indexes

of the String(length=XYZ) type with MyStringType(length=XYZ). docs: http://docs.sqlalchemy.org/en/rel_0_7/core/types.html#types-custom On Aug 2, 2012, at 5:41 AM, David Moore wrote: Hi, Further searching seems to indicate this is an Oracle issue, not a cx_Oracle issue

Re: [sqlalchemy] Full table scan using Oracle String indexes

unicode bind parameters passed into cx_Oracle into the client encoding. HTH, Dave Moore - Original Message - Le jeudi 25 octobre 2012 16:21:49 UTC+2, David Moore a écrit : Hello, Hi, In line with what is required for Python 3, would it not make sense to insist across the board

Re: [sqlalchemy] Postgres migration issue

types introduced in version 9 which pg8000 didn't know of in 1.08, and added in 1.09). regards -- David Moore Senior Software Engineer St. James Software Email: dav...@sjsoft.com -- You received this message because you are subscribed to the Google Groups sqlalchemy group. To post

Re: [sqlalchemy] Full table scan using Oracle String indexes

convert_unicode='force' only on Oracle databases across an application? I know the hooking syntax changed from sqlalchemy 0.6 to 0.7, so I'd imagine if there is a way, it would be different for those two versions. thanks, -- David Moore Senior Software Engineer St. James Software Email: dav...@sjsoft.com

Re: [sqlalchemy] Full table scan using Oracle String indexes

and message, it runs a FULL SCAN, and even though it seems to detect the conversion can be done, it does not use the index at all. Perhaps this is actually an Oracle issue? -- David Moore Senior Software Engineer St. James Software Email: dav...@sjsoft.com - Original Message - Hi

Re: [sqlalchemy] Full table scan using Oracle String indexes

, inconverter = lambda x: x.encode(cursor.connection.nencoding)) And then when creating the connection: connection.inputtypehandler = InputTypeHandler thanks for the help, -- David Moore Senior Software Engineer St. James Software Email: dav...@sjsoft.com - Original Message

[sqlalchemy] Full table scan using Oracle String indexes

to achieve the same result? Thanks in advance for any help, regards, -- David Moore Senior Software Engineer St. James Software Email: dav...@sjsoft.com -- You received this message because you are subscribed to the Google Groups sqlalchemy group. To post to this group, send email to sqlalchemy