[Pljava-dev] PL/Java 64bit - The specified procedure could not be found.

Binoy,

The dll is invoked by the Postgres Server which runs as a separate process. Therefore you have to have the pljava.dll on that classpath. I'm running with 64 bit Windows 7 and postgres.

My classpath is:

C:\Program Files (x86)\PC Connectivity Solution\;C:\Windows\system32;C:\Windows;
C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\Program
Files (x86)\Microsoft Application Virtualization Client;C:\Program Files\Java\jd
k1.6.0_23\jre\bin;C:\Postgres\9.0\bin;C:\Postgres\9.0\lib;C:\Program Files\Java\
jdk1.6.0_23\jre\bin\server;

I have put the pljava.dll and pljava.jar into C:\Postgres\9.0\lib

My postgresql.conf relevant stuff is:

#custom_variable_classes = ''
# list of custom variable class names
# DJLG change 2nd June 2007, checked 15 Oct 2010 for 8.4 and directory changed to lib
custom_variable_classes = 'pljava'
# list of custom variable class names
pljava.classpath='C:\\Postgres\\9.0\\lib\\pljava.jar'

# Set the size of the prepared statement MRU cache
#
pljava.statement_cache_size = 10

# If true, lingering savepoints will be released on function exit. If false,
# the will be rolled back
#
pljava.release_lingering_savepoints = true

# Define startup options for the Java VM.
#
pljava.vmoptions = '-Xmx64M'

# Setting debug to true will cause the postgres process to go
# into a sleep(1) loop on its first call to java. This variable is
# only useful if you want to debug the PL/Java internal C code.
#
pljava.debug = false

That works !

I have some diagnostic java code I developed and you could have a copy if you are still stuck.

Regards

David

David JL Gradwell, M.A. (Cantab), F.B.C.S.
Chartered IT Professional
Head of Consulting
VocaLink

t: +44 (0)870 920 8516
m:+44 (0)7920 143 639
e: david.gradwell at vocalink.com<mailto:david.gradwell at vocalink.com>
w: http://www.vocalink.com<http://www.vocalink.com/>

From: pljava-dev-bounces at pgfoundry.org [mailto:pljava-dev-bounces at pgfoundry.org] On Behalf Of Binoy
Sent: 23 May 2012 19:15
To: pljava-dev at pgfoundry.org
Subject: [Pljava-dev] PL/Java 64bit - The specified procedure could not be found.

hi,

I get this error when I try to install PL/Java 1.4.2.

java -classpath D:\PostgreSQL\pljava\deploy.jar;D:\Drivers\postgresql-9.1-902.jdbc4.jar org.postgresql.pljava.deploy.Deployer -install -database mydb -user postgres -password pass

org.postgresql.util.PSQLException: ERROR: could not load library "D:/PostgreSQL/pljava/pljava.dll": The specified procedure could not be found.

I have tried the suggestions from the archives without any success. Can you please let me know if I am missing out on any configuration settings?

PostgreSQL
PostgreSQL 9.1.3, compiled by Visual C++ build 1500, 64-bit

Windows
Windows 7 Enterprise 64 bit

Java
java version "1.6.0_26"
Java(TM) SE Runtime Environment (build 1.6.0_26-b03)
Java HotSpot(TM) 64-Bit Server VM (build 20.1-b02, mixed mode)

PL/Java
pljava-x86_64-w64-mingw32-pg9.0-1.4.2.tar.gz

postgresql.conf
Added the following three lines,
dynamic_library_path = '$libdir;D:\\PostgreSQL\\pljava'
custom_variable_classes = 'pljava'
pljava.classpath = 'D:\\PostgreSQL\\pljava\\pljava.jar'

PATH
C:\Program Files\Java\jre6\bin;C:\Program Files\Java\jre6\bin\server;D:\PostgreSQL\9.1\bin;...

Dependency Walker on pljava.dll shows,
Error: At least one required implicit or forwarded dependency was not found.
Error: At least one module has an unresolved import due to a missing export function in an implicitly dependent module.
Warning: At least one delay-load dependency module was not found.
Warning: At least one module has an unresolved import due to a missing export function in a delay-load dependent module.

The two modules are MSVCR90.DLL and IESHIMS.DLL

Thanks,
Binoy

*****************************************************
This email is issued by a VocaLink group company. It is confidential and intended for the exclusive use of the addressee only. You should not disclose its contents to any other person. If you are not the addressee (or responsible for delivery of the message to the addressee), please notify the originator immediately by return message and destroy the original message. The contents of this email will have no contractual effect unless it is otherwise agreed between a specific VocaLink group company and the recipient.

The VocaLink group companies include, among others: VocaLink Limited (Company No 06119048, VAT No. 907 9619 87) which is registered in England and Wales at registered office Drake House, Homestead Road, Rickmansworth, WD3 1FX. United Kingdom, Voca Limited (Company no 1023742, VAT No. 907 9619 87) which is registered in England and Wales at registered office Drake House, Three Rivers Court, Homestead Road, Rickmansworth, Hertfordshire. WD3 1FX. United Kingdom, LINK Interchange Network Limited (Company No 3565766, VAT No. 907 9619 87) which is registered in England and Wales at registered office Drake House, Homestead Road, Rickmansworth, WD3 1FX and VocaLink Holdings Limited (Company No 06119036, VAT No. 907 9619 87) which is registered in England and Wales at registered office Drake House, Homestead Road, Rickmansworth, WD3 1FX. United Kingdom.

The views and opinions expressed in this email may not reflect those of any member of the VocaLink group. This message and any attachments have been scanned for viruses prior to leaving the VocaLink group network; however, VocaLink does not guarantee the security of this message and will not be responsible for any damages arising as a result of any virus being passed on or arising from any alteration of this message by a third party. The VocaLink group may monitor emails sent to and from the VocaLink group network.

*************************************************************
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.pgfoundry.org/pipermail/pljava-dev/attachments/20120524/6b45b6c4/attachment.html>