[Zope] PoPy1.4 Installed:

2000-12-18 Thread Paolo Quaglia

Hi
Here Is some tips to install PoPy DA on a RH6.2

First: You have to use Postgres7.0 with PoPy1.4
- download the Postgres7.0 with the development libraries (the development
RPM from the Postgres download)
- Download the Popy1.4.1 and the ZPopyDA0.7
- untar Popy1.4.1
- $./configure
- change the Makefile ... the include path isn't /usr/include/postgres but
it's /usr/include/pgsql
- the file /usr/include/pgsql/os.h is a broken link .. we have to solve this
prob
download the source distribution of Posrgress7.0 (not the RPM) and
substitute the broken link os.h with the file linux.h ... rename
linux.h-os.h and put it in the correct path (/usr/include/pgsql)
- make will now finish without errors!! and you get the Popymodule.so
- copy the popymodule.so in the [zopedir]/lib/python

- Untar the  ZPopyDA and go to the ZPoPyDa directory in the
lib/python/Products dir of Zope
- modify the PoPy_db.py file changing,

__compatibility__ = ('1.4','1.4.1')

- Launch Zope and All WORKS!!

Hope this Help

Paolo Quaglia
Information Technology Coordinator
Sitek S.p.A.
[EMAIL PROTECTED]



___
Zope maillist  -  [EMAIL PROTECTED]
http://lists.zope.org/mailman/listinfo/zope
**   No cross posts or HTML encoding!  **
(Related lists - 
 http://lists.zope.org/mailman/listinfo/zope-announce
 http://lists.zope.org/mailman/listinfo/zope-dev )




[Zope] PopyDA and DBMS Transactions

2000-12-18 Thread Paolo Quaglia

Hi
I heve finally installed the PopyDA0.7 that is a Multithreaded DA (multiple
concurrent access on the DBMS)

Now I'm doing tests to verify the DBMS transactions (Postgress support DB
transations):
But something doesn't work as expected:

I summarize my tests:

I have two DTML Documents:

first DTML: now called D1
dtml-var header
...1st sql statement: select * from customers where name='white'
...time.sleep(10) #external function that invokea the sleep function (10
sec)
...2dn sql statement: update customer set descr='Updated 1' where
customer='white'
dtml-var footer

Second DTML: now called D2
dtml-var header
...sql statement: update customer set descr='Updated 2' where
customer='white'
dtml-var footer

with two browser I called:
D1 and then D2

My expected Behaviour was:
-With the first statement of D1, Postgres would locks the table
The update of D2 has to wait to write because the table is locked
only when D1 has finished, D2 commit
As result the updated field has to result "Update 2" and not 'Update 1"

With the option Auto-commit mode ON the Behaviour was:
-D2 autocommit without waiting the end of D1! (as espected with autocomm.
off)
As result the updated field has to result "Update 1" (because D1 ended after
D1)

With the option Auto-commit mode OFF the Behaviour was:
-D2 autocommit without waiting the end of D1!! Why??!?!??!?
-When D1 finished an error occurs:

Error Type: ProgrammingError
Error Value: ERROR: Can't serialize access due to concurrent update

As result the updated field has to result "Update 2" FAULT!!


HOW CAN I HAVE TO DO in order to build a concurrent transaction Application
with Popy and Postgress???

Thank you Very Much for your Help!


Paolo Quaglia
Information Technology Coordinator
Sitek S.p.A.
[EMAIL PROTECTED]



