[Pljava-dev] Errors running pljava test

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