agora inbox for pljava-dev@postgresql.org
help / color / mirror / Atom feedSubject: [Pljava-dev] PL/Java help.
Date: Tue, 18 Oct 2005 04:43:20 -0700 (PDT)
Message-ID: <20051018114320.18177.qmail@web60211.mail.yahoo.com> (raw)
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;
Message-ID: <20051018114320.18177.qmail@web60211.mail.yahoo.com>
Permalink: ../20051018114320.18177.qmail@web60211.mail.yahoo.com/
Also on: postgresql.org/message-id/20051018114320.18177.qmail@web60211.mail.yahoo.com
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pljava-dev@postgresql.org
Subject: Re: [Pljava-dev] PL/Java help.
In-Reply-To: <20051018114320.18177.qmail@web60211.mail.yahoo.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox