agora inbox for pljava-dev@postgresql.org  
help / color / mirror / Atom feed
Subject: [Pljava-dev] Errors running pljava test
Date: Thu, 08 Sep 2005 09:14:06 +0200
Message-ID: <thhal-0QX37Aw3H8LQOpLWDZ8t2QDgAYAguZF@mailblocks.com> (raw)
In-Reply-To: <431FE0EB.5070601@tokuii.com>
References: <431FBC71.5060803@tokuii.com>
	<431FD8ED.9050502@mailblocks.com>
	<thhal-0cHH7A5PG8LQxk2Nv1nWW2ejTEXji1F@mailblocks.com>
	<431FE0EB.5070601@tokuii.com>
	<431FE4BE.30304@mailblocks.com>
	<thhal-0QH37AwvH8LQwoKdphUc8mxoLtzBLd8@mailblocks.com>

kstian wrote:

> Hi Thomas,
>
> Thanks a lot for clarifying.  The previous problem was indeed due to 
> JDBC driver.  I downloaded jdbc3 and I also needed to add an 
> overloaded sqlj.replace_jar (CREATE FUNCTION sqlj.replace_jar(BYTEA, 
> VARCHAR, BOOLEAN) RETURNS void")) in Deployer.java in order to build 
> the test.

Ouch. I've been using the src/sql/install.sql script lately and forgot 
to add the BYTEA variants to the deployer. I'll fix that.

> There is one other thing I observed while running pljava test:
>
> - Before running pljava test, postgresql \z command listed all tables 
> in my DB: username_test, mdt, employees1, and employees2.
> - After running pljava test, postgresql \z command DID NOT list any of 
> these tables, and I could not access to these tables.

The tables (and functions) are all installed when the examples.jar is 
loaded and removed when you issue a remove_jar call on the examples.jar. 
The creation and removal are handled by the deployment descriptor inside 
that jar (see src/java/examples/deployment/examples.ddr.

> pljava test did hang.  I had been waiting for 10 minutes.  The 
> following is the on-screeen output while running pljava test:

What JVM are you using?

Regards,
Thomas Hallgren






view thread (8+ messages)  latest in thread

Message-ID: <thhal-0QX37Aw3H8LQOpLWDZ8t2QDgAYAguZF@mailblocks.com>
Permalink:  ../thhal-0QX37Aw3H8LQOpLWDZ8t2QDgAYAguZF@mailblocks.com/
Also on:    postgresql.org/message-id/thhal-0QX37Aw3H8LQOpLWDZ8t2QDgAYAguZF@mailblocks.com

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] Errors running pljava test
  In-Reply-To: <thhal-0QX37Aw3H8LQOpLWDZ8t2QDgAYAguZF@mailblocks.com>

* 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