From: | mfernandez at e-services(dot)cl (mfernand) |
---|---|
To: | |
Subject: | [Pljava-dev] (no subject) |
Date: | 2005-06-24 17:08:36 |
Message-ID: | 1119632916.22584.8.camel@localhost |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pljava-dev |
Hi,
When I try execute any function "select sqlj.function(..)" I am
getting the follow error :
select sqlj.get_classpath('sqlj');
server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
The connection to the server was lost. Attempting reset: Failed.
What can I do
I am using postgresql 8.0.3
java 1.4 and
\d sqlj.*
Table "sqlj.classpath_entry"
Column | Type | Modifiers
------------+-----------------------+-----------
schemaname | character varying(30) | not null
ordinal | smallint | not null
jarid | integer | not null
Indexes:
"classpath_entry_pkey" PRIMARY KEY, btree (schemaname, ordinal)
Foreign-key constraints:
"classpath_entry_jarid_fkey" FOREIGN KEY (jarid) REFERENCES
jar_repository(j arid) ON DELETE CASCADE
Index "sqlj.classpath_entry_pkey"
Column | Type
------------+-----------------------
schemaname | character varying(30)
ordinal | smallint
primary key, btree, for table "sqlj.classpath_entry"
Table "sqlj.jar_entry"
Column | Type |
Modifiers
------------+------------------------+------------------------------------------ --------------------
entryid | integer | not null default
nextval('sqlj.jar_entry_ entryid_seq'::text)
entryname | character varying(200) | not null
jarid | integer | not null
entryimage | bytea | not null
Indexes:
"jar_entry_pkey" PRIMARY KEY, btree (entryid)
"jar_entry_jarid_key" UNIQUE, btree (jarid, entryname)
Foreign-key constraints:
"jar_entry_jarid_fkey" FOREIGN KEY (jarid) REFERENCES
jar_repository(jarid) ON DELETE CASCADE
Sequence "sqlj.jar_entry_entryid_seq"
Column | Type
---------------+---------
sequence_name | name
last_value | bigint
increment_by | bigint
max_value | bigint
min_value | bigint
cache_value | bigint
log_cnt | bigint
is_cycled | boolean
is_called | boolean
Index "sqlj.jar_entry_jarid_key"
Column | Type
-----------+------------------------
jarid | integer
entryname | character varying(200)
unique, btree, for table "sqlj.jar_entry"
Index "sqlj.jar_entry_pkey"
Column | Type
---------+---------
entryid | integer
primary key, btree, for table "sqlj.jar_entry"
Table "sqlj.jar_repository"
Column | Type |
Modifiers
----------------+------------------------+-------------------------------------- ---------------------------
jarid | integer | not null default
nextval('sqlj.jar_re pository_jarid_seq'::text)
jarname | character varying(100) | not null
jarorigin | character varying(500) | not null
jarowner | integer | not null
deploymentdesc | integer |
Indexes:
"jar_repository_pkey" PRIMARY KEY, btree (jarid)
"jar_repository_jarname_key" UNIQUE, btree (jarname)
Foreign-key constraints:
"jar_repository_deploymentdesc_fkey" FOREIGN KEY (deploymentdesc)
REFERENCES jar_entry(entryid) ON DELETE SET NULL
Sequence "sqlj.jar_repository_jarid_seq"
Column | Type
---------------+---------
sequence_name | name
last_value | bigint
increment_by | bigint
max_value | bigint
min_value | bigint
cache_value | bigint
log_cnt | bigint
is_cycled | boolean
is_called | boolean
Index "sqlj.jar_repository_jarname_key"
Column | Type
---------+------------------------
jarname | character varying(100)
unique, btree, for table "sqlj.jar_repository"
Index "sqlj.jar_repository_pkey"
Column | Type
--------+---------
jarid | integer
primary key, btree, for table "sqlj.jar_repository"
Thank advance
Mario
From | Date | Subject | |
---|---|---|---|
Next Message | Rose Thaï | 2005-06-27 11:21:01 | [Pljava-dev] PLJAVA - could not load library libpljava ... |
Previous Message | Humberto Carvalho | 2005-06-23 01:42:40 | [Pljava-dev] could not load library "libpljava.dll": dynamic load errorpljava-dev@gborg.postgresql.org |