[Pljava-dev] Windows binaries

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>