Lists: | pljava-dev |
---|
From: | pkheswa at yahoo(dot)com (Mncedisi Kheswa) |
---|---|
To: | |
Subject: | [Pljava-dev] PL/Java help. |
Date: | 2005-10-18 11:43:20 |
Message-ID: | 20051018114320.18177.qmail@web60211.mail.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pljava-dev |
Hi all,
I'm new to PL/Java, I have installed postgres 8.0.2 from the source, java 1.4 from Sun and postgresql-8.0-312.jdbc3.jar drivers. I have downloaded PL/Java 1.1.0 source. Can anyone help me with what do I do next after I have setup the environment variables in the /etc/profile and set the values in the postgres.conf file as in below for PL/Java to work:
JAVA_HOME=/usr/local/j2sdk1.4.2
POSTGRES_HOME=/usr/local/pgsql
PATH=$JAVA_HOME/bin:$JAVA_HOME/jre/bin:$POSTGRES_HOME/bin:$PATH
CLASSPATH=.:/usr/local/pljava/deploy.jar:/usr/local/pgsql/share/java/postgresql-8.0-312.jdbc3.jar
LD_LIBRARY_PATH=$JAVA_HOME/jre/lib/i386:$JAVA_HOME/jre/lib/i386/client:$JAVA_HOME/jre/lib/i386/server:$JAVA_HOME/jre/lib/i386/native_threads
/usr/local/pgsql/data/postgresql.conf file :
dynamic_library_path = '$libdir:/usr/local/pljava/'
custom_variable_classes = 'pljava'
log_min_messages = info
pljava.classpath = '/usr/local/pljava/pljava.jar'
pljava.statement_cache_size = 10
pljava.release_lingering_savepoints = true
pljava.vmoptions = '-Xmx64M'
pljava.debug = false
I would not mind if it's for command after command as long as PL/Java is going to work.
Thanks in advance.
Mncedisi Kheswa.
---------------------------------
Yahoo! Music Unlimited - Access over 1 million songs. Try it free.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.pgfoundry.org/pipermail/pljava-dev/attachments/20051018/6c576994/attachment.html>