I found in the cx_oracle.py dialect file line 537 is as follows
def dbapi(cls):
import cx_Oracle
return cx_Oracle
But when i included those two lines in python script and run using eclipse
it runs without any error. When printed it gave something like following.
<module 'cx_Oracle' from 'C:\Python26\lib\site-packages\cx_Oracle.pyd'>
Since I am new to python programming, I can't understand what is the problem
here. Is it some configuration related issue. I observed that there's no
oracle related DLLs in C:\Python26\DLLs directory.
Thanks.
On Tue, Jul 5, 2011 at 8:31 PM, Upul Iroshan Abayagunawardhana <
[email protected]> wrote:
> Hi all,
>
> I am trying to write some plugin for Tiddlyspace[1], Which is using
> sqlalchemy for Data Access. Currently it's support MySQL. But now I am
> trying to use it with Oracle. So I've installed oracle driver for
> windows [2].
>
> I've tried out some samples without sqlalchemy and with sqlalchemy.
> Both samples worked fine and gave expected output. But when I am
> trying to integrate with tiddlywiki i am getting following error.
>
> 2011-07-05 13:41:15,078 WARNING Traceback (most recent call last):
> File "C:\Python26\lib\site-packages
> \tiddlywebplugins.prettyerror-0.9.5-py2.6.egg\tiddlywebplugins
> \prettyerror\exceptor.py", line 56, in __call__
> return self.application(environ, start_response)
> File "C:\Python26\lib\site-packages\tiddlyweb-1.2.36-py2.6.egg
> \tiddlyweb\web\wsgi.py", line 258, in __call__
> output = self.application(environ, start_response)
> File "C:\Python26\lib\site-packages\tiddlyweb-1.2.36-py2.6.egg
> \tiddlyweb\web\wsgi.py", line 47, in __call__
> output = self.application(environ, start_response)
> File "C:\Python26\lib\site-packages\tiddlyweb-1.2.36-py2.6.egg
> \tiddlyweb\web\serve.py", line 113, in __call__
> return self.application(environ, start_response)
> File "C:\Python26\lib\site-packages\tiddlyweb-1.2.36-py2.6.egg
> \tiddlyweb\web\serve.py", line 98, in __call__
> return self.application(environ, start_response)
> File "C:\Python26\lib\site-packages\tiddlyweb-1.2.36-py2.6.egg
> \tiddlyweb\web\query.py", line 27, in __call__
> return self.application(environ, start_response)
> File "C:\Python26\lib\site-packages
> \tiddlywebplugins.pathinfohack-0.9.1-py2.6.egg\tiddlywebplugins
> \pathinfohack.py", line 40, in __call__
> return self.application(environ, start_response)
> File "C:\Python26\lib\site-packages\tiddlyweb-1.2.36-py2.6.egg
> \tiddlyweb\web\wsgi.py", line 216, in __call__
> environ)
> File "C:\Python26\lib\site-packages\tiddlyweb-1.2.36-py2.6.egg
> \tiddlyweb\store.py", line 106, in __init__
> self._import()
> File "C:\Python26\lib\site-packages\tiddlyweb-1.2.36-py2.6.egg
> \tiddlyweb\store.py", line 121, in _import
> self.storage = imported_module.Store(self.config, self.environ)
> File "C:\Python26\lib\site-packages
> \tiddlywebplugins.sqlalchemy2-2.0.5-py2.6.egg\tiddlywebplugins
> \sqlalchemy2\__init__.py", line 344, in __init__
> self._init_store()
> File "C:\Python26\lib\site-packages\tiddlywebplugins.oracle10g-0.0.1-
> py2.6.egg\tiddlywebplugins\oracle.py", line 89, in _init_store
> ENGINE = create_engine(self._db_config())
> File "C:\Python26\lib\site-packages\sqlalchemy-0.7.1-py2.6.egg
> \sqlalchemy\engine\__init__.py", line 263, in create_engine
> return strategy.create(*args, **kwargs)
> File "C:\Python26\lib\site-packages\sqlalchemy-0.7.1-py2.6.egg
> \sqlalchemy\engine\strategies.py", line 64, in create
> dbapi = dialect_cls.dbapi(**dbapi_args)
> File "C:\Python26\lib\site-packages\sqlalchemy-0.7.1-py2.6.egg
> \sqlalchemy\dialects\oracle\cx_oracle.py", line 537, in dbapi
> import cx_Oracle
> ImportError: DLL load failed: The specified module could not be found.
>
> Please help me to resolve above issue.
>
> Thanks,
> Upul Abayagunawardhana.
>
> [1] : http://tiddlyspace.com/
> [2] :
> http://prdownloads.sourceforge.net/cx-oracle/cx_Oracle-5.1-10g.win32-py2.6.msi?download
--
*Upul Abayagunawardhana
**Mobile: *+94 713 280 622
<http://www.virtusa.com/>
<http://www.virtusa.com/blog/><http://www.twitter.com/uiroshan><http://lk.linkedin.com/in/upuliroshan><http://www.facebook.com/iroshan><http://www.youtube.com/uiroshan>
--
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en.
