agora inbox for pljava-dev@postgresql.org  

help / color / mirror / Atom feed

Subject: [Pljava-dev] (no subject)
Date: Fri, 24 Jun 2005 13:08:36 -0400
Message-ID: <1119632916.22584.8.camel@localhost> (raw)

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

view thread (8+ messages)  latest in thread

Message-ID: <1119632916.22584.8.camel@localhost>
Permalink:  ../1119632916.22584.8.camel@localhost/
Also on:    postgresql.org/message-id/1119632916.22584.8.camel@localhost

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pljava-dev@postgresql.org
  Subject: Re: [Pljava-dev] (no subject)
  In-Reply-To: <1119632916.22584.8.camel@localhost>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox