From: thhal at mailblocks.com (Thomas Hallgren)
Date: Thu, 08 Sep 2005 09:14:06 +0200
Subject: [Pljava-dev] Errors running pljava test
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>
Message-ID: <thhal-0QX37Aw3H8LQOpLWDZ8t2QDgAYAguZF@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