From: kongsen.tian at tokuii.com (kstian)
Date: Thu, 08 Sep 2005 17:40:57 +0800
Subject: [Pljava-dev] Errors running pljava test
In-Reply-To: <thhal-0QH37AwvH8LQwoKdphUc8mxoLtzBLd8@mailblocks.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: <43200729.1090407@tokuii.com>

I am using Blackdown jvm that comes with my gentoo system.  I will try 
Sun's and see if that makes a difference.

Thanks again for help.

Regards,
Kong

Thomas Hallgren wrote:

> 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
>
>
>
>