[Pljava-dev] FYI: pljava-1.0.0b5 on Mac OS X 10.3.6

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: <http://lists.pgfoundry.org/pipermail/pljava-dev/attachments/20041112/a3af6de9/attachment.bin>