From: p3consulting at mac.com (p3consulting) Date: Fri, 12 Nov 2004 10:05:26 +0100 Subject: [Pljava-dev] FYI: pljava-1.0.0b5 on Mac OS X 10.3.6 Message-ID: Now compiles and runs without problem (at least the Test) To compile expand pljava archive alongside you postgresql folder in Terminal.app cd to the enclosing folder of pljava and posgresql ln -s postgresql-x.y.z pgsql cd pljava-xyz # JAVA_HOME has to be defined as /usr export JAVA_HOME=/usr # assuming you are in bash (default under Panther) make sudo make install make test_all # make alone doesn't build test ? # pljava jar's have to be installed in /Library/Java/Extensions # this step should be added to the make install process ? sudo cp ./build/*.jar /Library/Java/Extensions/ # if you have a previous installed version you have to drop sqlj schema first (this is missing in the doc) psql template1 # assuming local user has access to template1 according to pg_hba.conf psql> drop schema sqlj cascade psql> \q # then proceed to normal installation java org.postgresql.pljava.deploy.Deployer -install -database YOURTESTDB psql YOURTESTDB psql> SELECT sqlj.install_jar('file:///LibraryJava/Extensions/examples.jar', 'samples', true); psql> \q java org.postgresql.pljava.test.Tester -database YOURTESTDB 54 + 2 = 56 nullOnEven(1) = 1 nullOnEven(2) = null Name = "nothing", username = "thomas" Name = "null", username = "pascal" Name = "empty string", username = "" Name = "space", username = " " Name = "tab", username = " " Name = "name", username = "name" Doing 800 updates with double triggers that leak statements (but not leak memory). One trigger executes SQL that reenters PL/Java Id = "1", idesc = "first", moddate = "2004-11-11 22:23:44.631717" Id = "2", idesc = "second", moddate = "2004-11-11 22:23:44.634155" Id = "3", idesc = "third", moddate = "2004-11-11 22:23:44.636938" Id = "4", idesc = "first", moddate = "2004-11-11 22:23:45.404" Id = "5", idesc = "second", moddate = "2004-11-11 22:23:45.414" Id = "6", idesc = "third", moddate = "2004-11-11 22:23:45.422" Id = "3", name = "Rebecka Shawn", salary = "30000" Id = "4", name = "Priscilla Johnson", salary = "25000" Base = "1", incbase = "6", ctime = "2004-11-11 22:23:45.04" Base = "1", incbase = "1", ctime = "2004-11-11 22:23:45.056" Base = "1", incbase = "6", ctime = "2004-11-11 22:23:45.058" Base = "1", incbase = "11", ctime = "2004-11-11 22:23:45.058" Base = "1", incbase = "16", ctime = "2004-11-11 22:23:45.058" Base = "1", incbase = "21", ctime = "2004-11-11 22:23:45.058" Base = "1", incbase = "26", ctime = "2004-11-11 22:23:45.058" Base = "1", incbase = "31", ctime = "2004-11-11 22:23:45.058" Base = "1", incbase = "36", ctime = "2004-11-11 22:23:45.058" Base = "1", incbase = "41", ctime = "2004-11-11 22:23:45.058" Base = "1", incbase = "46", ctime = "2004-11-11 22:23:45.058" Base = "1", incbase = "51", ctime = "2004-11-11 22:23:45.058" Base = "1", incbase = "56", ctime = "2004-11-11 22:23:45.06" Max = "10" Further testing in progress. Pascal Pochet p3consulting at mac.com ---------------------------------- PGP KeyID: 0x208C5DBF Fingerprint: 9BFB 245C 5BFE 7F1D 64B7 C473 ABB3 4E83 208C 5DBF -------------- next part -------------- A non-text attachment was scrubbed... Name: smime.p7s Type: application/pkcs7-signature Size: 2369 bytes Desc: not available URL: