Re: [cx-oracle-users] Python and Oracle DB API (cx_oracle)

SourceForge Headquarters 225 Broadway Suite 1600 San Diego, CA 92101 +1 (858) 422-6466

I think he means it is Off Topic for this Mailing List.

From: Me [mailto:zed...@ya...]
Sent: Sunday, June 05, 2011 5:07 PM
To: cx-...@li...
Subject: Re: [cx-oracle-users] Python and Oracle DB API (cx_oracle)

Hi

I don't understand when you said :

  Apache and mod_python are OT in a cx_Oracle maling list.

Does it mean when I log an issue I should log it under OT subject????

thanks for the URL for mod_python but in that site I can't find mod_python for python 2.6 and 2.7. Is there other link for it? cuz I can't find any Next or other navigation button to see the rest.

thanks for your help

We are all equal at the end.

________________________________
From: Marco De Paoli <dep...@gm...>
To: cx-...@li...
Sent: Sun, June 5, 2011 1:53:27 PM
Subject: Re: [cx-oracle-users] Python and Oracle DB API (cx_oracle)
please consider that Apache and mod_python are OT in a cx_Oracle maling list: cx_Oracle is not web-oriented, it is a wrapper for the Oracle Call Interface. Stop.

please consider that this list doesn't give help on Oracle website articles
please consider you are referring an article which is five year old

That said. I gave a look at the article you link: you need mod_python, you can't simply use CGI

you can download it from here
http://archive.apache.org/dist/httpd/modpython/win/3.3.1/

choose the correct version based on the python and apache you use

Marco

On Sun, Jun 5, 2011 at 3:12 AM, Me <zed...@ya...<mailto:zed...@ya...>> wrote:

Hi

thanks for your reply.

what I am wondering about is, why my script shown in previous email doesn't generate the expected result which is showing 'X' in browser after execution.?

explained in the Oracle page for cx_oracle db api for python.

the oracle URL from which I downloaded and followed for installation is:

http://www.oracle.com/technetwork/articles/piotrowski-pythoncore-084049.html

why this simple script doesn't get executed by apache?

-----------------------------------------------------

another question I like to ask you is:

where can I get a .exe for installing mod_python? (for python 2.7 and apache 2.2)

I've read the manual process for installing modpython in this web site:

http://www.modpython.org/live/mod_python-2.7.8/doc-html/app-wininst.html

but it requires 'mod_python.dll' which I don't know where and how to get it after googling it. it seems hard to find modpython for automation installation.

one has advise me to use 'mod_wsgi' and he said it's better then 'modpython' since i need it for web base apps in python.

if you know how \ where to get modpython full installation Please give me the URL.

thanks

We are all equal at the end.

________________________________
From: Marco De Paoli <dep...@gm...<mailto:dep...@gm...>>
To: cx-...@li...<mailto:cx-...@li...>
Sent: Fri, June 3, 2011 11:47:53 PM
Subject: Re: [cx-oracle-users] Python and Oracle DB API (cx_oracle)

cx_Oracle 5.1 is the current version

(I suggest you to use that and not not the 4.X)

First of all build a minimal script that works at the command line. Only at that point you can build a web version

psp means a mod_perl script
(Apache settings are OT in this ML)

Marco
On Sat, Jun 4, 2011 at 4:33 AM, Me <zed...@ya...<mailto:zed...@ya...>> wrote:

Hello All

I'm newbie to Python, Oracle and Apache 2.2

I've installed python 2.7 (ActiveState version), apache 2.2 and Oracle 10g XE.

All of them running in the same machine with XP as a OS.

I yet don't have 'mod_python' installed but I am planing to do so later.

(just using CGI script for time being although for web development i've read mod_python is the best.)

I just download the 'cx_Oracle-4.1.2-win32-10g-py27.exe' from the Oracle web site which is:

(http://www.oracle.com/technetwork/articles/piotrowski-pythoncore-084049.html)

the installation went smooth with no problem as the above site walks through.

then as site instructed::Create a file ora.psp under APACHE_HOME/htdocs to see whether the cx_Oracle module is working properly.

--------------------------------------

<%
import cx_Oracle
db = cx_Oracle.connect('username', 'password', '127.0.0.1/XE<http://127.0.0.1/XE>')
c = db.cursor()

c.execute('select * from dual')
req.write(c.fetchall()[0][0])

db.close()
%>

I put my  username\pass for log in to Oracle as it works with database after login.

------------------------------------

i did save the file in notepad and put it in  C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\ora.psp ( i saved as: "ora.psp" to eliminated the extra extention)

when i go to url:  ( http://127.0.0.1/ora.psp ) it just shows the content of the file like in notepad.(plain code) as it supposed to show 'x' in browser. (as a result of execuation of file)

Apache 2.2 runs in port 80 (default)

Oracle : http://127.0.0.1:8080/apex/f?p=4550:11:4261762709150240::NO::: (login page)

However at python command prompt when I execute the following:

>>> import cx_Oracle
>>> print 'The version of cx_oracle is: ', cx_Oracle.version
The version of cx_oracle is: 5.1

------------------------------------

Please help me to fix this test which is for connection to oracle.

  Is it because of I yet don't have mod_python installed in my machine?

Your help much appreciated.

Pink Floyd: >>>> We are all equal at the end.

------------------------------------------------------------------------------
Simplify data backup and recovery for your virtual environment with vRanger.
Installation's a snap, and flexible recovery options mean your data is safe,
secure and there when you need it. Discover what all the cheering's about.
Get your free trial download today.
http://p.sf.net/sfu/quest-dev2dev2
_______________________________________________
cx-oracle-users mailing list
cx-...@li...<mailto:cx-...@li...>
https://lists.sourceforge.net/lists/listinfo/cx-oracle-users

------------------------------------------------------------------------------
Simplify data backup and recovery for your virtual environment with vRanger.
Installation's a snap, and flexible recovery options mean your data is safe,
secure and there when you need it. Discover what all the cheering's about.
Get your free trial download today.
http://p.sf.net/sfu/quest-dev2dev2
_______________________________________________
cx-oracle-users mailing list
cx-...@li...<mailto:cx-...@li...>
https://lists.sourceforge.net/lists/listinfo/cx-oracle-users

________________________________
IMPORTANT: The information contained in this email and/or its attachments is confidential. If you are not the intended recipient, please notify the sender immediately by reply and immediately delete this message and all its attachments. Any review, use, reproduction, disclosure or dissemination of this message or any attachment by an unintended recipient is strictly prohibited. Neither this message nor any attachment is intended as or should be construed as an offer, solicitation or recommendation to buy or sell any security or other financial instrument. Neither the sender, his or her employer nor any of their respective affiliates makes any warranties as to the completeness or accuracy of any of the information contained herein or that this message or any of its attachments is free of viruses.