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

[p3consulting]

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