From: eric.kolotyluk at gmail.com (Eric Kolotyluk)
Date: Sun, 23 Jan 2011 10:11:52 -0800
Subject: [Pljava-dev] Windows binaries
In-Reply-To: <op.vprv75equxs6vk@asuka>
References: <C1A6B6FC8196CF43B9B4D0D2C63BFA5A18C4E39967@SPR3V9.office.local>
	<4D3A3076.4070905@gmail.com>
	<op.vporvh2cuxs6vk@asuka>	<COL116-W28471A0A9040F98339CD80D3FB0@phx.gbl>
	<4D3C6777.10708@gmail.com>	<op.vprvlq0cuxs6vk@asuka>
	<4D3C6B11.3010706@gmail.com> <op.vprv75equxs6vk@asuka>
Message-ID: <4D3C6F68.9060304@gmail.com>

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>