From: pkheswa at yahoo.com (Mncedisi Kheswa) Date: Tue, 18 Oct 2005 04:43:20 -0700 (PDT) Subject: [Pljava-dev] PL/Java help. Message-ID: <20051018114320.18177.qmail@web60211.mail.yahoo.com> 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: