为benchmarksql的PostgreSQL java驱动进行升级
[root@minion1 benchmarksql-4.1.0]# wget https://jdbc.postgresql.org/download/postgresql-9.4.1207.jre7.jar
--2016-01-19 15:38:17-- https://jdbc.postgresql.org/download/postgresql-9.4.1207.jre7.jar
Resolving jdbc.postgresql.org... 174.143.35.228, 2001:4800:1501:1::228
Connecting to jdbc.postgresql.org|174.143.35.228|:443... connected.
HTTP request sent, awaiting response... 200 OK
Length: 608054 (594K) [application/java-archive]
Saving to: ?.ostgresql-9.4.1207.jre7.jar?
100%[===============================================================================>] 608,054 66.8K/s in 8.8s
2016-01-19 15:38:28 (67.3 KB/s) - ?.ostgresql-9.4.1207.jre7.jar?.saved [608054/608054]
[root@minion1 benchmarksql-4.1.0]# ls
build build.xml dist HOW-TO-RUN.txt lib postgresql-9.4.1207.jre7.jar README.txt run src
[root@minion1 benchmarksql-4.1.0]# mv postgresql-9.4.1207.jre7.jar lib/
[root@minion1 benchmarksql-4.1.0]# cd lib/
[root@minion1 lib]# ls
apache-log4j-extras-1.1.jar log4j-1.2.17.jar postgresql-9.3-1101.jdbc41.jar postgresql-9.4.1207.jre7.jar
[root@minion1 lib]# cd /opt/soft_bak/benchmarksql-4.1.0/run/
[root@minion1 run]# ls
clean.sh log4j.xml props.pg runLoader.sh sqlIndexCreates sqlTableCopies sqlTableDrops
log props.ora runBenchmark.sh runSQL.sh sqlIndexDrops sqlTableCreates sqlTableTruncates
修改benchmark脚本里PG驱动程序为新的驱动 程序
[root@minion1 run]# vim runBenchmark.sh
java -cp .:../lib/postgresql-9.4.1207.jre7.jar:../lib/log4j-1.2.17.jar:../lib/apache-log4j-extras-1.1.jar:../dist/BenchmarkSQL-4.1.jar -Dprop=$1 jTPCC
[root@minion1 run]# vim runLoader.sh
java -cp .:../lib/postgresql-9.4.1207.jre7.jar:../dist/BenchmarkSQL-4.1.jar -Dprop=$1 LoadData $2 $3 $4 $5
[root@minion1 run]# vim runSQL.sh
myCP="../lib/postgresql-9.4.1207.jre7.jar"
myCP="$myCP:../dist/BenchmarkSQL-4.1.jar"
myOPTS="-Dprop=$1"
myOPTS="$myOPTS -DcommandFile=$2"
java -cp .:$myCP $myOPTS ExecJDBC