[sqlalchemy] Re: How to specify NOLOCK queries in SA (mssql)

2008-05-16 Thread BruceC
Hi Rick, This could involve quite a bit of investigation on our part, so it could take a while before we get to the bottom of it. We're running Windows 2003 as the OS, MS SQL Server 2005, via the SQL Server Native Driver, using PYODBC, Apache 2.2.6 mod_python 3.3.1. The app is based on Pylons,

[sqlalchemy] Access to AS/400 data

2008-05-16 Thread Jim Steil
Hi: Can anyone tell me if it is possible to access data on an AS/400 through SQLAlchemy? -Jim --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups sqlalchemy group. To post to this group, send email to

[sqlalchemy] Opportunistic locking or edit sequence

2008-05-16 Thread Michael Hipp
Hello, new to SQLAlchemy. A question... Does SA implement what is sometimes referred to as opportunistic locking or sequence locking? This is intended to prevent near simultaneous but incompatible UPDATESs of the same record in the database by two different clients. Some databases implement

[sqlalchemy] Re: Opportunistic locking or edit sequence

2008-05-16 Thread Michael Bayer
On May 16, 2008, at 9:38 AM, Michael Hipp wrote: Hello, new to SQLAlchemy. A question... Does SA implement what is sometimes referred to as opportunistic locking or sequence locking? This is intended to prevent near simultaneous but incompatible UPDATESs of the same record in the

[sqlalchemy] Re: Access to AS/400 data

2008-05-16 Thread Carlos Hanson
On Fri, May 16, 2008 at 6:13 AM, Jim Steil [EMAIL PROTECTED] wrote: Hi: Can anyone tell me if it is possible to access data on an AS/400 through SQLAlchemy? -Jim I'm connecting to an AS/400 using pyodbc, so I am sure that I can do it through SQLAlchemy. If I have a chances to test it,

[sqlalchemy] Re: Access to AS/400 data

2008-05-16 Thread Michael Bayer
On May 16, 2008, at 10:55 AM, Carlos Hanson wrote: On Fri, May 16, 2008 at 6:13 AM, Jim Steil [EMAIL PROTECTED] wrote: Hi: Can anyone tell me if it is possible to access data on an AS/400 through SQLAlchemy? -Jim I'm connecting to an AS/400 using pyodbc, so I am sure that I can

[sqlalchemy] Re: Access to AS/400 data

2008-05-16 Thread Jim Steil
Carlos Hanson wrote: On Fri, May 16, 2008 at 6:13 AM, Jim Steil [EMAIL PROTECTED] wrote: Hi: Can anyone tell me if it is possible to access data on an AS/400 through SQLAlchemy? -Jim I'm connecting to an AS/400 using pyodbc, so I am sure that I can do it through SQLAlchemy.

[sqlalchemy] Re: Access to AS/400 data

2008-05-16 Thread Carlos Hanson
On Fri, May 16, 2008 at 8:14 AM, Michael Bayer [EMAIL PROTECTED] wrote: On May 16, 2008, at 10:55 AM, Carlos Hanson wrote: On Fri, May 16, 2008 at 6:13 AM, Jim Steil [EMAIL PROTECTED] wrote: Hi: Can anyone tell me if it is possible to access data on an AS/400 through SQLAlchemy?

[sqlalchemy] Re: Access to AS/400 data

2008-05-16 Thread Lukasz Szybalski
On Fri, May 16, 2008 at 12:03 PM, Carlos Hanson [EMAIL PROTECTED] wrote: On Fri, May 16, 2008 at 8:14 AM, Michael Bayer [EMAIL PROTECTED] wrote: On May 16, 2008, at 10:55 AM, Carlos Hanson wrote: On Fri, May 16, 2008 at 6:13 AM, Jim Steil [EMAIL PROTECTED] wrote: Hi: Can anyone tell

[sqlalchemy] Re: Using SQLAlchemy with Plone/Zope

2008-05-16 Thread Mike
On May 16, 11:06 am, Andreas Jung [EMAIL PROTECTED] wrote: --On 16. Mai 2008 08:58:38 -0700 Mike [EMAIL PROTECTED] wrote: Hi, We are using SQLAlchemy 4.X in Zope using SQLAlchemyDA, found here: http://opensource.zopyx.com/projects/SQLAlchemyDA This uses SA 0.4.0. We are

[sqlalchemy] Re: Using SQLAlchemy with Plone/Zope

2008-05-16 Thread Michael Bayer
On May 16, 2008, at 11:58 AM, Mike wrote: I'm not sure how to go about troubleshooting this. Would upgrading it to SQLAlchemy 0.4.5 fix it? Any hints would be appreciated. Hi Mike - yeah, i see your stacktrace is from 0.4.0 and i have a vague recollection of some ResultProxy bug of

[sqlalchemy] Re: Access to AS/400 data

2008-05-16 Thread Jim Steil
Carlos Hanson wrote: On Fri, May 16, 2008 at 8:14 AM, Michael Bayer [EMAIL PROTECTED] wrote: On May 16, 2008, at 10:55 AM, Carlos Hanson wrote: On Fri, May 16, 2008 at 6:13 AM, Jim Steil [EMAIL PROTECTED] wrote: Hi: Can anyone tell me if it is possible to access data on an

[sqlalchemy] SQLAlchemy experts wanted

2008-05-16 Thread Jim R. Wilson
Hi all, SQLAlchemy is a great project and a growing niche. As it becomes even more popular, there will be increasing demand for experts in the field. I am compiling a contact list of SQLAlchemy experts who may be interested in opportunities under the right circumstances. I am not a recruiter

[sqlalchemy] Is inserting new data with column_mapped_collection inconsistent?

2008-05-16 Thread Allen Bierbaum
I have just started using column_mapped_collections. (http://www.sqlalchemy.org/docs/04/mappers.html#advdatamapping_relation_collections_dictcollections I must say, these are very powerful and extremely nice when reading data. But I have run into one thing that seems confusing when it comes to

[sqlalchemy] Re: Access to AS/400 data

2008-05-16 Thread Carlos Hanson
On Fri, May 16, 2008 at 10:49 AM, Jim Steil [EMAIL PROTECTED] wrote: Carlos Hanson wrote: On Fri, May 16, 2008 at 8:14 AM, Michael Bayer [EMAIL PROTECTED] wrote: On May 16, 2008, at 10:55 AM, Carlos Hanson wrote: On Fri, May 16, 2008 at 6:13 AM, Jim Steil [EMAIL PROTECTED] wrote:

[sqlalchemy] Re: Is inserting new data with column_mapped_collection inconsistent?

2008-05-16 Thread jason kirtland
Allen Bierbaum wrote: I have just started using column_mapped_collections. (http://www.sqlalchemy.org/docs/04/mappers.html#advdatamapping_relation_collections_dictcollections I must say, these are very powerful and extremely nice when reading data. But I have run into one thing that seems