class org.hsqldb.test.JDBCBench
minor version: 0
major version: 59
flags: flags: (0x0020) ACC_SUPER
this_class: org.hsqldb.test.JDBCBench
super_class: java.lang.Object
{
public static int tps;
descriptor: I
flags: (0x0009) ACC_PUBLIC, ACC_STATIC
public static int nbranches;
descriptor: I
flags: (0x0009) ACC_PUBLIC, ACC_STATIC
public static int ntellers;
descriptor: I
flags: (0x0009) ACC_PUBLIC, ACC_STATIC
public static int naccounts;
descriptor: I
flags: (0x0009) ACC_PUBLIC, ACC_STATIC
public static int nhistory;
descriptor: I
flags: (0x0009) ACC_PUBLIC, ACC_STATIC
public static final int TELLER;
descriptor: I
flags: (0x0019) ACC_PUBLIC, ACC_STATIC, ACC_FINAL
ConstantValue: 0
public static final int BRANCH;
descriptor: I
flags: (0x0019) ACC_PUBLIC, ACC_STATIC, ACC_FINAL
ConstantValue: 1
public static final int ACCOUNT;
descriptor: I
flags: (0x0019) ACC_PUBLIC, ACC_STATIC, ACC_FINAL
ConstantValue: 2
int failed_transactions;
descriptor: I
flags: (0x0000)
int transaction_count;
descriptor: I
flags: (0x0000)
static int n_clients;
descriptor: I
flags: (0x0008) ACC_STATIC
static int n_txn_per_client;
descriptor: I
flags: (0x0008) ACC_STATIC
long start_time;
descriptor: J
flags: (0x0000)
static boolean transactions;
descriptor: Z
flags: (0x0008) ACC_STATIC
static boolean prepared_stmt;
descriptor: Z
flags: (0x0008) ACC_STATIC
static java.lang.String tableExtension;
descriptor: Ljava/lang/String;
flags: (0x0008) ACC_STATIC
static java.lang.String createExtension;
descriptor: Ljava/lang/String;
flags: (0x0008) ACC_STATIC
static java.lang.String ShutdownCommand;
descriptor: Ljava/lang/String;
flags: (0x0008) ACC_STATIC
static java.io.PrintStream TabFile;
descriptor: Ljava/io/PrintStream;
flags: (0x0008) ACC_STATIC
static boolean verbose;
descriptor: Z
flags: (0x0008) ACC_STATIC
org.hsqldb.test.JDBCBench$MemoryWatcherThread MemoryWatcher;
descriptor: Lorg/hsqldb/test/JDBCBench$MemoryWatcherThread;
flags: (0x0000)
static void <clinit>();
descriptor: ()V
flags: (0x0008) ACC_STATIC
Code:
stack=1, locals=0, args_size=0
0: iconst_1
putstatic org.hsqldb.test.JDBCBench.tps:I
1: iconst_1
putstatic org.hsqldb.test.JDBCBench.nbranches:I
2: bipush 10
putstatic org.hsqldb.test.JDBCBench.ntellers:I
3: ldc 100000
putstatic org.hsqldb.test.JDBCBench.naccounts:I
4: ldc 864000
putstatic org.hsqldb.test.JDBCBench.nhistory:I
5: bipush 10
putstatic org.hsqldb.test.JDBCBench.n_clients:I
6: bipush 10
putstatic org.hsqldb.test.JDBCBench.n_txn_per_client:I
7: iconst_1
putstatic org.hsqldb.test.JDBCBench.transactions:Z
8: iconst_0
putstatic org.hsqldb.test.JDBCBench.prepared_stmt:Z
9: ldc ""
putstatic org.hsqldb.test.JDBCBench.tableExtension:Ljava/lang/String;
10: ldc ""
putstatic org.hsqldb.test.JDBCBench.createExtension:Ljava/lang/String;
11: ldc ""
putstatic org.hsqldb.test.JDBCBench.ShutdownCommand:Ljava/lang/String;
12: aconst_null
putstatic org.hsqldb.test.JDBCBench.TabFile:Ljava/io/PrintStream;
13: iconst_0
putstatic org.hsqldb.test.JDBCBench.verbose:Z
return
LocalVariableTable:
Start End Slot Name Signature
public static void main(java.lang.String[]);
descriptor: ([Ljava/lang/String;)V
flags: (0x0009) ACC_PUBLIC, ACC_STATIC
Code:
stack=5, locals=8, args_size=1
start local 0 0: ldc ""
astore 1
start local 1 1: ldc ""
astore 2
start local 2 2: ldc ""
astore 3
start local 3 3: ldc ""
astore 4
start local 4 4: iconst_0
istore 5
start local 5 5: iconst_0
istore 6
start local 6 6: goto 70
7: StackMap locals: java.lang.String[] java.lang.String java.lang.String java.lang.String java.lang.String int int
StackMap stack:
aload 0
iload 6
aaload
ldc "-clients"
invokevirtual java.lang.String.equals:(Ljava/lang/Object;)Z
ifeq 12
8: iload 6
iconst_1
iadd
aload 0
arraylength
if_icmpge 69
9: iinc 6 1
10: aload 0
iload 6
aaload
invokestatic java.lang.Integer.parseInt:(Ljava/lang/String;)I
putstatic org.hsqldb.test.JDBCBench.n_clients:I
11: goto 69
StackMap locals:
StackMap stack:
12: aload 0
iload 6
aaload
ldc "-driver"
invokevirtual java.lang.String.equals:(Ljava/lang/Object;)Z
ifeq 30
13: iload 6
iconst_1
iadd
aload 0
arraylength
if_icmpge 69
14: iinc 6 1
15: aload 0
iload 6
aaload
astore 1
16: aload 1
17: ldc "org.enhydra.instantdb.jdbc.idbDriver"
18: invokevirtual java.lang.String.equals:(Ljava/lang/Object;)Z
19: ifeq 21
20: ldc "SHUTDOWN"
putstatic org.hsqldb.test.JDBCBench.ShutdownCommand:Ljava/lang/String;
21: StackMap locals:
StackMap stack:
aload 1
22: ldc "com.borland.datastore.jdbc.DataStoreDriver"
23: invokevirtual java.lang.String.equals:(Ljava/lang/Object;)Z
pop
24: aload 1
ldc "com.mckoi.JDBCDriver"
invokevirtual java.lang.String.equals:(Ljava/lang/Object;)Z
ifeq 26
25: ldc "SHUTDOWN"
putstatic org.hsqldb.test.JDBCBench.ShutdownCommand:Ljava/lang/String;
26: StackMap locals:
StackMap stack:
aload 1
ldc "org.hsqldb.jdbc.JDBCDriver"
invokevirtual java.lang.String.equals:(Ljava/lang/Object;)Z
ifne 28
27: aload 1
ldc "org.hsqldb.jdbcDriver"
invokevirtual java.lang.String.equals:(Ljava/lang/Object;)Z
ifeq 69
28: StackMap locals:
StackMap stack:
ldc "CREATE CACHED TABLE "
putstatic org.hsqldb.test.JDBCBench.tableExtension:Ljava/lang/String;
29: goto 69
StackMap locals:
StackMap stack:
30: aload 0
iload 6
aaload
ldc "-url"
invokevirtual java.lang.String.equals:(Ljava/lang/Object;)Z
ifeq 35
31: iload 6
iconst_1
iadd
aload 0
arraylength
if_icmpge 69
32: iinc 6 1
33: aload 0
iload 6
aaload
astore 2
34: goto 69
StackMap locals:
StackMap stack:
35: aload 0
iload 6
aaload
ldc "-user"
invokevirtual java.lang.String.equals:(Ljava/lang/Object;)Z
ifeq 40
36: iload 6
iconst_1
iadd
aload 0
arraylength
if_icmpge 69
37: iinc 6 1
38: aload 0
iload 6
aaload
astore 3
39: goto 69
StackMap locals:
StackMap stack:
40: aload 0
iload 6
aaload
ldc "-tabfile"
invokevirtual java.lang.String.equals:(Ljava/lang/Object;)Z
ifeq 49
41: iload 6
iconst_1
iadd
aload 0
arraylength
if_icmpge 69
42: iinc 6 1
43: new java.io.FileOutputStream
dup
aload 0
iload 6
aaload
invokespecial java.io.FileOutputStream.<init>:(Ljava/lang/String;)V
astore 7
start local 7 44: new java.io.PrintStream
dup
aload 7
invokespecial java.io.PrintStream.<init>:(Ljava/io/OutputStream;)V
putstatic org.hsqldb.test.JDBCBench.TabFile:Ljava/io/PrintStream;
end local 7 45: goto 69
StackMap locals:
StackMap stack: java.lang.Exception
46: pop
47: aconst_null
putstatic org.hsqldb.test.JDBCBench.TabFile:Ljava/io/PrintStream;
48: goto 69
StackMap locals:
StackMap stack:
49: aload 0
iload 6
aaload
ldc "-password"
invokevirtual java.lang.String.equals:(Ljava/lang/Object;)Z
ifeq 54
50: iload 6
iconst_1
iadd
aload 0
arraylength
if_icmpge 69
51: iinc 6 1
52: aload 0
iload 6
aaload
astore 4
53: goto 69
StackMap locals:
StackMap stack:
54: aload 0
iload 6
aaload
ldc "-tpc"
invokevirtual java.lang.String.equals:(Ljava/lang/Object;)Z
ifeq 59
55: iload 6
iconst_1
iadd
aload 0
arraylength
if_icmpge 69
56: iinc 6 1
57: aload 0
iload 6
aaload
invokestatic java.lang.Integer.parseInt:(Ljava/lang/String;)I
putstatic org.hsqldb.test.JDBCBench.n_txn_per_client:I
58: goto 69
StackMap locals:
StackMap stack:
59: aload 0
iload 6
aaload
ldc "-init"
invokevirtual java.lang.String.equals:(Ljava/lang/Object;)Z
ifeq 62
60: iconst_1
istore 5
61: goto 69
StackMap locals:
StackMap stack:
62: aload 0
iload 6
aaload
ldc "-tps"
invokevirtual java.lang.String.equals:(Ljava/lang/Object;)Z
ifeq 67
63: iload 6
iconst_1
iadd
aload 0
arraylength
if_icmpge 69
64: iinc 6 1
65: aload 0
iload 6
aaload
invokestatic java.lang.Integer.parseInt:(Ljava/lang/String;)I
putstatic org.hsqldb.test.JDBCBench.tps:I
66: goto 69
StackMap locals:
StackMap stack:
67: aload 0
iload 6
aaload
ldc "-v"
invokevirtual java.lang.String.equals:(Ljava/lang/Object;)Z
ifeq 69
68: iconst_1
putstatic org.hsqldb.test.JDBCBench.verbose:Z
69: StackMap locals:
StackMap stack:
iinc 6 1
StackMap locals:
StackMap stack:
70: iload 6
aload 0
arraylength
if_icmplt 7
end local 6 71: aload 1
invokevirtual java.lang.String.length:()I
ifeq 72
aload 2
invokevirtual java.lang.String.length:()I
ifne 81
72: StackMap locals:
StackMap stack:
getstatic java.lang.System.out:Ljava/io/PrintStream;
73: ldc "usage: java JDBCBench -driver [driver_class_name] -url [url_to_db] -user [username] -password [password] [-v] [-init] [-tpc n] [-clients n]"
74: invokevirtual java.io.PrintStream.println:(Ljava/lang/String;)V
75: getstatic java.lang.System.out:Ljava/io/PrintStream;
invokevirtual java.io.PrintStream.println:()V
76: getstatic java.lang.System.out:Ljava/io/PrintStream;
ldc "-v verbose error messages"
invokevirtual java.io.PrintStream.println:(Ljava/lang/String;)V
77: getstatic java.lang.System.out:Ljava/io/PrintStream;
ldc "-init initialize the tables"
invokevirtual java.io.PrintStream.println:(Ljava/lang/String;)V
78: getstatic java.lang.System.out:Ljava/io/PrintStream;
ldc "-tpc transactions per client"
invokevirtual java.io.PrintStream.println:(Ljava/lang/String;)V
79: getstatic java.lang.System.out:Ljava/io/PrintStream;
ldc "-clients number of simultaneous clients"
invokevirtual java.io.PrintStream.println:(Ljava/lang/String;)V
80: iconst_m1
invokestatic java.lang.System.exit:(I)V
81: StackMap locals:
StackMap stack:
getstatic java.lang.System.out:Ljava/io/PrintStream;
82: ldc "*********************************************************"
83: invokevirtual java.io.PrintStream.println:(Ljava/lang/String;)V
84: getstatic java.lang.System.out:Ljava/io/PrintStream;
85: ldc "* JDBCBench v1.1 *"
86: invokevirtual java.io.PrintStream.println:(Ljava/lang/String;)V
87: getstatic java.lang.System.out:Ljava/io/PrintStream;
88: ldc "*********************************************************"
89: invokevirtual java.io.PrintStream.println:(Ljava/lang/String;)V
90: getstatic java.lang.System.out:Ljava/io/PrintStream;
invokevirtual java.io.PrintStream.println:()V
91: getstatic java.lang.System.out:Ljava/io/PrintStream;
new java.lang.StringBuilder
dup
ldc "Driver: "
invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
aload 1
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
invokevirtual java.io.PrintStream.println:(Ljava/lang/String;)V
92: getstatic java.lang.System.out:Ljava/io/PrintStream;
new java.lang.StringBuilder
dup
ldc "URL:"
invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
aload 2
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
invokevirtual java.io.PrintStream.println:(Ljava/lang/String;)V
93: getstatic java.lang.System.out:Ljava/io/PrintStream;
invokevirtual java.io.PrintStream.println:()V
94: getstatic java.lang.System.out:Ljava/io/PrintStream;
new java.lang.StringBuilder
dup
ldc "Scale factor value: "
invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
getstatic org.hsqldb.test.JDBCBench.tps:I
invokevirtual java.lang.StringBuilder.append:(I)Ljava/lang/StringBuilder;
invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
invokevirtual java.io.PrintStream.println:(Ljava/lang/String;)V
95: getstatic java.lang.System.out:Ljava/io/PrintStream;
new java.lang.StringBuilder
dup
ldc "Number of clients: "
invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
getstatic org.hsqldb.test.JDBCBench.n_clients:I
invokevirtual java.lang.StringBuilder.append:(I)Ljava/lang/StringBuilder;
invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
invokevirtual java.io.PrintStream.println:(Ljava/lang/String;)V
96: getstatic java.lang.System.out:Ljava/io/PrintStream;
new java.lang.StringBuilder
dup
ldc "Number of transactions per client: "
invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
97: getstatic org.hsqldb.test.JDBCBench.n_txn_per_client:I
invokevirtual java.lang.StringBuilder.append:(I)Ljava/lang/StringBuilder;
invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
98: invokevirtual java.io.PrintStream.println:(Ljava/lang/String;)V
99: getstatic java.lang.System.out:Ljava/io/PrintStream;
invokevirtual java.io.PrintStream.println:()V
100: aload 1
invokestatic java.lang.Class.forName:(Ljava/lang/String;)Ljava/lang/Class;
pop
101: new org.hsqldb.test.JDBCBench
aload 2
aload 3
aload 4
102: iload 5
103: invokespecial org.hsqldb.test.JDBCBench.<init>:(Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;Z)V
104: goto 108
StackMap locals:
StackMap stack: java.lang.Exception
105: astore 6
start local 6 106: getstatic java.lang.System.out:Ljava/io/PrintStream;
aload 6
invokevirtual java.lang.Exception.toString:()Ljava/lang/String;
invokevirtual java.io.PrintStream.println:(Ljava/lang/String;)V
107: aload 6
invokevirtual java.lang.Exception.printStackTrace:()V
end local 6 108: StackMap locals:
StackMap stack:
return
end local 5 end local 4 end local 3 end local 2 end local 1 end local 0 LocalVariableTable:
Start End Slot Name Signature
0 109 0 Args [Ljava/lang/String;
1 109 1 DriverName Ljava/lang/String;
2 109 2 DBUrl Ljava/lang/String;
3 109 3 DBUser Ljava/lang/String;
4 109 4 DBPassword Ljava/lang/String;
5 109 5 initialize_dataset Z
6 71 6 i I
44 45 7 File Ljava/io/FileOutputStream;
106 108 6 E Ljava/lang/Exception;
Exception table:
from to target type
43 45 46 Class java.lang.Exception
100 104 105 Class java.lang.Exception
MethodParameters:
Name Flags
Args
public void <init>(java.lang.String, java.lang.String, java.lang.String, boolean);
descriptor: (Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;Z)V
flags: (0x0001) ACC_PUBLIC
Code:
stack=6, locals=11, args_size=5
start local 0 start local 1 start local 2 start local 3 start local 4 0: aload 0
invokespecial java.lang.Object.<init>:()V
1: aload 0
iconst_0
putfield org.hsqldb.test.JDBCBench.failed_transactions:I
2: aload 0
iconst_0
putfield org.hsqldb.test.JDBCBench.transaction_count:I
3: aload 0
lconst_0
putfield org.hsqldb.test.JDBCBench.start_time:J
4: new java.util.Vector
invokespecial java.util.Vector.<init>:()V
5: aconst_null
astore 5
start local 5 6: new java.util.Date
dup
invokespecial java.util.Date.<init>:()V
astore 6
start local 6 7: iload 4
ifeq 18
8: getstatic java.lang.System.out:Ljava/io/PrintStream;
new java.lang.StringBuilder
dup
ldc "Start: "
invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
aload 6
invokevirtual java.util.Date.toString:()Ljava/lang/String;
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
invokevirtual java.io.PrintStream.println:(Ljava/lang/String;)V
9: getstatic java.lang.System.out:Ljava/io/PrintStream;
ldc "Initializing dataset..."
invokevirtual java.io.PrintStream.print:(Ljava/lang/String;)V
10: aload 0
aload 1
aload 2
aload 3
invokevirtual org.hsqldb.test.JDBCBench.createDatabase:(Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;)V
11: invokestatic java.lang.System.currentTimeMillis:()J
aload 6
invokevirtual java.util.Date.getTime:()J
lsub
l2d
12: ldc 1000.0
13: ddiv
dstore 7
start local 7 14: getstatic java.lang.System.out:Ljava/io/PrintStream;
new java.lang.StringBuilder
dup
ldc "done. in "
invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
dload 7
invokevirtual java.lang.StringBuilder.append:(D)Ljava/lang/StringBuilder;
ldc " seconds\n"
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
invokevirtual java.io.PrintStream.println:(Ljava/lang/String;)V
15: getstatic java.lang.System.out:Ljava/io/PrintStream;
new java.lang.StringBuilder
dup
ldc "Complete: "
invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
16: new java.util.Date
dup
invokespecial java.util.Date.<init>:()V
invokevirtual java.util.Date.toString:()Ljava/lang/String;
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
17: invokevirtual java.io.PrintStream.println:(Ljava/lang/String;)V
end local 7 18: StackMap locals: org.hsqldb.test.JDBCBench java.lang.String java.lang.String java.lang.String int java.sql.Connection java.util.Date
StackMap stack:
getstatic java.lang.System.out:Ljava/io/PrintStream;
ldc "* Starting Benchmark Run *"
invokevirtual java.io.PrintStream.println:(Ljava/lang/String;)V
19: aload 0
new org.hsqldb.test.JDBCBench$MemoryWatcherThread
dup
aload 0
invokespecial org.hsqldb.test.JDBCBench$MemoryWatcherThread.<init>:(Lorg/hsqldb/test/JDBCBench;)V
putfield org.hsqldb.test.JDBCBench.MemoryWatcher:Lorg/hsqldb/test/JDBCBench$MemoryWatcherThread;
20: aload 0
getfield org.hsqldb.test.JDBCBench.MemoryWatcher:Lorg/hsqldb/test/JDBCBench$MemoryWatcherThread;
invokevirtual org.hsqldb.test.JDBCBench$MemoryWatcherThread.start:()V
21: aload 0
aload 1
aload 2
aload 3
getstatic org.hsqldb.test.JDBCBench.transactions:Z
iconst_1
invokevirtual org.hsqldb.test.JDBCBench.oneRound:(Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;ZZ)V
22: aload 0
aload 1
aload 2
aload 3
getstatic org.hsqldb.test.JDBCBench.transactions:Z
iconst_1
invokevirtual org.hsqldb.test.JDBCBench.oneRound:(Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;ZZ)V
23: aload 0
aload 1
aload 2
aload 3
getstatic org.hsqldb.test.JDBCBench.transactions:Z
iconst_1
invokevirtual org.hsqldb.test.JDBCBench.oneRound:(Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;ZZ)V
end local 6 24: goto 54
StackMap locals: org.hsqldb.test.JDBCBench java.lang.String java.lang.String java.lang.String int java.sql.Connection
StackMap stack: java.lang.Exception
25: astore 6
start local 6 26: getstatic java.lang.System.out:Ljava/io/PrintStream;
aload 6
invokevirtual java.lang.Exception.toString:()Ljava/lang/String;
invokevirtual java.io.PrintStream.println:(Ljava/lang/String;)V
27: aload 6
invokevirtual java.lang.Exception.printStackTrace:()V
end local 6 28: aload 0
getfield org.hsqldb.test.JDBCBench.MemoryWatcher:Lorg/hsqldb/test/JDBCBench$MemoryWatcherThread;
invokevirtual org.hsqldb.test.JDBCBench$MemoryWatcherThread.end:()V
29: aload 0
getfield org.hsqldb.test.JDBCBench.MemoryWatcher:Lorg/hsqldb/test/JDBCBench$MemoryWatcherThread;
invokevirtual org.hsqldb.test.JDBCBench$MemoryWatcherThread.join:()V
30: getstatic org.hsqldb.test.JDBCBench.ShutdownCommand:Ljava/lang/String;
invokevirtual java.lang.String.length:()I
ifle 36
31: aload 1
aload 2
aload 3
invokestatic org.hsqldb.test.JDBCBench.connect:(Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;)Ljava/sql/Connection;
astore 5
32: aload 5
invokeinterface java.sql.Connection.createStatement:()Ljava/sql/Statement;
astore 10
start local 10 33: aload 10
ldc "SHUTDOWN IMMEDIATELY"
invokeinterface java.sql.Statement.execute:(Ljava/lang/String;)Z
pop
34: aload 10
invokeinterface java.sql.Statement.close:()V
35: aload 5
invokestatic org.hsqldb.test.JDBCBench.connectClose:(Ljava/sql/Connection;)V
end local 10 36: StackMap locals:
StackMap stack:
getstatic org.hsqldb.test.JDBCBench.TabFile:Ljava/io/PrintStream;
ifnull 66
37: getstatic org.hsqldb.test.JDBCBench.TabFile:Ljava/io/PrintStream;
invokevirtual java.io.PrintStream.close:()V
38: goto 66
StackMap locals:
StackMap stack: java.lang.Exception
39: pop
goto 66
40: StackMap locals:
StackMap stack: java.lang.Throwable
astore 9
41: aload 0
getfield org.hsqldb.test.JDBCBench.MemoryWatcher:Lorg/hsqldb/test/JDBCBench$MemoryWatcherThread;
invokevirtual org.hsqldb.test.JDBCBench$MemoryWatcherThread.end:()V
42: aload 0
getfield org.hsqldb.test.JDBCBench.MemoryWatcher:Lorg/hsqldb/test/JDBCBench$MemoryWatcherThread;
invokevirtual org.hsqldb.test.JDBCBench$MemoryWatcherThread.join:()V
43: getstatic org.hsqldb.test.JDBCBench.ShutdownCommand:Ljava/lang/String;
invokevirtual java.lang.String.length:()I
ifle 49
44: aload 1
aload 2
aload 3
invokestatic org.hsqldb.test.JDBCBench.connect:(Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;)Ljava/sql/Connection;
astore 5
45: aload 5
invokeinterface java.sql.Connection.createStatement:()Ljava/sql/Statement;
astore 10
start local 10 46: aload 10
ldc "SHUTDOWN IMMEDIATELY"
invokeinterface java.sql.Statement.execute:(Ljava/lang/String;)Z
pop
47: aload 10
invokeinterface java.sql.Statement.close:()V
48: aload 5
invokestatic org.hsqldb.test.JDBCBench.connectClose:(Ljava/sql/Connection;)V
end local 10 49: StackMap locals: org.hsqldb.test.JDBCBench java.lang.String java.lang.String java.lang.String int java.sql.Connection top top top java.lang.Throwable
StackMap stack:
getstatic org.hsqldb.test.JDBCBench.TabFile:Ljava/io/PrintStream;
ifnull 53
50: getstatic org.hsqldb.test.JDBCBench.TabFile:Ljava/io/PrintStream;
invokevirtual java.io.PrintStream.close:()V
51: goto 53
StackMap locals:
StackMap stack: java.lang.Exception
52: pop
53: StackMap locals:
StackMap stack:
aload 9
athrow
54: StackMap locals: org.hsqldb.test.JDBCBench java.lang.String java.lang.String java.lang.String int java.sql.Connection
StackMap stack:
aload 0
getfield org.hsqldb.test.JDBCBench.MemoryWatcher:Lorg/hsqldb/test/JDBCBench$MemoryWatcherThread;
invokevirtual org.hsqldb.test.JDBCBench$MemoryWatcherThread.end:()V
55: aload 0
getfield org.hsqldb.test.JDBCBench.MemoryWatcher:Lorg/hsqldb/test/JDBCBench$MemoryWatcherThread;
invokevirtual org.hsqldb.test.JDBCBench$MemoryWatcherThread.join:()V
56: getstatic org.hsqldb.test.JDBCBench.ShutdownCommand:Ljava/lang/String;
invokevirtual java.lang.String.length:()I
ifle 62
57: aload 1
aload 2
aload 3
invokestatic org.hsqldb.test.JDBCBench.connect:(Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;)Ljava/sql/Connection;
astore 5
58: aload 5
invokeinterface java.sql.Connection.createStatement:()Ljava/sql/Statement;
astore 10
start local 10 59: aload 10
ldc "SHUTDOWN IMMEDIATELY"
invokeinterface java.sql.Statement.execute:(Ljava/lang/String;)Z
pop
60: aload 10
invokeinterface java.sql.Statement.close:()V
61: aload 5
invokestatic org.hsqldb.test.JDBCBench.connectClose:(Ljava/sql/Connection;)V
end local 10 62: StackMap locals:
StackMap stack:
getstatic org.hsqldb.test.JDBCBench.TabFile:Ljava/io/PrintStream;
ifnull 66
63: getstatic org.hsqldb.test.JDBCBench.TabFile:Ljava/io/PrintStream;
invokevirtual java.io.PrintStream.close:()V
64: goto 66
StackMap locals:
StackMap stack: java.lang.Exception
65: pop
66: StackMap locals:
StackMap stack:
return
end local 5 end local 4 end local 3 end local 2 end local 1 end local 0 LocalVariableTable:
Start End Slot Name Signature
0 67 0 this Lorg/hsqldb/test/JDBCBench;
0 67 1 url Ljava/lang/String;
0 67 2 user Ljava/lang/String;
0 67 3 password Ljava/lang/String;
0 67 4 init Z
6 67 5 guardian Ljava/sql/Connection;
7 24 6 start Ljava/util/Date;
14 18 7 seconds D
26 28 6 E Ljava/lang/Exception;
33 36 10 Stmt Ljava/sql/Statement;
46 49 10 Stmt Ljava/sql/Statement;
59 62 10 Stmt Ljava/sql/Statement;
Exception table:
from to target type
6 24 25 Class java.lang.Exception
29 38 39 Class java.lang.Exception
6 28 40 any
42 51 52 Class java.lang.Exception
55 64 65 Class java.lang.Exception
MethodParameters:
Name Flags
url
user
password
init
void oneRound(java.lang.String, java.lang.String, java.lang.String, boolean, boolean);
descriptor: (Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;ZZ)V
flags: (0x0000)
Code:
stack=8, locals=11, args_size=6
start local 0 start local 1 start local 2 start local 3 start local 4 start local 5 0: new java.util.Vector
dup
invokespecial java.util.Vector.<init>:()V
astore 6
start local 6 1: aconst_null
astore 7
start local 7 2: aconst_null
astore 8
start local 8 3: aconst_null
astore 9
start local 9 4: iload 4
putstatic org.hsqldb.test.JDBCBench.transactions:Z
5: iload 5
putstatic org.hsqldb.test.JDBCBench.prepared_stmt:Z
6: aload 0
invokestatic java.lang.System.currentTimeMillis:()J
putfield org.hsqldb.test.JDBCBench.start_time:J
7: iconst_0
istore 10
start local 10 8: goto 15
9: StackMap locals: org.hsqldb.test.JDBCBench java.lang.String java.lang.String java.lang.String int int java.util.Vector java.lang.Thread java.util.Enumeration java.sql.Connection int
StackMap stack:
new org.hsqldb.test.JDBCBench$ClientThread
dup
aload 0
getstatic org.hsqldb.test.JDBCBench.n_txn_per_client:I
aload 1
aload 2
aload 3
10: iconst_2
11: invokespecial org.hsqldb.test.JDBCBench$ClientThread.<init>:(Lorg/hsqldb/test/JDBCBench;ILjava/lang/String;Ljava/lang/String;Ljava/lang/String;I)V
astore 7
12: aload 7
invokevirtual java.lang.Thread.start:()V
13: aload 6
aload 7
invokevirtual java.util.Vector.addElement:(Ljava/lang/Object;)V
14: iinc 10 1
StackMap locals:
StackMap stack:
15: iload 10
getstatic org.hsqldb.test.JDBCBench.n_clients:I
if_icmplt 9
end local 10 16: aload 6
invokevirtual java.util.Vector.elements:()Ljava/util/Enumeration;
astore 8
17: goto 20
18: StackMap locals:
StackMap stack:
aload 8
invokeinterface java.util.Enumeration.nextElement:()Ljava/lang/Object;
checkcast java.lang.Thread
astore 7
19: aload 7
invokevirtual java.lang.Thread.join:()V
20: StackMap locals:
StackMap stack:
aload 8
invokeinterface java.util.Enumeration.hasMoreElements:()Z
ifne 18
21: aload 6
invokevirtual java.util.Vector.removeAllElements:()V
22: aload 0
invokevirtual org.hsqldb.test.JDBCBench.reportDone:()V
23: aload 1
aload 2
aload 3
invokestatic org.hsqldb.test.JDBCBench.connect:(Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;)Ljava/sql/Connection;
astore 9
24: aload 0
aload 9
invokevirtual org.hsqldb.test.JDBCBench.checkSums:(Ljava/sql/Connection;)V
25: aload 9
invokestatic org.hsqldb.test.JDBCBench.connectClose:(Ljava/sql/Connection;)V
26: return
end local 9 end local 8 end local 7 end local 6 end local 5 end local 4 end local 3 end local 2 end local 1 end local 0 LocalVariableTable:
Start End Slot Name Signature
0 27 0 this Lorg/hsqldb/test/JDBCBench;
0 27 1 url Ljava/lang/String;
0 27 2 user Ljava/lang/String;
0 27 3 password Ljava/lang/String;
0 27 4 transactions Z
0 27 5 prepared Z
1 27 6 vClient Ljava/util/Vector;
2 27 7 Client Ljava/lang/Thread;
3 27 8 e Ljava/util/Enumeration;
4 27 9 guardian Ljava/sql/Connection;
8 16 10 i I
Exceptions:
throws java.lang.InterruptedException, java.sql.SQLException
MethodParameters:
Name Flags
url
user
password
transactions
prepared
public void reportDone();
descriptor: ()V
flags: (0x0001) ACC_PUBLIC
Code:
stack=7, locals=7, args_size=1
start local 0 0: invokestatic java.lang.System.currentTimeMillis:()J
lstore 1
start local 1 1: lload 1
l2d
aload 0
getfield org.hsqldb.test.JDBCBench.start_time:J
l2d
dsub
2: ldc 1000.0
3: ddiv
dstore 3
start local 3 4: getstatic org.hsqldb.test.JDBCBench.TabFile:Ljava/io/PrintStream;
ifnull 8
5: getstatic org.hsqldb.test.JDBCBench.TabFile:Ljava/io/PrintStream;
new java.lang.StringBuilder
dup
getstatic org.hsqldb.test.JDBCBench.tps:I
invokestatic java.lang.String.valueOf:(I)Ljava/lang/String;
invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
ldc ";"
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
getstatic org.hsqldb.test.JDBCBench.n_clients:I
invokevirtual java.lang.StringBuilder.append:(I)Ljava/lang/StringBuilder;
ldc ";"
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
getstatic org.hsqldb.test.JDBCBench.n_txn_per_client:I
invokevirtual java.lang.StringBuilder.append:(I)Ljava/lang/StringBuilder;
6: ldc ";"
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
7: invokevirtual java.io.PrintStream.print:(Ljava/lang/String;)V
8: StackMap locals: long double
StackMap stack:
getstatic java.lang.System.out:Ljava/io/PrintStream;
ldc "\n* Benchmark Report *"
invokevirtual java.io.PrintStream.println:(Ljava/lang/String;)V
9: getstatic java.lang.System.out:Ljava/io/PrintStream;
ldc "* Featuring "
invokevirtual java.io.PrintStream.print:(Ljava/lang/String;)V
10: getstatic org.hsqldb.test.JDBCBench.prepared_stmt:Z
ifeq 15
11: getstatic java.lang.System.out:Ljava/io/PrintStream;
ldc "<prepared statements> "
invokevirtual java.io.PrintStream.print:(Ljava/lang/String;)V
12: getstatic org.hsqldb.test.JDBCBench.TabFile:Ljava/io/PrintStream;
ifnull 18
13: getstatic org.hsqldb.test.JDBCBench.TabFile:Ljava/io/PrintStream;
ldc "<prepared statements>;"
invokevirtual java.io.PrintStream.print:(Ljava/lang/String;)V
14: goto 18
15: StackMap locals:
StackMap stack:
getstatic java.lang.System.out:Ljava/io/PrintStream;
ldc "<direct queries> "
invokevirtual java.io.PrintStream.print:(Ljava/lang/String;)V
16: getstatic org.hsqldb.test.JDBCBench.TabFile:Ljava/io/PrintStream;
ifnull 18
17: getstatic org.hsqldb.test.JDBCBench.TabFile:Ljava/io/PrintStream;
ldc "<direct queries>;"
invokevirtual java.io.PrintStream.print:(Ljava/lang/String;)V
18: StackMap locals:
StackMap stack:
getstatic org.hsqldb.test.JDBCBench.transactions:Z
ifeq 23
19: getstatic java.lang.System.out:Ljava/io/PrintStream;
ldc "<transactions> "
invokevirtual java.io.PrintStream.print:(Ljava/lang/String;)V
20: getstatic org.hsqldb.test.JDBCBench.TabFile:Ljava/io/PrintStream;
ifnull 26
21: getstatic org.hsqldb.test.JDBCBench.TabFile:Ljava/io/PrintStream;
ldc "<transactions>;"
invokevirtual java.io.PrintStream.print:(Ljava/lang/String;)V
22: goto 26
23: StackMap locals:
StackMap stack:
getstatic java.lang.System.out:Ljava/io/PrintStream;
ldc "<auto-commit> "
invokevirtual java.io.PrintStream.print:(Ljava/lang/String;)V
24: getstatic org.hsqldb.test.JDBCBench.TabFile:Ljava/io/PrintStream;
ifnull 26
25: getstatic org.hsqldb.test.JDBCBench.TabFile:Ljava/io/PrintStream;
ldc "<auto-commit>;"
invokevirtual java.io.PrintStream.print:(Ljava/lang/String;)V
26: StackMap locals:
StackMap stack:
getstatic java.lang.System.out:Ljava/io/PrintStream;
ldc "\n--------------------"
invokevirtual java.io.PrintStream.println:(Ljava/lang/String;)V
27: getstatic java.lang.System.out:Ljava/io/PrintStream;
new java.lang.StringBuilder
dup
ldc "Time to execute "
invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
aload 0
getfield org.hsqldb.test.JDBCBench.transaction_count:I
invokevirtual java.lang.StringBuilder.append:(I)Ljava/lang/StringBuilder;
28: ldc " transactions: "
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
dload 3
invokevirtual java.lang.StringBuilder.append:(D)Ljava/lang/StringBuilder;
29: ldc " seconds."
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
30: invokevirtual java.io.PrintStream.println:(Ljava/lang/String;)V
31: getstatic java.lang.System.out:Ljava/io/PrintStream;
new java.lang.StringBuilder
dup
ldc "Max/Min memory usage: "
invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
32: aload 0
getfield org.hsqldb.test.JDBCBench.MemoryWatcher:Lorg/hsqldb/test/JDBCBench$MemoryWatcherThread;
getfield org.hsqldb.test.JDBCBench$MemoryWatcherThread.max:J
ldc 1024
ldiv
invokevirtual java.lang.StringBuilder.append:(J)Ljava/lang/StringBuilder;
ldc " / "
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
33: aload 0
getfield org.hsqldb.test.JDBCBench.MemoryWatcher:Lorg/hsqldb/test/JDBCBench$MemoryWatcherThread;
getfield org.hsqldb.test.JDBCBench$MemoryWatcherThread.min:J
ldc 1024
ldiv
invokevirtual java.lang.StringBuilder.append:(J)Ljava/lang/StringBuilder;
ldc " kb"
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
34: invokevirtual java.io.PrintStream.println:(Ljava/lang/String;)V
35: getstatic java.lang.System.out:Ljava/io/PrintStream;
new java.lang.StringBuilder
dup
aload 0
getfield org.hsqldb.test.JDBCBench.failed_transactions:I
invokestatic java.lang.String.valueOf:(I)Ljava/lang/String;
invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
ldc " / "
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
aload 0
getfield org.hsqldb.test.JDBCBench.transaction_count:I
invokevirtual java.lang.StringBuilder.append:(I)Ljava/lang/StringBuilder;
36: ldc " failed to complete."
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
37: invokevirtual java.io.PrintStream.println:(Ljava/lang/String;)V
38: aload 0
getfield org.hsqldb.test.JDBCBench.transaction_count:I
aload 0
getfield org.hsqldb.test.JDBCBench.failed_transactions:I
isub
i2d
39: dload 3
40: ddiv
dstore 5
start local 5 41: getstatic java.lang.System.out:Ljava/io/PrintStream;
new java.lang.StringBuilder
dup
ldc "Transaction rate: "
invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
dload 5
invokevirtual java.lang.StringBuilder.append:(D)Ljava/lang/StringBuilder;
ldc " txn/sec."
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
invokevirtual java.io.PrintStream.println:(Ljava/lang/String;)V
42: getstatic org.hsqldb.test.JDBCBench.TabFile:Ljava/io/PrintStream;
ifnull 47
43: getstatic org.hsqldb.test.JDBCBench.TabFile:Ljava/io/PrintStream;
new java.lang.StringBuilder
dup
aload 0
getfield org.hsqldb.test.JDBCBench.MemoryWatcher:Lorg/hsqldb/test/JDBCBench$MemoryWatcherThread;
getfield org.hsqldb.test.JDBCBench$MemoryWatcherThread.max:J
ldc 1024
ldiv
invokestatic java.lang.String.valueOf:(J)Ljava/lang/String;
invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
ldc ";"
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
44: aload 0
getfield org.hsqldb.test.JDBCBench.MemoryWatcher:Lorg/hsqldb/test/JDBCBench$MemoryWatcherThread;
getfield org.hsqldb.test.JDBCBench$MemoryWatcherThread.min:J
ldc 1024
ldiv
invokevirtual java.lang.StringBuilder.append:(J)Ljava/lang/StringBuilder;
ldc ";"
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
45: aload 0
getfield org.hsqldb.test.JDBCBench.failed_transactions:I
invokevirtual java.lang.StringBuilder.append:(I)Ljava/lang/StringBuilder;
ldc ";"
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
dload 5
invokevirtual java.lang.StringBuilder.append:(D)Ljava/lang/StringBuilder;
ldc "\n"
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
46: invokevirtual java.io.PrintStream.print:(Ljava/lang/String;)V
47: StackMap locals: double
StackMap stack:
aload 0
iconst_0
putfield org.hsqldb.test.JDBCBench.transaction_count:I
48: aload 0
iconst_0
putfield org.hsqldb.test.JDBCBench.failed_transactions:I
49: aload 0
getfield org.hsqldb.test.JDBCBench.MemoryWatcher:Lorg/hsqldb/test/JDBCBench$MemoryWatcherThread;
invokevirtual org.hsqldb.test.JDBCBench$MemoryWatcherThread.reset:()V
50: return
end local 5 end local 3 end local 1 end local 0 LocalVariableTable:
Start End Slot Name Signature
0 51 0 this Lorg/hsqldb/test/JDBCBench;
1 51 1 end_time J
4 51 3 completion_time D
41 51 5 rate D
public synchronized void incrementTransactionCount();
descriptor: ()V
flags: (0x0021) ACC_PUBLIC, ACC_SYNCHRONIZED
Code:
stack=3, locals=1, args_size=1
start local 0 0: aload 0
dup
getfield org.hsqldb.test.JDBCBench.transaction_count:I
iconst_1
iadd
putfield org.hsqldb.test.JDBCBench.transaction_count:I
1: return
end local 0 LocalVariableTable:
Start End Slot Name Signature
0 2 0 this Lorg/hsqldb/test/JDBCBench;
public synchronized void incrementFailedTransactionCount();
descriptor: ()V
flags: (0x0021) ACC_PUBLIC, ACC_SYNCHRONIZED
Code:
stack=3, locals=1, args_size=1
start local 0 0: aload 0
dup
getfield org.hsqldb.test.JDBCBench.failed_transactions:I
iconst_1
iadd
putfield org.hsqldb.test.JDBCBench.failed_transactions:I
1: return
end local 0 LocalVariableTable:
Start End Slot Name Signature
0 2 0 this Lorg/hsqldb/test/JDBCBench;
void createDatabase(java.lang.String, java.lang.String, java.lang.String);
descriptor: (Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;)V
flags: (0x0000)
Code:
stack=4, locals=10, args_size=4
start local 0 start local 1 start local 2 start local 3 0: aload 1
aload 2
aload 3
invokestatic org.hsqldb.test.JDBCBench.connect:(Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;)Ljava/sql/Connection;
astore 4
start local 4 1: aload 4
invokeinterface java.sql.Connection.getMetaData:()Ljava/sql/DatabaseMetaData;
invokeinterface java.sql.DatabaseMetaData.getDatabaseProductName:()Ljava/lang/String;
astore 5
start local 5 2: getstatic java.lang.System.out:Ljava/io/PrintStream;
new java.lang.StringBuilder
dup
ldc "DBMS: "
invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
aload 5
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
invokevirtual java.io.PrintStream.println:(Ljava/lang/String;)V
3: iconst_1
putstatic org.hsqldb.test.JDBCBench.transactions:Z
4: getstatic org.hsqldb.test.JDBCBench.transactions:Z
ifeq 10
5: aload 4
iconst_0
invokeinterface java.sql.Connection.setAutoCommit:(Z)V
6: getstatic java.lang.System.out:Ljava/io/PrintStream;
ldc "In transaction mode"
invokevirtual java.io.PrintStream.println:(Ljava/lang/String;)V
7: goto 10
StackMap locals: org.hsqldb.test.JDBCBench java.lang.String java.lang.String java.lang.String java.sql.Connection java.lang.String
StackMap stack: java.sql.SQLException
8: pop
9: iconst_0
putstatic org.hsqldb.test.JDBCBench.transactions:Z
10: StackMap locals:
StackMap stack:
iconst_0
istore 6
start local 6 11: aload 4
invokeinterface java.sql.Connection.createStatement:()Ljava/sql/Statement;
astore 7
start local 7 12: aload 7
ldc "SET WRITE_DELAY 10000 MILLIS;"
invokeinterface java.sql.Statement.execute:(Ljava/lang/String;)Z
pop
13: aload 7
ldc "SET PROPERTY \"hsqldb.cache_scale\" 16;"
invokeinterface java.sql.Statement.execute:(Ljava/lang/String;)Z
pop
14: ldc "SELECT count(*) "
astore 8
start local 8 15: new java.lang.StringBuilder
dup
aload 8
invokestatic java.lang.String.valueOf:(Ljava/lang/Object;)Ljava/lang/String;
invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
ldc "FROM accounts"
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
astore 8
16: aload 7
aload 8
invokeinterface java.sql.Statement.executeQuery:(Ljava/lang/String;)Ljava/sql/ResultSet;
astore 9
start local 9 17: aload 7
invokeinterface java.sql.Statement.clearWarnings:()V
18: goto 20
19: StackMap locals: org.hsqldb.test.JDBCBench java.lang.String java.lang.String java.lang.String java.sql.Connection java.lang.String int java.sql.Statement java.lang.String java.sql.ResultSet
StackMap stack:
aload 9
iconst_1
invokeinterface java.sql.ResultSet.getInt:(I)I
istore 6
20: StackMap locals:
StackMap stack:
aload 9
invokeinterface java.sql.ResultSet.next:()Z
ifne 19
21: getstatic org.hsqldb.test.JDBCBench.transactions:Z
ifeq 23
22: aload 4
invokeinterface java.sql.Connection.commit:()V
23: StackMap locals:
StackMap stack:
aload 7
invokeinterface java.sql.Statement.close:()V
24: iload 6
getstatic org.hsqldb.test.JDBCBench.naccounts:I
getstatic org.hsqldb.test.JDBCBench.tps:I
imul
if_icmpne 29
25: getstatic java.lang.System.out:Ljava/io/PrintStream;
ldc "Already initialized"
invokevirtual java.io.PrintStream.println:(Ljava/lang/String;)V
26: aload 4
invokestatic org.hsqldb.test.JDBCBench.connectClose:(Ljava/sql/Connection;)V
27: return
end local 9 end local 8 end local 7 end local 6 28: StackMap locals: org.hsqldb.test.JDBCBench java.lang.String java.lang.String java.lang.String java.sql.Connection java.lang.String
StackMap stack: java.lang.Exception
pop
29: StackMap locals:
StackMap stack:
getstatic java.lang.System.out:Ljava/io/PrintStream;
ldc "Drop old tables if they exist"
invokevirtual java.io.PrintStream.println:(Ljava/lang/String;)V
30: aload 4
invokeinterface java.sql.Connection.createStatement:()Ljava/sql/Statement;
astore 6
start local 6 31: ldc "DROP TABLE history"
astore 7
start local 7 32: aload 6
aload 7
invokeinterface java.sql.Statement.execute:(Ljava/lang/String;)Z
pop
33: aload 6
invokeinterface java.sql.Statement.clearWarnings:()V
34: ldc "DROP TABLE accounts"
astore 7
35: aload 6
aload 7
invokeinterface java.sql.Statement.execute:(Ljava/lang/String;)Z
pop
36: aload 6
invokeinterface java.sql.Statement.clearWarnings:()V
37: ldc "DROP TABLE tellers"
astore 7
38: aload 6
aload 7
invokeinterface java.sql.Statement.execute:(Ljava/lang/String;)Z
pop
39: aload 6
invokeinterface java.sql.Statement.clearWarnings:()V
40: ldc "DROP TABLE branches"
astore 7
41: aload 6
aload 7
invokeinterface java.sql.Statement.execute:(Ljava/lang/String;)Z
pop
42: aload 6
invokeinterface java.sql.Statement.clearWarnings:()V
43: getstatic org.hsqldb.test.JDBCBench.transactions:Z
ifeq 45
44: aload 4
invokeinterface java.sql.Connection.commit:()V
45: StackMap locals: java.sql.Statement java.lang.String
StackMap stack:
aload 6
invokeinterface java.sql.Statement.close:()V
end local 7 end local 6 46: goto 48
StackMap locals: org.hsqldb.test.JDBCBench java.lang.String java.lang.String java.lang.String java.sql.Connection java.lang.String
StackMap stack: java.lang.Exception
47: pop
48: StackMap locals:
StackMap stack:
getstatic java.lang.System.out:Ljava/io/PrintStream;
ldc "Creates tables"
invokevirtual java.io.PrintStream.println:(Ljava/lang/String;)V
49: aload 4
invokeinterface java.sql.Connection.createStatement:()Ljava/sql/Statement;
astore 6
start local 6 50: getstatic org.hsqldb.test.JDBCBench.tableExtension:Ljava/lang/String;
invokevirtual java.lang.String.length:()I
ifle 53
51: new java.lang.StringBuilder
dup
getstatic org.hsqldb.test.JDBCBench.tableExtension:Ljava/lang/String;
invokestatic java.lang.String.valueOf:(Ljava/lang/Object;)Ljava/lang/String;
invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
ldc " branches ("
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
astore 7
start local 7 52: goto 54
end local 7 53: StackMap locals: java.sql.Statement
StackMap stack:
ldc "CREATE TABLE branches ("
astore 7
start local 7 54: StackMap locals: java.lang.String
StackMap stack:
new java.lang.StringBuilder
dup
aload 7
invokestatic java.lang.String.valueOf:(Ljava/lang/Object;)Ljava/lang/String;
invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
ldc "Bid INTEGER NOT NULL PRIMARY KEY, "
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
astore 7
55: new java.lang.StringBuilder
dup
aload 7
invokestatic java.lang.String.valueOf:(Ljava/lang/Object;)Ljava/lang/String;
invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
ldc "Bbalance INTEGER,"
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
astore 7
56: new java.lang.StringBuilder
dup
aload 7
invokestatic java.lang.String.valueOf:(Ljava/lang/Object;)Ljava/lang/String;
invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
ldc "filler CHAR(88))"
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
astore 7
57: getstatic org.hsqldb.test.JDBCBench.createExtension:Ljava/lang/String;
invokevirtual java.lang.String.length:()I
ifle 59
58: new java.lang.StringBuilder
dup
aload 7
invokestatic java.lang.String.valueOf:(Ljava/lang/Object;)Ljava/lang/String;
invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
getstatic org.hsqldb.test.JDBCBench.createExtension:Ljava/lang/String;
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
astore 7
59: StackMap locals:
StackMap stack:
aload 6
aload 7
invokeinterface java.sql.Statement.execute:(Ljava/lang/String;)Z
pop
60: aload 6
invokeinterface java.sql.Statement.clearWarnings:()V
61: getstatic org.hsqldb.test.JDBCBench.tableExtension:Ljava/lang/String;
invokevirtual java.lang.String.length:()I
ifle 64
62: new java.lang.StringBuilder
dup
getstatic org.hsqldb.test.JDBCBench.tableExtension:Ljava/lang/String;
invokestatic java.lang.String.valueOf:(Ljava/lang/Object;)Ljava/lang/String;
invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
ldc " tellers ("
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
astore 7
63: goto 65
64: StackMap locals:
StackMap stack:
ldc "CREATE TABLE tellers ("
astore 7
65: StackMap locals:
StackMap stack:
new java.lang.StringBuilder
dup
aload 7
invokestatic java.lang.String.valueOf:(Ljava/lang/Object;)Ljava/lang/String;
invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
ldc "Tid INTEGER NOT NULL PRIMARY KEY,"
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
astore 7
66: new java.lang.StringBuilder
dup
aload 7
invokestatic java.lang.String.valueOf:(Ljava/lang/Object;)Ljava/lang/String;
invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
ldc "Bid INTEGER,"
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
astore 7
67: new java.lang.StringBuilder
dup
aload 7
invokestatic java.lang.String.valueOf:(Ljava/lang/Object;)Ljava/lang/String;
invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
ldc "Tbalance INTEGER,"
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
astore 7
68: new java.lang.StringBuilder
dup
aload 7
invokestatic java.lang.String.valueOf:(Ljava/lang/Object;)Ljava/lang/String;
invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
ldc "filler CHAR(84))"
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
astore 7
69: getstatic org.hsqldb.test.JDBCBench.createExtension:Ljava/lang/String;
invokevirtual java.lang.String.length:()I
ifle 71
70: new java.lang.StringBuilder
dup
aload 7
invokestatic java.lang.String.valueOf:(Ljava/lang/Object;)Ljava/lang/String;
invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
getstatic org.hsqldb.test.JDBCBench.createExtension:Ljava/lang/String;
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
astore 7
71: StackMap locals:
StackMap stack:
aload 6
aload 7
invokeinterface java.sql.Statement.execute:(Ljava/lang/String;)Z
pop
72: aload 6
invokeinterface java.sql.Statement.clearWarnings:()V
73: getstatic org.hsqldb.test.JDBCBench.tableExtension:Ljava/lang/String;
invokevirtual java.lang.String.length:()I
ifle 76
74: new java.lang.StringBuilder
dup
getstatic org.hsqldb.test.JDBCBench.tableExtension:Ljava/lang/String;
invokestatic java.lang.String.valueOf:(Ljava/lang/Object;)Ljava/lang/String;
invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
ldc " accounts ("
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
astore 7
75: goto 77
76: StackMap locals:
StackMap stack:
ldc "CREATE TABLE accounts ("
astore 7
77: StackMap locals:
StackMap stack:
new java.lang.StringBuilder
dup
aload 7
invokestatic java.lang.String.valueOf:(Ljava/lang/Object;)Ljava/lang/String;
invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
ldc "Aid INTEGER NOT NULL PRIMARY KEY, "
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
astore 7
78: new java.lang.StringBuilder
dup
aload 7
invokestatic java.lang.String.valueOf:(Ljava/lang/Object;)Ljava/lang/String;
invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
ldc "Bid INTEGER, "
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
astore 7
79: new java.lang.StringBuilder
dup
aload 7
invokestatic java.lang.String.valueOf:(Ljava/lang/Object;)Ljava/lang/String;
invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
ldc "Abalance INTEGER, "
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
astore 7
80: new java.lang.StringBuilder
dup
aload 7
invokestatic java.lang.String.valueOf:(Ljava/lang/Object;)Ljava/lang/String;
invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
ldc "filler CHAR(84))"
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
astore 7
81: getstatic org.hsqldb.test.JDBCBench.createExtension:Ljava/lang/String;
invokevirtual java.lang.String.length:()I
ifle 83
82: new java.lang.StringBuilder
dup
aload 7
invokestatic java.lang.String.valueOf:(Ljava/lang/Object;)Ljava/lang/String;
invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
getstatic org.hsqldb.test.JDBCBench.createExtension:Ljava/lang/String;
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
astore 7
83: StackMap locals:
StackMap stack:
aload 6
aload 7
invokeinterface java.sql.Statement.execute:(Ljava/lang/String;)Z
pop
84: aload 6
invokeinterface java.sql.Statement.clearWarnings:()V
85: getstatic org.hsqldb.test.JDBCBench.tableExtension:Ljava/lang/String;
invokevirtual java.lang.String.length:()I
ifle 88
86: new java.lang.StringBuilder
dup
getstatic org.hsqldb.test.JDBCBench.tableExtension:Ljava/lang/String;
invokestatic java.lang.String.valueOf:(Ljava/lang/Object;)Ljava/lang/String;
invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
ldc " history ("
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
astore 7
87: goto 89
88: StackMap locals:
StackMap stack:
ldc "CREATE TABLE history ("
astore 7
89: StackMap locals:
StackMap stack:
new java.lang.StringBuilder
dup
aload 7
invokestatic java.lang.String.valueOf:(Ljava/lang/Object;)Ljava/lang/String;
invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
ldc "Tid INTEGER, "
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
astore 7
90: new java.lang.StringBuilder
dup
aload 7
invokestatic java.lang.String.valueOf:(Ljava/lang/Object;)Ljava/lang/String;
invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
ldc "Bid INTEGER, "
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
astore 7
91: new java.lang.StringBuilder
dup
aload 7
invokestatic java.lang.String.valueOf:(Ljava/lang/Object;)Ljava/lang/String;
invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
ldc "Aid INTEGER, "
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
astore 7
92: new java.lang.StringBuilder
dup
aload 7
invokestatic java.lang.String.valueOf:(Ljava/lang/Object;)Ljava/lang/String;
invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
ldc "delta INTEGER, "
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
astore 7
93: new java.lang.StringBuilder
dup
aload 7
invokestatic java.lang.String.valueOf:(Ljava/lang/Object;)Ljava/lang/String;
invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
ldc "tstime TIMESTAMP, "
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
astore 7
94: new java.lang.StringBuilder
dup
aload 7
invokestatic java.lang.String.valueOf:(Ljava/lang/Object;)Ljava/lang/String;
invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
ldc "filler CHAR(22))"
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
astore 7
95: getstatic org.hsqldb.test.JDBCBench.createExtension:Ljava/lang/String;
invokevirtual java.lang.String.length:()I
ifle 97
96: new java.lang.StringBuilder
dup
aload 7
invokestatic java.lang.String.valueOf:(Ljava/lang/Object;)Ljava/lang/String;
invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
getstatic org.hsqldb.test.JDBCBench.createExtension:Ljava/lang/String;
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
astore 7
97: StackMap locals:
StackMap stack:
aload 6
aload 7
invokeinterface java.sql.Statement.execute:(Ljava/lang/String;)Z
pop
98: aload 6
invokeinterface java.sql.Statement.clearWarnings:()V
99: getstatic org.hsqldb.test.JDBCBench.transactions:Z
ifeq 101
100: aload 4
invokeinterface java.sql.Connection.commit:()V
101: StackMap locals:
StackMap stack:
aload 6
invokeinterface java.sql.Statement.close:()V
end local 7 end local 6 102: goto 107
StackMap locals: org.hsqldb.test.JDBCBench java.lang.String java.lang.String java.lang.String java.sql.Connection java.lang.String
StackMap stack: java.lang.Exception
103: pop
104: getstatic java.lang.System.out:Ljava/io/PrintStream;
105: ldc "Delete elements in table in case Drop didn't work"
106: invokevirtual java.io.PrintStream.println:(Ljava/lang/String;)V
107: StackMap locals:
StackMap stack:
getstatic java.lang.System.out:Ljava/io/PrintStream;
108: ldc "Delete elements in table in case Drop didn't work"
109: invokevirtual java.io.PrintStream.println:(Ljava/lang/String;)V
110: aload 4
invokeinterface java.sql.Connection.createStatement:()Ljava/sql/Statement;
astore 6
start local 6 111: ldc "DELETE FROM history"
astore 7
start local 7 112: aload 6
aload 7
invokeinterface java.sql.Statement.execute:(Ljava/lang/String;)Z
pop
113: aload 6
invokeinterface java.sql.Statement.clearWarnings:()V
114: ldc "DELETE FROM accounts"
astore 7
115: aload 6
aload 7
invokeinterface java.sql.Statement.execute:(Ljava/lang/String;)Z
pop
116: aload 6
invokeinterface java.sql.Statement.clearWarnings:()V
117: ldc "DELETE FROM tellers"
astore 7
118: aload 6
aload 7
invokeinterface java.sql.Statement.execute:(Ljava/lang/String;)Z
pop
119: aload 6
invokeinterface java.sql.Statement.clearWarnings:()V
120: ldc "DELETE FROM branches"
astore 7
121: aload 6
aload 7
invokeinterface java.sql.Statement.execute:(Ljava/lang/String;)Z
pop
122: aload 6
invokeinterface java.sql.Statement.clearWarnings:()V
123: getstatic org.hsqldb.test.JDBCBench.transactions:Z
ifeq 125
124: aload 4
invokeinterface java.sql.Connection.commit:()V
125: StackMap locals: java.sql.Statement java.lang.String
StackMap stack:
aconst_null
astore 8
start local 8 126: iconst_1
putstatic org.hsqldb.test.JDBCBench.prepared_stmt:Z
127: getstatic org.hsqldb.test.JDBCBench.prepared_stmt:Z
ifeq 135
128: ldc "INSERT INTO branches(Bid,Bbalance) VALUES (?,0)"
astore 7
129: aload 4
aload 7
invokeinterface java.sql.Connection.prepareStatement:(Ljava/lang/String;)Ljava/sql/PreparedStatement;
astore 8
130: getstatic java.lang.System.out:Ljava/io/PrintStream;
ldc "Using prepared statements"
invokevirtual java.io.PrintStream.println:(Ljava/lang/String;)V
131: goto 135
StackMap locals: org.hsqldb.test.JDBCBench java.lang.String java.lang.String java.lang.String java.sql.Connection java.lang.String java.sql.Statement java.lang.String java.sql.PreparedStatement
StackMap stack: java.sql.SQLException
132: pop
133: aconst_null
astore 8
134: iconst_0
putstatic org.hsqldb.test.JDBCBench.prepared_stmt:Z
135: StackMap locals:
StackMap stack:
getstatic java.lang.System.out:Ljava/io/PrintStream;
ldc "Insert data in branches table"
invokevirtual java.io.PrintStream.println:(Ljava/lang/String;)V
136: iconst_0
istore 9
start local 9 137: goto 150
138: StackMap locals: int
StackMap stack:
getstatic org.hsqldb.test.JDBCBench.prepared_stmt:Z
ifeq 143
139: aload 8
iconst_1
iload 9
invokeinterface java.sql.PreparedStatement.setInt:(II)V
140: aload 8
invokeinterface java.sql.PreparedStatement.executeUpdate:()I
pop
141: aload 8
invokeinterface java.sql.PreparedStatement.clearWarnings:()V
142: goto 147
143: StackMap locals:
StackMap stack:
new java.lang.StringBuilder
dup
ldc "INSERT INTO branches(Bid,Bbalance) VALUES ("
invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
iload 9
invokevirtual java.lang.StringBuilder.append:(I)Ljava/lang/StringBuilder;
144: ldc ",0)"
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
145: invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
astore 7
146: aload 6
aload 7
invokeinterface java.sql.Statement.executeUpdate:(Ljava/lang/String;)I
pop
147: StackMap locals:
StackMap stack:
iload 9
bipush 100
irem
ifne 149
getstatic org.hsqldb.test.JDBCBench.transactions:Z
ifeq 149
148: aload 4
invokeinterface java.sql.Connection.commit:()V
149: StackMap locals:
StackMap stack:
iinc 9 1
StackMap locals:
StackMap stack:
150: iload 9
getstatic org.hsqldb.test.JDBCBench.nbranches:I
getstatic org.hsqldb.test.JDBCBench.tps:I
imul
if_icmplt 138
end local 9 151: getstatic org.hsqldb.test.JDBCBench.prepared_stmt:Z
ifeq 153
152: aload 8
invokeinterface java.sql.PreparedStatement.close:()V
153: StackMap locals:
StackMap stack:
getstatic org.hsqldb.test.JDBCBench.transactions:Z
ifeq 155
154: aload 4
invokeinterface java.sql.Connection.commit:()V
155: StackMap locals:
StackMap stack:
getstatic org.hsqldb.test.JDBCBench.prepared_stmt:Z
ifeq 158
156: ldc "INSERT INTO tellers(Tid,Bid,Tbalance) VALUES (?,?,0)"
astore 7
157: aload 4
aload 7
invokeinterface java.sql.Connection.prepareStatement:(Ljava/lang/String;)Ljava/sql/PreparedStatement;
astore 8
158: StackMap locals:
StackMap stack:
getstatic java.lang.System.out:Ljava/io/PrintStream;
ldc "Insert data in tellers table"
invokevirtual java.io.PrintStream.println:(Ljava/lang/String;)V
159: iconst_0
istore 9
start local 9 160: goto 174
161: StackMap locals: int
StackMap stack:
getstatic org.hsqldb.test.JDBCBench.prepared_stmt:Z
ifeq 167
162: aload 8
iconst_1
iload 9
invokeinterface java.sql.PreparedStatement.setInt:(II)V
163: aload 8
iconst_2
iload 9
getstatic org.hsqldb.test.JDBCBench.ntellers:I
idiv
invokeinterface java.sql.PreparedStatement.setInt:(II)V
164: aload 8
invokeinterface java.sql.PreparedStatement.executeUpdate:()I
pop
165: aload 8
invokeinterface java.sql.PreparedStatement.clearWarnings:()V
166: goto 171
167: StackMap locals:
StackMap stack:
new java.lang.StringBuilder
dup
ldc "INSERT INTO tellers(Tid,Bid,Tbalance) VALUES ("
invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
168: iload 9
invokevirtual java.lang.StringBuilder.append:(I)Ljava/lang/StringBuilder;
ldc ","
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
iload 9
getstatic org.hsqldb.test.JDBCBench.ntellers:I
idiv
invokevirtual java.lang.StringBuilder.append:(I)Ljava/lang/StringBuilder;
ldc ",0)"
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
169: invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
astore 7
170: aload 6
aload 7
invokeinterface java.sql.Statement.executeUpdate:(Ljava/lang/String;)I
pop
171: StackMap locals:
StackMap stack:
iload 9
bipush 100
irem
ifne 173
getstatic org.hsqldb.test.JDBCBench.transactions:Z
ifeq 173
172: aload 4
invokeinterface java.sql.Connection.commit:()V
173: StackMap locals:
StackMap stack:
iinc 9 1
StackMap locals:
StackMap stack:
174: iload 9
getstatic org.hsqldb.test.JDBCBench.ntellers:I
getstatic org.hsqldb.test.JDBCBench.tps:I
imul
if_icmplt 161
end local 9 175: getstatic org.hsqldb.test.JDBCBench.prepared_stmt:Z
ifeq 177
176: aload 8
invokeinterface java.sql.PreparedStatement.close:()V
177: StackMap locals:
StackMap stack:
getstatic org.hsqldb.test.JDBCBench.transactions:Z
ifeq 179
178: aload 4
invokeinterface java.sql.Connection.commit:()V
179: StackMap locals:
StackMap stack:
getstatic org.hsqldb.test.JDBCBench.prepared_stmt:Z
ifeq 183
180: ldc "INSERT INTO accounts(Aid,Bid,Abalance) VALUES (?,?,0)"
181: astore 7
182: aload 4
aload 7
invokeinterface java.sql.Connection.prepareStatement:(Ljava/lang/String;)Ljava/sql/PreparedStatement;
astore 8
183: StackMap locals:
StackMap stack:
getstatic java.lang.System.out:Ljava/io/PrintStream;
ldc "Insert data in accounts table"
invokevirtual java.io.PrintStream.println:(Ljava/lang/String;)V
184: iconst_0
istore 9
start local 9 185: goto 201
186: StackMap locals: int
StackMap stack:
getstatic org.hsqldb.test.JDBCBench.prepared_stmt:Z
ifeq 192
187: aload 8
iconst_1
iload 9
invokeinterface java.sql.PreparedStatement.setInt:(II)V
188: aload 8
iconst_2
iload 9
getstatic org.hsqldb.test.JDBCBench.naccounts:I
idiv
invokeinterface java.sql.PreparedStatement.setInt:(II)V
189: aload 8
invokeinterface java.sql.PreparedStatement.executeUpdate:()I
pop
190: aload 8
invokeinterface java.sql.PreparedStatement.clearWarnings:()V
191: goto 196
192: StackMap locals:
StackMap stack:
new java.lang.StringBuilder
dup
ldc "INSERT INTO accounts(Aid,Bid,Abalance) VALUES ("
invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
193: iload 9
invokevirtual java.lang.StringBuilder.append:(I)Ljava/lang/StringBuilder;
ldc ","
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
iload 9
getstatic org.hsqldb.test.JDBCBench.naccounts:I
idiv
invokevirtual java.lang.StringBuilder.append:(I)Ljava/lang/StringBuilder;
ldc ",0)"
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
194: invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
astore 7
195: aload 6
aload 7
invokeinterface java.sql.Statement.executeUpdate:(Ljava/lang/String;)I
pop
196: StackMap locals:
StackMap stack:
iload 9
sipush 10000
irem
ifne 198
getstatic org.hsqldb.test.JDBCBench.transactions:Z
ifeq 198
197: aload 4
invokeinterface java.sql.Connection.commit:()V
198: StackMap locals:
StackMap stack:
iload 9
ifle 200
iload 9
sipush 10000
irem
ifne 200
199: getstatic java.lang.System.out:Ljava/io/PrintStream;
new java.lang.StringBuilder
dup
ldc "\t"
invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
iload 9
invokevirtual java.lang.StringBuilder.append:(I)Ljava/lang/StringBuilder;
ldc "\t records inserted"
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
invokevirtual java.io.PrintStream.println:(Ljava/lang/String;)V
200: StackMap locals:
StackMap stack:
iinc 9 1
StackMap locals:
StackMap stack:
201: iload 9
getstatic org.hsqldb.test.JDBCBench.naccounts:I
getstatic org.hsqldb.test.JDBCBench.tps:I
imul
if_icmplt 186
end local 9 202: getstatic org.hsqldb.test.JDBCBench.prepared_stmt:Z
ifeq 204
203: aload 8
invokeinterface java.sql.PreparedStatement.close:()V
204: StackMap locals:
StackMap stack:
getstatic org.hsqldb.test.JDBCBench.transactions:Z
ifeq 206
205: aload 4
invokeinterface java.sql.Connection.commit:()V
206: StackMap locals:
StackMap stack:
getstatic java.lang.System.out:Ljava/io/PrintStream;
new java.lang.StringBuilder
dup
ldc "\t"
invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
getstatic org.hsqldb.test.JDBCBench.naccounts:I
getstatic org.hsqldb.test.JDBCBench.tps:I
imul
invokevirtual java.lang.StringBuilder.append:(I)Ljava/lang/StringBuilder;
207: ldc "\t records inserted"
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
208: invokevirtual java.io.PrintStream.println:(Ljava/lang/String;)V
209: getstatic org.hsqldb.test.JDBCBench.ShutdownCommand:Ljava/lang/String;
invokevirtual java.lang.String.length:()I
ifle 211
210: aload 6
getstatic org.hsqldb.test.JDBCBench.ShutdownCommand:Ljava/lang/String;
invokeinterface java.sql.Statement.execute:(Ljava/lang/String;)Z
pop
211: StackMap locals:
StackMap stack:
aload 6
invokeinterface java.sql.Statement.close:()V
end local 8 end local 7 end local 6 212: goto 216
StackMap locals: org.hsqldb.test.JDBCBench java.lang.String java.lang.String java.lang.String java.sql.Connection java.lang.String
StackMap stack: java.lang.Exception
213: astore 6
start local 6 214: getstatic java.lang.System.out:Ljava/io/PrintStream;
aload 6
invokevirtual java.lang.Exception.toString:()Ljava/lang/String;
invokevirtual java.io.PrintStream.println:(Ljava/lang/String;)V
215: aload 6
invokevirtual java.lang.Exception.printStackTrace:()V
end local 6 216: StackMap locals:
StackMap stack:
aload 4
invokestatic org.hsqldb.test.JDBCBench.connectClose:(Ljava/sql/Connection;)V
217: return
end local 5 end local 4 end local 3 end local 2 end local 1 end local 0 LocalVariableTable:
Start End Slot Name Signature
0 218 0 this Lorg/hsqldb/test/JDBCBench;
0 218 1 url Ljava/lang/String;
0 218 2 user Ljava/lang/String;
0 218 3 password Ljava/lang/String;
1 218 4 Conn Ljava/sql/Connection;
2 218 5 s Ljava/lang/String;
11 28 6 accountsnb I
12 28 7 Stmt Ljava/sql/Statement;
15 28 8 Query Ljava/lang/String;
17 28 9 RS Ljava/sql/ResultSet;
31 46 6 Stmt Ljava/sql/Statement;
32 46 7 Query Ljava/lang/String;
50 102 6 Stmt Ljava/sql/Statement;
52 53 7 Query Ljava/lang/String;
54 102 7 Query Ljava/lang/String;
111 212 6 Stmt Ljava/sql/Statement;
112 212 7 Query Ljava/lang/String;
126 212 8 pstmt Ljava/sql/PreparedStatement;
137 151 9 i I
160 175 9 i I
185 202 9 i I
214 216 6 E Ljava/lang/Exception;
Exception table:
from to target type
5 7 8 Class java.sql.SQLException
10 27 28 Class java.lang.Exception
30 46 47 Class java.lang.Exception
49 102 103 Class java.lang.Exception
128 131 132 Class java.sql.SQLException
110 212 213 Class java.lang.Exception
Exceptions:
throws java.lang.Exception
MethodParameters:
Name Flags
url
user
password
public static int getRandomInt(int, int);
descriptor: (II)I
flags: (0x0009) ACC_PUBLIC, ACC_STATIC
Code:
stack=4, locals=3, args_size=2
start local 0 start local 1 0: iconst_0
istore 2
start local 2 1: invokestatic java.lang.Math.random:()D
iload 1
iload 0
isub
iconst_1
iadd
i2d
dmul
d2i
istore 2
2: iload 2
iload 0
iadd
istore 2
3: iload 2
ireturn
end local 2 end local 1 end local 0 LocalVariableTable:
Start End Slot Name Signature
0 4 0 lo I
0 4 1 hi I
1 4 2 ret I
MethodParameters:
Name Flags
lo
hi
public static int getRandomID(int);
descriptor: (I)I
flags: (0x0009) ACC_PUBLIC, ACC_STATIC
Code:
stack=2, locals=3, args_size=1
start local 0 0: iconst_0
istore 1
start local 1 1: iconst_0
istore 2
start local 2 2: iload 0
tableswitch { // 0 - 2
0: 3
1: 5
2: 7
default: 8
}
3: StackMap locals: int int
StackMap stack:
getstatic org.hsqldb.test.JDBCBench.ntellers:I
getstatic org.hsqldb.test.JDBCBench.tps:I
imul
iconst_1
isub
istore 2
4: goto 8
5: StackMap locals:
StackMap stack:
getstatic org.hsqldb.test.JDBCBench.nbranches:I
getstatic org.hsqldb.test.JDBCBench.tps:I
imul
iconst_1
isub
istore 2
6: goto 8
7: StackMap locals:
StackMap stack:
getstatic org.hsqldb.test.JDBCBench.naccounts:I
getstatic org.hsqldb.test.JDBCBench.tps:I
imul
iconst_1
isub
istore 2
8: StackMap locals:
StackMap stack:
iload 1
iload 2
invokestatic org.hsqldb.test.JDBCBench.getRandomInt:(II)I
ireturn
end local 2 end local 1 end local 0 LocalVariableTable:
Start End Slot Name Signature
0 9 0 type I
1 9 1 min I
2 9 2 max I
MethodParameters:
Name Flags
type
public static java.sql.Connection connect(java.lang.String, java.lang.String, java.lang.String);
descriptor: (Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;)Ljava/sql/Connection;
flags: (0x0009) ACC_PUBLIC, ACC_STATIC
Code:
stack=3, locals=4, args_size=3
start local 0 start local 1 start local 2 0: aload 0
aload 1
1: aload 2
2: invokestatic java.sql.DriverManager.getConnection:(Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;)Ljava/sql/Connection;
astore 3
start local 3 3: aload 3
4: areturn
end local 3 5: StackMap locals:
StackMap stack: java.lang.Exception
astore 3
start local 3 6: getstatic java.lang.System.out:Ljava/io/PrintStream;
aload 3
invokevirtual java.lang.Exception.toString:()Ljava/lang/String;
invokevirtual java.io.PrintStream.println:(Ljava/lang/String;)V
7: aload 3
invokevirtual java.lang.Exception.printStackTrace:()V
end local 3 8: aconst_null
areturn
end local 2 end local 1 end local 0 LocalVariableTable:
Start End Slot Name Signature
0 9 0 DBUrl Ljava/lang/String;
0 9 1 DBUser Ljava/lang/String;
0 9 2 DBPassword Ljava/lang/String;
3 5 3 conn Ljava/sql/Connection;
6 8 3 E Ljava/lang/Exception;
Exception table:
from to target type
0 4 5 Class java.lang.Exception
MethodParameters:
Name Flags
DBUrl
DBUser
DBPassword
public static void connectClose(java.sql.Connection);
descriptor: (Ljava/sql/Connection;)V
flags: (0x0009) ACC_PUBLIC, ACC_STATIC
Code:
stack=2, locals=2, args_size=1
start local 0 0: aload 0
ifnonnull 2
1: return
2: StackMap locals:
StackMap stack:
aload 0
invokeinterface java.sql.Connection.close:()V
3: goto 7
StackMap locals:
StackMap stack: java.lang.Exception
4: astore 1
start local 1 5: getstatic java.lang.System.out:Ljava/io/PrintStream;
aload 1
invokevirtual java.lang.Exception.toString:()Ljava/lang/String;
invokevirtual java.io.PrintStream.println:(Ljava/lang/String;)V
6: aload 1
invokevirtual java.lang.Exception.printStackTrace:()V
end local 1 7: StackMap locals:
StackMap stack:
return
end local 0 LocalVariableTable:
Start End Slot Name Signature
0 8 0 c Ljava/sql/Connection;
5 7 1 E Ljava/lang/Exception;
Exception table:
from to target type
2 3 4 Class java.lang.Exception
MethodParameters:
Name Flags
c
void checkSums(java.sql.Connection);
descriptor: (Ljava/sql/Connection;)V
flags: (0x0000)
Code:
stack=4, locals=9, args_size=2
start local 0 start local 1 0: aconst_null
astore 2
start local 2 1: aconst_null
astore 3
start local 3 2: aload 1
invokeinterface java.sql.Connection.createStatement:()Ljava/sql/Statement;
astore 2
3: aload 2
ldc "select sum(bbalance) from branches"
invokeinterface java.sql.Statement.executeQuery:(Ljava/lang/String;)Ljava/sql/ResultSet;
astore 3
4: aload 3
invokeinterface java.sql.ResultSet.next:()Z
pop
5: aload 3
iconst_1
invokeinterface java.sql.ResultSet.getInt:(I)I
istore 4
start local 4 6: aload 3
invokeinterface java.sql.ResultSet.close:()V
7: aload 2
ldc "select sum(tbalance) from tellers"
invokeinterface java.sql.Statement.executeQuery:(Ljava/lang/String;)Ljava/sql/ResultSet;
astore 3
8: aload 3
invokeinterface java.sql.ResultSet.next:()Z
pop
9: aload 3
iconst_1
invokeinterface java.sql.ResultSet.getInt:(I)I
istore 5
start local 5 10: aload 3
invokeinterface java.sql.ResultSet.close:()V
11: aload 2
ldc "select sum(abalance) from accounts"
invokeinterface java.sql.Statement.executeQuery:(Ljava/lang/String;)Ljava/sql/ResultSet;
astore 3
12: aload 3
invokeinterface java.sql.ResultSet.next:()Z
pop
13: aload 3
iconst_1
invokeinterface java.sql.ResultSet.getInt:(I)I
istore 6
start local 6 14: aload 3
invokeinterface java.sql.ResultSet.close:()V
15: aload 2
ldc "select sum(delta) from history"
invokeinterface java.sql.Statement.executeQuery:(Ljava/lang/String;)Ljava/sql/ResultSet;
astore 3
16: aload 3
invokeinterface java.sql.ResultSet.next:()Z
pop
17: aload 3
iconst_1
invokeinterface java.sql.ResultSet.getInt:(I)I
istore 7
start local 7 18: aload 3
invokeinterface java.sql.ResultSet.close:()V
19: aconst_null
astore 3
20: aload 2
invokeinterface java.sql.Statement.close:()V
21: aconst_null
astore 2
22: iload 6
iload 4
if_icmpne 24
iload 4
iload 5
if_icmpne 24
23: iload 5
iload 7
if_icmpeq 26
24: StackMap locals: org.hsqldb.test.JDBCBench java.sql.Connection java.sql.Statement java.sql.ResultSet int int int int
StackMap stack:
getstatic java.lang.System.out:Ljava/io/PrintStream;
ldc "sums don't match!"
invokevirtual java.io.PrintStream.println:(Ljava/lang/String;)V
25: goto 27
26: StackMap locals:
StackMap stack:
getstatic java.lang.System.out:Ljava/io/PrintStream;
ldc "sums match!"
invokevirtual java.io.PrintStream.println:(Ljava/lang/String;)V
27: StackMap locals:
StackMap stack:
getstatic java.lang.System.out:Ljava/io/PrintStream;
new java.lang.StringBuilder
dup
ldc "A "
invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
iload 6
invokevirtual java.lang.StringBuilder.append:(I)Ljava/lang/StringBuilder;
ldc " B "
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
iload 4
invokevirtual java.lang.StringBuilder.append:(I)Ljava/lang/StringBuilder;
28: ldc " T "
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
iload 5
invokevirtual java.lang.StringBuilder.append:(I)Ljava/lang/StringBuilder;
ldc " H "
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
iload 7
invokevirtual java.lang.StringBuilder.append:(I)Ljava/lang/StringBuilder;
invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
29: invokevirtual java.io.PrintStream.println:(Ljava/lang/String;)V
30: goto 35
end local 7 end local 6 end local 5 end local 4 StackMap locals: org.hsqldb.test.JDBCBench java.sql.Connection java.sql.Statement java.sql.ResultSet
StackMap stack: java.lang.Throwable
31: astore 8
32: aload 2
ifnull 34
33: aload 2
invokeinterface java.sql.Statement.close:()V
34: StackMap locals: org.hsqldb.test.JDBCBench java.sql.Connection java.sql.Statement java.sql.ResultSet top top top top java.lang.Throwable
StackMap stack:
aload 8
athrow
start local 4 start local 5 start local 6 start local 7 35: StackMap locals: org.hsqldb.test.JDBCBench java.sql.Connection java.sql.Statement java.sql.ResultSet int int int int
StackMap stack:
aload 2
ifnull 37
36: aload 2
invokeinterface java.sql.Statement.close:()V
37: StackMap locals:
StackMap stack:
return
end local 7 end local 6 end local 5 end local 4 end local 3 end local 2 end local 1 end local 0 LocalVariableTable:
Start End Slot Name Signature
0 38 0 this Lorg/hsqldb/test/JDBCBench;
0 38 1 conn Ljava/sql/Connection;
1 38 2 st1 Ljava/sql/Statement;
2 38 3 rs Ljava/sql/ResultSet;
6 31 4 bbalancesum I
35 38 4 bbalancesum I
10 31 5 tbalancesum I
35 38 5 tbalancesum I
14 31 6 abalancesum I
35 38 6 abalancesum I
18 31 7 deltasum I
35 38 7 deltasum I
Exception table:
from to target type
2 31 31 any
Exceptions:
throws java.sql.SQLException
MethodParameters:
Name Flags
conn
}
SourceFile: "JDBCBench.java"
NestMembers:
org.hsqldb.test.JDBCBench$ClientThread org.hsqldb.test.JDBCBench$MemoryWatcherThread
InnerClasses:
ClientThread = org.hsqldb.test.JDBCBench$ClientThread of org.hsqldb.test.JDBCBench
MemoryWatcherThread = org.hsqldb.test.JDBCBench$MemoryWatcherThread of org.hsqldb.test.JDBCBench