___
Zope maillist  -  [EMAIL PROTECTED]
http://lists.zope.org/mailman/listinfo/zope
**   No cross posts or HTML encoding!  **
(Related lists - 
 http://lists.zope.org/mailman/listinfo/zope-announce
 http://lists.zope.org/mailman/listinfo/zope-dev )




RE: [Zope] I SOLVED!!

2000-12-16 Thread Paolo Quaglia


Sure I will post My detailed solution in a few days!!

Ciao to all

Paolo Quaglia 


-Original Message-
From: Eric Walstad [EMAIL PROTECTED]
Date: Fri, 15 Dec 2000 11:10:45 -0800
Subject: RE: [Zope] I SOLVED!!

 Hi Paolo, you should post your solution to the mailing list so that
 if
 others run into your same problem they can find your solution by
 searching
 ht emailing list archives.
 Just a thought.
 Eric.
 
 //  -Original Message-
 //  From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf
 Of Paolo
 //  Quaglia
 //  Sent: Friday, December 15, 2000 10:26 AM
 //  To: [EMAIL PROTECTED]
 //  Subject: [Zope] I SOLVED!!
 //
 //
 //  THANKS TO ALL for your help But I solved the Probs with the PoPy
 DA.
 //
 //  Ciao
 //
 //  Paolo
 //
 //
 //
 //
 //  ___
 //  Zope maillist  -  [EMAIL PROTECTED]
 //  http://lists.zope.org/mailman/listinfo/zope
 //  **   No cross posts or HTML encoding!  **
 //  (Related lists -
 //   http://lists.zope.org/mailman/listinfo/zope-announce
 //   http://lists.zope.org/mailman/listinfo/zope-dev )
 //
 



___
Zope maillist  -  [EMAIL PROTECTED]
http://lists.zope.org/mailman/listinfo/zope
**   No cross posts or HTML encoding!  **
(Related lists - 
 http://lists.zope.org/mailman/listinfo/zope-announce
 http://lists.zope.org/mailman/listinfo/zope-dev )




[Zope] PoPy module finally compiled but there is another prob

2000-12-15 Thread Paolo Quaglia

Hi to all
Finally I compiled the Popy module (the 1.4) and I obtained the
PoPymodule.so file
I copied the module in the [ZopDir]/lib/python directory
I installed the ZPoPyDA.0.7

but When I start Zop this error occour:

Traceback (innermost last):
  File "/usr/local/Zope-2.2.4-linux2-x86/lib/python/OFS/Application.py",
line 397, in import_products
product=__import__(pname, global_dict, global_dict, silly)
  File
"/usr/local/Zope-2.2.4-linux2-x86/lib/python/Products/ZPoPyDA/__init__.py",
line 32, in ?
import sys, os, Globals, DA
  File "/usr/local/Zope-2.2.4-linux2-x86/lib/python/Products/ZPoPyDA/DA.py",
line 35, in ?
from PoPy_db import DB
  File
"/usr/local/Zope-2.2.4-linux2-x86/lib/python/Products/ZPoPyDA/PoPy_db.py",
line 37, in ?
raise "The PoPy module is old: Update your version of PoPy"
The PoPy module is old: Update your version of PoPy

Has someone had the same probs?
How do you think the problem is?

Thanks


Paolo Quaglia




___
Zope maillist  -  [EMAIL PROTECTED]
http://lists.zope.org/mailman/listinfo/zope
**   No cross posts or HTML encoding!  **
(Related lists - 
 http://lists.zope.org/mailman/listinfo/zope-announce
 http://lists.zope.org/mailman/listinfo/zope-dev )




[Zope] I SOLVED!!

2000-12-15 Thread Paolo Quaglia

THANKS TO ALL for your help But I solved the Probs with the PoPy DA.

Ciao

Paolo 




___
Zope maillist  -  [EMAIL PROTECTED]
http://lists.zope.org/mailman/listinfo/zope
**   No cross posts or HTML encoding!  **
(Related lists - 
 http://lists.zope.org/mailman/listinfo/zope-announce
 http://lists.zope.org/mailman/listinfo/zope-dev )




[Zope] HELP with Postgress!! HELP!!

2000-12-14 Thread Paolo Quaglia



Hi 

I m trying to setup 
a linux box (Redhat 6.1) with PostGress 6.5 
What DA shall I 
use?

I have tried the 
ZPyGreSQLDA-0.3-rjr2.tar.gz, but the product result BROKEN 
PRODUCT!!

I have tried some 
ZPopyDA but some error occours
How Can I Install a 
decent PostGress SQL DA?

I thank you VERY 
Much
Paolo Quaglia


RE: [Zope] HELP with Postgress!! HELP!!

2000-12-14 Thread Paolo Quaglia

Thank you very much to all for the quick replies.
I'm fighting compiling the modules ... and trying to solve the prob

I'll let you know ... :)

Ciao

Paolo Quaglia

 -Original Message-
 From: [EMAIL PROTECTED]
 [mailto:[EMAIL PROTECTED]]On Behalf Of César A. K. Grossmann
 Sent: Thursday, December 14, 2000 6:49 PM
 To: Paolo Quaglia
 Cc: [EMAIL PROTECTED]
 Subject: Re: [Zope] HELP with Postgress!! HELP!!


  Paolo Quaglia wrote:
 
  I have tried the ZPyGreSQLDA-0.3-rjr2.tar.gz, but the product result
  BROKEN PRODUCT!!

 Did you have compiled it?

 []s
 --
  +-+-+
  | César A. K. Grossmann   | Capacitação Solidária   |
  | [EMAIL PROTECTED]| http://www.uol.com.br/umminuto/ |
  | http://members.xoom.com/ckant/  | Clique e doe - é de graça   |
  +-+-+
http://www.halcyon.com/sciclub/cgi-pvt/instr/instr.html
   A ética do iG: http://antispambr.abranetrj.org.br/not-20001023.html

 All is well that ends well.
   -- John Heywood





___
Zope maillist  -  [EMAIL PROTECTED]
http://lists.zope.org/mailman/listinfo/zope
**   No cross posts or HTML encoding!  **
(Related lists - 
 http://lists.zope.org/mailman/listinfo/zope-announce
 http://lists.zope.org/mailman/listinfo/zope-dev )




[Zope] Advanced Transactions:

2000-12-13 Thread Paolo Quaglia



Hi 
All,
I'm building a high 
transaction traffic db application using Zope.
I used for this 
tests two DB: MSAccess 97 and SQL Server 7.0 with the ZODBCDA 
product

I havemade 
some tests and I have found this:

The test 
is:
I have two DTML 
document called Test1 and Test2
I have 2 ZSQL 
Queries called Select1 and Select2
I have an external 
method (which id is Wait) that call the time.sleep(10) #it sleeps 10 
seconds

Test1 calls Select1 
and then the Wait() 

Test2 calls Select2 


First transaction 
test:
Select1 and Select2 
queries are equal:= select * from Users where name='example'
I call test1 in 
abrowser and immediately after test2 in another 
Browser.
RESULT: Test2 wait 
the end of test1 before the page was displayed

Second Transaction 
test:

Select1 = select * 
from Users where name='example'
Select2 = select * 
fromProducts where id='example'
I call test1 in 
abrowser and immediately after test2 in another 
Browser.
RESULT: Test2 wait 
the end of test1 before the page was 
displayed!!


Third Transaction 
test:

Select1 = select * 
from Users where name='example' on the Access Connection
Select2 = select * 
fromProducts where id='example' on the SQL sever 
Connection
I call test1 in 
abrowser and immediately after test2 in another 
Browser.
RESULT: Test2 wait 
the end of test1 before the page was displayed!! :(

Now 
Summarizing:
I think the Zope 
transaction Server works in every Zope operation. This is good, but it 
seemsthat it uses a bad locking method. I mean when I read a DB (usually a 
select) I wouldn't to lock the entire DB and I would let the other DB session 
free to call select statements!!

Am I right?? Or I do 
some mistake?? 
Thanks Very much for 
your cooperation
Paolo QuagliaInformation Technology 
CoordinatorSitek S.p.A.[EMAIL PROTECTED] 



[Zope] More on DB Transactions

2000-12-13 Thread Paolo Quaglia



Reading the [EMAIL PROTECTED] archive I found one message with 
an interesting sentence:

[Message]
 I am currently considering and evaluating Zope 
as one of the options we have to build a really large, completely 
databasedriven "enterprise scale" web-platform. I am a bit worried about 
this "maximum of 7 threads per dbThis isn't a maximum. It's just 
the default. It's easy to increase thenumber of 
connections.
[/Message]


Where is this 
Default and How can I increase this counter??
Thanks very much in 
advance
Paolo QuagliaInformation Technology 
CoordinatorSitek S.p.A.[EMAIL PROTECTED] 



RE: [Zope] ODBC Connection

2000-12-12 Thread Paolo Quaglia



Try to 
use the ZODBCDA 
http://www.zope.org/Products/DA/ZODBCDA


It 
works very well!

Paolo 
Quaglia


  -Original Message-From: [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED]]On Behalf Of Emmon SimboSent: 
  Tuesday, December 12, 2000 11:26 AMTo: 
  [EMAIL PROTECTED]Subject: [Zope] ODBC Connection
  Hi 
  
  I have a few 
  customers who are using Zope and have shown an interest inusing 
  the 
  OpenLink ODBC Drivers. Unfortunately, I am not familiar with Zope and wondered 
  if there was a How-To that I can use to show me how to use Zope with ODBC. I 
  have downloaded the ZmxODBCDA module but when I select this from the Products 
  menu, it shows up as ZmxODBCDA(Brokenproduct ZmxODBCA). If I click on 
  the link, I get
  
   File 
  "D:\APPS\ZopeWeb\lib\python\OFS\Application.py", line 397, in 
  import_products product=__import__(pname, global_dict, 
  global_dict, silly) File 
  "D:\APPS\ZopeWeb\lib\python\Products\ZmxODBCDA\__init__.py", line 91, in 
  ? import DA File 
  "D:\APPS\ZopeWeb\lib\python\Products\ZmxODBCDA\DA.py", line 92, in 
  ? from db import DB, manage_ODBCDataSources 
  File "D:\PROGRA~1\Zope22\lib\python\Products\ZmxODBCDA\db.py", line 87, in 
  ?ImportError: No module named mx.ODBC
  
  Any ideas what's 
  wrong here and secondly how I can go about making an ODBC 
  connection.
  
  Thanks for you 
  help in advance
  
  Best Regards,
  
  Emmon SimboConsultantOpenLink 
  SoftwareTel: +44 (0) 20 8681 7701Web: http://www.openlinksw.comXML  E-Business Infrastructure Technology Provider 
  
  


[Zope] Last day of Month

2000-12-12 Thread Paolo Quaglia



Hi 
everibody
Is there some tricky 
way to know the last day of the month of a DateTime object?
for ex: if my 
DateTime object is 12/12/2000  is there a method or a function that return 
the last day of the month?(in this example 31)

Thanks a 
lot
Paolo QuagliaInformation Technology 
CoordinatorSitek S.p.A.[EMAIL PROTECTED] 



RE: [Zope] ODBC Connection

2000-12-12 Thread Paolo Quaglia



Hi 
Emmon
I 
don't well understandthe exact moment the error 
occurs:

If you 
correctly havetheZODBCDA entry in the product list, you should have 
a new entry in the available objects list.
Now 
you have to create a new datasource with the win32 ODBC manager (in control 
panel).
thengo to a folder and add a new ZODBC Database 
connection and chose the created ODBC Datasorce

for me 
this work well ... 
Let me 
know

Paolo 
Quaglia

  -Original Message-From: [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED]]On Behalf Of Emmon SimboSent: 
  Tuesday, December 12, 2000 1:19 PMTo: Paolo Quaglia; 
  [EMAIL PROTECTED]Subject: RE: [Zope] ODBC 
  Connection
  Hi 
  Paolo
  
  I 
  already have that. The problem was that it wasn't in the lib/python path. 
  Moving it there fixed the problem. Now I get an error
  
  Error Type: 
  NameErrorError Value: 
  SQLDataSources
  whenI try to add a new 
  datasource.
  
  Emmon
  -Original Message-From: [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED]]On Behalf Of Paolo QuagliaSent: 
  12 December 2000 11:12To: [EMAIL PROTECTED]Subject: RE: 
  [Zope] ODBC Connection
  Try 
  to use the ZODBCDA 
  http://www.zope.org/Products/DA/ZODBCDA
  
  
  It 
  works very well!
  
  Paolo Quaglia
  
  
-Original Message-From: [EMAIL PROTECTED] 
[mailto:[EMAIL PROTECTED]]On Behalf Of Emmon SimboSent: 
Tuesday, December 12, 2000 11:26 AMTo: 
[EMAIL PROTECTED]Subject: [Zope] ODBC Connection
Hi 

I have a few 
customers who are using Zope and have shown an interest inusing 
the 
OpenLink ODBC Drivers. Unfortunately, I am not familiar with Zope and 
wondered if there was a How-To that I can use to show me how to use Zope 
with ODBC. I have downloaded the ZmxODBCDA module but when I select this 
from the Products menu, it shows up as ZmxODBCDA(Brokenproduct 
ZmxODBCA). If I click on the link, I get

 File 
"D:\APPS\ZopeWeb\lib\python\OFS\Application.py", line 397, in 
import_products product=__import__(pname, global_dict, 
global_dict, silly) File 
"D:\APPS\ZopeWeb\lib\python\Products\ZmxODBCDA\__init__.py", line 91, in 
? import DA File 
"D:\APPS\ZopeWeb\lib\python\Products\ZmxODBCDA\DA.py", line 92, in 
? from db import DB, manage_ODBCDataSources 
File "D:\PROGRA~1\Zope22\lib\python\Products\ZmxODBCDA\db.py", line 87, in 
?ImportError: No module named mx.ODBC

Any ideas what's 
wrong here and secondly how I can go about making an ODBC 
connection.

Thanks for you 
help in advance

Best Regards,

Emmon 
SimboConsultantOpenLink SoftwareTel: +44 (0) 20 8681 
7701Web: http://www.openlinksw.comXML  E-Business Infrastructure Technology 
Provider