PostgreSQL如何使用PLJava支持Java编程

墨墨导读：本文介绍PostgreSQL里如何使用pljava扩展支持java编程。

系统环境

Centos7.6 x86_64

安装java 8

yum install java-1.8.0-openjdkyum install java-1.8.0-openjdk-devel

下载解压maven

wget http://mirrors.cnnic.cn/apache/maven/maven-3/3.6.3/binaries/apache-maven-3.6.3-bin.tar.gz 
tar -zxvf apache-maven-3.6.3-bin.tar.gz
./apache-maven-3.6.3/bin/mvn --versionApache Maven 3.6.3 (cecedd343002696d0abb50b32b541b8a6ba2883f)Maven home: /home/postgres/apache-maven-3.6.3Java version: 1.8.0_181, vendor: Oracle Corporation, runtime: /usr/lib/jvm/java-1.8.0-openjdk-1.8.0.181-7.b13.el7.x86_64/jreDefault locale: en_US, platform encoding: UTF-8OS name: "linux", version: "3.10.0-957.el7.x86_64", arch: "amd64", family: "unix"

使用maven编译pljava-1.5

PL/Java brings functions, triggers, and types in Java. The 1.5 series supports legacy applications, with PostgreSQL support extending from 13 back to 8.2, and Java from 14 back to 8 (7 or 6 with some extra build effort).

wget https://github.com/tada/pljava/archive/V1_5_7.tar.gz
tar zxvf V1_5_7.tar.gz
cd pljava-1_5_7/
/home/postgres/apache-maven-3.6.3/bin/mvn -Dpgsql.pgconfig=/opt/pg125/bin/pg_config clean install

安装pljava-pg.jar文件

java -Dpgconfig=/opt/pg125/bin/pg_config \-jar pljava-packaging/target/pljava-pg12.5-amd64-Linux-gpp.jar

数据库超级用户设置java动态库文件<