From: kongsen.tian at tokuii.com (kstian) Date: Fri, 09 Sep 2005 17:08:25 +0800 Subject: [Pljava-dev] Errors running pljava test In-Reply-To: <43200729.1090407@tokuii.com> References: <431FBC71.5060803@tokuii.com> <431FD8ED.9050502@mailblocks.com> <431FE0EB.5070601@tokuii.com> <431FE4BE.30304@mailblocks.com> <43200729.1090407@tokuii.com> Message-ID: <43215109.2060004@tokuii.com> Hi Thomas, I have switched to using Sun-jdk-1.4.2.08. The pljava test is still hanging in the middle. Sometimes, it hung at "*** testBinaryColumns()", sometimes, it also hung at "*** DatabaseMetaData 'int' functions:" Is there anything I can try? Thank you again for help. Regards, Kong kstian wrote: > 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 >> >> >> >> > > _______________________________________________ > Pljava-dev mailing list > Pljava-dev at gborg.postgresql.org > http://gborg.postgresql.org/mailman/listinfo/pljava-dev > >