From: mfernandez at e-services.cl (mfernand)
Date: Fri, 24 Jun 2005 13:08:36 -0400
Subject: [Pljava-dev] (no subject)
Message-ID: <1119632916.22584.8.camel@localhost>

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