[Zope] Sybase & Thread

Nicholas Lo nicklo@computer.org
Sun, 6 Aug 2000 12:29:56 +0800


This is a multi-part message in MIME format.

------=_NextPart_000_0019_01BFFFA2.07B5C100
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Hi,

I just wonder if anyone can help me with my problem. Recently, I've=20
been working on creating a ZOPE product which requires periodic=20
access to my Sybase. I have created a thread process using the=20
Threading module. There is no problem of periodically wake up the=20
thread and print something to the screen. So, I guess I have no=20
problem with thread programming under ZOPE. However, when I add some=20
database related routines to the thread, problems started to occur. I=20
sometimes got '... not connected to the database'. When I did an=20
SQL 'update', nothing has been updated on the database server when I=20
actually looked into the database using isql. After a whole day of=20
trial & error, now I've got 'ZOPE Memory Error'! I just wonder what=20
has gone wrong. I really have no clue and my deadline is pressing :(

1) I want to know what is the proper way of using thread under ZOPE.
2) Is there any critical limitation of SybaseDAv2?
3) Can SybaseDAv2 & Threading live together happily?
4) What the role of ZODB in such situation?

Thanks a million if anyone can help!

Regards,
Nick



------=_NextPart_000_0019_01BFFFA2.07B5C100
Content-Type: text/html;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content=3D"text/html; charset=3Diso-8859-1" =
http-equiv=3DContent-Type>
<META content=3D"MSHTML 5.00.2314.1000" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffecd8>
<DIV><FONT face=3DArial size=3D2>Hi,<BR><BR>I just wonder if anyone can =
help me with=20
my problem. Recently, I've <BR>been working on creating a ZOPE product =
which=20
requires periodic <BR>access to my Sybase. I have created a thread =
process using=20
the <BR>Threading module. There is no problem of periodically wake up =
the=20
<BR>thread and print something to the screen. So, I guess I have no =
<BR>problem=20
with thread programming under ZOPE. However, when I add some =
<BR>database=20
related routines to the thread, problems started to occur. I =
<BR>sometimes got=20
'... not connected to the database'. When I did an <BR>SQL 'update', =
nothing has=20
been updated on the database server when I <BR>actually looked into the =
database=20
using isql. After a whole day of <BR>trial &amp; error, now I've got =
'ZOPE=20
Memory Error'! I just wonder what <BR>has gone wrong. I really have no =
clue and=20
my deadline is pressing :(<BR><BR>1) I want to know what is the proper =
way of=20
using thread under ZOPE.<BR>2) Is there any critical limitation of=20
SybaseDAv2?<BR>3) Can SybaseDAv2 &amp; Threading live together =
happily?<BR>4)=20
What the role of ZODB in such situation?<BR><BR>Thanks a million if =
anyone can=20
help!<BR><BR>Regards,<BR>Nick<BR><BR></FONT></DIV></BODY></HTML>

------=_NextPart_000_0019_01BFFFA2.07B5C100--