Recent changes to bugs

incorrect informativeText output format

2016-05-06T06:30:32.984000Z

There's wrong code in jTPCC.java, which cause the output format of informativeText become incorrect.(I run it in Linux)

jTPCC.java:
for (int count = 0; count < 1+informativeText.length(); count++)

the above should be:
for (int count = 0; count < informativeText.length(); count++)

BTW:
I want to write a script to parse the output of runBenchmark.sh, but there is too many informativeText output if i redirect the stdout to a log file.
Could write the informativeText to stderr instead of stdout. As the following.

        System.err.print(informativeText);
        for (int count = 0; count < informativeText.length(); count++)
            System.err.print("\b");

Print next exception

2014-05-31T09:58:12.671000Z

When an exception is thrown, sometimes is not enough to deal with the exception itself, but it is necessary, in order to understand the reason, to scan the "next exceptions"

At the moment of the catch exception, print the message of not only that given exception, but any other wrapped exception, and for this the nextException() method could be used.

That helps to resolve problem easily.

The issue is present in the Java classes that deal with SQLExceptions.

Code

2013-12-18T15:40:30.726000Z

I would like to know where the code is hosted? The SVN or git server.
I know the code is provide as part of the release, but it is better to get a copy of the most recent versions.

Modify script to change the driver

2013-12-18T15:12:58.765000Z

I just downloaded the application to test a db2 database, but I needed to modify many scripts (runSQL, runLoader, runBenchmark) in order to load the right drivers and execute the benchmark.

However, I found that the scripts and the documentation is oriented to postgres. It is not bad, but it could be more flexible.

I would like to propose to create a symbolic link to the postgres driver. In this way, the scripts reference to the symbolic link, and by default it uses postgres. For other users, like me, we need to replace the symbolic link to point to our own driver, in my case the db2jcc4.jar.

For example, in the run directory execute:

ln -s ../lib/postgresql-9.3-1100.jdbc4.jar jdbc-driver.jar

and then, replace the scripts with lines like this:

runSQL.sh
myCP="./jdbc-driver.jar"

runBenchmark.sh
java -cp .:./jdbc-driver.jar:../lib/log4j-1.2.17.jar:../lib/apache-log4j-extras-1.1.jar:../dist/BenchmarkSQL-4.0.jar -Dprop=$1 jTPCC

For other databases, it is not necessary to modify the script, but just remove the link and recreate. In my case

rm jdbc-driver.jar
ln -s /home/db2inst1/sqllib/java/db2jcc4.jar jdbc-driver.jar

If the symbolic link is not a good option, you could also put a env variable, and use parameter expansion.

For example, in all scripts put a variable like this
JDBC_DRIVER=${JDBC_DRIVER:-../lib/postgresql-9.3-1100.jdbc4.jar}

java -cp .:${JDBC_DRIVER}:../lib/log4j-1.2.17.jar:../lib/apache-log4j-extras-1.1.jar:../dist/BenchmarkSQL-4.0.jar -Dprop=$1 jTPCC

If the variable is not defined, the script will override this with the postgres value. Other users will defined before call the script just by doing this:
export JDBC_DRIVER=/home/db2inst1/sqllib/java/db2jcc4.jar

For more information:
https://www.gnu.org/software/bash/manual/html_node/Shell-Parameter-Expansion.html

Incorrect transaction boundaries

2009-02-27T09:30:20Z

The Stock-Level transaction and the Order-Status transaction are both missing a call to the transCommit()
method.

Need to add a call to transCommit() at lines 696 and 1149 of jTPCCTerminal.java .

Customer loading failures

2006-04-26T14:19:23Z

BenchmarkSQL version: 2.3.2
Database: postgresql 8.1.3, oracle 9.2.0.4
Drivers: postgresql-8.0.309.jdbc3.jar, classes12.jar

I get errors like these (in the ERRORS tab) when
running BenchmarkSQL 2.3.2:

[ERROR] TERMINAL=Term-01 TYPE=ORDER-STATUS COUNT=197
java.lang.Exception: C_LAST=CALLYPRESPRI C_D_ID=9
C_W_ID=4 not found!
at
jTPCCTerminal.orderStatusTransaction(jTPCCTerminal.java:578)
at
jTPCCTerminal.executeTransaction(jTPCCTerminal.java:310)
at
jTPCCTerminal.executeTransactions(jTPCCTerminal.java:165)
at jTPCCTerminal.run(jTPCCTerminal.java:111)
at java.lang.Thread.run(Thread.java:595)

[ERROR] TERMINAL=Term-01 TYPE=ORDER-STATUS COUNT=654
java.lang.Exception: C_LAST=ATIONCALLYEING C_D_ID=4
C_W_ID=4 not found!
at
jTPCCTerminal.orderStatusTransaction(jTPCCTerminal.java:578)
at
jTPCCTerminal.executeTransaction(jTPCCTerminal.java:310)
at
jTPCCTerminal.executeTransactions(jTPCCTerminal.java:165)
at jTPCCTerminal.run(jTPCCTerminal.java:111)
at java.lang.Thread.run(Thread.java:595)

[ERROR] TERMINAL=Term-01 TYPE=ORDER-STATUS COUNT=860
java.lang.Exception: C_LAST=PRIESEPRI C_D_ID=7 C_W_ID=4
not found!
at
jTPCCTerminal.orderStatusTransaction(jTPCCTerminal.java:578)
at
jTPCCTerminal.executeTransaction(jTPCCTerminal.java:310)
at
jTPCCTerminal.executeTransactions(jTPCCTerminal.java:165)
at jTPCCTerminal.run(jTPCCTerminal.java:111)
at java.lang.Thread.run(Thread.java:595)

[ERROR] TERMINAL=Term-01 TYPE=ORDER-STATUS COUNT=1407
java.lang.Exception: C_LAST=ESEESEPRES C_D_ID=1
C_W_ID=4 not found!
at
jTPCCTerminal.orderStatusTransaction(jTPCCTerminal.java:578)
at
jTPCCTerminal.executeTransaction(jTPCCTerminal.java:310)
at
jTPCCTerminal.executeTransactions(jTPCCTerminal.java:165)
at jTPCCTerminal.run(jTPCCTerminal.java:111)
at java.lang.Thread.run(Thread.java:595)