[Zope-DB] RE: Oracle 9i, Zope 2.9.0 and Windows
Title: RE: Oracle 9i, Zope 2.9.0 and Windows Try this http://zope.org/Members/timmorgan/products/ZODBCDA/document_view it's the one I use and it works pretty good, you just have to install also the Mark Hammond's Python Win32 Extensions before, chek this link it has the instructions. I hope this will help you... Jose Rivera -Mensaje original- Hi :-) I'm doing a commercial project on Zope 2.9.0 in which I have to read and write data to Oracle 9.2.0.4 database. It won't be a substitution for ZODB but something more of an import/export feature. I've looked pretty closely on Zope - relational database connectivity and I understand the concepts of Database Adapter, Database Connection and Z SQL Methods. I've played around a bit with Gadfly. I've found the wiki page: http://zopewiki.org/Oracle and it seems that DOracle2 would be the best thing for my needs (I only need simple inserts and querries, nothing really fancy). But as I see there is no binary for Python 2.4 and Windows I've found a couple of howto's on compiling the extension but they're not easy or at least not for me, especially that I can't use the Ms Visual Studio :-( So before I take on the task I would like to ask for any suggestions (links are very welcome). Maybe someone has the adapter and could share it? Is the Oracle Client still needed after I've compiled the adapter? If I compile it in Linux is it possible to use it in Windows? As you've probably guessed I'm pretty newbie - but very much willing to learn :-) Please excuse my English. I will be very grateful for any help. Best regards, Maciej Zieba * La presente informacion se envia unicamente para el destinatario, y contiene Informacion de caracter CONFIDENCIAL o PRIVILEGIADA. La modificacion, retransmision, difusion, copia u otro uso de esta informacion por cualquier medio, por personas distintas al destinatario esta estrictamente prohibido. Si usted no es el destinatario, por favor notifique al remitente respondiendo a este mensaje, y borre el mismo y sus anexos sin retener copia alguna. Gracias. The information contained in this message is being sent to the intended recipient, and contains PRIVILEGED / CONFIDENTIAL Information. The modification, retransmission, disclosure, copy or other use of such information by persons other than the intended recipient is strictly prohibited. If you are not the intended recipient, please advise the sender immediately by reply e-mail and delete this message and any attachments without retaining a copy. Thank you. * ___ Zope-DB mailing list Zope-DB@zope.org http://mail.zope.org/mailman/listinfo/zope-db
Re: [Zope-DB] Oracle 9i, Zope 2.9.0 and Windows
[EMAIL PROTECTED] wrote at 2006-4-4 13:08 CES: ... I've found the wiki page: http://zopewiki.org/Oracle and it seems that DOracle2 would be the best thing for my needs (I only n= eed simple inserts and querries, nothing really fancy). But as I see ther= e is no binary for Python 2.4 and Windows. DCOracle2 currently has not maintainer. Maybe, you should look for cx_Oracle (which has an active maintainer). -- Dieter ___ Zope-DB mailing list Zope-DB@zope.org http://mail.zope.org/mailman/listinfo/zope-db
[Zope-DB] ZSQL + MySQL + sqltest + list
Hi, Really frustrated by this. dtml-sqltest catId type=int multiple I want catId to be a list: ie [4, 6, 8]. Examples indicate that I can do this. However, ZSQL generates an error every time I put in more than one integer. How can I pass a list of integers? Many thanks. -- Matthew Fairclough ___ Zope-DB mailing list Zope-DB@zope.org http://mail.zope.org/mailman/listinfo/zope-db
[Zope-DB] Oracle 9i, Zope 2.9.0 and Windows
You can use www.egenix.com for connection to Oracle ortry Postgresql 8.x. Postgresql can run natively on WIndows XP Pro. The adapter is available from www.initd.org. CY|I'm doing a commercial project on Zope 2.9.0 in which I have to read |and write data to Oracle 9.2.0.4 database. It won't be a substitution for |ZODB but something more of an import/export feature.||I've looked pretty closely on Zope - relational database connectivity |and I understand the concepts of Database Adapter, Database Connection |and Z SQL Methods. I've played around a bit with Gadfly. New Yahoo! Messenger with Voice. Call regular phones from your PC and save big.___ Zope-DB mailing list Zope-DB@zope.org http://mail.zope.org/mailman/listinfo/zope-db
[Zope-DB] mysql / zope db connection issue
Hi, I have written a series of zope pages for a person to update their record in our mysql database. They use a zpt-python-db sql-db driver-db flow and work pretty well. Unfortunately, if enough people use it, the number of open db connections grows until it hits a limit and the db stops accepting connections. I have seen that there is a connection issue with zope and mysql, but have not been able to find a solution. Is there one? Also, I put in some exception handling to trap any db errors and email the post if there are any. However, i am not sure it is working. I performed a test to the db update from my page with the db off and got a Database Error that wasn't caught by my exception handler. I am not sure why since I thought Exception would be the root of Database Errors. My code looks like this: try: result = context.updatePerson(**query_args) return text except Exception: try: mto = to address mfrom = from address subject = Updated supporter information body = printed context.MailHost.simple_send(mto, mfrom, subject, body) print result return text except Exception: errorText = 'h1Ooooppps!/h1pThere was an error submitting your information to our database and our backup logging method. Please email the a href=mailto:webmaster@domainwebmaster/a that you got an error so that we can track it down and fix it./ppThanks!/p' print errorText return printed return errorText The traceback error is: Exception Type Database Error Exception Value updatePerson is not connected to a database Any insights would be most welcome. Thanks! Jamie ___ Zope-DB mailing list Zope-DB@zope.org http://mail.zope.org/mailman/listinfo/zope-db
