[Pljava-dev] PL/Java help.

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
Thread:
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>

Browse pljava-dev by date

  From Date Subject
Next Message Nacho 2005-10-27 06:55:25 [Pljava-dev] PostgreSQL is unable to load the libpljava.so
Previous Message Rakesh Vidyadharan 2005-10-18 03:05:30 [Pljava-dev] Passing custom java object to PL/Java