agora inbox for pljava-dev@postgresql.org
help / color / mirror / Atom feed[Pljava-dev] Windows binaries
42+ messages / 0 participants
[nested] [flat]
* [Pljava-dev] Windows binaries
@ 2011-01-22 05:50
2011-01-23 17:37 ` [Pljava-dev] Windows binaries
0 siblings, 1 reply; 42+ messages in thread
From: @ 2011-01-22 05:50 UTC (permalink / raw)
Hi,I got pljava binaries from postgres plus for Windows.http://www.enterprisedb.com/products-services-training/products/postgres-plus-standard-server
After installing it then you can find the binaries in the lib directory and share/pljava directory.
I have already tried the postgres 8.4 binaries and it worked perfectly, of course we are talking about pljava 1.4Right now I just installed the postgres 9.0 plus and it has the pljava binaries too in the same directories. I m using a WindowsXP 32 bits...anyways postgres plus didnt ask me about 32/64 bits version..maybe we are missing the 64 bits pljava version anyways.
I guess it is pljava 1.4 but not sure..maybe could be 1.4.2 already??
Another question is if to use these binaries and use them in other applications is legal or not...i didnt study the postgres plus licence.
Johann, if the postgres plus team is building the pljava binaries for windows..they could not help you about that and to joinefforts to have the pljava win binaries in the pljava official page?
I strongly think people need windows binaries.
Cheers,Jose
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.pgfoundry.org/pipermail/pljava-dev/attachments/20110122/3d7243ab/attachment.html;
^ permalink raw reply [nested|flat] 42+ messages in thread
* [Pljava-dev] Windows binaries
2011-01-22 05:50 [Pljava-dev] Windows binaries
@ 2011-01-23 17:37 `
2011-01-23 17:45 ` [Pljava-dev] Windows binaries
0 siblings, 1 reply; 42+ messages in thread
From: @ 2011-01-23 17:37 UTC (permalink / raw)
OK, I installed the latest Enterprise DB postgres-plus-standard-server.
I have been trying for hours to figure out pljava, but it doesn't make
sense, it does not seem to be a complete installation of pljava. For
example, the SQLJ scheme is not already in the database, and I cannot
find the Deployer anywhere to deploy the schema.
Jose, could you please tell me what you did to get pljava working - the
documentation just gets me to a dead end.
Cheers, Eric
On 2011-01-21 9:50 PM, JOSE CARLOS MARTINEZ LLARIO wrote:
> Hi,
> I got pljava binaries from postgres plus for Windows.
> http://www.enterprisedb.com/products-services-training/products/postgres-plus-standard-server
>
> After installing it then you can find the binaries in the lib
> directory and share/pljava directory.
>
> I have already tried the postgres 8.4 binaries and it worked
> perfectly, of course we are talking about pljava 1.4
> Right now I just installed the postgres 9.0 plus and it has the pljava
> binaries too in the same directories. I m using a Windows
> XP 32 bits...anyways postgres plus didnt ask me about 32/64 bits
> version..maybe we are missing the 64 bits pljava version anyways.
>
> I guess it is pljava 1.4 but not sure..maybe could be 1.4.2 already??
>
> Another question is if to use these binaries and use them in other
> applications is legal or not...i didnt study the postgres plus licence.
>
> Johann, if the postgres plus team is building the pljava binaries for
> windows..they could not help you about that and to join
> efforts to have the pljava win binaries in the pljava official page?
>
> I strongly think people need windows binaries.
>
> Cheers,
> Jose
>
>
>
>
>
> _______________________________________________
> Pljava-dev mailing list
> Pljava-dev at pgfoundry.org
> http://pgfoundry.org/mailman/listinfo/pljava-dev
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.pgfoundry.org/pipermail/pljava-dev/attachments/20110123/2a333630/attachment.html;
^ permalink raw reply [nested|flat] 42+ messages in thread
* [Pljava-dev] Windows binaries
2011-01-22 05:50 [Pljava-dev] Windows binaries
2011-01-23 17:37 ` [Pljava-dev] Windows binaries
@ 2011-01-23 17:45 `
2011-01-23 17:53 ` [Pljava-dev] Windows binaries
0 siblings, 1 reply; 42+ messages in thread
From: @ 2011-01-23 17:45 UTC (permalink / raw)
On Sun, 23 Jan 2011 17:37:59 -0000, Eric Kolotyluk
<eric.kolotyluk at gmail.com> wrote:
> Jose, could you please tell me what you did to get pljava working - the
> documentation just gets me to a dead end.
Do you have the install.sql file? It hasn't been changed since 1.4.0 so
it doesn't whether you have the one from 1.4.2 or not. You use it like
psql -f install.sql <database>
The same can be said about the deployer. You can just use the one found
in the linux binaries.
Sorry about all the trouble. This is one part of PL/Java I haven't
touched yet, the installation. Also, the wiki could do with a but of
updating.
--
Johann Oskarsson http://www.2ndquadrant.com/ |[]
PostgreSQL Development, 24x7 Support, Training and Services --+--
|
Blog: http://my.opera.com/myrkraverk/blog/
^ permalink raw reply [nested|flat] 42+ messages in thread
* [Pljava-dev] Windows binaries
2011-01-22 05:50 [Pljava-dev] Windows binaries
2011-01-23 17:37 ` [Pljava-dev] Windows binaries
2011-01-23 17:45 ` [Pljava-dev] Windows binaries
@ 2011-01-23 17:53 `
2011-01-23 17:58 ` [Pljava-dev] Windows binaries
2011-01-23 17:58 ` [Pljava-dev] Windows binaries
0 siblings, 2 replies; 42+ messages in thread
From: @ 2011-01-23 17:53 UTC (permalink / raw)
Yes, I have install.sql
What does <database> refer to?
Cheers, Eric
On 2011-01-23 9:45 AM, Johann 'Myrkraverk' Oskarsson wrote:
> On Sun, 23 Jan 2011 17:37:59 -0000, Eric Kolotyluk
> <eric.kolotyluk at gmail.com> wrote:
>
>> Jose, could you please tell me what you did to get pljava working - the
>> documentation just gets me to a dead end.
>
> Do you have the install.sql file? It hasn't been changed since 1.4.0
> so it doesn't whether you have the one from 1.4.2 or not. You use it
> like
>
> psql -f install.sql <database>
>
> The same can be said about the deployer. You can just use the one
> found in the linux binaries.
>
>
> Sorry about all the trouble. This is one part of PL/Java I haven't
> touched yet, the installation. Also, the wiki could do with a but of
> updating.
>
^ permalink raw reply [nested|flat] 42+ messages in thread
* [Pljava-dev] Windows binaries
2011-01-22 05:50 [Pljava-dev] Windows binaries
2011-01-23 17:37 ` [Pljava-dev] Windows binaries
2011-01-23 17:45 ` [Pljava-dev] Windows binaries
2011-01-23 17:53 ` [Pljava-dev] Windows binaries
@ 2011-01-23 17:58 `
1 sibling, 0 replies; 42+ messages in thread
From: @ 2011-01-23 17:58 UTC (permalink / raw)
On 01/23/11 9:53 AM, Eric Kolotyluk wrote:
> Yes, I have install.sql
>
> What does <database> refer to?
>
that would be the database you want to install the pljava functions in
^ permalink raw reply [nested|flat] 42+ messages in thread
* [Pljava-dev] Windows binaries
2011-01-22 05:50 [Pljava-dev] Windows binaries
2011-01-23 17:37 ` [Pljava-dev] Windows binaries
2011-01-23 17:45 ` [Pljava-dev] Windows binaries
2011-01-23 17:53 ` [Pljava-dev] Windows binaries
@ 2011-01-23 17:58 `
2011-01-23 18:11 ` [Pljava-dev] Windows binaries
1 sibling, 1 reply; 42+ messages in thread
From: @ 2011-01-23 17:58 UTC (permalink / raw)
On Sun, 23 Jan 2011 17:53:21 -0000, Eric Kolotyluk
<eric.kolotyluk at gmail.com> wrote:
> Yes, I have install.sql
>
> What does <database> refer to?
The database you want to install the schema to. If you run psql normally
without it you can omit it as well from this command. You can also see
the name by running \c in psql without any argument.
--
Johann Oskarsson http://www.2ndquadrant.com/ |[]
PostgreSQL Development, 24x7 Support, Training and Services --+--
|
Blog: http://my.opera.com/myrkraverk/blog/
^ permalink raw reply [nested|flat] 42+ messages in thread
* [Pljava-dev] Windows binaries
2011-01-22 05:50 [Pljava-dev] Windows binaries
2011-01-23 17:37 ` [Pljava-dev] Windows binaries
2011-01-23 17:45 ` [Pljava-dev] Windows binaries
2011-01-23 17:53 ` [Pljava-dev] Windows binaries
2011-01-23 17:58 ` [Pljava-dev] Windows binaries
@ 2011-01-23 18:11 `
2011-01-23 18:22 ` [Pljava-dev] Windows binaries
0 siblings, 1 reply; 42+ messages in thread
From: @ 2011-01-23 18:11 UTC (permalink / raw)
On 2011-01-23 9:58 AM, Johann 'Myrkraverk' Oskarsson wrote:
> On Sun, 23 Jan 2011 17:53:21 -0000, Eric Kolotyluk
> <eric.kolotyluk at gmail.com> wrote:
>
>> Yes, I have install.sql
>>
>> What does <database> refer to?
>
> The database you want to install the schema to. If you run psql
> normally without it you can omit it as well from this command. You
> can also see the name by running \c in psql without any argument.
>
OK, this is what happens...
The pljava.dll file is certainly in the lib directory, so I can't
understand why it is complaining it cannot find it.
Cheers, Eric
C:\Program Files (x86)\PostgresPlus\9.0SS\share\pljava>psql -f install.sql
Password:
CREATE SCHEMA
GRANT
psql:install.sql:6: ERROR: could not load library "C:/Program Files
(x86)/PostgresPlus/9.0SS/lib/pljava.dll": The specified module could not
be found.
psql:install.sql:8: ERROR: function sqlj.java_call_handler() does not exist
psql:install.sql:12: ERROR: could not load library "C:/Program Files
(x86)/PostgresPlus/9.0SS/lib/pljava.dll": The specified module could not
be found.
psql:install.sql:14: ERROR: function sqlj.javau_call_handler() does not
exist
psql:install.sql:23: NOTICE: CREATE TABLE will create implicit sequence
"jar_repository_jarid_seq" for serial column "jar_repository.jarid"
psql:install.sql:23: NOTICE: CREATE TABLE / PRIMARY KEY will create
implicit index "jar_repository_pkey" for table "jar_repository"
psql:install.sql:23: NOTICE: CREATE TABLE / UNIQUE will create implicit
index " jar_repository_jarname_key" for table "jar_repository"
CREATE TABLE
GRANT
psql:install.sql:32: NOTICE: CREATE TABLE will create implicit sequence
"jar_en
try_entryid_seq" for serial column "jar_entry.entryid"
psql:install.sql:32: NOTICE: CREATE TABLE / PRIMARY KEY will create
implicit in
dex "jar_entry_pkey" for table "jar_entry"
psql:install.sql:32: NOTICE: CREATE TABLE / UNIQUE will create implicit
index "
jar_entry_jarid_entryname_key" for table "jar_entry"
CREATE TABLE
GRANT
ALTER TABLE
psql:install.sql:43: NOTICE: CREATE TABLE / PRIMARY KEY will create
implicit index "classpath_entry_pkey" for table "classpath_entry"
CREATE TABLE
GRANT
psql:install.sql:50: NOTICE: CREATE TABLE will create implicit sequence
"typemap_entry_mapid_seq" for serial column "typemap_entry.mapid"
psql:install.sql:50: NOTICE: CREATE TABLE / PRIMARY KEY will create
implicit index "typemap_entry_pkey" for table "typemap_entry"
CREATE TABLE
GRANT
psql:install.sql:55: ERROR: language "java" does not exist
psql:install.sql:59: ERROR: language "java" does not exist
psql:install.sql:63: ERROR: language "java" does not exist
psql:install.sql:67: ERROR: language "java" does not exist
psql:install.sql:71: ERROR: language "java" does not exist
psql:install.sql:75: ERROR: language "java" does not exist
psql:install.sql:79: ERROR: language "java" does not exist
psql:install.sql:83: ERROR: language "java" does not exist
psql:install.sql:87: ERROR: language "java" does not exist
C:\Program Files (x86)\PostgresPlus\9.0SS\share\pljava>
^ permalink raw reply [nested|flat] 42+ messages in thread
* [Pljava-dev] Windows binaries
2011-01-22 05:50 [Pljava-dev] Windows binaries
2011-01-23 17:37 ` [Pljava-dev] Windows binaries
2011-01-23 17:45 ` [Pljava-dev] Windows binaries
2011-01-23 17:53 ` [Pljava-dev] Windows binaries
2011-01-23 17:58 ` [Pljava-dev] Windows binaries
2011-01-23 18:11 ` [Pljava-dev] Windows binaries
@ 2011-01-23 18:22 `
2011-01-23 18:40 ` [Pljava-dev] Windows binaries
0 siblings, 1 reply; 42+ messages in thread
From: @ 2011-01-23 18:22 UTC (permalink / raw)
On Sun, 23 Jan 2011 18:11:52 -0000, Eric Kolotyluk
<eric.kolotyluk at gmail.com> wrote:
> The pljava.dll file is certainly in the lib directory, so I can't
> understand why it is complaining it cannot find it.
Try putting it in a directory without any spaces and add it to
dynamic_library_path in postgresql.conf. Also make sure your JVM dll is
in the path of your server process. I believe that's how they're located
on Windows. Otherwise you may have to look up how it's located.
If all else fails, I believe the full path to the dll can be set within
the install.sql. Let me know how the other tips work out before I spend
time to confirm or deny it.
--
Johann Oskarsson http://www.2ndquadrant.com/ |[]
PostgreSQL Development, 24x7 Support, Training and Services --+--
|
Blog: http://my.opera.com/myrkraverk/blog/
^ permalink raw reply [nested|flat] 42+ messages in thread
* [Pljava-dev] Windows binaries
2011-01-22 05:50 [Pljava-dev] Windows binaries
2011-01-23 17:37 ` [Pljava-dev] Windows binaries
2011-01-23 17:45 ` [Pljava-dev] Windows binaries
2011-01-23 17:53 ` [Pljava-dev] Windows binaries
2011-01-23 17:58 ` [Pljava-dev] Windows binaries
2011-01-23 18:11 ` [Pljava-dev] Windows binaries
2011-01-23 18:22 ` [Pljava-dev] Windows binaries
@ 2011-01-23 18:40 `
2011-01-23 18:50 ` [Pljava-dev] Windows binaries
2011-01-23 18:51 ` [Pljava-dev] Windows binaries
0 siblings, 2 replies; 42+ messages in thread
From: @ 2011-01-23 18:40 UTC (permalink / raw)
On 2011-01-23 10:22 AM, Johann 'Myrkraverk' Oskarsson wrote:
> On Sun, 23 Jan 2011 18:11:52 -0000, Eric Kolotyluk
> <eric.kolotyluk at gmail.com> wrote:
>
>> The pljava.dll file is certainly in the lib directory, so I can't
>> understand why it is complaining it cannot find it.
>
> Try putting it in a directory without any spaces and add it to
> dynamic_library_path in postgresql.conf. Also make sure your JVM dll
> is in the path of your server process. I believe that's how they're
> located on Windows. Otherwise you may have to look up how it's located.
>
> If all else fails, I believe the full path to the dll can be set
> within the install.sql. Let me know how the other tips work out
> before I spend time to confirm or deny it.
>
Sorry, please bear with me, I am new to PostgreSQL as I am evaluating it
for possible use, so nothing is familiar.
In my postgresql.conf file I have
#dynamic_library_path = '$libdir'
So would I change it to something like
#dynamic_library_path = '$libdir;c:\postgres'
I do not know how to confirm
"Also make sure your JVM dll is in the path of your server process."
Also, per the instructions I added the following to my postgresql.conf
file earlier - is this correct?
# define "pljava" as a custom variable class. This is a comma separated
# list of names.
#
custom_variable_classes = 'pljava'
# define the class path that the JVM will use when loading the
# initial library. Only meaningful for non GCJ installations
#
pljava.classpath = 'C:\Program Files
(x86)\PostgresPlus\9.0SS\PostGIS\java\pljava\postgis_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
^ permalink raw reply [nested|flat] 42+ messages in thread
* [Pljava-dev] Windows binaries
2011-01-22 05:50 [Pljava-dev] Windows binaries
2011-01-23 17:37 ` [Pljava-dev] Windows binaries
2011-01-23 17:45 ` [Pljava-dev] Windows binaries
2011-01-23 17:53 ` [Pljava-dev] Windows binaries
2011-01-23 17:58 ` [Pljava-dev] Windows binaries
2011-01-23 18:11 ` [Pljava-dev] Windows binaries
2011-01-23 18:22 ` [Pljava-dev] Windows binaries
2011-01-23 18:40 ` [Pljava-dev] Windows binaries
@ 2011-01-23 18:50 `
1 sibling, 0 replies; 42+ messages in thread
From: @ 2011-01-23 18:50 UTC (permalink / raw)
On 2011-01-23 10:40 AM, Eric Kolotyluk wrote:
> On 2011-01-23 10:22 AM, Johann 'Myrkraverk' Oskarsson wrote:
>> On Sun, 23 Jan 2011 18:11:52 -0000, Eric Kolotyluk
>> <eric.kolotyluk at gmail.com> wrote:
>>
>>> The pljava.dll file is certainly in the lib directory, so I can't
>>> understand why it is complaining it cannot find it.
>>
>> Try putting it in a directory without any spaces and add it to
>> dynamic_library_path in postgresql.conf. Also make sure your JVM dll
>> is in the path of your server process. I believe that's how they're
>> located on Windows. Otherwise you may have to look up how it's located.
>>
>> If all else fails, I believe the full path to the dll can be set
>> within the install.sql. Let me know how the other tips work out
>> before I spend time to confirm or deny it.
>>
> Sorry, please bear with me, I am new to PostgreSQL as I am evaluating
> it for possible use, so nothing is familiar.
>
> In my postgresql.conf file I have
>
> #dynamic_library_path = '$libdir'
>
> So would I change it to something like
>
> #dynamic_library_path = '$libdir;c:\postgres'
>
> I do not know how to confirm
>
> "Also make sure your JVM dll is in the path of your server process."
>
> Also, per the instructions I added the following to my postgresql.conf
> file earlier - is this correct?
>
> # define "pljava" as a custom variable class. This is a comma separated
> # list of names.
> #
> custom_variable_classes = 'pljava'
>
> # define the class path that the JVM will use when loading the
> # initial library. Only meaningful for non GCJ installations
> #
> pljava.classpath = 'C:\Program Files
> (x86)\PostgresPlus\9.0SS\PostGIS\java\pljava\postgis_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
>
Here is my Windows system path:
C:\Program Files\Common Files\Microsoft Shared\Windows Live;C:\Program
Files (x86)\Common Files\Microsoft Shared\Windows
Live;%SystemRoot%\system32;%SystemRoot%;%SystemRoot%\System32\Wbem;%SYSTEMROOT%\System32\WindowsPowerShell\v1.0\;C:\Program
Files\Intel\DMIX;C;\scala-2.8.0.Beta1\bin;C:\Program Files (x86)\Windows
Live\Shared;C:\Program Files (x86)\ATI
Technologies\ATI.ACE\Core-Static;C:\Program Files
(x86)\QuickTime\QTSystem\;%JAVA_HOME%\jre\bin;%JAVA_HOME%\jre\bin\client;C:\Program
Files (x86)\PostgresPlus\9.0SS\bin
Also, the install.sql did create the schema in spite of the errors, but
I can only assume that it is not complete because of the errors.
Presumably I have to run uninstall.sql before running install.sql again?
Cheers, Eric
^ permalink raw reply [nested|flat] 42+ messages in thread
* [Pljava-dev] Windows binaries
2011-01-22 05:50 [Pljava-dev] Windows binaries
2011-01-23 17:37 ` [Pljava-dev] Windows binaries
2011-01-23 17:45 ` [Pljava-dev] Windows binaries
2011-01-23 17:53 ` [Pljava-dev] Windows binaries
2011-01-23 17:58 ` [Pljava-dev] Windows binaries
2011-01-23 18:11 ` [Pljava-dev] Windows binaries
2011-01-23 18:22 ` [Pljava-dev] Windows binaries
2011-01-23 18:40 ` [Pljava-dev] Windows binaries
@ 2011-01-23 18:51 `
2011-01-23 19:14 ` [Pljava-dev] Windows binaries
1 sibling, 1 reply; 42+ messages in thread
From: @ 2011-01-23 18:51 UTC (permalink / raw)
On Sun, 23 Jan 2011 18:40:06 -0000, Eric Kolotyluk
<eric.kolotyluk at gmail.com> wrote:
> Sorry, please bear with me, I am new to PostgreSQL as I am evaluating it
> for possible use, so nothing is familiar.
>
> In my postgresql.conf file I have
>
> #dynamic_library_path = '$libdir'
>
> So would I change it to something like
>
> #dynamic_library_path = '$libdir;c:\postgres'
Yes, assuming you've moved the pljava.dll to c:\postgres. The you just
have to uncomment it by removing the #.
dynamic_library_path = '$libdir;c:\postgres'
> I do not know how to confirm
After this change it's probably best to restart the server. If you used
pg_ctl to start it you can use the restart command, or stop and then
start. See the reference for pg_ctl for the details.
> "Also make sure your JVM dll is in the path of your server process."
As long as JVM.DLL (or maybe LIBJVM.DLL) is in your path, such as in
either %JAVA_HOME%\jre\bin or %JAVA_HOME%\jre\bin\client you'll be fine.
> Also, per the instructions I added the following to my postgresql.conf
> file earlier - is this correct?
Everything seems fine to me.
> pljava.classpath = 'C:\Program Files
> (x86)\PostgresPlus\9.0SS\PostGIS\java\pljava\postgis_pljava.jar'
Perhaps it's worthwhile to set this to a path without spaces as well.
--
Johann Oskarsson http://www.2ndquadrant.com/ |[]
PostgreSQL Development, 24x7 Support, Training and Services --+--
|
Blog: http://my.opera.com/myrkraverk/blog/
^ permalink raw reply [nested|flat] 42+ messages in thread
* [Pljava-dev] Windows binaries
2011-01-22 05:50 [Pljava-dev] Windows binaries
2011-01-23 17:37 ` [Pljava-dev] Windows binaries
2011-01-23 17:45 ` [Pljava-dev] Windows binaries
2011-01-23 17:53 ` [Pljava-dev] Windows binaries
2011-01-23 17:58 ` [Pljava-dev] Windows binaries
2011-01-23 18:11 ` [Pljava-dev] Windows binaries
2011-01-23 18:22 ` [Pljava-dev] Windows binaries
2011-01-23 18:40 ` [Pljava-dev] Windows binaries
2011-01-23 18:51 ` [Pljava-dev] Windows binaries
@ 2011-01-23 19:14 `
2011-01-23 19:34 ` [Pljava-dev] Windows binaries
0 siblings, 1 reply; 42+ messages in thread
From: @ 2011-01-23 19:14 UTC (permalink / raw)
On 2011-01-23 10:51 AM, Johann 'Myrkraverk' Oskarsson wrote:
> On Sun, 23 Jan 2011 18:40:06 -0000, Eric Kolotyluk
> <eric.kolotyluk at gmail.com> wrote:
>
>> Sorry, please bear with me, I am new to PostgreSQL as I am evaluating
>> it for possible use, so nothing is familiar.
>>
>> In my postgresql.conf file I have
>>
>> #dynamic_library_path = '$libdir'
>>
>> So would I change it to something like
>>
>> #dynamic_library_path = '$libdir;c:\postgres'
>
> Yes, assuming you've moved the pljava.dll to c:\postgres. The you
> just have to uncomment it by removing the #.
>
> dynamic_library_path = '$libdir;c:\postgres'
>
>> I do not know how to confirm
>
> After this change it's probably best to restart the server. If you
> used pg_ctl to start it you can use the restart command, or stop and
> then start. See the reference for pg_ctl for the details.
>
>> "Also make sure your JVM dll is in the path of your server process."
>
> As long as JVM.DLL (or maybe LIBJVM.DLL) is in your path, such as in
> either %JAVA_HOME%\jre\bin or %JAVA_HOME%\jre\bin\client you'll be fine.
>
>> Also, per the instructions I added the following to my
>> postgresql.conf file earlier - is this correct?
>
> Everything seems fine to me.
>
>> pljava.classpath = 'C:\Program Files
>> (x86)\PostgresPlus\9.0SS\PostGIS\java\pljava\postgis_pljava.jar'
>
> Perhaps it's worthwhile to set this to a path without spaces as well.
>
Took me a while to figure out how to stop/start the service. I forgot I
had to run pgAdmin III as Administrator.
I stopped and started the server. Here is what I put in the .config file
dynamic_library_path = '$libdir;c:\postgres'
and here is the error when I run install.sql
C:\Program Files (x86)\PostgresPlus\9.0SS\share\pljava>psql -f install.sql
Password:
CREATE SCHEMA
GRANT
psql:install.sql:6: ERROR: component in parameter
"dynamic_library_path" is not an absolute path
psql:install.sql:8: ERROR: function sqlj.java_call_handler() does not exist
psql:install.sql:12: ERROR: component in parameter
"dynamic_library_path" is not an absolute path
psql:install.sql:14: ERROR: function sqlj.javau_call_handler() does not
exist
psql:install.sql:23: NOTICE: CREATE TABLE will create implicit sequence
"jar_re
pository_jarid_seq" for serial column "jar_repository.jarid"
psql:install.sql:23: NOTICE: CREATE TABLE / PRIMARY KEY will create
implicit in
dex "jar_repository_pkey" for table "jar_repository"
psql:install.sql:23: NOTICE: CREATE TABLE / UNIQUE will create implicit
index "
jar_repository_jarname_key" for table "jar_repository"
CREATE TABLE
GRANT
psql:install.sql:32: NOTICE: CREATE TABLE will create implicit sequence
"jar_en
try_entryid_seq" for serial column "jar_entry.entryid"
psql:install.sql:32: NOTICE: CREATE TABLE / PRIMARY KEY will create
implicit in
dex "jar_entry_pkey" for table "jar_entry"
psql:install.sql:32: NOTICE: CREATE TABLE / UNIQUE will create implicit
index "
jar_entry_jarid_entryname_key" for table "jar_entry"
CREATE TABLE
GRANT
ALTER TABLE
psql:install.sql:43: NOTICE: CREATE TABLE / PRIMARY KEY will create
implicit in
dex "classpath_entry_pkey" for table "classpath_entry"
CREATE TABLE
GRANT
psql:install.sql:50: NOTICE: CREATE TABLE will create implicit sequence
"typema
p_entry_mapid_seq" for serial column "typemap_entry.mapid"
psql:install.sql:50: NOTICE: CREATE TABLE / PRIMARY KEY will create
implicit in
dex "typemap_entry_pkey" for table "typemap_entry"
CREATE TABLE
GRANT
psql:install.sql:55: ERROR: language "java" does not exist
psql:install.sql:59: ERROR: language "java" does not exist
psql:install.sql:63: ERROR: language "java" does not exist
psql:install.sql:67: ERROR: language "java" does not exist
psql:install.sql:71: ERROR: language "java" does not exist
psql:install.sql:75: ERROR: language "java" does not exist
psql:install.sql:79: ERROR: language "java" does not exist
psql:install.sql:83: ERROR: language "java" does not exist
psql:install.sql:87: ERROR: language "java" does not exist
^ permalink raw reply [nested|flat] 42+ messages in thread
* [Pljava-dev] Windows binaries
2011-01-22 05:50 [Pljava-dev] Windows binaries
2011-01-23 17:37 ` [Pljava-dev] Windows binaries
2011-01-23 17:45 ` [Pljava-dev] Windows binaries
2011-01-23 17:53 ` [Pljava-dev] Windows binaries
2011-01-23 17:58 ` [Pljava-dev] Windows binaries
2011-01-23 18:11 ` [Pljava-dev] Windows binaries
2011-01-23 18:22 ` [Pljava-dev] Windows binaries
2011-01-23 18:40 ` [Pljava-dev] Windows binaries
2011-01-23 18:51 ` [Pljava-dev] Windows binaries
2011-01-23 19:14 ` [Pljava-dev] Windows binaries
@ 2011-01-23 19:34 `
2011-01-23 21:59 ` [Pljava-dev] Windows binaries
0 siblings, 1 reply; 42+ messages in thread
From: @ 2011-01-23 19:34 UTC (permalink / raw)
On Sun, 23 Jan 2011 19:14:24 -0000, Eric Kolotyluk
<eric.kolotyluk at gmail.com> wrote:
> I stopped and started the server. Here is what I put in the .config file
>
> dynamic_library_path = '$libdir;c:\postgres'
Perhaps you can try 'C:\postgres;$libdir' instead? Your original setting
looks alright when compared to
http://www.postgresql.org/docs/9.0/interactive/runtime-config-client.html#RUNTIME-CONFIG-CLIENT-OTHE...
> "dynamic_library_path" is not an absolute path
If you keep getting this error it may be a bug in the server/binary you're
using. I don't know.
And if it keeps failing, you can try replacing the two lines that look like
RETURNS language_handler AS 'pljava'
to
RETURNS language_handler AS 'C:\postgres\pljava.dll'
or your relevant full path in install.sql.
--
Johann Oskarsson http://www.2ndquadrant.com/ |[]
PostgreSQL Development, 24x7 Support, Training and Services --+--
|
Blog: http://my.opera.com/myrkraverk/blog/
^ permalink raw reply [nested|flat] 42+ messages in thread
* [Pljava-dev] Windows binaries
2011-01-22 05:50 [Pljava-dev] Windows binaries
2011-01-23 17:37 ` [Pljava-dev] Windows binaries
2011-01-23 17:45 ` [Pljava-dev] Windows binaries
2011-01-23 17:53 ` [Pljava-dev] Windows binaries
2011-01-23 17:58 ` [Pljava-dev] Windows binaries
2011-01-23 18:11 ` [Pljava-dev] Windows binaries
2011-01-23 18:22 ` [Pljava-dev] Windows binaries
2011-01-23 18:40 ` [Pljava-dev] Windows binaries
2011-01-23 18:51 ` [Pljava-dev] Windows binaries
2011-01-23 19:14 ` [Pljava-dev] Windows binaries
2011-01-23 19:34 ` [Pljava-dev] Windows binaries
@ 2011-01-23 21:59 `
2011-01-23 22:17 ` [Pljava-dev] Windows binaries
0 siblings, 1 reply; 42+ messages in thread
From: @ 2011-01-23 21:59 UTC (permalink / raw)
On 2011-01-23 11:34 AM, Johann 'Myrkraverk' Oskarsson wrote:
> On Sun, 23 Jan 2011 19:14:24 -0000, Eric Kolotyluk
> <eric.kolotyluk at gmail.com> wrote:
>
>> I stopped and started the server. Here is what I put in the .config file
>>
>> dynamic_library_path = '$libdir;c:\postgres'
>
> Perhaps you can try 'C:\postgres;$libdir' instead? Your original
> setting looks alright when compared to
>
> http://www.postgresql.org/docs/9.0/interactive/runtime-config-client.html#RUNTIME-CONFIG-CLIENT-OTHE...
>
>
>> "dynamic_library_path" is not an absolute path
>
> If you keep getting this error it may be a bug in the server/binary
> you're using. I don't know.
>
> And if it keeps failing, you can try replacing the two lines that look
> like
>
> RETURNS language_handler AS 'pljava'
>
> to
> RETURNS language_handler AS 'C:\postgres\pljava.dll'
>
> or your relevant full path in install.sql.
>
So, when I use
dynamic_library_path = 'C:\postgres;$libdir
I get the same
psql:install.sql:6: ERROR: component in parameter
"dynamic_library_path" is not an absolute path
When I try using
RETURNS language_handler AS 'C:\\postgres\\pljava.dll'
I get
psql:install.sql:6: WARNING: nonstandard use of \\ in a string literal
LINE 2: RETURNS language_handler AS 'C:\\postgres\\pljava.dll'
^
HINT: Use the escape string syntax for backslashes, e.g., E'\\'.
psql:install.sql:6: ERROR: could not load library
"C:\postgres\pljava.dll": The
specified module could not be found.
Now this is just getting plain silly. A message telling me to use the
escape string syntax for backslashes when I am already doing that. Now
to me this is clearly a bug in someone's code.
Is it common to have this much trouble getting pljava working?
Cheers, Eric
^ permalink raw reply [nested|flat] 42+ messages in thread
* [Pljava-dev] Windows binaries
2011-01-22 05:50 [Pljava-dev] Windows binaries
2011-01-23 17:37 ` [Pljava-dev] Windows binaries
2011-01-23 17:45 ` [Pljava-dev] Windows binaries
2011-01-23 17:53 ` [Pljava-dev] Windows binaries
2011-01-23 17:58 ` [Pljava-dev] Windows binaries
2011-01-23 18:11 ` [Pljava-dev] Windows binaries
2011-01-23 18:22 ` [Pljava-dev] Windows binaries
2011-01-23 18:40 ` [Pljava-dev] Windows binaries
2011-01-23 18:51 ` [Pljava-dev] Windows binaries
2011-01-23 19:14 ` [Pljava-dev] Windows binaries
2011-01-23 19:34 ` [Pljava-dev] Windows binaries
2011-01-23 21:59 ` [Pljava-dev] Windows binaries
@ 2011-01-23 22:17 `
2011-01-23 22:44 ` [Pljava-dev] Windows binaries
0 siblings, 1 reply; 42+ messages in thread
From: @ 2011-01-23 22:17 UTC (permalink / raw)
On Sun, 23 Jan 2011 21:59:25 -0000, Eric Kolotyluk
<eric.kolotyluk at gmail.com> wrote:
> Is it common to have this much trouble getting pljava working?
Not in Linux or Solaris. As evident, I do not have prior experience with
it on Windows. I'm sorry but I've run out of ideas. Perhaps you can get
more help on general PostgreSQL forums since loading a library isn't
PL/Java specific.
--
Johann Oskarsson http://www.2ndquadrant.com/ |[]
PostgreSQL Development, 24x7 Support, Training and Services --+--
|
Blog: http://my.opera.com/myrkraverk/blog/
^ permalink raw reply [nested|flat] 42+ messages in thread
* [Pljava-dev] Windows binaries
2011-01-22 05:50 [Pljava-dev] Windows binaries
2011-01-23 17:37 ` [Pljava-dev] Windows binaries
2011-01-23 17:45 ` [Pljava-dev] Windows binaries
2011-01-23 17:53 ` [Pljava-dev] Windows binaries
2011-01-23 17:58 ` [Pljava-dev] Windows binaries
2011-01-23 18:11 ` [Pljava-dev] Windows binaries
2011-01-23 18:22 ` [Pljava-dev] Windows binaries
2011-01-23 18:40 ` [Pljava-dev] Windows binaries
2011-01-23 18:51 ` [Pljava-dev] Windows binaries
2011-01-23 19:14 ` [Pljava-dev] Windows binaries
2011-01-23 19:34 ` [Pljava-dev] Windows binaries
2011-01-23 21:59 ` [Pljava-dev] Windows binaries
2011-01-23 22:17 ` [Pljava-dev] Windows binaries
@ 2011-01-23 22:44 `
2011-01-23 23:02 ` [Pljava-dev] Windows binaries
0 siblings, 1 reply; 42+ messages in thread
From: @ 2011-01-23 22:44 UTC (permalink / raw)
On 01/23/11 2:17 PM, Johann 'Myrkraverk' Oskarsson wrote:
> On Sun, 23 Jan 2011 21:59:25 -0000, Eric Kolotyluk
> <eric.kolotyluk at gmail.com> wrote:
>
>> Is it common to have this much trouble getting pljava working?
>
> Not in Linux or Solaris. As evident, I do not have prior experience
> with it on Windows. I'm sorry but I've run out of ideas. Perhaps you
> can get more help on general PostgreSQL forums since loading a library
> isn't PL/Java specific.
>
use / for Windows paths, not \
\ is only required in CMD commands and .BAT files and such.
^ permalink raw reply [nested|flat] 42+ messages in thread
* [Pljava-dev] Windows binaries
2011-01-22 05:50 [Pljava-dev] Windows binaries
2011-01-23 17:37 ` [Pljava-dev] Windows binaries
2011-01-23 17:45 ` [Pljava-dev] Windows binaries
2011-01-23 17:53 ` [Pljava-dev] Windows binaries
2011-01-23 17:58 ` [Pljava-dev] Windows binaries
2011-01-23 18:11 ` [Pljava-dev] Windows binaries
2011-01-23 18:22 ` [Pljava-dev] Windows binaries
2011-01-23 18:40 ` [Pljava-dev] Windows binaries
2011-01-23 18:51 ` [Pljava-dev] Windows binaries
2011-01-23 19:14 ` [Pljava-dev] Windows binaries
2011-01-23 19:34 ` [Pljava-dev] Windows binaries
2011-01-23 21:59 ` [Pljava-dev] Windows binaries
2011-01-23 22:17 ` [Pljava-dev] Windows binaries
2011-01-23 22:44 ` [Pljava-dev] Windows binaries
@ 2011-01-23 23:02 `
2011-01-23 23:13 ` [Pljava-dev] Windows binaries
0 siblings, 1 reply; 42+ messages in thread
From: @ 2011-01-23 23:02 UTC (permalink / raw)
On 2011-01-23 2:44 PM, John R Pierce wrote:
> On 01/23/11 2:17 PM, Johann 'Myrkraverk' Oskarsson wrote:
>> On Sun, 23 Jan 2011 21:59:25 -0000, Eric Kolotyluk
>> <eric.kolotyluk at gmail.com> wrote:
>>
>>> Is it common to have this much trouble getting pljava working?
>>
>> Not in Linux or Solaris. As evident, I do not have prior experience
>> with it on Windows. I'm sorry but I've run out of ideas. Perhaps
>> you can get more help on general PostgreSQL forums since loading a
>> library isn't PL/Java specific.
>>
>
>
> use / for Windows paths, not \
>
> \ is only required in CMD commands and .BAT files and such.
OK, I tried both 'C:/postgres/pljava.dll' and '/postgres/pljava.dll' in
the install.sql file and I get the same error message.
C:\Program Files (x86)\PostgresPlus\9.0SS\share\pljava>psql -f install.sql
Password:
CREATE SCHEMA
GRANT
psql:install.sql:6: ERROR: could not load library
"/postgres/pljava.dll": The specified module could not be found.
I also used
dynamic_library_path = 'C:/postgres;$libdir'
in the config file and I still get the same message.
Could it be that pljava.dll is just not a proper DLL file?
Chees, Eric
^ permalink raw reply [nested|flat] 42+ messages in thread
* [Pljava-dev] Windows binaries
2011-01-22 05:50 [Pljava-dev] Windows binaries
2011-01-23 17:37 ` [Pljava-dev] Windows binaries
2011-01-23 17:45 ` [Pljava-dev] Windows binaries
2011-01-23 17:53 ` [Pljava-dev] Windows binaries
2011-01-23 17:58 ` [Pljava-dev] Windows binaries
2011-01-23 18:11 ` [Pljava-dev] Windows binaries
2011-01-23 18:22 ` [Pljava-dev] Windows binaries
2011-01-23 18:40 ` [Pljava-dev] Windows binaries
2011-01-23 18:51 ` [Pljava-dev] Windows binaries
2011-01-23 19:14 ` [Pljava-dev] Windows binaries
2011-01-23 19:34 ` [Pljava-dev] Windows binaries
2011-01-23 21:59 ` [Pljava-dev] Windows binaries
2011-01-23 22:17 ` [Pljava-dev] Windows binaries
2011-01-23 22:44 ` [Pljava-dev] Windows binaries
2011-01-23 23:02 ` [Pljava-dev] Windows binaries
@ 2011-01-23 23:13 `
2011-01-23 23:19 ` [Pljava-dev] Windows binaries
0 siblings, 1 reply; 42+ messages in thread
From: @ 2011-01-23 23:13 UTC (permalink / raw)
On 01/23/11 3:02 PM, Eric Kolotyluk wrote:
>
> OK, I tried both 'C:/postgres/pljava.dll' and '/postgres/pljava.dll'
> in the install.sql file and I get the same error message.
>
> C:\Program Files (x86)\PostgresPlus\9.0SS\share\pljava>psql -f
> install.sql
> Password:
> CREATE SCHEMA
> GRANT
> psql:install.sql:6: ERROR: could not load library
> "/postgres/pljava.dll": The specified module could not be found.
>
> I also used
>
> dynamic_library_path = 'C:/postgres;$libdir'
>
> in the config file and I still get the same message.
>
> Could it be that pljava.dll is just not a proper DLL file?
or perhaps the postgres server user doesn't have 'execute' access to
that specific file ? check its access rights with (windows cmd)
cacl \postgres\pljava.dll
it should look something like...
C:\postgres\pljava.dll BUILTIN\Administrators:F
NT AUTHORITY\SYSTEM:F
BUILTIN\Users:R
and you should verify that Postgres is a member of Users (via Local
Users and Groups, in Windows control panel -> admin tools -> computer
management)
^ permalink raw reply [nested|flat] 42+ messages in thread
* [Pljava-dev] Windows binaries
2011-01-22 05:50 [Pljava-dev] Windows binaries
2011-01-23 17:37 ` [Pljava-dev] Windows binaries
2011-01-23 17:45 ` [Pljava-dev] Windows binaries
2011-01-23 17:53 ` [Pljava-dev] Windows binaries
2011-01-23 17:58 ` [Pljava-dev] Windows binaries
2011-01-23 18:11 ` [Pljava-dev] Windows binaries
2011-01-23 18:22 ` [Pljava-dev] Windows binaries
2011-01-23 18:40 ` [Pljava-dev] Windows binaries
2011-01-23 18:51 ` [Pljava-dev] Windows binaries
2011-01-23 19:14 ` [Pljava-dev] Windows binaries
2011-01-23 19:34 ` [Pljava-dev] Windows binaries
2011-01-23 21:59 ` [Pljava-dev] Windows binaries
2011-01-23 22:17 ` [Pljava-dev] Windows binaries
2011-01-23 22:44 ` [Pljava-dev] Windows binaries
2011-01-23 23:02 ` [Pljava-dev] Windows binaries
2011-01-23 23:13 ` [Pljava-dev] Windows binaries
@ 2011-01-23 23:19 `
2011-01-23 23:19 ` [Pljava-dev] Windows binaries
0 siblings, 1 reply; 42+ messages in thread
From: @ 2011-01-23 23:19 UTC (permalink / raw)
On 2011-01-23 3:13 PM, John R Pierce wrote:
> On 01/23/11 3:02 PM, Eric Kolotyluk wrote:
>>
>> OK, I tried both 'C:/postgres/pljava.dll' and '/postgres/pljava.dll'
>> in the install.sql file and I get the same error message.
>>
>> C:\Program Files (x86)\PostgresPlus\9.0SS\share\pljava>psql -f
>> install.sql
>> Password:
>> CREATE SCHEMA
>> GRANT
>> psql:install.sql:6: ERROR: could not load library
>> "/postgres/pljava.dll": The specified module could not be found.
>>
>> I also used
>>
>> dynamic_library_path = 'C:/postgres;$libdir'
>>
>> in the config file and I still get the same message.
>>
>> Could it be that pljava.dll is just not a proper DLL file?
>
> or perhaps the postgres server user doesn't have 'execute' access to
> that specific file ? check its access rights with (windows cmd)
>
> cacl \postgres\pljava.dll
>
>
> it should look something like...
>
> C:\postgres\pljava.dll BUILTIN\Administrators:F
> NT AUTHORITY\SYSTEM:F
> BUILTIN\Users:R
>
> and you should verify that Postgres is a member of Users (via Local
> Users and Groups, in Windows control panel -> admin tools -> computer
> management)
>
And in what context do I execute the cacl command? Can you please give
an example.
Cheers, Eric
^ permalink raw reply [nested|flat] 42+ messages in thread
* [Pljava-dev] Windows binaries
2011-01-22 05:50 [Pljava-dev] Windows binaries
2011-01-23 17:37 ` [Pljava-dev] Windows binaries
2011-01-23 17:45 ` [Pljava-dev] Windows binaries
2011-01-23 17:53 ` [Pljava-dev] Windows binaries
2011-01-23 17:58 ` [Pljava-dev] Windows binaries
2011-01-23 18:11 ` [Pljava-dev] Windows binaries
2011-01-23 18:22 ` [Pljava-dev] Windows binaries
2011-01-23 18:40 ` [Pljava-dev] Windows binaries
2011-01-23 18:51 ` [Pljava-dev] Windows binaries
2011-01-23 19:14 ` [Pljava-dev] Windows binaries
2011-01-23 19:34 ` [Pljava-dev] Windows binaries
2011-01-23 21:59 ` [Pljava-dev] Windows binaries
2011-01-23 22:17 ` [Pljava-dev] Windows binaries
2011-01-23 22:44 ` [Pljava-dev] Windows binaries
2011-01-23 23:02 ` [Pljava-dev] Windows binaries
2011-01-23 23:13 ` [Pljava-dev] Windows binaries
2011-01-23 23:19 ` [Pljava-dev] Windows binaries
@ 2011-01-23 23:19 `
2011-01-23 23:34 ` [Pljava-dev] Windows binaries
0 siblings, 1 reply; 42+ messages in thread
From: @ 2011-01-23 23:19 UTC (permalink / raw)
On 01/23/11 3:19 PM, Eric Kolotyluk wrote:
>
> And in what context do I execute the cacl command? Can you please give
> an example.
its a command line, executed from a Windows CMD ('DOS prompt') window.
^ permalink raw reply [nested|flat] 42+ messages in thread
* [Pljava-dev] Windows binaries
2011-01-22 05:50 [Pljava-dev] Windows binaries
2011-01-23 17:37 ` [Pljava-dev] Windows binaries
2011-01-23 17:45 ` [Pljava-dev] Windows binaries
2011-01-23 17:53 ` [Pljava-dev] Windows binaries
2011-01-23 17:58 ` [Pljava-dev] Windows binaries
2011-01-23 18:11 ` [Pljava-dev] Windows binaries
2011-01-23 18:22 ` [Pljava-dev] Windows binaries
2011-01-23 18:40 ` [Pljava-dev] Windows binaries
2011-01-23 18:51 ` [Pljava-dev] Windows binaries
2011-01-23 19:14 ` [Pljava-dev] Windows binaries
2011-01-23 19:34 ` [Pljava-dev] Windows binaries
2011-01-23 21:59 ` [Pljava-dev] Windows binaries
2011-01-23 22:17 ` [Pljava-dev] Windows binaries
2011-01-23 22:44 ` [Pljava-dev] Windows binaries
2011-01-23 23:02 ` [Pljava-dev] Windows binaries
2011-01-23 23:13 ` [Pljava-dev] Windows binaries
2011-01-23 23:19 ` [Pljava-dev] Windows binaries
2011-01-23 23:19 ` [Pljava-dev] Windows binaries
@ 2011-01-23 23:34 `
2011-01-24 17:20 ` [Pljava-dev] Windows binaries
0 siblings, 1 reply; 42+ messages in thread
From: @ 2011-01-23 23:34 UTC (permalink / raw)
On 2011-01-23 3:19 PM, John R Pierce wrote:
> On 01/23/11 3:19 PM, Eric Kolotyluk wrote:
>>
>> And in what context do I execute the cacl command? Can you please
>> give an example.
>
> its a command line, executed from a Windows CMD ('DOS prompt') window.
>
>
Ah, I guess you meant cacls?
C:\Program Files (x86)\PostgresPlus\9.0SS\share\pljava>cacls
c:\postgres\pljava.dll
c:\postgres\pljava.dll BUILTIN\Administrators:(ID)F
NT AUTHORITY\SYSTEM:(ID)F
BUILTIN\Users:(ID)R
NT AUTHORITY\Authenticated Users:(ID)C
Yes, postgres is a member of Users.
I even added postgres to the Administrator group, but I still get the
same error message.
Anything else I can try?
Cheers, Eric
^ permalink raw reply [nested|flat] 42+ messages in thread
* [Pljava-dev] Windows binaries
2011-01-22 05:50 [Pljava-dev] Windows binaries
2011-01-23 17:37 ` [Pljava-dev] Windows binaries
2011-01-23 17:45 ` [Pljava-dev] Windows binaries
2011-01-23 17:53 ` [Pljava-dev] Windows binaries
2011-01-23 17:58 ` [Pljava-dev] Windows binaries
2011-01-23 18:11 ` [Pljava-dev] Windows binaries
2011-01-23 18:22 ` [Pljava-dev] Windows binaries
2011-01-23 18:40 ` [Pljava-dev] Windows binaries
2011-01-23 18:51 ` [Pljava-dev] Windows binaries
2011-01-23 19:14 ` [Pljava-dev] Windows binaries
2011-01-23 19:34 ` [Pljava-dev] Windows binaries
2011-01-23 21:59 ` [Pljava-dev] Windows binaries
2011-01-23 22:17 ` [Pljava-dev] Windows binaries
2011-01-23 22:44 ` [Pljava-dev] Windows binaries
2011-01-23 23:02 ` [Pljava-dev] Windows binaries
2011-01-23 23:13 ` [Pljava-dev] Windows binaries
2011-01-23 23:19 ` [Pljava-dev] Windows binaries
2011-01-23 23:19 ` [Pljava-dev] Windows binaries
2011-01-23 23:34 ` [Pljava-dev] Windows binaries
@ 2011-01-24 17:20 `
2011-01-24 17:37 ` [Pljava-dev] Windows binaries
0 siblings, 1 reply; 42+ messages in thread
From: @ 2011-01-24 17:20 UTC (permalink / raw)
On 2011-01-23 3:34 PM, Eric Kolotyluk wrote:
> On 2011-01-23 3:19 PM, John R Pierce wrote:
>> On 01/23/11 3:19 PM, Eric Kolotyluk wrote:
>>>
>>> And in what context do I execute the cacl command? Can you please
>>> give an example.
>>
>> its a command line, executed from a Windows CMD ('DOS prompt') window.
>>
>>
> Ah, I guess you meant cacls?
>
> C:\Program Files (x86)\PostgresPlus\9.0SS\share\pljava>cacls
> c:\postgres\pljava.dll
> c:\postgres\pljava.dll BUILTIN\Administrators:(ID)F
> NT AUTHORITY\SYSTEM:(ID)F
> BUILTIN\Users:(ID)R
> NT AUTHORITY\Authenticated Users:(ID)C
>
> Yes, postgres is a member of Users.
>
> I even added postgres to the Administrator group, but I still get the
> same error message.
>
> Anything else I can try?
>
> Cheers, Eric
I installed Dependency Walker to look at the pljava.dll file. It
complained that it could not find jvm.dll, msvcr71.dll, and msvcr90.dll
- so I put them all in the postgres lib directory where pljava.dll is.
That problem went away.
However, Dependency Walker is still complaining about
Error: At least one module has an unresolved import due to a missing
export function in an implicitly dependent module.
Error: Modules with different CPU types were found.
Warning: At least one module has an unresolved import due to a missing
export function in a delay-load dependent module.
Is this a problem because I am running on a 64-bit version of Windows 7?
When I try to run install.sql I still get
C:\Program Files (x86)\PostgresPlus\9.0SS\share\pljava>psql -f install.sql
Password:
CREATE SCHEMA
GRANT
psql:install.sql:6: ERROR: could not load library "C:/Program Files
(x86)/PostgresPlus/9.0SS/lib/pljava.dll": The specified module could not
be found.
Does anyone else have any ideas?
Cheers, Eric
^ permalink raw reply [nested|flat] 42+ messages in thread
* [Pljava-dev] Windows binaries
2011-01-22 05:50 [Pljava-dev] Windows binaries
2011-01-23 17:37 ` [Pljava-dev] Windows binaries
2011-01-23 17:45 ` [Pljava-dev] Windows binaries
2011-01-23 17:53 ` [Pljava-dev] Windows binaries
2011-01-23 17:58 ` [Pljava-dev] Windows binaries
2011-01-23 18:11 ` [Pljava-dev] Windows binaries
2011-01-23 18:22 ` [Pljava-dev] Windows binaries
2011-01-23 18:40 ` [Pljava-dev] Windows binaries
2011-01-23 18:51 ` [Pljava-dev] Windows binaries
2011-01-23 19:14 ` [Pljava-dev] Windows binaries
2011-01-23 19:34 ` [Pljava-dev] Windows binaries
2011-01-23 21:59 ` [Pljava-dev] Windows binaries
2011-01-23 22:17 ` [Pljava-dev] Windows binaries
2011-01-23 22:44 ` [Pljava-dev] Windows binaries
2011-01-23 23:02 ` [Pljava-dev] Windows binaries
2011-01-23 23:13 ` [Pljava-dev] Windows binaries
2011-01-23 23:19 ` [Pljava-dev] Windows binaries
2011-01-23 23:19 ` [Pljava-dev] Windows binaries
2011-01-23 23:34 ` [Pljava-dev] Windows binaries
2011-01-24 17:20 ` [Pljava-dev] Windows binaries
@ 2011-01-24 17:37 `
2011-01-24 18:13 ` [Pljava-dev] Windows binaries
0 siblings, 1 reply; 42+ messages in thread
From: @ 2011-01-24 17:37 UTC (permalink / raw)
On Mon, 24 Jan 2011 17:20:58 -0000, Eric Kolotyluk
<eric.kolotyluk at gmail.com> wrote:
> I installed Dependency Walker to look at the pljava.dll file. It
> complained that it could not find jvm.dll, msvcr71.dll, and msvcr90.dll
> - so I put them all in the postgres lib directory where pljava.dll is.
> That problem went away.
>
> However, Dependency Walker is still complaining about
>
> Error: At least one module has an unresolved import due to a missing
> export function in an implicitly dependent module.
> Error: Modules with different CPU types were found.
> Warning: At least one module has an unresolved import due to a missing
> export function in a delay-load dependent module.
Can you check that the DLLs you copied are all 64 bits? Also, the JVM (on
Unix) needs more DLLs, here is an output I posted previously to this list,
for Solaris:
/export/home/johann/src/external/pljava-head/build/objs/pljava.so
/opt/myrkraverk/jdk1.5.0_22/jre/lib/amd64/server/libjvm.so
<snip>
/opt/myrkraverk/jdk1.5.0_22/jre/lib/amd64/native_threads/libhpi.so
/opt/myrkraverk/solstudio12.2/lib/dbx/amd64/runtime/libdbx_agent.so
/opt/myrkraverk/jdk1.5.0_22/jre/lib/amd64/libverify.so
/opt/myrkraverk/jdk1.5.0_22/jre/lib/amd64/libjava.so
/opt/myrkraverk/jdk1.5.0_22/jre/lib/amd64/libzip.so
Notes:
You don't need to run PL/Java with Java 5, it works equally well with a
Java 6 VM. The libdbx_agent is only for debugging PL/Java code with dbx,
and is not applicable for Windows.
> Is this a problem because I am running on a 64-bit version of Windows 7?
It shouldn't be, but it seems your walker is finding a 32bit DLL where it
expects a 64bit DLL.
> When I try to run install.sql I still get
> psql:install.sql:6: ERROR: could not load library "C:/Program Files
> (x86)/PostgresPlus/9.0SS/lib/pljava.dll": The specified module could not
> be found.
This is an unfortunate message. In Linux it tells me which (sub) DLL is
missing such as "libjvm.so could not be found."
--
Johann Oskarsson http://www.2ndquadrant.com/ |[]
PostgreSQL Development, 24x7 Support, Training and Services --+--
|
Blog: http://my.opera.com/myrkraverk/blog/
^ permalink raw reply [nested|flat] 42+ messages in thread
* [Pljava-dev] Windows binaries
2011-01-22 05:50 [Pljava-dev] Windows binaries
2011-01-23 17:37 ` [Pljava-dev] Windows binaries
2011-01-23 17:45 ` [Pljava-dev] Windows binaries
2011-01-23 17:53 ` [Pljava-dev] Windows binaries
2011-01-23 17:58 ` [Pljava-dev] Windows binaries
2011-01-23 18:11 ` [Pljava-dev] Windows binaries
2011-01-23 18:22 ` [Pljava-dev] Windows binaries
2011-01-23 18:40 ` [Pljava-dev] Windows binaries
2011-01-23 18:51 ` [Pljava-dev] Windows binaries
2011-01-23 19:14 ` [Pljava-dev] Windows binaries
2011-01-23 19:34 ` [Pljava-dev] Windows binaries
2011-01-23 21:59 ` [Pljava-dev] Windows binaries
2011-01-23 22:17 ` [Pljava-dev] Windows binaries
2011-01-23 22:44 ` [Pljava-dev] Windows binaries
2011-01-23 23:02 ` [Pljava-dev] Windows binaries
2011-01-23 23:13 ` [Pljava-dev] Windows binaries
2011-01-23 23:19 ` [Pljava-dev] Windows binaries
2011-01-23 23:19 ` [Pljava-dev] Windows binaries
2011-01-23 23:34 ` [Pljava-dev] Windows binaries
2011-01-24 17:20 ` [Pljava-dev] Windows binaries
2011-01-24 17:37 ` [Pljava-dev] Windows binaries
@ 2011-01-24 18:13 `
2011-01-24 18:23 ` [Pljava-dev] Windows binaries
0 siblings, 1 reply; 42+ messages in thread
From: @ 2011-01-24 18:13 UTC (permalink / raw)
On 2011-01-24 9:37 AM, Johann 'Myrkraverk' Oskarsson wrote:
> On Mon, 24 Jan 2011 17:20:58 -0000, Eric Kolotyluk
> <eric.kolotyluk at gmail.com> wrote:
>
>> I installed Dependency Walker to look at the pljava.dll file. It
>> complained that it could not find jvm.dll, msvcr71.dll, and
>> msvcr90.dll - so I put them all in the postgres lib directory where
>> pljava.dll is. That problem went away.
>>
>> However, Dependency Walker is still complaining about
>>
>> Error: At least one module has an unresolved import due to a missing
>> export function in an implicitly dependent module.
>> Error: Modules with different CPU types were found.
>> Warning: At least one module has an unresolved import due to a
>> missing export function in a delay-load dependent module.
>
> Can you check that the DLLs you copied are all 64 bits? Also, the JVM
> (on Unix) needs more DLLs, here is an output I posted previously to
> this list, for Solaris:
Dependency Walker reports that jvm.dll, msvcr71.dll, and msvcr90.dll are
all x86 - as is pljava.dll and all the other postgres DLLs. Why would
the DLLs need to be 64-bit?
I am using Java 6.
I have copied hpi.dll, verify.dll, java.dll, and zip.dll to the lib
directory. I could not find dbx_agent.dll
>
> /export/home/johann/src/external/pljava-head/build/objs/pljava.so
> /opt/myrkraverk/jdk1.5.0_22/jre/lib/amd64/server/libjvm.so
>
> <snip>
>
> /opt/myrkraverk/jdk1.5.0_22/jre/lib/amd64/native_threads/libhpi.so
> /opt/myrkraverk/solstudio12.2/lib/dbx/amd64/runtime/libdbx_agent.so
> /opt/myrkraverk/jdk1.5.0_22/jre/lib/amd64/libverify.so
> /opt/myrkraverk/jdk1.5.0_22/jre/lib/amd64/libjava.so
> /opt/myrkraverk/jdk1.5.0_22/jre/lib/amd64/libzip.so
>
> Notes:
>
> You don't need to run PL/Java with Java 5, it works equally well with
> a Java 6 VM. The libdbx_agent is only for debugging PL/Java code with
> dbx, and is not applicable for Windows.
>
>> Is this a problem because I am running on a 64-bit version of Windows 7?
>
> It shouldn't be, but it seems your walker is finding a 32bit DLL where
> it expects a 64bit DLL.
Again, why would it expect 64 bit DLLs when I am running 32-bit postgres
and 32-bit Java?
However, Dependency Walker is listing a lot of other 64-bit DLLs for
some reason.
>
>> When I try to run install.sql I still get
>> psql:install.sql:6: ERROR: could not load library "C:/Program Files
>> (x86)/PostgresPlus/9.0SS/lib/pljava.dll": The specified module could
>> not be found.
>
> This is an unfortunate message. In Linux it tells me which (sub) DLL
> is missing such as "libjvm.so could not be found."
>
jvm.dll is in the same directory as pljava.dll. At first it was not and
Dependency Walker complained it was missing, so I added it and
Dependency Walker stopped complaining.
Cheers, Eric
^ permalink raw reply [nested|flat] 42+ messages in thread
* [Pljava-dev] Windows binaries
2011-01-22 05:50 [Pljava-dev] Windows binaries
2011-01-23 17:37 ` [Pljava-dev] Windows binaries
2011-01-23 17:45 ` [Pljava-dev] Windows binaries
2011-01-23 17:53 ` [Pljava-dev] Windows binaries
2011-01-23 17:58 ` [Pljava-dev] Windows binaries
2011-01-23 18:11 ` [Pljava-dev] Windows binaries
2011-01-23 18:22 ` [Pljava-dev] Windows binaries
2011-01-23 18:40 ` [Pljava-dev] Windows binaries
2011-01-23 18:51 ` [Pljava-dev] Windows binaries
2011-01-23 19:14 ` [Pljava-dev] Windows binaries
2011-01-23 19:34 ` [Pljava-dev] Windows binaries
2011-01-23 21:59 ` [Pljava-dev] Windows binaries
2011-01-23 22:17 ` [Pljava-dev] Windows binaries
2011-01-23 22:44 ` [Pljava-dev] Windows binaries
2011-01-23 23:02 ` [Pljava-dev] Windows binaries
2011-01-23 23:13 ` [Pljava-dev] Windows binaries
2011-01-23 23:19 ` [Pljava-dev] Windows binaries
2011-01-23 23:19 ` [Pljava-dev] Windows binaries
2011-01-23 23:34 ` [Pljava-dev] Windows binaries
2011-01-24 17:20 ` [Pljava-dev] Windows binaries
2011-01-24 17:37 ` [Pljava-dev] Windows binaries
2011-01-24 18:13 ` [Pljava-dev] Windows binaries
@ 2011-01-24 18:23 `
2011-01-24 18:37 ` [Pljava-dev] Windows binaries
2011-01-24 20:34 ` [Pljava-dev] Windows binaries
0 siblings, 2 replies; 42+ messages in thread
From: @ 2011-01-24 18:23 UTC (permalink / raw)
On Mon, 24 Jan 2011 18:13:10 -0000, Eric Kolotyluk
<eric.kolotyluk at gmail.com> wrote:
> Dependency Walker reports that jvm.dll, msvcr71.dll, and msvcr90.dll are
> all x86 - as is pljava.dll and all the other postgres DLLs. Why would
> the DLLs need to be 64-bit?
Sorry, I thought you were running a 64bit PostgreSQL server.
> I am using Java 6.
Which is fine.
> I have copied hpi.dll, verify.dll, java.dll, and zip.dll to the lib
> directory. I could not find dbx_agent.dll
Which is normal, you don't need dbx_agent.
> Again, why would it expect 64 bit DLLs when I am running 32-bit postgres
> and 32-bit Java?
I have no idea. To reverse my previous statement: it seems to be finding
64bit DLLs where it exects 32bits.
> However, Dependency Walker is listing a lot of other 64-bit DLLs for
> some reason.
...
> jvm.dll is in the same directory as pljava.dll. At first it was not and
> Dependency Walker complained it was missing, so I added it and
> Dependency Walker stopped complaining.
This is beyond my expertiese with Windows, I do not really know how it
finds DLLs (I thought it used PATH) and I'm afraid I can't help you much
further. I would at this point be asking in Windows specific forums
and/or real time chats such as ##windows on the Freenode irc network.
--
Johann Oskarsson http://www.2ndquadrant.com/ |[]
PostgreSQL Development, 24x7 Support, Training and Services --+--
|
Blog: http://my.opera.com/myrkraverk/blog/
^ permalink raw reply [nested|flat] 42+ messages in thread
* [Pljava-dev] Windows binaries
2011-01-22 05:50 [Pljava-dev] Windows binaries
2011-01-23 17:37 ` [Pljava-dev] Windows binaries
2011-01-23 17:45 ` [Pljava-dev] Windows binaries
2011-01-23 17:53 ` [Pljava-dev] Windows binaries
2011-01-23 17:58 ` [Pljava-dev] Windows binaries
2011-01-23 18:11 ` [Pljava-dev] Windows binaries
2011-01-23 18:22 ` [Pljava-dev] Windows binaries
2011-01-23 18:40 ` [Pljava-dev] Windows binaries
2011-01-23 18:51 ` [Pljava-dev] Windows binaries
2011-01-23 19:14 ` [Pljava-dev] Windows binaries
2011-01-23 19:34 ` [Pljava-dev] Windows binaries
2011-01-23 21:59 ` [Pljava-dev] Windows binaries
2011-01-23 22:17 ` [Pljava-dev] Windows binaries
2011-01-23 22:44 ` [Pljava-dev] Windows binaries
2011-01-23 23:02 ` [Pljava-dev] Windows binaries
2011-01-23 23:13 ` [Pljava-dev] Windows binaries
2011-01-23 23:19 ` [Pljava-dev] Windows binaries
2011-01-23 23:19 ` [Pljava-dev] Windows binaries
2011-01-23 23:34 ` [Pljava-dev] Windows binaries
2011-01-24 17:20 ` [Pljava-dev] Windows binaries
2011-01-24 17:37 ` [Pljava-dev] Windows binaries
2011-01-24 18:13 ` [Pljava-dev] Windows binaries
2011-01-24 18:23 ` [Pljava-dev] Windows binaries
@ 2011-01-24 18:37 `
2011-01-24 18:43 ` [Pljava-dev] Windows binaries
1 sibling, 1 reply; 42+ messages in thread
From: @ 2011-01-24 18:37 UTC (permalink / raw)
On 2011-01-24 10:23 AM, Johann 'Myrkraverk' Oskarsson wrote:
> On Mon, 24 Jan 2011 18:13:10 -0000, Eric Kolotyluk
> <eric.kolotyluk at gmail.com> wrote:
>
>> Dependency Walker reports that jvm.dll, msvcr71.dll, and msvcr90.dll
>> are all x86 - as is pljava.dll and all the other postgres DLLs. Why
>> would the DLLs need to be 64-bit?
>
> Sorry, I thought you were running a 64bit PostgreSQL server.
>
>> I am using Java 6.
>
> Which is fine.
>
>> I have copied hpi.dll, verify.dll, java.dll, and zip.dll to the lib
>> directory. I could not find dbx_agent.dll
>
> Which is normal, you don't need dbx_agent.
>
>> Again, why would it expect 64 bit DLLs when I am running 32-bit
>> postgres and 32-bit Java?
>
> I have no idea. To reverse my previous statement: it seems to be
> finding 64bit DLLs where it exects 32bits.
>
>> However, Dependency Walker is listing a lot of other 64-bit DLLs for
>> some reason.
>
> ...
>
>> jvm.dll is in the same directory as pljava.dll. At first it was not
>> and Dependency Walker complained it was missing, so I added it and
>> Dependency Walker stopped complaining.
>
> This is beyond my expertiese with Windows, I do not really know how it
> finds DLLs (I thought it used PATH) and I'm afraid I can't help you
> much further. I would at this point be asking in Windows specific
> forums and/or real time chats such as ##windows on the Freenode irc
> network.
>
What is ##windows? Is that some sort of Twitter thing?
Cheers, Eric
^ permalink raw reply [nested|flat] 42+ messages in thread
* [Pljava-dev] Windows binaries
2011-01-22 05:50 [Pljava-dev] Windows binaries
2011-01-23 17:37 ` [Pljava-dev] Windows binaries
2011-01-23 17:45 ` [Pljava-dev] Windows binaries
2011-01-23 17:53 ` [Pljava-dev] Windows binaries
2011-01-23 17:58 ` [Pljava-dev] Windows binaries
2011-01-23 18:11 ` [Pljava-dev] Windows binaries
2011-01-23 18:22 ` [Pljava-dev] Windows binaries
2011-01-23 18:40 ` [Pljava-dev] Windows binaries
2011-01-23 18:51 ` [Pljava-dev] Windows binaries
2011-01-23 19:14 ` [Pljava-dev] Windows binaries
2011-01-23 19:34 ` [Pljava-dev] Windows binaries
2011-01-23 21:59 ` [Pljava-dev] Windows binaries
2011-01-23 22:17 ` [Pljava-dev] Windows binaries
2011-01-23 22:44 ` [Pljava-dev] Windows binaries
2011-01-23 23:02 ` [Pljava-dev] Windows binaries
2011-01-23 23:13 ` [Pljava-dev] Windows binaries
2011-01-23 23:19 ` [Pljava-dev] Windows binaries
2011-01-23 23:19 ` [Pljava-dev] Windows binaries
2011-01-23 23:34 ` [Pljava-dev] Windows binaries
2011-01-24 17:20 ` [Pljava-dev] Windows binaries
2011-01-24 17:37 ` [Pljava-dev] Windows binaries
2011-01-24 18:13 ` [Pljava-dev] Windows binaries
2011-01-24 18:23 ` [Pljava-dev] Windows binaries
2011-01-24 18:37 ` [Pljava-dev] Windows binaries
@ 2011-01-24 18:43 `
0 siblings, 0 replies; 42+ messages in thread
From: @ 2011-01-24 18:43 UTC (permalink / raw)
On Mon, 24 Jan 2011 18:37:09 -0000, Eric Kolotyluk
<eric.kolotyluk at gmail.com> wrote:
> What is ##windows? Is that some sort of Twitter thing?
I'd say it's more like a public IM chat room. Certain browsers will allow
you to enter with this URI irc://irc.freenode.net/#windows the first
prefixed # goes away in the URI. Opera works, and probably Firefox with
the ChatZilla plugin. There are also special purpose IRC clients out
there.
--
Johann Oskarsson http://www.2ndquadrant.com/ |[]
PostgreSQL Development, 24x7 Support, Training and Services --+--
|
Blog: http://my.opera.com/myrkraverk/blog/
^ permalink raw reply [nested|flat] 42+ messages in thread
* [Pljava-dev] Windows binaries
2011-01-22 05:50 [Pljava-dev] Windows binaries
2011-01-23 17:37 ` [Pljava-dev] Windows binaries
2011-01-23 17:45 ` [Pljava-dev] Windows binaries
2011-01-23 17:53 ` [Pljava-dev] Windows binaries
2011-01-23 17:58 ` [Pljava-dev] Windows binaries
2011-01-23 18:11 ` [Pljava-dev] Windows binaries
2011-01-23 18:22 ` [Pljava-dev] Windows binaries
2011-01-23 18:40 ` [Pljava-dev] Windows binaries
2011-01-23 18:51 ` [Pljava-dev] Windows binaries
2011-01-23 19:14 ` [Pljava-dev] Windows binaries
2011-01-23 19:34 ` [Pljava-dev] Windows binaries
2011-01-23 21:59 ` [Pljava-dev] Windows binaries
2011-01-23 22:17 ` [Pljava-dev] Windows binaries
2011-01-23 22:44 ` [Pljava-dev] Windows binaries
2011-01-23 23:02 ` [Pljava-dev] Windows binaries
2011-01-23 23:13 ` [Pljava-dev] Windows binaries
2011-01-23 23:19 ` [Pljava-dev] Windows binaries
2011-01-23 23:19 ` [Pljava-dev] Windows binaries
2011-01-23 23:34 ` [Pljava-dev] Windows binaries
2011-01-24 17:20 ` [Pljava-dev] Windows binaries
2011-01-24 17:37 ` [Pljava-dev] Windows binaries
2011-01-24 18:13 ` [Pljava-dev] Windows binaries
2011-01-24 18:23 ` [Pljava-dev] Windows binaries
@ 2011-01-24 20:34 `
2011-01-24 20:43 ` [Pljava-dev] Windows binaries
1 sibling, 1 reply; 42+ messages in thread
From: @ 2011-01-24 20:34 UTC (permalink / raw)
when i got this problem i resolve it putting
"C:\...\jdk1.xxx\jre\bin\client" on PATH env. variable.
Eric
On Mon, Jan 24, 2011 at 3:23 PM, Johann 'Myrkraverk' Oskarsson <
johann at 2ndquadrant.com> wrote:
> On Mon, 24 Jan 2011 18:13:10 -0000, Eric Kolotyluk <
> eric.kolotyluk at gmail.com> wrote:
>
> Dependency Walker reports that jvm.dll, msvcr71.dll, and msvcr90.dll are
>> all x86 - as is pljava.dll and all the other postgres DLLs. Why would the
>> DLLs need to be 64-bit?
>>
>
> Sorry, I thought you were running a 64bit PostgreSQL server.
>
>
> I am using Java 6.
>>
>
> Which is fine.
>
>
> I have copied hpi.dll, verify.dll, java.dll, and zip.dll to the lib
>> directory. I could not find dbx_agent.dll
>>
>
> Which is normal, you don't need dbx_agent.
>
>
> Again, why would it expect 64 bit DLLs when I am running 32-bit postgres
>> and 32-bit Java?
>>
>
> I have no idea. To reverse my previous statement: it seems to be finding
> 64bit DLLs where it exects 32bits.
>
>
> However, Dependency Walker is listing a lot of other 64-bit DLLs for some
>> reason.
>>
>
> ...
>
>
> jvm.dll is in the same directory as pljava.dll. At first it was not and
>> Dependency Walker complained it was missing, so I added it and Dependency
>> Walker stopped complaining.
>>
>
> This is beyond my expertiese with Windows, I do not really know how it
> finds DLLs (I thought it used PATH) and I'm afraid I can't help you much
> further. I would at this point be asking in Windows specific forums and/or
> real time chats such as ##windows on the Freenode irc network.
>
>
> --
> Johann Oskarsson http://www.2ndquadrant.com/ |[]
> PostgreSQL Development, 24x7 Support, Training and Services --+--
> |
> Blog: http://my.opera.com/myrkraverk/blog/
> _______________________________________________
> Pljava-dev mailing list
> Pljava-dev at pgfoundry.org
> http://pgfoundry.org/mailman/listinfo/pljava-dev
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.pgfoundry.org/pipermail/pljava-dev/attachments/20110124/cd6733e9/attachment.html;
^ permalink raw reply [nested|flat] 42+ messages in thread
* [Pljava-dev] Windows binaries
2011-01-22 05:50 [Pljava-dev] Windows binaries
2011-01-23 17:37 ` [Pljava-dev] Windows binaries
2011-01-23 17:45 ` [Pljava-dev] Windows binaries
2011-01-23 17:53 ` [Pljava-dev] Windows binaries
2011-01-23 17:58 ` [Pljava-dev] Windows binaries
2011-01-23 18:11 ` [Pljava-dev] Windows binaries
2011-01-23 18:22 ` [Pljava-dev] Windows binaries
2011-01-23 18:40 ` [Pljava-dev] Windows binaries
2011-01-23 18:51 ` [Pljava-dev] Windows binaries
2011-01-23 19:14 ` [Pljava-dev] Windows binaries
2011-01-23 19:34 ` [Pljava-dev] Windows binaries
2011-01-23 21:59 ` [Pljava-dev] Windows binaries
2011-01-23 22:17 ` [Pljava-dev] Windows binaries
2011-01-23 22:44 ` [Pljava-dev] Windows binaries
2011-01-23 23:02 ` [Pljava-dev] Windows binaries
2011-01-23 23:13 ` [Pljava-dev] Windows binaries
2011-01-23 23:19 ` [Pljava-dev] Windows binaries
2011-01-23 23:19 ` [Pljava-dev] Windows binaries
2011-01-23 23:34 ` [Pljava-dev] Windows binaries
2011-01-24 17:20 ` [Pljava-dev] Windows binaries
2011-01-24 17:37 ` [Pljava-dev] Windows binaries
2011-01-24 18:13 ` [Pljava-dev] Windows binaries
2011-01-24 18:23 ` [Pljava-dev] Windows binaries
2011-01-24 20:34 ` [Pljava-dev] Windows binaries
@ 2011-01-24 20:43 `
2011-01-25 00:31 ` [Pljava-dev] Windows binaries
0 siblings, 1 reply; 42+ messages in thread
From: @ 2011-01-24 20:43 UTC (permalink / raw)
My PATH is
C:\Program Files\Common Files\Microsoft Shared\Windows Live;C:\Program
Files (x86)\Common Files\Microsoft Shared\Windows
Live;%SystemRoot%\system32;%SystemRoot%;%SystemRoot%\System32\Wbem;%SYSTEMROOT%\System32\WindowsPowerShell\v1.0\;C:\Program
Files\Intel\DMIX;C;\scala-2.8.0.Beta1\bin;C:\Program Files (x86)\Windows
Live\Shared;C:\Program Files (x86)\ATI
Technologies\ATI.ACE\Core-Static;C:\Program Files
(x86)\QuickTime\QTSystem\;%JAVA_HOME%\jre\bin;%JAVA_HOME%\jre\bin\client;C:\Program
Files (x86)\PostgresPlus\9.0SS\bin
JAVA_HOME is C:\Program Files (x86)\Java\jre6
Cheers, Eric
On 2011-01-24 12:34 PM, Eric Bazzana wrote:
> when i got this problem i resolve it putting
> "C:\...\jdk1.xxx\jre\bin\client" on PATH env. variable.
> Eric
^ permalink raw reply [nested|flat] 42+ messages in thread
* [Pljava-dev] Windows binaries
2011-01-22 05:50 [Pljava-dev] Windows binaries
2011-01-23 17:37 ` [Pljava-dev] Windows binaries
2011-01-23 17:45 ` [Pljava-dev] Windows binaries
2011-01-23 17:53 ` [Pljava-dev] Windows binaries
2011-01-23 17:58 ` [Pljava-dev] Windows binaries
2011-01-23 18:11 ` [Pljava-dev] Windows binaries
2011-01-23 18:22 ` [Pljava-dev] Windows binaries
2011-01-23 18:40 ` [Pljava-dev] Windows binaries
2011-01-23 18:51 ` [Pljava-dev] Windows binaries
2011-01-23 19:14 ` [Pljava-dev] Windows binaries
2011-01-23 19:34 ` [Pljava-dev] Windows binaries
2011-01-23 21:59 ` [Pljava-dev] Windows binaries
2011-01-23 22:17 ` [Pljava-dev] Windows binaries
2011-01-23 22:44 ` [Pljava-dev] Windows binaries
2011-01-23 23:02 ` [Pljava-dev] Windows binaries
2011-01-23 23:13 ` [Pljava-dev] Windows binaries
2011-01-23 23:19 ` [Pljava-dev] Windows binaries
2011-01-23 23:19 ` [Pljava-dev] Windows binaries
2011-01-23 23:34 ` [Pljava-dev] Windows binaries
2011-01-24 17:20 ` [Pljava-dev] Windows binaries
2011-01-24 17:37 ` [Pljava-dev] Windows binaries
2011-01-24 18:13 ` [Pljava-dev] Windows binaries
2011-01-24 18:23 ` [Pljava-dev] Windows binaries
2011-01-24 20:34 ` [Pljava-dev] Windows binaries
2011-01-24 20:43 ` [Pljava-dev] Windows binaries
@ 2011-01-25 00:31 `
2011-01-25 03:03 ` [Pljava-dev] Windows binaries
0 siblings, 1 reply; 42+ messages in thread
From: @ 2011-01-25 00:31 UTC (permalink / raw)
OK, I've made a little more progress. I switched from 64-bit Windows 7 to
32-bit Windows 7. I suspect something is hosed with 64-bit - probably
pljava.dll was not built on a 64-bit system???
I am able to run: psql -f install.sql
I was also able to do
SELECT sqlj.install_jar('file:///Program
Files/PostgresPlus/9.0SS/PostGIS/java/pljava/postgis_pljava.jar',
'postgis_pljava_jar', false);
CREATE OR REPLACE FUNCTION public.helloworld()
RETURNS "varchar" AS
'org.postgis.pljava.HelloWorld.helloWorld'
LANGUAGE 'java' VOLATILE;
but now when I try to do
SELECT helloWorld();
I get
ERROR: java.lang.ClassNotFoundException: org.postgis.pljava.HelloWorld
********** Error **********
ERROR: java.lang.ClassNotFoundException: org.postgis.pljava.HelloWorld
SQL state: XX000
I can see "org/postgis/pljava/HelloWorld.class" in the table sqlj.jar_entry
so I'm not sure what the problem is.
Does anyone have any ideas?
Cheers, Eric
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.pgfoundry.org/pipermail/pljava-dev/attachments/20110124/862c3534/attachment.html;
^ permalink raw reply [nested|flat] 42+ messages in thread
* [Pljava-dev] Windows binaries
2011-01-22 05:50 [Pljava-dev] Windows binaries
2011-01-23 17:37 ` [Pljava-dev] Windows binaries
2011-01-23 17:45 ` [Pljava-dev] Windows binaries
2011-01-23 17:53 ` [Pljava-dev] Windows binaries
2011-01-23 17:58 ` [Pljava-dev] Windows binaries
2011-01-23 18:11 ` [Pljava-dev] Windows binaries
2011-01-23 18:22 ` [Pljava-dev] Windows binaries
2011-01-23 18:40 ` [Pljava-dev] Windows binaries
2011-01-23 18:51 ` [Pljava-dev] Windows binaries
2011-01-23 19:14 ` [Pljava-dev] Windows binaries
2011-01-23 19:34 ` [Pljava-dev] Windows binaries
2011-01-23 21:59 ` [Pljava-dev] Windows binaries
2011-01-23 22:17 ` [Pljava-dev] Windows binaries
2011-01-23 22:44 ` [Pljava-dev] Windows binaries
2011-01-23 23:02 ` [Pljava-dev] Windows binaries
2011-01-23 23:13 ` [Pljava-dev] Windows binaries
2011-01-23 23:19 ` [Pljava-dev] Windows binaries
2011-01-23 23:19 ` [Pljava-dev] Windows binaries
2011-01-23 23:34 ` [Pljava-dev] Windows binaries
2011-01-24 17:20 ` [Pljava-dev] Windows binaries
2011-01-24 17:37 ` [Pljava-dev] Windows binaries
2011-01-24 18:13 ` [Pljava-dev] Windows binaries
2011-01-24 18:23 ` [Pljava-dev] Windows binaries
2011-01-24 20:34 ` [Pljava-dev] Windows binaries
2011-01-24 20:43 ` [Pljava-dev] Windows binaries
2011-01-25 00:31 ` [Pljava-dev] Windows binaries
@ 2011-01-25 03:03 `
2011-01-25 15:26 ` [Pljava-dev] Windows binaries
0 siblings, 1 reply; 42+ messages in thread
From: @ 2011-01-25 03:03 UTC (permalink / raw)
On Tue, 25 Jan 2011 00:31:44 -0000, Eric Kolotyluk
<eric.kolotyluk at gmail.com> wrote:
>
> but now when I try to do
>
> SELECT helloWorld();
>
> I get
>
> ERROR: java.lang.ClassNotFoundException: org.postgis.pljava.HelloWorld
Seems you forgot (or did not know to) to set the classpath.
SELECT sqlj.set_classpath( <schema>, <jar name> );
In your case, I believe it is
SELECT sqlj.set_classpath( 'public', 'postgis_pljava_jar' );
You can see the proper schema to use with
SHOW search_path;
which, if you haven't set it to anything, will be the public one as in my
example.
--
Johann Oskarsson http://www.2ndquadrant.com/ |[]
PostgreSQL Development, 24x7 Support, Training and Services --+--
|
Blog: http://my.opera.com/myrkraverk/blog/
^ permalink raw reply [nested|flat] 42+ messages in thread
* [Pljava-dev] Windows binaries
2011-01-22 05:50 [Pljava-dev] Windows binaries
2011-01-23 17:37 ` [Pljava-dev] Windows binaries
2011-01-23 17:45 ` [Pljava-dev] Windows binaries
2011-01-23 17:53 ` [Pljava-dev] Windows binaries
2011-01-23 17:58 ` [Pljava-dev] Windows binaries
2011-01-23 18:11 ` [Pljava-dev] Windows binaries
2011-01-23 18:22 ` [Pljava-dev] Windows binaries
2011-01-23 18:40 ` [Pljava-dev] Windows binaries
2011-01-23 18:51 ` [Pljava-dev] Windows binaries
2011-01-23 19:14 ` [Pljava-dev] Windows binaries
2011-01-23 19:34 ` [Pljava-dev] Windows binaries
2011-01-23 21:59 ` [Pljava-dev] Windows binaries
2011-01-23 22:17 ` [Pljava-dev] Windows binaries
2011-01-23 22:44 ` [Pljava-dev] Windows binaries
2011-01-23 23:02 ` [Pljava-dev] Windows binaries
2011-01-23 23:13 ` [Pljava-dev] Windows binaries
2011-01-23 23:19 ` [Pljava-dev] Windows binaries
2011-01-23 23:19 ` [Pljava-dev] Windows binaries
2011-01-23 23:34 ` [Pljava-dev] Windows binaries
2011-01-24 17:20 ` [Pljava-dev] Windows binaries
2011-01-24 17:37 ` [Pljava-dev] Windows binaries
2011-01-24 18:13 ` [Pljava-dev] Windows binaries
2011-01-24 18:23 ` [Pljava-dev] Windows binaries
2011-01-24 20:34 ` [Pljava-dev] Windows binaries
2011-01-24 20:43 ` [Pljava-dev] Windows binaries
2011-01-25 00:31 ` [Pljava-dev] Windows binaries
2011-01-25 03:03 ` [Pljava-dev] Windows binaries
@ 2011-01-25 15:26 `
2011-01-28 22:02 ` [Pljava-dev] Windows binaries
0 siblings, 1 reply; 42+ messages in thread
From: @ 2011-01-25 15:26 UTC (permalink / raw)
Thanks, that did the trick. I am able to run helloworld()
Phew - nice to finally get something working.
Thanks enormously everyone for helping.
Who can I talk to about the reason pljava does not work on 64-bit Windows? I
have never come across 32-bit software that does not run on 64-bit windows
before. There must be something funny about how they built the DLL.
Cheers, Eric
On Mon, Jan 24, 2011 at 7:03 PM, Johann 'Myrkraverk' Oskarsson <
johann at 2ndquadrant.com> wrote:
>
> On Tue, 25 Jan 2011 00:31:44 -0000, Eric Kolotyluk
> <eric.kolotyluk at gmail.com> wrote:
>
>
>> but now when I try to do
>>
>> SELECT helloWorld();
>>
>> I get
>>
>> ERROR: java.lang.ClassNotFoundException: org.postgis.pljava.HelloWorld
>>
>
> Seems you forgot (or did not know to) to set the classpath.
>
> SELECT sqlj.set_classpath( <schema>, <jar name> );
>
> In your case, I believe it is
>
> SELECT sqlj.set_classpath( 'public', 'postgis_pljava_jar' );
>
> You can see the proper schema to use with
>
> SHOW search_path;
>
> which, if you haven't set it to anything, will be the public one as in my
> example.
>
>
> --
> Johann Oskarsson http://www.2ndquadrant.com/ |[]
> PostgreSQL Development, 24x7 Support, Training and Services --+--
> |
> Blog: http://my.opera.com/myrkraverk/blog/
> _______________________________________________
> Pljava-dev mailing list
> Pljava-dev at pgfoundry.org
> http://pgfoundry.org/mailman/listinfo/pljava-dev
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.pgfoundry.org/pipermail/pljava-dev/attachments/20110125/2defcdac/attachment.html;
^ permalink raw reply [nested|flat] 42+ messages in thread
* [Pljava-dev] Windows binaries
2011-01-22 05:50 [Pljava-dev] Windows binaries
2011-01-23 17:37 ` [Pljava-dev] Windows binaries
2011-01-23 17:45 ` [Pljava-dev] Windows binaries
2011-01-23 17:53 ` [Pljava-dev] Windows binaries
2011-01-23 17:58 ` [Pljava-dev] Windows binaries
2011-01-23 18:11 ` [Pljava-dev] Windows binaries
2011-01-23 18:22 ` [Pljava-dev] Windows binaries
2011-01-23 18:40 ` [Pljava-dev] Windows binaries
2011-01-23 18:51 ` [Pljava-dev] Windows binaries
2011-01-23 19:14 ` [Pljava-dev] Windows binaries
2011-01-23 19:34 ` [Pljava-dev] Windows binaries
2011-01-23 21:59 ` [Pljava-dev] Windows binaries
2011-01-23 22:17 ` [Pljava-dev] Windows binaries
2011-01-23 22:44 ` [Pljava-dev] Windows binaries
2011-01-23 23:02 ` [Pljava-dev] Windows binaries
2011-01-23 23:13 ` [Pljava-dev] Windows binaries
2011-01-23 23:19 ` [Pljava-dev] Windows binaries
2011-01-23 23:19 ` [Pljava-dev] Windows binaries
2011-01-23 23:34 ` [Pljava-dev] Windows binaries
2011-01-24 17:20 ` [Pljava-dev] Windows binaries
2011-01-24 17:37 ` [Pljava-dev] Windows binaries
2011-01-24 18:13 ` [Pljava-dev] Windows binaries
2011-01-24 18:23 ` [Pljava-dev] Windows binaries
2011-01-24 20:34 ` [Pljava-dev] Windows binaries
2011-01-24 20:43 ` [Pljava-dev] Windows binaries
2011-01-25 00:31 ` [Pljava-dev] Windows binaries
2011-01-25 03:03 ` [Pljava-dev] Windows binaries
2011-01-25 15:26 ` [Pljava-dev] Windows binaries
@ 2011-01-28 22:02 `
0 siblings, 0 replies; 42+ messages in thread
From: @ 2011-01-28 22:02 UTC (permalink / raw)
Hi Eric,When you said pljava does not work on 64-bit Windows, you are using postgres 64 bits or postgres 32 bits on 64-bit Windows?Regards,Jose
Date: Tue, 25 Jan 2011 07:26:16 -0800
From: eric.kolotyluk at gmail.com
To: johann at 2ndquadrant.com
CC: pljava-dev at pgfoundry.org
Subject: Re: [Pljava-dev] Windows binaries
Thanks, that did the trick. I am able to run helloworld()
Phew - nice to finally get something working.
Thanks enormously everyone for helping.
Who can I talk to about the reason pljava does not work on 64-bit Windows? I have never come across 32-bit software that does not run on 64-bit windows before. There must be something funny about how they built the DLL.
Cheers, Eric
On Mon, Jan 24, 2011 at 7:03 PM, Johann 'Myrkraverk' Oskarsson <johann at 2ndquadrant.com> wrote:
On Tue, 25 Jan 2011 00:31:44 -0000, Eric Kolotyluk
<eric.kolotyluk at gmail.com> wrote:
but now when I try to do
SELECT helloWorld();
I get
ERROR: java.lang.ClassNotFoundException: org.postgis.pljava.HelloWorld
Seems you forgot (or did not know to) to set the classpath.
SELECT sqlj.set_classpath( <schema>, <jar name> );
In your case, I believe it is
SELECT sqlj.set_classpath( 'public', 'postgis_pljava_jar' );
You can see the proper schema to use with
SHOW search_path;
which, if you haven't set it to anything, will be the public one as in my
example.
--
Johann Oskarsson http://www.2ndquadrant.com/ |[]
PostgreSQL Development, 24x7 Support, Training and Services --+--
|
Blog: http://my.opera.com/myrkraverk/blog/
_______________________________________________
Pljava-dev mailing list
Pljava-dev at pgfoundry.org
http://pgfoundry.org/mailman/listinfo/pljava-dev
_______________________________________________
Pljava-dev mailing list
Pljava-dev at pgfoundry.org
http://pgfoundry.org/mailman/listinfo/pljava-dev
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.pgfoundry.org/pipermail/pljava-dev/attachments/20110128/faac524b/attachment.html;
^ permalink raw reply [nested|flat] 42+ messages in thread
* [Pljava-dev] Fwd: Re: Windows binaries
@ 2011-01-29 00:51
2011-01-29 01:38 ` [Pljava-dev] Windows binaries
2011-01-29 02:02 ` [Pljava-dev] Fwd: Re: Windows binaries
0 siblings, 2 replies; 42+ messages in thread
From: @ 2011-01-29 00:51 UTC (permalink / raw)
In this particular case I was using 32-bit PostgreSQL on 64-bit Windows
Ultimate - I could not get pljava.dll to load. According to Dependency
Walker the DLL is trying to resolve all kinds of 64-bit DLLs which are
not compatible with the 32-bit pljava.
When I ran the same download of 32-bit PostgreSQL on 32-bit Windows
Professional - the pljava.dll loaded fine presumably because there are
no 64-bit DLLs to resolve to.
Enterprise DB do not seem to have a binary release of 64-bit Postgres
Plus for me to try.
At the moment this is a bit of a showstopper for us as we need to be
able to deploy on both 32-bit and 64-bit Windows.
Off hand neither me nor my colleagues have heard of a situation where a
32-bit DLL does not run on 64-bit windows, so we cannot imagine what is
wrong with pljava.dll.
Cheers, Eric
On 2011-01-28 2:02 PM, JOSE CARLOS MARTINEZ LLARIO wrote:
> Hi Eric,
> When you said pljava does not work on 64-bit Windows, you are using
> postgres 64 bits or postgres 32 bits on 64-bit Windows?
> Regards,
> Jose
>
> ------------------------------------------------------------------------
> Date: Tue, 25 Jan 2011 07:26:16 -0800
> From: eric.kolotyluk at gmail.com
> To: johann at 2ndquadrant.com
> CC: pljava-dev at pgfoundry.org
> Subject: Re: [Pljava-dev] Windows binaries
>
> Thanks, that did the trick. I am able to run helloworld()
>
> Phew - nice to finally get something working.
>
> Thanks enormously everyone for helping.
>
> Who can I talk to about the reason pljava does not work on 64-bit
> Windows? I have never come across 32-bit software that does not run on
> 64-bit windows before. There must be something funny about how they
> built the DLL.
>
> Cheers, Eric
>
> On Mon, Jan 24, 2011 at 7:03 PM, Johann 'Myrkraverk' Oskarsson
> <johann at 2ndquadrant.com <mailto:johann at 2ndquadrant.com>> wrote:
>
>
> On Tue, 25 Jan 2011 00:31:44 -0000, Eric Kolotyluk
> <eric.kolotyluk at gmail.com <mailto:eric.kolotyluk at gmail.com>> wrote:
>
>
> but now when I try to do
>
> SELECT helloWorld();
>
> I get
>
> ERROR: java.lang.ClassNotFoundException:
> org.postgis.pljava.HelloWorld
>
>
> Seems you forgot (or did not know to) to set the classpath.
>
> SELECT sqlj.set_classpath( <schema>, <jar name> );
>
> In your case, I believe it is
>
> SELECT sqlj.set_classpath( 'public', 'postgis_pljava_jar' );
>
> You can see the proper schema to use with
>
> SHOW search_path;
>
> which, if you haven't set it to anything, will be the public one
> as in my
> example.
>
>
> --
> Johann Oskarsson http://www.2ndquadrant.com/ |[]
> PostgreSQL Development, 24x7 Support, Training and Services --+--
> |
> Blog: http://my.opera.com/myrkraverk/blog/
> _______________________________________________
> Pljava-dev mailing list
> Pljava-dev at pgfoundry.org <mailto:Pljava-dev at pgfoundry.org>
> http://pgfoundry.org/mailman/listinfo/pljava-dev
>
>
>
> _______________________________________________ Pljava-dev mailing
> list Pljava-dev at pgfoundry.org
> http://pgfoundry.org/mailman/listinfo/pljava-dev
>
>
> _______________________________________________
> Pljava-dev mailing list
> Pljava-dev at pgfoundry.org
> http://pgfoundry.org/mailman/listinfo/pljava-dev
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.pgfoundry.org/pipermail/pljava-dev/attachments/20110128/8bb1c087/attachment.html;
^ permalink raw reply [nested|flat] 42+ messages in thread
* [Pljava-dev] Windows binaries
2011-01-29 00:51 [Pljava-dev] Fwd: Re: Windows binaries
@ 2011-01-29 01:38 `
2011-01-29 23:00 ` [Pljava-dev] Windows binaries
1 sibling, 1 reply; 42+ messages in thread
From: @ 2011-01-29 01:38 UTC (permalink / raw)
On Sat, 29 Jan 2011 00:51:34 -0000, Eric Kolotyluk
<eric.kolotyluk at gmail.com> wrote:
> Enterprise DB do not seem to have a binary release of 64-bit Postgres
> Plus for me to try.
>
> At the moment this is a bit of a showstopper for us as we need to be
> able to deploy on both 32-bit and 64-bit Windows.
That is unfortunate. At the moment I do not envision having the time to
build Windows binaries until after February 11th. There are mainly two
things that stop me. First is the complete lack of the Windows operating
system license and installation media. The second is a computer/cpu with
virtualization support so I can run 64bit Windows in a virtual machine.
> Off hand neither me nor my colleagues have heard of a situation where a
> 32-bit DLL does not run on 64-bit windows, so we cannot imagine what is
> wrong with pljava.dll.
And neither can I. I have heard of incompatible libraries such as Python
2.7 components that refused to work together. As I understood the story
that had nothing to do with 32 vs. 64 bits and had to do with incompatible
compilers or compilation settings.
>> Who can I talk to about the reason pljava does not work on 64-bit
>> Windows? I have never come across 32-bit software that does not run on
>> 64-bit windows before. There must be something funny about how they
>> built the DLL.
In an ideal world that would be I. And I have no idea who to talk to at
Enterprise DB about this.
--
Johann Oskarsson http://www.2ndquadrant.com/ |[]
PostgreSQL Development, 24x7 Support, Training and Services --+--
|
Blog: http://my.opera.com/myrkraverk/blog/
^ permalink raw reply [nested|flat] 42+ messages in thread
* [Pljava-dev] Windows binaries
2011-01-29 00:51 [Pljava-dev] Fwd: Re: Windows binaries
2011-01-29 01:38 ` [Pljava-dev] Windows binaries
@ 2011-01-29 23:00 `
0 siblings, 0 replies; 42+ messages in thread
From: @ 2011-01-29 23:00 UTC (permalink / raw)
On 2011-01-28 5:38 PM, Johann 'Myrkraverk' Oskarsson wrote:
> On Sat, 29 Jan 2011 00:51:34 -0000, Eric Kolotyluk
> <eric.kolotyluk at gmail.com> wrote:
>
>> Enterprise DB do not seem to have a binary release of 64-bit Postgres
>> Plus for me to try.
>>
>> At the moment this is a bit of a showstopper for us as we need to be
>> able to deploy on both 32-bit and 64-bit Windows.
>
> That is unfortunate. At the moment I do not envision having the time
> to build Windows binaries until after February 11th. There are mainly
> two things that stop me. First is the complete lack of the Windows
> operating system license and installation media. The second is a
> computer/cpu with virtualization support so I can run 64bit Windows in
> a virtual machine.
Well, we do not need to deploy until well after Feb 11. But it would be
nice to be able to test on 64-bit windows. I do have a high end
workstation with VMWare Workstation, and Windows 7 installation ISOs
with MSDN licenses. If there is any way I could help please let me know.
I can certainly test any DLLs you want me to.
>
>> Off hand neither me nor my colleagues have heard of a situation where a
>> 32-bit DLL does not run on 64-bit windows, so we cannot imagine what is
>> wrong with pljava.dll.
>
> And neither can I. I have heard of incompatible libraries such as
> Python 2.7 components that refused to work together. As I understood
> the story that had nothing to do with 32 vs. 64 bits and had to do
> with incompatible compilers or compilation settings.
I was wondering about the compiler and linker environment you were using
for Windows. Is it GNU or Microsoft?
>
>>> Who can I talk to about the reason pljava does not work on 64-bit
>>> Windows? I have never come across 32-bit software that does not run on
>>> 64-bit windows before. There must be something funny about how they
>>> built the DLL.
>
> In an ideal world that would be I. And I have no idea who to talk to
> at Enterprise DB about this.
>
I have raised the issue on the Enterprise support forum, but have heard
nothing in a week. For the most part I have been trying to avoid having
to build the binaries myself, but I have been able to test my proof of
concept in the allotted time, so I may have an opportunity to go this
route later.
Cheers, Eric
^ permalink raw reply [nested|flat] 42+ messages in thread
* [Pljava-dev] Fwd: Re: Windows binaries
2011-01-29 00:51 [Pljava-dev] Fwd: Re: Windows binaries
@ 2011-01-29 02:02 `
2011-01-29 23:10 ` [Pljava-dev] Fwd: Re: Windows binaries
1 sibling, 1 reply; 42+ messages in thread
From: @ 2011-01-29 02:02 UTC (permalink / raw)
On Fri, 28 Jan 2011, Eric Kolotyluk wrote:
> In this particular case I was using 32-bit PostgreSQL on 64-bit Windows
> Ultimate - I could not get pljava.dll to load. According to Dependency
> Walker the DLL is trying to resolve all kinds of 64-bit DLLs which are not
> compatible with the 32-bit pljava.
Do you have a 32 or 64 bit java? You would need a 32bit java version to
run in the same process as 32bit postgresql and 32bit plajva.
> Enterprise DB do not seem to have a binary release of 64-bit Postgres Plus
> for me to try.
EnterpriseDB does offer 64 bit versions of 9.0 for windows of the base
postgresql release. I don't know what postgres plus offers above that or
if you need it or not.
http://www.enterprisedb.com/products-services-training/pgdownload#windows
A further complication is that building a 64bit version is only
supported using MSVC at the moment. Just this week Andrew Dunstan has
gotten a 64bit mingw(the build system that pljava supports) build running.
http://archives.postgresql.org/pgsql-hackers/2011-01/msg02692.php
So to really get this all to work to run a 64 bit server, you'd have to
backpatch Andrew's patch to 9.0 and build a mingw server version and then
build pljava against that. You wouldn't necessarily need to deploy your
self-built server version, but you need it to build pljava.
> At the moment this is a bit of a showstopper for us as we need to be able to
> deploy on both 32-bit and 64-bit Windows.
>
I would stick with trying to get the 32bit server version running on 64bit
windows.
Kris Jurka
^ permalink raw reply [nested|flat] 42+ messages in thread
* [Pljava-dev] Fwd: Re: Windows binaries
2011-01-29 00:51 [Pljava-dev] Fwd: Re: Windows binaries
2011-01-29 02:02 ` [Pljava-dev] Fwd: Re: Windows binaries
@ 2011-01-29 23:10 `
2011-01-30 16:03 ` [Pljava-dev] Windows binaries
0 siblings, 1 reply; 42+ messages in thread
From: @ 2011-01-29 23:10 UTC (permalink / raw)
On 2011-01-28 6:02 PM, Kris Jurka wrote:
>
>
> On Fri, 28 Jan 2011, Eric Kolotyluk wrote:
>
>> In this particular case I was using 32-bit PostgreSQL on 64-bit Windows
>> Ultimate - I could not get pljava.dll to load. According to Dependency
>> Walker the DLL is trying to resolve all kinds of 64-bit DLLs which
>> are not
>> compatible with the 32-bit pljava.
>
> Do you have a 32 or 64 bit java? You would need a 32bit java version
> to run in the same process as 32bit postgresql and 32bit plajva.
I only have the 32-bit Java in my PATH.
>
>> Enterprise DB do not seem to have a binary release of 64-bit Postgres
>> Plus
>> for me to try.
>
> EnterpriseDB does offer 64 bit versions of 9.0 for windows of the base
> postgresql release. I don't know what postgres plus offers above that or
> if you need it or not.
I wanted PostgresPlus so I could use the pljava support, and the
standard PostgreSQL binaries don't have that. In reality, we do not need
64-bit PostgreSQL at this time. I only mentioned it in case it might
help in troubleshooting the current pljava issues.
>
> http://www.enterprisedb.com/products-services-training/pgdownload#windows
>
> A further complication is that building a 64bit version is only
> supported using MSVC at the moment. Just this week Andrew Dunstan has
> gotten a 64bit mingw(the build system that pljava supports) build
> running.
>
> http://archives.postgresql.org/pgsql-hackers/2011-01/msg02692.php
>
> So to really get this all to work to run a 64 bit server, you'd have
> to backpatch Andrew's patch to 9.0 and build a mingw server version
> and then build pljava against that. You wouldn't necessarily need to
> deploy your self-built server version, but you need it to build pljava.
>
>> At the moment this is a bit of a showstopper for us as we need to be
>> able to
>> deploy on both 32-bit and 64-bit Windows.
>>
>
> I would stick with trying to get the 32bit server version running on
> 64bit windows.
Exactly! :-)
>
> Kris Jurka
Cheers, Eric
^ permalink raw reply [nested|flat] 42+ messages in thread
* [Pljava-dev] Windows binaries
2011-01-29 00:51 [Pljava-dev] Fwd: Re: Windows binaries
2011-01-29 02:02 ` [Pljava-dev] Fwd: Re: Windows binaries
2011-01-29 23:10 ` [Pljava-dev] Fwd: Re: Windows binaries
@ 2011-01-30 16:03 `
2011-02-01 17:01 ` [Pljava-dev] Windows binaries
0 siblings, 1 reply; 42+ messages in thread
From: @ 2011-01-30 16:03 UTC (permalink / raw)
I'm running 64 bit Postgresql 9.0.1.1 on Windows 7 b(64 bit) with either Java 1.5 or Java 1.6 (1.6 preferred).
I'd be happy to test pljava against that configuration.
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
w: http://www.vocalink.com
-----Original Message-----
From: pljava-dev-bounces at pgfoundry.org [mailto:pljava-dev-bounces at pgfoundry.org] On Behalf Of Eric Kolotyluk
Sent: 29 January 2011 23:11
To: Kris Jurka
Cc: pljava-dev at pgfoundry.org
Subject: Re: [Pljava-dev] Fwd: Re: Windows binaries
On 2011-01-28 6:02 PM, Kris Jurka wrote:
>
>
> On Fri, 28 Jan 2011, Eric Kolotyluk wrote:
>
>> In this particular case I was using 32-bit PostgreSQL on 64-bit Windows
>> Ultimate - I could not get pljava.dll to load. According to Dependency
>> Walker the DLL is trying to resolve all kinds of 64-bit DLLs which
>> are not
>> compatible with the 32-bit pljava.
>
> Do you have a 32 or 64 bit java? You would need a 32bit java version
> to run in the same process as 32bit postgresql and 32bit plajva.
I only have the 32-bit Java in my PATH.
>
>> Enterprise DB do not seem to have a binary release of 64-bit Postgres
>> Plus
>> for me to try.
>
> EnterpriseDB does offer 64 bit versions of 9.0 for windows of the base
> postgresql release. I don't know what postgres plus offers above that or
> if you need it or not.
I wanted PostgresPlus so I could use the pljava support, and the
standard PostgreSQL binaries don't have that. In reality, we do not need
64-bit PostgreSQL at this time. I only mentioned it in case it might
help in troubleshooting the current pljava issues.
>
> http://www.enterprisedb.com/products-services-training/pgdownload#windows
>
> A further complication is that building a 64bit version is only
> supported using MSVC at the moment. Just this week Andrew Dunstan has
> gotten a 64bit mingw(the build system that pljava supports) build
> running.
>
> http://archives.postgresql.org/pgsql-hackers/2011-01/msg02692.php
>
> So to really get this all to work to run a 64 bit server, you'd have
> to backpatch Andrew's patch to 9.0 and build a mingw server version
> and then build pljava against that. You wouldn't necessarily need to
> deploy your self-built server version, but you need it to build pljava.
>
>> At the moment this is a bit of a showstopper for us as we need to be
>> able to
>> deploy on both 32-bit and 64-bit Windows.
>>
>
> I would stick with trying to get the 32bit server version running on
> 64bit windows.
Exactly! :-)
>
> Kris Jurka
Cheers, Eric
_______________________________________________
Pljava-dev mailing list
Pljava-dev at pgfoundry.org
http://pgfoundry.org/mailman/listinfo/pljava-dev
*****************************************************
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 Arundel House, 1 Liverpool Gardens, Worthing, West Sussex, BN11 1SL 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.
This message has been checked for all email viruses by MessageLabs.
*************************************************************
^ permalink raw reply [nested|flat] 42+ messages in thread
* [Pljava-dev] Windows binaries
2011-01-29 00:51 [Pljava-dev] Fwd: Re: Windows binaries
2011-01-29 02:02 ` [Pljava-dev] Fwd: Re: Windows binaries
2011-01-29 23:10 ` [Pljava-dev] Fwd: Re: Windows binaries
2011-01-30 16:03 ` [Pljava-dev] Windows binaries
@ 2011-02-01 17:01 `
2011-02-01 23:42 ` [Pljava-dev] Windows binaries
0 siblings, 1 reply; 42+ messages in thread
From: @ 2011-02-01 17:01 UTC (permalink / raw)
Hi,
As I said in an email before I got the pljava binaries from the postgres plus installation, then I installed the
standard PostgreSQL from:
http://www.enterprisedb.com/products-services-training/pgdownload#windows
Windows 7 64 bits / Postres 9.0.2 32 bits -> WORKED
Windows 7 64 bits / Postres 8.4.7 32 bits -> WORKED
Windows 7 64 bits / Postres 9.0.2 64 bits -> FAILED as expected (showing pljava is not a a valid win32 application, should have said 'not valid win64 application' ?).
I didnt try it on but I guess Windows 7 32 bits is working with pljava too.
Anyone can tell me what pljava version is distributing postgres plus?..I guess it is 1.4.0 but not sure.
I am still kind of surprised that I have to take the pljava dlls from postgres plus and not from the pljava official web site. Maybe the Postgres plus guys should share their knowledge about building pljava in Windows or to give the binaries directly to the pljava project?.
Still I think we need 1.4.2 pljava binaries and the 64 bit version.
Cheers,
Jose
^ permalink raw reply [nested|flat] 42+ messages in thread
* [Pljava-dev] Windows binaries
2011-01-29 00:51 [Pljava-dev] Fwd: Re: Windows binaries
2011-01-29 02:02 ` [Pljava-dev] Fwd: Re: Windows binaries
2011-01-29 23:10 ` [Pljava-dev] Fwd: Re: Windows binaries
2011-01-30 16:03 ` [Pljava-dev] Windows binaries
2011-02-01 17:01 ` [Pljava-dev] Windows binaries
@ 2011-02-01 23:42 `
0 siblings, 0 replies; 42+ messages in thread
From: @ 2011-02-01 23:42 UTC (permalink / raw)
In my case I simply installed the latest version of "Postgres Plus" (not
standard PostgreSQL), and used the pljava that was embedded in it. That
seems to be a slight variation on what you tried.
Cheers, Eric
On Tue, Feb 1, 2011 at 9:01 AM, JOSE CARLOS MARTINEZ LLARIO <
jcllario at hotmail.com> wrote:
>
> Hi,
> As I said in an email before I got the pljava binaries from the postgres
> plus installation, then I installed the
> standard PostgreSQL from:
> http://www.enterprisedb.com/products-services-training/pgdownload#windows
>
>
> Windows 7 64 bits / Postres 9.0.2 32 bits -> WORKED
> Windows 7 64 bits / Postres 8.4.7 32 bits -> WORKED
> Windows 7 64 bits / Postres 9.0.2 64 bits -> FAILED as expected (showing
> pljava is not a a valid win32 application, should have said 'not valid win64
> application' ?).
>
> I didnt try it on but I guess Windows 7 32 bits is working with pljava too.
>
> Anyone can tell me what pljava version is distributing postgres plus?..I
> guess it is 1.4.0 but not sure.
>
> I am still kind of surprised that I have to take the pljava dlls from
> postgres plus and not from the pljava official web site. Maybe the Postgres
> plus guys should share their knowledge about building pljava in Windows or
> to give the binaries directly to the pljava project?.
>
> Still I think we need 1.4.2 pljava binaries and the 64 bit version.
>
> Cheers,
> Jose
>
>
>
> _______________________________________________
> Pljava-dev mailing list
> Pljava-dev at pgfoundry.org
> http://pgfoundry.org/mailman/listinfo/pljava-dev
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.pgfoundry.org/pipermail/pljava-dev/attachments/20110201/5368f577/attachment.html;
^ permalink raw reply [nested|flat] 42+ messages in thread
* [Pljava-dev] Windows Binaries
@ 2011-04-16 00:18
0 siblings, 0 replies; 42+ messages in thread
From: @ 2011-04-16 00:18 UTC (permalink / raw)
Below...
On 2011-04-15 4:52 PM, Johann 'Myrkraverk' Oskarsson wrote:
> On Fri, 15 Apr 2011 23:41:12 -0000, Eric Kolotyluk
> <eric.kolotyluk at gmail.com> wrote:
>
>> Sorry to intrude on your discussion...
>>
>> Is the 64-bit verson of PL/Java for Windows 64-bit or for Postgres
>> 64-bit.
>
> When (if?) I build 64bit binaries, it will be for a 64bit Postgres
> server.
>
>> I tried getting the 32-bit version of PL/Java to run on Windows
>> 64-bit with a 32-bit version of Postgres, but could not get that to
>> work because the loader kept trying to link the 32-bit DLLs against
>> 64-bit Windows libraries.
>
> Windows libraries? Are you sure it was not just a 64 bit JRE in your
> path it was linking against?
Well, I used a tool called PE Explorer to explore the PL/Java DLL, and
it showed that Windows was trying to link against 64 bit system libraries.
I do have both 64-bit and 32-bit Java on my machine, so I will try to
check for that next time.
>
> Can you be explicit about which libraries?
>
>> I need to be able to run PL/Java on both 32-bit Windows and 64-bit
>> Windows.
>
> Yes. Unfortunately, I do not have access to a machine capable of
> running 64bit Windows so I can't test it at the moment.
I have lots of machines running 64-bit windows if that helps :-)
>
>
> A question: Does it matter whether Windows binaries are distributed
> in a tar.gz file or the traditional .zip? I'm only asking because the
> build system makes a .tar.gz file.
>
I have 7-zip, which seems to be able to open most anything.
Cheers, Eric
^ permalink raw reply [nested|flat] 42+ messages in thread
end of thread, other threads:[~2011-04-16 00:18 UTC | newest]
Thread overview: 42+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2011-01-22 05:50 [Pljava-dev] Windows binaries
2011-01-23 17:37 `
2011-01-23 17:45 `
2011-01-23 17:53 `
2011-01-23 17:58 `
2011-01-23 17:58 `
2011-01-23 18:11 `
2011-01-23 18:22 `
2011-01-23 18:40 `
2011-01-23 18:50 `
2011-01-23 18:51 `
2011-01-23 19:14 `
2011-01-23 19:34 `
2011-01-23 21:59 `
2011-01-23 22:17 `
2011-01-23 22:44 `
2011-01-23 23:02 `
2011-01-23 23:13 `
2011-01-23 23:19 `
2011-01-23 23:19 `
2011-01-23 23:34 `
2011-01-24 17:20 `
2011-01-24 17:37 `
2011-01-24 18:13 `
2011-01-24 18:23 `
2011-01-24 18:37 `
2011-01-24 18:43 `
2011-01-24 20:34 `
2011-01-24 20:43 `
2011-01-25 00:31 `
2011-01-25 03:03 `
2011-01-25 15:26 `
2011-01-28 22:02 `
2011-01-29 00:51 [Pljava-dev] Fwd: Re: Windows binaries
2011-01-29 01:38 `
2011-01-29 23:00 `
2011-01-29 02:02 `
2011-01-29 23:10 `
2011-01-30 16:03 `
2011-02-01 17:01 `
2011-02-01 23:42 `
2011-04-16 00:18 [Pljava-dev] Windows Binaries
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox