[sqlalchemy] Release posted on homepage!

2007-04-20 Thread Greg Copeland
I noticed current release information is now available on the SQLAlchemy homepage! Good job! Greg --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalchemy

[sqlalchemy] Re: Database Disconnection Detection

2007-04-03 Thread Greg Copeland
I've done a little bit more testing and have found some interesting results. If a connection has previously been established and it then fails, I get a cx_Oracle exception. If a connection has yet to be established, I get a SQLAlchemy exception. These are the guys I'm seeing. If it would be he

[sqlalchemy] Re: PyInstaller Support

2007-04-02 Thread Greg Copeland
urces...is that > supported by PyInstaller also ? > > On Apr 2, 2007, at 5:32 PM, Greg Copeland wrote: > > > > > If anyone cares, the next release of PyInstaller has have support for > > SQLAlchemy. I tested with version 3.5 of SQLAlchemy and 1.3 of > > PyInstall

[sqlalchemy] PyInstaller Support

2007-04-02 Thread Greg Copeland
If anyone cares, the next release of PyInstaller has have support for SQLAlchemy. I tested with version 3.5 of SQLAlchemy and 1.3 of PyInstaller. Support has already been checked into the RC system. So look for any release newer than 1.3 of PyInstaller. If you don't already know, PyInstaller i

[sqlalchemy] Re: Database Disconnection Detection

2007-04-02 Thread Greg Copeland
> >connection, I then pulled my network cable and issued the execute on > >my connection. > > Nice. I've been restarting the database server (for MSSQL, MySQL, > Postgres) but I wonder if that will yield slightly different results. > If you need me to shutdown the database and retry, I can try th

[sqlalchemy] Re: Database Disconnection Detection

2007-04-02 Thread Greg Copeland
my network cable and issued the execute on my connection. Let me know if you want me to go about this from another direction. Greg > Greg Copeland wrote: > >I'm using sqlalcehmy 2.5 with cx_Oracle 4.2.1. What is the proper way > >to detect an sqlalchemy operation has lost it

[sqlalchemy] Re: Database Disconnection Detection

2007-04-02 Thread Greg Copeland
ors like these if you think your database is going to > crash a lot, put a very low "pool_recycle" setting on your > engine...that way connections can be kept very fresh. > > also there has just been discusson on this list about this issue not > more than a week ago so fee

[sqlalchemy] Re: Database Disconnection Detection

2007-04-02 Thread Greg Copeland
on <[EMAIL PROTECTED]> wrote: > Greg, > > If you can send the traceback you get when such an error occurs, that > would be helpful for providing Oracle support for this condition. > > Paul > > Greg Copeland wrote: > >I'm using sqlalcehmy 2.5 with cx_Or

[sqlalchemy] Re: Update Latest News on website?

2007-04-02 Thread Greg Copeland
be pretty boring (also the news > on the site is not RSS aggregated or anything...its not very > functional). > > On Apr 2, 2007, at 1:08 PM, Greg Copeland wrote: > > > > > Perhaps I missed it, but it would be great if you guys would

[sqlalchemy] Re: Database Disconnection Detection

2007-04-02 Thread Greg Copeland
QLAlchemy right now, assuming the DBAPI actually returns an exception? Greg > > On Apr 2, 2007, at 1:07 PM, Greg Copeland wrote: > > > > > I'm using sqlalcehmy 2.5 with cx_Oracle 4.2.1. What is the proper way > > to detect an sqlalchemy operation has lost its dat

[sqlalchemy] Update Latest News on website?

2007-04-02 Thread Greg Copeland
Perhaps I missed it, but it would be great if you guys would update the Latest News section on the SA homepage when a new release is made available. Greg --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "sqlalchemy"

[sqlalchemy] Database Disconnection Detection

2007-04-02 Thread Greg Copeland
I'm using sqlalcehmy 2.5 with cx_Oracle 4.2.1. What is the proper way to detect an sqlalchemy operation has lost its database connection and reconnection/retry? The manual doesn't seem to say much about the topic. When connection loss occurs, does SA throw the native dbapi exception? If not, w

[sqlalchemy] Re: memory leak with psyco

2007-03-21 Thread Greg Copeland
One of the optimizations that psyco performs is function specialization. It is possible this is what is occuring. Regardless, you should see memory consumption taper after sustained use, under the assumption that psyco will eventually stop creating new variants of the specialized function. You

[sqlalchemy] Re: Functions with out parameters?

2007-03-09 Thread Greg Copeland
> you can pull raw_connection() off of the engine. > > On Mar 9, 11:33 am, "Greg Copeland" <[EMAIL PROTECTED]> wrote: > > > On Mar 8, 4:46 pm, Michael Bayer <[EMAIL PROTECTED]> wrote: > > > > we have a notion of how this feature can be implement

[sqlalchemy] Re: Functions with out parameters?

2007-03-09 Thread Greg Copeland
On Mar 8, 4:46 pm, Michael Bayer <[EMAIL PROTECTED]> wrote: > we have a notion of how this feature can be implemented with oracle > but the actual work has not been performed. > > i just put this notion into ticket #507 since I hadnt written it down > anywhere. > > for now theres not really a good

[sqlalchemy] Functions with out parameters?

2007-03-08 Thread Greg Copeland
This was cross posted to comp.lang.python because it would not let me join here. At any rate, I'm using engine.func.blah(1, 2, 3, error ).execute() and get: sqlalchemy.exceptions.SQLError: (DatabaseError) ORA-06572: Function blah has out arguments. Anthing special I need to do to call an Oracle