I use Sybase SQL Anywhere 9.02 with the objectcraft sybase python driver compiled with freetds. I know now it is definitely a timeout issue and it is driver/database specific.
I am testing a workaround that seems good so far even though it is an ugly hack. I use the turbogears scheduler to run the equivalent of a SELECT 1 every 3 minutes. Timeout problems gone! :) As far a real solution, I am unfortunately not much help in that regard. It seems to be a tough problem. I read yesterday that SQLAlchemy suffers the same problem with their MySQL adapter. Thanks for the help! Regards, Aaron sophana wrote: > Do you use mysql 5? > I had this problem corrected once with a patch in mysqldb and in > sqlobject0.8. > But When I upgraded to mysqldb 1.2.2, it didn't work anymore. I also > reverted to latest sqlobject 0.7.x > My application make regular checks. So the mysql done away problem > doesn't appear. > The mysqldb patch was setting a reconnect option at the mysql C api level. ------------------------------------------------------------------------- Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys - and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV _______________________________________________ sqlobject-discuss mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
