On Nov 7, 2011, at 22:28, Jiang Fung Wong <jiangfung.w...@jamiq.com> wrote:
> Dear All,
>
> I got this error when trying to import pylucene inside Postgres PL/Python.
>
> ERROR: ('Traceback (most recent call last):
> File "<string>", line 17, in __plpython_procedure_testing_1517611
> File
> "d:\\ve\\Lib\\site-packages\\lucene-3.4.0-py2.6-win32.egg\\lucene\\__init__.py",
> line 5, in <module>
> import jcc, _lucene
> File
> "d:\\ve\\Lib\\site-packages\\jcc-2.11-py2.6-win32.egg\\jcc\\__init__.py",
> line 34, in <module>
> from _jcc import initVM
> ImportError: DLL load failed: The specified module could not be found.
> ',)
>
> I have no isue importing jvm.dll using ctypes,
> ctypes.windll.LoadLibrary("jvm")
> The path to jvm.dll is also listed on the PATH environment variable,
> from the output of the statement plpy.info(os.environ['Path']) below.
> I have no problem importing pylucene on my system's python
> interpretor, outside Postgres.
>
> How to solve this?
You probably need to set some PATH environment variable to contain the
directory that contains the _jcc.dll for the process Postgres is running in.
A Postgres windows user mailing list may have more details for you.
Don't forget that you also must run initVM() from the process' main thread and
that each thread calling into PyLucene must call attachCurrentThread() too.
Last but not least, is the version of Python embedded in Postgres the same as
the one you used to build PyLucene ?
Andi..
>
> Here's my code:
>
> drop function testing();
> CREATE FUNCTION testing()
> RETURNS text
> AS $$
>
> import os
> import ctypes
> ctypes.windll.LoadLibrary("jvm")
> plpy.info(os.environ['Path'])
>
> try:
> import lucene
> except Exception, e:
> import traceback
> plpy.error(traceback.format_exc())
> else:
> return ""
>
> $$ LANGUAGE plpythonu;
