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: .line 27
            iconst_1
            putstatic org.hsqldb.test.JDBCBench.tps:I
         1: .line 28
            iconst_1
            putstatic org.hsqldb.test.JDBCBench.nbranches:I
         2: .line 29
            bipush 10
            putstatic org.hsqldb.test.JDBCBench.ntellers:I
         3: .line 30
            ldc 100000
            putstatic org.hsqldb.test.JDBCBench.naccounts:I
         4: .line 31
            ldc 864000
            putstatic org.hsqldb.test.JDBCBench.nhistory:I
         5: .line 37
            bipush 10
            putstatic org.hsqldb.test.JDBCBench.n_clients:I
         6: .line 38
            bipush 10
            putstatic org.hsqldb.test.JDBCBench.n_txn_per_client:I
         7: .line 40
            iconst_1
            putstatic org.hsqldb.test.JDBCBench.transactions:Z
         8: .line 41
            iconst_0
            putstatic org.hsqldb.test.JDBCBench.prepared_stmt:Z
         9: .line 42
            ldc ""
            putstatic org.hsqldb.test.JDBCBench.tableExtension:Ljava/lang/String;
        10: .line 43
            ldc ""
            putstatic org.hsqldb.test.JDBCBench.createExtension:Ljava/lang/String;
        11: .line 44
            ldc ""
            putstatic org.hsqldb.test.JDBCBench.ShutdownCommand:Ljava/lang/String;
        12: .line 45
            aconst_null
            putstatic org.hsqldb.test.JDBCBench.TabFile:Ljava/io/PrintStream;
        13: .line 46
            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 // java.lang.String[] Args
         0: .line 56
            ldc ""
            astore 1 /* DriverName */
        start local 1 // java.lang.String DriverName
         1: .line 57
            ldc ""
            astore 2 /* DBUrl */
        start local 2 // java.lang.String DBUrl
         2: .line 58
            ldc ""
            astore 3 /* DBUser */
        start local 3 // java.lang.String DBUser
         3: .line 59
            ldc ""
            astore 4 /* DBPassword */
        start local 4 // java.lang.String DBPassword
         4: .line 60
            iconst_0
            istore 5 /* initialize_dataset */
        start local 5 // boolean initialize_dataset
         5: .line 62
            iconst_0
            istore 6 /* i */
        start local 6 // int i
         6: goto 70
         7: .line 63
      StackMap locals: java.lang.String[] java.lang.String java.lang.String java.lang.String java.lang.String int int
      StackMap stack:
            aload 0 /* Args */
            iload 6 /* i */
            aaload
            ldc "-clients"
            invokevirtual java.lang.String.equals:(Ljava/lang/Object;)Z
            ifeq 12
         8: .line 64
            iload 6 /* i */
            iconst_1
            iadd
            aload 0 /* Args */
            arraylength
            if_icmpge 69
         9: .line 65
            iinc 6 /* i */ 1
        10: .line 67
            aload 0 /* Args */
            iload 6 /* i */
            aaload
            invokestatic java.lang.Integer.parseInt:(Ljava/lang/String;)I
            putstatic org.hsqldb.test.JDBCBench.n_clients:I
        11: .line 69
            goto 69
      StackMap locals:
      StackMap stack:
        12: aload 0 /* Args */
            iload 6 /* i */
            aaload
            ldc "-driver"
            invokevirtual java.lang.String.equals:(Ljava/lang/Object;)Z
            ifeq 30
        13: .line 70
            iload 6 /* i */
            iconst_1
            iadd
            aload 0 /* Args */
            arraylength
            if_icmpge 69
        14: .line 71
            iinc 6 /* i */ 1
        15: .line 73
            aload 0 /* Args */
            iload 6 /* i */
            aaload
            astore 1 /* DriverName */
        16: .line 75
            aload 1 /* DriverName */
        17: .line 76
            ldc "org.enhydra.instantdb.jdbc.idbDriver"
        18: .line 75
            invokevirtual java.lang.String.equals:(Ljava/lang/Object;)Z
        19: .line 76
            ifeq 21
        20: .line 77
            ldc "SHUTDOWN"
            putstatic org.hsqldb.test.JDBCBench.ShutdownCommand:Ljava/lang/String;
        21: .line 80
      StackMap locals:
      StackMap stack:
            aload 1 /* DriverName */
        22: .line 81
            ldc "com.borland.datastore.jdbc.DataStoreDriver"
        23: .line 80
            invokevirtual java.lang.String.equals:(Ljava/lang/Object;)Z
            pop
        24: .line 85
            aload 1 /* DriverName */
            ldc "com.mckoi.JDBCDriver"
            invokevirtual java.lang.String.equals:(Ljava/lang/Object;)Z
            ifeq 26
        25: .line 86
            ldc "SHUTDOWN"
            putstatic org.hsqldb.test.JDBCBench.ShutdownCommand:Ljava/lang/String;
        26: .line 89
      StackMap locals:
      StackMap stack:
            aload 1 /* DriverName */
            ldc "org.hsqldb.jdbc.JDBCDriver"
            invokevirtual java.lang.String.equals:(Ljava/lang/Object;)Z
            ifne 28
        27: .line 90
            aload 1 /* DriverName */
            ldc "org.hsqldb.jdbcDriver"
            invokevirtual java.lang.String.equals:(Ljava/lang/Object;)Z
            ifeq 69
        28: .line 91
      StackMap locals:
      StackMap stack:
            ldc "CREATE CACHED TABLE "
            putstatic org.hsqldb.test.JDBCBench.tableExtension:Ljava/lang/String;
        29: .line 96
            goto 69
      StackMap locals:
      StackMap stack:
        30: aload 0 /* Args */
            iload 6 /* i */
            aaload
            ldc "-url"
            invokevirtual java.lang.String.equals:(Ljava/lang/Object;)Z
            ifeq 35
        31: .line 97
            iload 6 /* i */
            iconst_1
            iadd
            aload 0 /* Args */
            arraylength
            if_icmpge 69
        32: .line 98
            iinc 6 /* i */ 1
        33: .line 100
            aload 0 /* Args */
            iload 6 /* i */
            aaload
            astore 2 /* DBUrl */
        34: .line 102
            goto 69
      StackMap locals:
      StackMap stack:
        35: aload 0 /* Args */
            iload 6 /* i */
            aaload
            ldc "-user"
            invokevirtual java.lang.String.equals:(Ljava/lang/Object;)Z
            ifeq 40
        36: .line 103
            iload 6 /* i */
            iconst_1
            iadd
            aload 0 /* Args */
            arraylength
            if_icmpge 69
        37: .line 104
            iinc 6 /* i */ 1
        38: .line 106
            aload 0 /* Args */
            iload 6 /* i */
            aaload
            astore 3 /* DBUser */
        39: .line 108
            goto 69
      StackMap locals:
      StackMap stack:
        40: aload 0 /* Args */
            iload 6 /* i */
            aaload
            ldc "-tabfile"
            invokevirtual java.lang.String.equals:(Ljava/lang/Object;)Z
            ifeq 49
        41: .line 109
            iload 6 /* i */
            iconst_1
            iadd
            aload 0 /* Args */
            arraylength
            if_icmpge 69
        42: .line 110
            iinc 6 /* i */ 1
        43: .line 113
            new java.io.FileOutputStream
            dup
            aload 0 /* Args */
            iload 6 /* i */
            aaload
            invokespecial java.io.FileOutputStream.<init>:(Ljava/lang/String;)V
            astore 7 /* File */
        start local 7 // java.io.FileOutputStream File
        44: .line 115
            new java.io.PrintStream
            dup
            aload 7 /* File */
            invokespecial java.io.PrintStream.<init>:(Ljava/io/OutputStream;)V
            putstatic org.hsqldb.test.JDBCBench.TabFile:Ljava/io/PrintStream;
        end local 7 // java.io.FileOutputStream File
        45: .line 116
            goto 69
      StackMap locals:
      StackMap stack: java.lang.Exception
        46: pop
        47: .line 117
            aconst_null
            putstatic org.hsqldb.test.JDBCBench.TabFile:Ljava/io/PrintStream;
        48: .line 120
            goto 69
      StackMap locals:
      StackMap stack:
        49: aload 0 /* Args */
            iload 6 /* i */
            aaload
            ldc "-password"
            invokevirtual java.lang.String.equals:(Ljava/lang/Object;)Z
            ifeq 54
        50: .line 121
            iload 6 /* i */
            iconst_1
            iadd
            aload 0 /* Args */
            arraylength
            if_icmpge 69
        51: .line 122
            iinc 6 /* i */ 1
        52: .line 124
            aload 0 /* Args */
            iload 6 /* i */
            aaload
            astore 4 /* DBPassword */
        53: .line 126
            goto 69
      StackMap locals:
      StackMap stack:
        54: aload 0 /* Args */
            iload 6 /* i */
            aaload
            ldc "-tpc"
            invokevirtual java.lang.String.equals:(Ljava/lang/Object;)Z
            ifeq 59
        55: .line 127
            iload 6 /* i */
            iconst_1
            iadd
            aload 0 /* Args */
            arraylength
            if_icmpge 69
        56: .line 128
            iinc 6 /* i */ 1
        57: .line 130
            aload 0 /* Args */
            iload 6 /* i */
            aaload
            invokestatic java.lang.Integer.parseInt:(Ljava/lang/String;)I
            putstatic org.hsqldb.test.JDBCBench.n_txn_per_client:I
        58: .line 132
            goto 69
      StackMap locals:
      StackMap stack:
        59: aload 0 /* Args */
            iload 6 /* i */
            aaload
            ldc "-init"
            invokevirtual java.lang.String.equals:(Ljava/lang/Object;)Z
            ifeq 62
        60: .line 133
            iconst_1
            istore 5 /* initialize_dataset */
        61: .line 134
            goto 69
      StackMap locals:
      StackMap stack:
        62: aload 0 /* Args */
            iload 6 /* i */
            aaload
            ldc "-tps"
            invokevirtual java.lang.String.equals:(Ljava/lang/Object;)Z
            ifeq 67
        63: .line 135
            iload 6 /* i */
            iconst_1
            iadd
            aload 0 /* Args */
            arraylength
            if_icmpge 69
        64: .line 136
            iinc 6 /* i */ 1
        65: .line 138
            aload 0 /* Args */
            iload 6 /* i */
            aaload
            invokestatic java.lang.Integer.parseInt:(Ljava/lang/String;)I
            putstatic org.hsqldb.test.JDBCBench.tps:I
        66: .line 140
            goto 69
      StackMap locals:
      StackMap stack:
        67: aload 0 /* Args */
            iload 6 /* i */
            aaload
            ldc "-v"
            invokevirtual java.lang.String.equals:(Ljava/lang/Object;)Z
            ifeq 69
        68: .line 141
            iconst_1
            putstatic org.hsqldb.test.JDBCBench.verbose:Z
        69: .line 62
      StackMap locals:
      StackMap stack:
            iinc 6 /* i */ 1
      StackMap locals:
      StackMap stack:
        70: iload 6 /* i */
            aload 0 /* Args */
            arraylength
            if_icmplt 7
        end local 6 // int i
        71: .line 145
            aload 1 /* DriverName */
            invokevirtual java.lang.String.length:()I
            ifeq 72
            aload 2 /* DBUrl */
            invokevirtual java.lang.String.length:()I
            ifne 81
        72: .line 146
      StackMap locals:
      StackMap stack:
            getstatic java.lang.System.out:Ljava/io/PrintStream;
        73: .line 147
            ldc "usage: java JDBCBench -driver [driver_class_name] -url [url_to_db] -user [username] -password [password] [-v] [-init] [-tpc n] [-clients n]"
        74: .line 146
            invokevirtual java.io.PrintStream.println:(Ljava/lang/String;)V
        75: .line 148
            getstatic java.lang.System.out:Ljava/io/PrintStream;
            invokevirtual java.io.PrintStream.println:()V
        76: .line 149
            getstatic java.lang.System.out:Ljava/io/PrintStream;
            ldc "-v          verbose error messages"
            invokevirtual java.io.PrintStream.println:(Ljava/lang/String;)V
        77: .line 150
            getstatic java.lang.System.out:Ljava/io/PrintStream;
            ldc "-init       initialize the tables"
            invokevirtual java.io.PrintStream.println:(Ljava/lang/String;)V
        78: .line 151
            getstatic java.lang.System.out:Ljava/io/PrintStream;
            ldc "-tpc        transactions per client"
            invokevirtual java.io.PrintStream.println:(Ljava/lang/String;)V
        79: .line 152
            getstatic java.lang.System.out:Ljava/io/PrintStream;
            ldc "-clients    number of simultaneous clients"
            invokevirtual java.io.PrintStream.println:(Ljava/lang/String;)V
        80: .line 153
            iconst_m1
            invokestatic java.lang.System.exit:(I)V
        81: .line 156
      StackMap locals:
      StackMap stack:
            getstatic java.lang.System.out:Ljava/io/PrintStream;
        82: .line 157
            ldc "*********************************************************"
        83: .line 156
            invokevirtual java.io.PrintStream.println:(Ljava/lang/String;)V
        84: .line 158
            getstatic java.lang.System.out:Ljava/io/PrintStream;
        85: .line 159
            ldc "* JDBCBench v1.1                                        *"
        86: .line 158
            invokevirtual java.io.PrintStream.println:(Ljava/lang/String;)V
        87: .line 160
            getstatic java.lang.System.out:Ljava/io/PrintStream;
        88: .line 161
            ldc "*********************************************************"
        89: .line 160
            invokevirtual java.io.PrintStream.println:(Ljava/lang/String;)V
        90: .line 162
            getstatic java.lang.System.out:Ljava/io/PrintStream;
            invokevirtual java.io.PrintStream.println:()V
        91: .line 163
            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 /* DriverName */
            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: .line 164
            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 /* DBUrl */
            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: .line 165
            getstatic java.lang.System.out:Ljava/io/PrintStream;
            invokevirtual java.io.PrintStream.println:()V
        94: .line 166
            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: .line 167
            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: .line 168
            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: .line 169
            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: .line 168
            invokevirtual java.io.PrintStream.println:(Ljava/lang/String;)V
        99: .line 170
            getstatic java.lang.System.out:Ljava/io/PrintStream;
            invokevirtual java.io.PrintStream.println:()V
       100: .line 173
            aload 1 /* DriverName */
            invokestatic java.lang.Class.forName:(Ljava/lang/String;)Ljava/lang/Class;
            pop
       101: .line 175
            new org.hsqldb.test.JDBCBench
            aload 2 /* DBUrl */
            aload 3 /* DBUser */
            aload 4 /* DBPassword */
       102: .line 176
            iload 5 /* initialize_dataset */
       103: .line 175
            invokespecial org.hsqldb.test.JDBCBench.<init>:(Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;Z)V
       104: .line 177
            goto 108
      StackMap locals:
      StackMap stack: java.lang.Exception
       105: astore 6 /* E */
        start local 6 // java.lang.Exception E
       106: .line 178
            getstatic java.lang.System.out:Ljava/io/PrintStream;
            aload 6 /* E */
            invokevirtual java.lang.Exception.toString:()Ljava/lang/String;
            invokevirtual java.io.PrintStream.println:(Ljava/lang/String;)V
       107: .line 179
            aload 6 /* E */
            invokevirtual java.lang.Exception.printStackTrace:()V
        end local 6 // java.lang.Exception E
       108: .line 181
      StackMap locals:
      StackMap stack:
            return
        end local 5 // boolean initialize_dataset
        end local 4 // java.lang.String DBPassword
        end local 3 // java.lang.String DBUser
        end local 2 // java.lang.String DBUrl
        end local 1 // java.lang.String DriverName
        end local 0 // java.lang.String[] Args
      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 // org.hsqldb.test.JDBCBench this
        start local 1 // java.lang.String url
        start local 2 // java.lang.String user
        start local 3 // java.lang.String password
        start local 4 // boolean init
         0: .line 183
            aload 0 /* this */
            invokespecial java.lang.Object.<init>:()V
         1: .line 35
            aload 0 /* this */
            iconst_0
            putfield org.hsqldb.test.JDBCBench.failed_transactions:I
         2: .line 36
            aload 0 /* this */
            iconst_0
            putfield org.hsqldb.test.JDBCBench.transaction_count:I
         3: .line 39
            aload 0 /* this */
            lconst_0
            putfield org.hsqldb.test.JDBCBench.start_time:J
         4: .line 185
            new java.util.Vector
            invokespecial java.util.Vector.<init>:()V
         5: .line 188
            aconst_null
            astore 5 /* guardian */
        start local 5 // java.sql.Connection guardian
         6: .line 191
            new java.util.Date
            dup
            invokespecial java.util.Date.<init>:()V
            astore 6 /* start */
        start local 6 // java.util.Date start
         7: .line 193
            iload 4 /* init */
            ifeq 18
         8: .line 194
            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 /* start */
            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: .line 195
            getstatic java.lang.System.out:Ljava/io/PrintStream;
            ldc "Initializing dataset..."
            invokevirtual java.io.PrintStream.print:(Ljava/lang/String;)V
        10: .line 196
            aload 0 /* this */
            aload 1 /* url */
            aload 2 /* user */
            aload 3 /* password */
            invokevirtual org.hsqldb.test.JDBCBench.createDatabase:(Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;)V
        11: .line 198
            invokestatic java.lang.System.currentTimeMillis:()J
            aload 6 /* start */
            invokevirtual java.util.Date.getTime:()J
            lsub
            l2d
        12: .line 199
            ldc 1000.0
        13: .line 198
            ddiv
            dstore 7 /* seconds */
        start local 7 // double seconds
        14: .line 201
            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 /* seconds */
            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: .line 202
            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: .line 203
            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: .line 202
            invokevirtual java.io.PrintStream.println:(Ljava/lang/String;)V
        end local 7 // double seconds
        18: .line 206
      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: .line 208
            aload 0 /* this */
            new org.hsqldb.test.JDBCBench$MemoryWatcherThread
            dup
            aload 0 /* this */
            invokespecial org.hsqldb.test.JDBCBench$MemoryWatcherThread.<init>:(Lorg/hsqldb/test/JDBCBench;)V
            putfield org.hsqldb.test.JDBCBench.MemoryWatcher:Lorg/hsqldb/test/JDBCBench$MemoryWatcherThread;
        20: .line 210
            aload 0 /* this */
            getfield org.hsqldb.test.JDBCBench.MemoryWatcher:Lorg/hsqldb/test/JDBCBench$MemoryWatcherThread;
            invokevirtual org.hsqldb.test.JDBCBench$MemoryWatcherThread.start:()V
        21: .line 211
            aload 0 /* this */
            aload 1 /* url */
            aload 2 /* user */
            aload 3 /* password */
            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: .line 212
            aload 0 /* this */
            aload 1 /* url */
            aload 2 /* user */
            aload 3 /* password */
            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: .line 213
            aload 0 /* this */
            aload 1 /* url */
            aload 2 /* user */
            aload 3 /* password */
            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 // java.util.Date start
        24: .line 226
            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 /* E */
        start local 6 // java.lang.Exception E
        26: .line 227
            getstatic java.lang.System.out:Ljava/io/PrintStream;
            aload 6 /* E */
            invokevirtual java.lang.Exception.toString:()Ljava/lang/String;
            invokevirtual java.io.PrintStream.println:(Ljava/lang/String;)V
        27: .line 228
            aload 6 /* E */
            invokevirtual java.lang.Exception.printStackTrace:()V
        end local 6 // java.lang.Exception E
        28: .line 230
            aload 0 /* this */
            getfield org.hsqldb.test.JDBCBench.MemoryWatcher:Lorg/hsqldb/test/JDBCBench$MemoryWatcherThread;
            invokevirtual org.hsqldb.test.JDBCBench$MemoryWatcherThread.end:()V
        29: .line 233
            aload 0 /* this */
            getfield org.hsqldb.test.JDBCBench.MemoryWatcher:Lorg/hsqldb/test/JDBCBench$MemoryWatcherThread;
            invokevirtual org.hsqldb.test.JDBCBench$MemoryWatcherThread.join:()V
        30: .line 235
            getstatic org.hsqldb.test.JDBCBench.ShutdownCommand:Ljava/lang/String;
            invokevirtual java.lang.String.length:()I
            ifle 36
        31: .line 236
            aload 1 /* url */
            aload 2 /* user */
            aload 3 /* password */
            invokestatic org.hsqldb.test.JDBCBench.connect:(Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;)Ljava/sql/Connection;
            astore 5 /* guardian */
        32: .line 238
            aload 5 /* guardian */
            invokeinterface java.sql.Connection.createStatement:()Ljava/sql/Statement;
            astore 10 /* Stmt */
        start local 10 // java.sql.Statement Stmt
        33: .line 240
            aload 10 /* Stmt */
            ldc "SHUTDOWN IMMEDIATELY"
            invokeinterface java.sql.Statement.execute:(Ljava/lang/String;)Z
            pop
        34: .line 241
            aload 10 /* Stmt */
            invokeinterface java.sql.Statement.close:()V
        35: .line 242
            aload 5 /* guardian */
            invokestatic org.hsqldb.test.JDBCBench.connectClose:(Ljava/sql/Connection;)V
        end local 10 // java.sql.Statement Stmt
        36: .line 245
      StackMap locals:
      StackMap stack:
            getstatic org.hsqldb.test.JDBCBench.TabFile:Ljava/io/PrintStream;
            ifnull 66
        37: .line 246
            getstatic org.hsqldb.test.JDBCBench.TabFile:Ljava/io/PrintStream;
            invokevirtual java.io.PrintStream.close:()V
        38: .line 248
            goto 66
      StackMap locals:
      StackMap stack: java.lang.Exception
        39: pop
            goto 66
        40: .line 229
      StackMap locals:
      StackMap stack: java.lang.Throwable
            astore 9
        41: .line 230
            aload 0 /* this */
            getfield org.hsqldb.test.JDBCBench.MemoryWatcher:Lorg/hsqldb/test/JDBCBench$MemoryWatcherThread;
            invokevirtual org.hsqldb.test.JDBCBench$MemoryWatcherThread.end:()V
        42: .line 233
            aload 0 /* this */
            getfield org.hsqldb.test.JDBCBench.MemoryWatcher:Lorg/hsqldb/test/JDBCBench$MemoryWatcherThread;
            invokevirtual org.hsqldb.test.JDBCBench$MemoryWatcherThread.join:()V
        43: .line 235
            getstatic org.hsqldb.test.JDBCBench.ShutdownCommand:Ljava/lang/String;
            invokevirtual java.lang.String.length:()I
            ifle 49
        44: .line 236
            aload 1 /* url */
            aload 2 /* user */
            aload 3 /* password */
            invokestatic org.hsqldb.test.JDBCBench.connect:(Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;)Ljava/sql/Connection;
            astore 5 /* guardian */
        45: .line 238
            aload 5 /* guardian */
            invokeinterface java.sql.Connection.createStatement:()Ljava/sql/Statement;
            astore 10 /* Stmt */
        start local 10 // java.sql.Statement Stmt
        46: .line 240
            aload 10 /* Stmt */
            ldc "SHUTDOWN IMMEDIATELY"
            invokeinterface java.sql.Statement.execute:(Ljava/lang/String;)Z
            pop
        47: .line 241
            aload 10 /* Stmt */
            invokeinterface java.sql.Statement.close:()V
        48: .line 242
            aload 5 /* guardian */
            invokestatic org.hsqldb.test.JDBCBench.connectClose:(Ljava/sql/Connection;)V
        end local 10 // java.sql.Statement Stmt
        49: .line 245
      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: .line 246
            getstatic org.hsqldb.test.JDBCBench.TabFile:Ljava/io/PrintStream;
            invokevirtual java.io.PrintStream.close:()V
        51: .line 248
            goto 53
      StackMap locals:
      StackMap stack: java.lang.Exception
        52: pop
        53: .line 251
      StackMap locals:
      StackMap stack:
            aload 9
            athrow
        54: .line 230
      StackMap locals: org.hsqldb.test.JDBCBench java.lang.String java.lang.String java.lang.String int java.sql.Connection
      StackMap stack:
            aload 0 /* this */
            getfield org.hsqldb.test.JDBCBench.MemoryWatcher:Lorg/hsqldb/test/JDBCBench$MemoryWatcherThread;
            invokevirtual org.hsqldb.test.JDBCBench$MemoryWatcherThread.end:()V
        55: .line 233
            aload 0 /* this */
            getfield org.hsqldb.test.JDBCBench.MemoryWatcher:Lorg/hsqldb/test/JDBCBench$MemoryWatcherThread;
            invokevirtual org.hsqldb.test.JDBCBench$MemoryWatcherThread.join:()V
        56: .line 235
            getstatic org.hsqldb.test.JDBCBench.ShutdownCommand:Ljava/lang/String;
            invokevirtual java.lang.String.length:()I
            ifle 62
        57: .line 236
            aload 1 /* url */
            aload 2 /* user */
            aload 3 /* password */
            invokestatic org.hsqldb.test.JDBCBench.connect:(Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;)Ljava/sql/Connection;
            astore 5 /* guardian */
        58: .line 238
            aload 5 /* guardian */
            invokeinterface java.sql.Connection.createStatement:()Ljava/sql/Statement;
            astore 10 /* Stmt */
        start local 10 // java.sql.Statement Stmt
        59: .line 240
            aload 10 /* Stmt */
            ldc "SHUTDOWN IMMEDIATELY"
            invokeinterface java.sql.Statement.execute:(Ljava/lang/String;)Z
            pop
        60: .line 241
            aload 10 /* Stmt */
            invokeinterface java.sql.Statement.close:()V
        61: .line 242
            aload 5 /* guardian */
            invokestatic org.hsqldb.test.JDBCBench.connectClose:(Ljava/sql/Connection;)V
        end local 10 // java.sql.Statement Stmt
        62: .line 245
      StackMap locals:
      StackMap stack:
            getstatic org.hsqldb.test.JDBCBench.TabFile:Ljava/io/PrintStream;
            ifnull 66
        63: .line 246
            getstatic org.hsqldb.test.JDBCBench.TabFile:Ljava/io/PrintStream;
            invokevirtual java.io.PrintStream.close:()V
        64: .line 248
            goto 66
      StackMap locals:
      StackMap stack: java.lang.Exception
        65: pop
        66: .line 252
      StackMap locals:
      StackMap stack:
            return
        end local 5 // java.sql.Connection guardian
        end local 4 // boolean init
        end local 3 // java.lang.String password
        end local 2 // java.lang.String user
        end local 1 // java.lang.String url
        end local 0 // org.hsqldb.test.JDBCBench this
      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 // org.hsqldb.test.JDBCBench this
        start local 1 // java.lang.String url
        start local 2 // java.lang.String user
        start local 3 // java.lang.String password
        start local 4 // boolean transactions
        start local 5 // boolean prepared
         0: .line 258
            new java.util.Vector
            dup
            invokespecial java.util.Vector.<init>:()V
            astore 6 /* vClient */
        start local 6 // java.util.Vector vClient
         1: .line 259
            aconst_null
            astore 7 /* Client */
        start local 7 // java.lang.Thread Client
         2: .line 260
            aconst_null
            astore 8 /* e */
        start local 8 // java.util.Enumeration e
         3: .line 261
            aconst_null
            astore 9 /* guardian */
        start local 9 // java.sql.Connection guardian
         4: .line 264
            iload 4 /* transactions */
            putstatic org.hsqldb.test.JDBCBench.transactions:Z
         5: .line 265
            iload 5 /* prepared */
            putstatic org.hsqldb.test.JDBCBench.prepared_stmt:Z
         6: .line 266
            aload 0 /* this */
            invokestatic java.lang.System.currentTimeMillis:()J
            putfield org.hsqldb.test.JDBCBench.start_time:J
         7: .line 268
            iconst_0
            istore 10 /* i */
        start local 10 // int i
         8: goto 15
         9: .line 269
      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 /* this */
            getstatic org.hsqldb.test.JDBCBench.n_txn_per_client:I
            aload 1 /* url */
            aload 2 /* user */
            aload 3 /* password */
        10: .line 270
            iconst_2
        11: .line 269
            invokespecial org.hsqldb.test.JDBCBench$ClientThread.<init>:(Lorg/hsqldb/test/JDBCBench;ILjava/lang/String;Ljava/lang/String;Ljava/lang/String;I)V
            astore 7 /* Client */
        12: .line 272
            aload 7 /* Client */
            invokevirtual java.lang.Thread.start:()V
        13: .line 273
            aload 6 /* vClient */
            aload 7 /* Client */
            invokevirtual java.util.Vector.addElement:(Ljava/lang/Object;)V
        14: .line 268
            iinc 10 /* i */ 1
      StackMap locals:
      StackMap stack:
        15: iload 10 /* i */
            getstatic org.hsqldb.test.JDBCBench.n_clients:I
            if_icmplt 9
        end local 10 // int i
        16: .line 279
            aload 6 /* vClient */
            invokevirtual java.util.Vector.elements:()Ljava/util/Enumeration;
            astore 8 /* e */
        17: .line 281
            goto 20
        18: .line 282
      StackMap locals:
      StackMap stack:
            aload 8 /* e */
            invokeinterface java.util.Enumeration.nextElement:()Ljava/lang/Object;
            checkcast java.lang.Thread
            astore 7 /* Client */
        19: .line 284
            aload 7 /* Client */
            invokevirtual java.lang.Thread.join:()V
        20: .line 281
      StackMap locals:
      StackMap stack:
            aload 8 /* e */
            invokeinterface java.util.Enumeration.hasMoreElements:()Z
            ifne 18
        21: .line 287
            aload 6 /* vClient */
            invokevirtual java.util.Vector.removeAllElements:()V
        22: .line 288
            aload 0 /* this */
            invokevirtual org.hsqldb.test.JDBCBench.reportDone:()V
        23: .line 290
            aload 1 /* url */
            aload 2 /* user */
            aload 3 /* password */
            invokestatic org.hsqldb.test.JDBCBench.connect:(Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;)Ljava/sql/Connection;
            astore 9 /* guardian */
        24: .line 292
            aload 0 /* this */
            aload 9 /* guardian */
            invokevirtual org.hsqldb.test.JDBCBench.checkSums:(Ljava/sql/Connection;)V
        25: .line 293
            aload 9 /* guardian */
            invokestatic org.hsqldb.test.JDBCBench.connectClose:(Ljava/sql/Connection;)V
        26: .line 294
            return
        end local 9 // java.sql.Connection guardian
        end local 8 // java.util.Enumeration e
        end local 7 // java.lang.Thread Client
        end local 6 // java.util.Vector vClient
        end local 5 // boolean prepared
        end local 4 // boolean transactions
        end local 3 // java.lang.String password
        end local 2 // java.lang.String user
        end local 1 // java.lang.String url
        end local 0 // org.hsqldb.test.JDBCBench this
      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 // org.hsqldb.test.JDBCBench this
         0: .line 298
            invokestatic java.lang.System.currentTimeMillis:()J
            lstore 1 /* end_time */
        start local 1 // long end_time
         1: .line 299
            lload 1 /* end_time */
            l2d
            aload 0 /* this */
            getfield org.hsqldb.test.JDBCBench.start_time:J
            l2d
            dsub
         2: .line 300
            ldc 1000.0
         3: .line 299
            ddiv
            dstore 3 /* completion_time */
        start local 3 // double completion_time
         4: .line 302
            getstatic org.hsqldb.test.JDBCBench.TabFile:Ljava/io/PrintStream;
            ifnull 8
         5: .line 303
            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: .line 304
            ldc ";"
            invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
            invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
         7: .line 303
            invokevirtual java.io.PrintStream.print:(Ljava/lang/String;)V
         8: .line 307
      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: .line 308
            getstatic java.lang.System.out:Ljava/io/PrintStream;
            ldc "* Featuring "
            invokevirtual java.io.PrintStream.print:(Ljava/lang/String;)V
        10: .line 310
            getstatic org.hsqldb.test.JDBCBench.prepared_stmt:Z
            ifeq 15
        11: .line 311
            getstatic java.lang.System.out:Ljava/io/PrintStream;
            ldc "<prepared statements> "
            invokevirtual java.io.PrintStream.print:(Ljava/lang/String;)V
        12: .line 313
            getstatic org.hsqldb.test.JDBCBench.TabFile:Ljava/io/PrintStream;
            ifnull 18
        13: .line 314
            getstatic org.hsqldb.test.JDBCBench.TabFile:Ljava/io/PrintStream;
            ldc "<prepared statements>;"
            invokevirtual java.io.PrintStream.print:(Ljava/lang/String;)V
        14: .line 316
            goto 18
        15: .line 317
      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: .line 319
            getstatic org.hsqldb.test.JDBCBench.TabFile:Ljava/io/PrintStream;
            ifnull 18
        17: .line 320
            getstatic org.hsqldb.test.JDBCBench.TabFile:Ljava/io/PrintStream;
            ldc "<direct queries>;"
            invokevirtual java.io.PrintStream.print:(Ljava/lang/String;)V
        18: .line 324
      StackMap locals:
      StackMap stack:
            getstatic org.hsqldb.test.JDBCBench.transactions:Z
            ifeq 23
        19: .line 325
            getstatic java.lang.System.out:Ljava/io/PrintStream;
            ldc "<transactions> "
            invokevirtual java.io.PrintStream.print:(Ljava/lang/String;)V
        20: .line 327
            getstatic org.hsqldb.test.JDBCBench.TabFile:Ljava/io/PrintStream;
            ifnull 26
        21: .line 328
            getstatic org.hsqldb.test.JDBCBench.TabFile:Ljava/io/PrintStream;
            ldc "<transactions>;"
            invokevirtual java.io.PrintStream.print:(Ljava/lang/String;)V
        22: .line 330
            goto 26
        23: .line 331
      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: .line 333
            getstatic org.hsqldb.test.JDBCBench.TabFile:Ljava/io/PrintStream;
            ifnull 26
        25: .line 334
            getstatic org.hsqldb.test.JDBCBench.TabFile:Ljava/io/PrintStream;
            ldc "<auto-commit>;"
            invokevirtual java.io.PrintStream.print:(Ljava/lang/String;)V
        26: .line 338
      StackMap locals:
      StackMap stack:
            getstatic java.lang.System.out:Ljava/io/PrintStream;
            ldc "\n--------------------"
            invokevirtual java.io.PrintStream.println:(Ljava/lang/String;)V
        27: .line 339
            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 /* this */
            getfield org.hsqldb.test.JDBCBench.transaction_count:I
            invokevirtual java.lang.StringBuilder.append:(I)Ljava/lang/StringBuilder;
        28: .line 340
            ldc " transactions: "
            invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
            dload 3 /* completion_time */
            invokevirtual java.lang.StringBuilder.append:(D)Ljava/lang/StringBuilder;
        29: .line 341
            ldc " seconds."
            invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
            invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
        30: .line 339
            invokevirtual java.io.PrintStream.println:(Ljava/lang/String;)V
        31: .line 342
            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: .line 343
            aload 0 /* this */
            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: .line 344
            aload 0 /* this */
            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: .line 342
            invokevirtual java.io.PrintStream.println:(Ljava/lang/String;)V
        35: .line 345
            getstatic java.lang.System.out:Ljava/io/PrintStream;
            new java.lang.StringBuilder
            dup
            aload 0 /* this */
            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 /* this */
            getfield org.hsqldb.test.JDBCBench.transaction_count:I
            invokevirtual java.lang.StringBuilder.append:(I)Ljava/lang/StringBuilder;
        36: .line 346
            ldc " failed to complete."
            invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
            invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
        37: .line 345
            invokevirtual java.io.PrintStream.println:(Ljava/lang/String;)V
        38: .line 348
            aload 0 /* this */
            getfield org.hsqldb.test.JDBCBench.transaction_count:I
            aload 0 /* this */
            getfield org.hsqldb.test.JDBCBench.failed_transactions:I
            isub
            i2d
        39: .line 349
            dload 3 /* completion_time */
        40: .line 348
            ddiv
            dstore 5 /* rate */
        start local 5 // double rate
        41: .line 351
            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 /* rate */
            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: .line 353
            getstatic org.hsqldb.test.JDBCBench.TabFile:Ljava/io/PrintStream;
            ifnull 47
        43: .line 354
            getstatic org.hsqldb.test.JDBCBench.TabFile:Ljava/io/PrintStream;
            new java.lang.StringBuilder
            dup
            aload 0 /* this */
            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: .line 355
            aload 0 /* this */
            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: .line 356
            aload 0 /* this */
            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 /* rate */
            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: .line 354
            invokevirtual java.io.PrintStream.print:(Ljava/lang/String;)V
        47: .line 359
      StackMap locals: double
      StackMap stack:
            aload 0 /* this */
            iconst_0
            putfield org.hsqldb.test.JDBCBench.transaction_count:I
        48: .line 360
            aload 0 /* this */
            iconst_0
            putfield org.hsqldb.test.JDBCBench.failed_transactions:I
        49: .line 362
            aload 0 /* this */
            getfield org.hsqldb.test.JDBCBench.MemoryWatcher:Lorg/hsqldb/test/JDBCBench$MemoryWatcherThread;
            invokevirtual org.hsqldb.test.JDBCBench$MemoryWatcherThread.reset:()V
        50: .line 363
            return
        end local 5 // double rate
        end local 3 // double completion_time
        end local 1 // long end_time
        end local 0 // org.hsqldb.test.JDBCBench this
      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 // org.hsqldb.test.JDBCBench this
         0: .line 366
            aload 0 /* this */
            dup
            getfield org.hsqldb.test.JDBCBench.transaction_count:I
            iconst_1
            iadd
            putfield org.hsqldb.test.JDBCBench.transaction_count:I
         1: .line 367
            return
        end local 0 // org.hsqldb.test.JDBCBench this
      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 // org.hsqldb.test.JDBCBench this
         0: .line 370
            aload 0 /* this */
            dup
            getfield org.hsqldb.test.JDBCBench.failed_transactions:I
            iconst_1
            iadd
            putfield org.hsqldb.test.JDBCBench.failed_transactions:I
         1: .line 371
            return
        end local 0 // org.hsqldb.test.JDBCBench this
      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 // org.hsqldb.test.JDBCBench this
        start local 1 // java.lang.String url
        start local 2 // java.lang.String user
        start local 3 // java.lang.String password
         0: .line 376
            aload 1 /* url */
            aload 2 /* user */
            aload 3 /* password */
            invokestatic org.hsqldb.test.JDBCBench.connect:(Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;)Ljava/sql/Connection;
            astore 4 /* Conn */
        start local 4 // java.sql.Connection Conn
         1: .line 377
            aload 4 /* Conn */
            invokeinterface java.sql.Connection.getMetaData:()Ljava/sql/DatabaseMetaData;
            invokeinterface java.sql.DatabaseMetaData.getDatabaseProductName:()Ljava/lang/String;
            astore 5 /* s */
        start local 5 // java.lang.String s
         2: .line 379
            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 /* s */
            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: .line 381
            iconst_1
            putstatic org.hsqldb.test.JDBCBench.transactions:Z
         4: .line 383
            getstatic org.hsqldb.test.JDBCBench.transactions:Z
            ifeq 10
         5: .line 385
            aload 4 /* Conn */
            iconst_0
            invokeinterface java.sql.Connection.setAutoCommit:(Z)V
         6: .line 386
            getstatic java.lang.System.out:Ljava/io/PrintStream;
            ldc "In transaction mode"
            invokevirtual java.io.PrintStream.println:(Ljava/lang/String;)V
         7: .line 387
            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: .line 388
            iconst_0
            putstatic org.hsqldb.test.JDBCBench.transactions:Z
        10: .line 393
      StackMap locals:
      StackMap stack:
            iconst_0
            istore 6 /* accountsnb */
        start local 6 // int accountsnb
        11: .line 394
            aload 4 /* Conn */
            invokeinterface java.sql.Connection.createStatement:()Ljava/sql/Statement;
            astore 7 /* Stmt */
        start local 7 // java.sql.Statement Stmt
        12: .line 398
            aload 7 /* Stmt */
            ldc "SET WRITE_DELAY 10000 MILLIS;"
            invokeinterface java.sql.Statement.execute:(Ljava/lang/String;)Z
            pop
        13: .line 399
            aload 7 /* Stmt */
            ldc "SET PROPERTY \"hsqldb.cache_scale\" 16;"
            invokeinterface java.sql.Statement.execute:(Ljava/lang/String;)Z
            pop
        14: .line 402
            ldc "SELECT count(*) "
            astore 8 /* Query */
        start local 8 // java.lang.String Query
        15: .line 403
            new java.lang.StringBuilder
            dup
            aload 8 /* Query */
            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 /* Query */
        16: .line 405
            aload 7 /* Stmt */
            aload 8 /* Query */
            invokeinterface java.sql.Statement.executeQuery:(Ljava/lang/String;)Ljava/sql/ResultSet;
            astore 9 /* RS */
        start local 9 // java.sql.ResultSet RS
        17: .line 407
            aload 7 /* Stmt */
            invokeinterface java.sql.Statement.clearWarnings:()V
        18: .line 409
            goto 20
        19: .line 410
      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 /* RS */
            iconst_1
            invokeinterface java.sql.ResultSet.getInt:(I)I
            istore 6 /* accountsnb */
        20: .line 409
      StackMap locals:
      StackMap stack:
            aload 9 /* RS */
            invokeinterface java.sql.ResultSet.next:()Z
            ifne 19
        21: .line 413
            getstatic org.hsqldb.test.JDBCBench.transactions:Z
            ifeq 23
        22: .line 414
            aload 4 /* Conn */
            invokeinterface java.sql.Connection.commit:()V
        23: .line 417
      StackMap locals:
      StackMap stack:
            aload 7 /* Stmt */
            invokeinterface java.sql.Statement.close:()V
        24: .line 419
            iload 6 /* accountsnb */
            getstatic org.hsqldb.test.JDBCBench.naccounts:I
            getstatic org.hsqldb.test.JDBCBench.tps:I
            imul
            if_icmpne 29
        25: .line 420
            getstatic java.lang.System.out:Ljava/io/PrintStream;
            ldc "Already initialized"
            invokevirtual java.io.PrintStream.println:(Ljava/lang/String;)V
        26: .line 421
            aload 4 /* Conn */
            invokestatic org.hsqldb.test.JDBCBench.connectClose:(Ljava/sql/Connection;)V
        27: .line 423
            return
        end local 9 // java.sql.ResultSet RS
        end local 8 // java.lang.String Query
        end local 7 // java.sql.Statement Stmt
        end local 6 // int accountsnb
        28: .line 425
      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: .line 427
      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: .line 430
            aload 4 /* Conn */
            invokeinterface java.sql.Connection.createStatement:()Ljava/sql/Statement;
            astore 6 /* Stmt */
        start local 6 // java.sql.Statement Stmt
        31: .line 433
            ldc "DROP TABLE history"
            astore 7 /* Query */
        start local 7 // java.lang.String Query
        32: .line 435
            aload 6 /* Stmt */
            aload 7 /* Query */
            invokeinterface java.sql.Statement.execute:(Ljava/lang/String;)Z
            pop
        33: .line 436
            aload 6 /* Stmt */
            invokeinterface java.sql.Statement.clearWarnings:()V
        34: .line 438
            ldc "DROP TABLE accounts"
            astore 7 /* Query */
        35: .line 440
            aload 6 /* Stmt */
            aload 7 /* Query */
            invokeinterface java.sql.Statement.execute:(Ljava/lang/String;)Z
            pop
        36: .line 441
            aload 6 /* Stmt */
            invokeinterface java.sql.Statement.clearWarnings:()V
        37: .line 443
            ldc "DROP TABLE tellers"
            astore 7 /* Query */
        38: .line 445
            aload 6 /* Stmt */
            aload 7 /* Query */
            invokeinterface java.sql.Statement.execute:(Ljava/lang/String;)Z
            pop
        39: .line 446
            aload 6 /* Stmt */
            invokeinterface java.sql.Statement.clearWarnings:()V
        40: .line 448
            ldc "DROP TABLE branches"
            astore 7 /* Query */
        41: .line 450
            aload 6 /* Stmt */
            aload 7 /* Query */
            invokeinterface java.sql.Statement.execute:(Ljava/lang/String;)Z
            pop
        42: .line 451
            aload 6 /* Stmt */
            invokeinterface java.sql.Statement.clearWarnings:()V
        43: .line 453
            getstatic org.hsqldb.test.JDBCBench.transactions:Z
            ifeq 45
        44: .line 454
            aload 4 /* Conn */
            invokeinterface java.sql.Connection.commit:()V
        45: .line 457
      StackMap locals: java.sql.Statement java.lang.String
      StackMap stack:
            aload 6 /* Stmt */
            invokeinterface java.sql.Statement.close:()V
        end local 7 // java.lang.String Query
        end local 6 // java.sql.Statement Stmt
        46: .line 458
            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: .line 460
      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: .line 463
            aload 4 /* Conn */
            invokeinterface java.sql.Connection.createStatement:()Ljava/sql/Statement;
            astore 6 /* Stmt */
        start local 6 // java.sql.Statement Stmt
        50: .line 466
            getstatic org.hsqldb.test.JDBCBench.tableExtension:Ljava/lang/String;
            invokevirtual java.lang.String.length:()I
            ifle 53
        51: .line 467
            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 /* Query */
        start local 7 // java.lang.String Query
        52: .line 468
            goto 54
        end local 7 // java.lang.String Query
        53: .line 469
      StackMap locals: java.sql.Statement
      StackMap stack:
            ldc "CREATE TABLE branches ("
            astore 7 /* Query */
        start local 7 // java.lang.String Query
        54: .line 472
      StackMap locals: java.lang.String
      StackMap stack:
            new java.lang.StringBuilder
            dup
            aload 7 /* Query */
            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 /* Query */
        55: .line 473
            new java.lang.StringBuilder
            dup
            aload 7 /* Query */
            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 /* Query */
        56: .line 474
            new java.lang.StringBuilder
            dup
            aload 7 /* Query */
            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 /* Query */
        57: .line 476
            getstatic org.hsqldb.test.JDBCBench.createExtension:Ljava/lang/String;
            invokevirtual java.lang.String.length:()I
            ifle 59
        58: .line 477
            new java.lang.StringBuilder
            dup
            aload 7 /* Query */
            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 /* Query */
        59: .line 480
      StackMap locals:
      StackMap stack:
            aload 6 /* Stmt */
            aload 7 /* Query */
            invokeinterface java.sql.Statement.execute:(Ljava/lang/String;)Z
            pop
        60: .line 481
            aload 6 /* Stmt */
            invokeinterface java.sql.Statement.clearWarnings:()V
        61: .line 483
            getstatic org.hsqldb.test.JDBCBench.tableExtension:Ljava/lang/String;
            invokevirtual java.lang.String.length:()I
            ifle 64
        62: .line 484
            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 /* Query */
        63: .line 485
            goto 65
        64: .line 486
      StackMap locals:
      StackMap stack:
            ldc "CREATE TABLE tellers ("
            astore 7 /* Query */
        65: .line 489
      StackMap locals:
      StackMap stack:
            new java.lang.StringBuilder
            dup
            aload 7 /* Query */
            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 /* Query */
        66: .line 490
            new java.lang.StringBuilder
            dup
            aload 7 /* Query */
            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 /* Query */
        67: .line 491
            new java.lang.StringBuilder
            dup
            aload 7 /* Query */
            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 /* Query */
        68: .line 492
            new java.lang.StringBuilder
            dup
            aload 7 /* Query */
            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 /* Query */
        69: .line 494
            getstatic org.hsqldb.test.JDBCBench.createExtension:Ljava/lang/String;
            invokevirtual java.lang.String.length:()I
            ifle 71
        70: .line 495
            new java.lang.StringBuilder
            dup
            aload 7 /* Query */
            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 /* Query */
        71: .line 498
      StackMap locals:
      StackMap stack:
            aload 6 /* Stmt */
            aload 7 /* Query */
            invokeinterface java.sql.Statement.execute:(Ljava/lang/String;)Z
            pop
        72: .line 499
            aload 6 /* Stmt */
            invokeinterface java.sql.Statement.clearWarnings:()V
        73: .line 501
            getstatic org.hsqldb.test.JDBCBench.tableExtension:Ljava/lang/String;
            invokevirtual java.lang.String.length:()I
            ifle 76
        74: .line 502
            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 /* Query */
        75: .line 503
            goto 77
        76: .line 504
      StackMap locals:
      StackMap stack:
            ldc "CREATE TABLE accounts ("
            astore 7 /* Query */
        77: .line 507
      StackMap locals:
      StackMap stack:
            new java.lang.StringBuilder
            dup
            aload 7 /* Query */
            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 /* Query */
        78: .line 508
            new java.lang.StringBuilder
            dup
            aload 7 /* Query */
            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 /* Query */
        79: .line 509
            new java.lang.StringBuilder
            dup
            aload 7 /* Query */
            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 /* Query */
        80: .line 510
            new java.lang.StringBuilder
            dup
            aload 7 /* Query */
            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 /* Query */
        81: .line 512
            getstatic org.hsqldb.test.JDBCBench.createExtension:Ljava/lang/String;
            invokevirtual java.lang.String.length:()I
            ifle 83
        82: .line 513
            new java.lang.StringBuilder
            dup
            aload 7 /* Query */
            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 /* Query */
        83: .line 516
      StackMap locals:
      StackMap stack:
            aload 6 /* Stmt */
            aload 7 /* Query */
            invokeinterface java.sql.Statement.execute:(Ljava/lang/String;)Z
            pop
        84: .line 517
            aload 6 /* Stmt */
            invokeinterface java.sql.Statement.clearWarnings:()V
        85: .line 519
            getstatic org.hsqldb.test.JDBCBench.tableExtension:Ljava/lang/String;
            invokevirtual java.lang.String.length:()I
            ifle 88
        86: .line 520
            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 /* Query */
        87: .line 521
            goto 89
        88: .line 522
      StackMap locals:
      StackMap stack:
            ldc "CREATE TABLE history ("
            astore 7 /* Query */
        89: .line 525
      StackMap locals:
      StackMap stack:
            new java.lang.StringBuilder
            dup
            aload 7 /* Query */
            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 /* Query */
        90: .line 526
            new java.lang.StringBuilder
            dup
            aload 7 /* Query */
            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 /* Query */
        91: .line 527
            new java.lang.StringBuilder
            dup
            aload 7 /* Query */
            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 /* Query */
        92: .line 528
            new java.lang.StringBuilder
            dup
            aload 7 /* Query */
            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 /* Query */
        93: .line 529
            new java.lang.StringBuilder
            dup
            aload 7 /* Query */
            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 /* Query */
        94: .line 530
            new java.lang.StringBuilder
            dup
            aload 7 /* Query */
            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 /* Query */
        95: .line 532
            getstatic org.hsqldb.test.JDBCBench.createExtension:Ljava/lang/String;
            invokevirtual java.lang.String.length:()I
            ifle 97
        96: .line 533
            new java.lang.StringBuilder
            dup
            aload 7 /* Query */
            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 /* Query */
        97: .line 536
      StackMap locals:
      StackMap stack:
            aload 6 /* Stmt */
            aload 7 /* Query */
            invokeinterface java.sql.Statement.execute:(Ljava/lang/String;)Z
            pop
        98: .line 537
            aload 6 /* Stmt */
            invokeinterface java.sql.Statement.clearWarnings:()V
        99: .line 545
            getstatic org.hsqldb.test.JDBCBench.transactions:Z
            ifeq 101
       100: .line 546
            aload 4 /* Conn */
            invokeinterface java.sql.Connection.commit:()V
       101: .line 549
      StackMap locals:
      StackMap stack:
            aload 6 /* Stmt */
            invokeinterface java.sql.Statement.close:()V
        end local 7 // java.lang.String Query
        end local 6 // java.sql.Statement Stmt
       102: .line 550
            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: .line 551
            getstatic java.lang.System.out:Ljava/io/PrintStream;
       105: .line 552
            ldc "Delete elements in table in case Drop didn't work"
       106: .line 551
            invokevirtual java.io.PrintStream.println:(Ljava/lang/String;)V
       107: .line 555
      StackMap locals:
      StackMap stack:
            getstatic java.lang.System.out:Ljava/io/PrintStream;
       108: .line 556
            ldc "Delete elements in table in case Drop didn't work"
       109: .line 555
            invokevirtual java.io.PrintStream.println:(Ljava/lang/String;)V
       110: .line 559
            aload 4 /* Conn */
            invokeinterface java.sql.Connection.createStatement:()Ljava/sql/Statement;
            astore 6 /* Stmt */
        start local 6 // java.sql.Statement Stmt
       111: .line 562
            ldc "DELETE FROM history"
            astore 7 /* Query */
        start local 7 // java.lang.String Query
       112: .line 564
            aload 6 /* Stmt */
            aload 7 /* Query */
            invokeinterface java.sql.Statement.execute:(Ljava/lang/String;)Z
            pop
       113: .line 565
            aload 6 /* Stmt */
            invokeinterface java.sql.Statement.clearWarnings:()V
       114: .line 567
            ldc "DELETE FROM accounts"
            astore 7 /* Query */
       115: .line 569
            aload 6 /* Stmt */
            aload 7 /* Query */
            invokeinterface java.sql.Statement.execute:(Ljava/lang/String;)Z
            pop
       116: .line 570
            aload 6 /* Stmt */
            invokeinterface java.sql.Statement.clearWarnings:()V
       117: .line 572
            ldc "DELETE FROM tellers"
            astore 7 /* Query */
       118: .line 574
            aload 6 /* Stmt */
            aload 7 /* Query */
            invokeinterface java.sql.Statement.execute:(Ljava/lang/String;)Z
            pop
       119: .line 575
            aload 6 /* Stmt */
            invokeinterface java.sql.Statement.clearWarnings:()V
       120: .line 577
            ldc "DELETE FROM branches"
            astore 7 /* Query */
       121: .line 579
            aload 6 /* Stmt */
            aload 7 /* Query */
            invokeinterface java.sql.Statement.execute:(Ljava/lang/String;)Z
            pop
       122: .line 580
            aload 6 /* Stmt */
            invokeinterface java.sql.Statement.clearWarnings:()V
       123: .line 582
            getstatic org.hsqldb.test.JDBCBench.transactions:Z
            ifeq 125
       124: .line 583
            aload 4 /* Conn */
            invokeinterface java.sql.Connection.commit:()V
       125: .line 591
      StackMap locals: java.sql.Statement java.lang.String
      StackMap stack:
            aconst_null
            astore 8 /* pstmt */
        start local 8 // java.sql.PreparedStatement pstmt
       126: .line 593
            iconst_1
            putstatic org.hsqldb.test.JDBCBench.prepared_stmt:Z
       127: .line 595
            getstatic org.hsqldb.test.JDBCBench.prepared_stmt:Z
            ifeq 135
       128: .line 597
            ldc "INSERT INTO branches(Bid,Bbalance) VALUES (?,0)"
            astore 7 /* Query */
       129: .line 598
            aload 4 /* Conn */
            aload 7 /* Query */
            invokeinterface java.sql.Connection.prepareStatement:(Ljava/lang/String;)Ljava/sql/PreparedStatement;
            astore 8 /* pstmt */
       130: .line 600
            getstatic java.lang.System.out:Ljava/io/PrintStream;
            ldc "Using prepared statements"
            invokevirtual java.io.PrintStream.println:(Ljava/lang/String;)V
       131: .line 601
            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: .line 602
            aconst_null
            astore 8 /* pstmt */
       134: .line 603
            iconst_0
            putstatic org.hsqldb.test.JDBCBench.prepared_stmt:Z
       135: .line 607
      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: .line 609
            iconst_0
            istore 9 /* i */
        start local 9 // int i
       137: goto 150
       138: .line 610
      StackMap locals: int
      StackMap stack:
            getstatic org.hsqldb.test.JDBCBench.prepared_stmt:Z
            ifeq 143
       139: .line 611
            aload 8 /* pstmt */
            iconst_1
            iload 9 /* i */
            invokeinterface java.sql.PreparedStatement.setInt:(II)V
       140: .line 612
            aload 8 /* pstmt */
            invokeinterface java.sql.PreparedStatement.executeUpdate:()I
            pop
       141: .line 613
            aload 8 /* pstmt */
            invokeinterface java.sql.PreparedStatement.clearWarnings:()V
       142: .line 614
            goto 147
       143: .line 615
      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 /* i */
            invokevirtual java.lang.StringBuilder.append:(I)Ljava/lang/StringBuilder;
       144: .line 616
            ldc ",0)"
            invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
       145: .line 615
            invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
            astore 7 /* Query */
       146: .line 618
            aload 6 /* Stmt */
            aload 7 /* Query */
            invokeinterface java.sql.Statement.executeUpdate:(Ljava/lang/String;)I
            pop
       147: .line 621
      StackMap locals:
      StackMap stack:
            iload 9 /* i */
            bipush 100
            irem
            ifne 149
            getstatic org.hsqldb.test.JDBCBench.transactions:Z
            ifeq 149
       148: .line 622
            aload 4 /* Conn */
            invokeinterface java.sql.Connection.commit:()V
       149: .line 609
      StackMap locals:
      StackMap stack:
            iinc 9 /* i */ 1
      StackMap locals:
      StackMap stack:
       150: iload 9 /* i */
            getstatic org.hsqldb.test.JDBCBench.nbranches:I
            getstatic org.hsqldb.test.JDBCBench.tps:I
            imul
            if_icmplt 138
        end local 9 // int i
       151: .line 626
            getstatic org.hsqldb.test.JDBCBench.prepared_stmt:Z
            ifeq 153
       152: .line 627
            aload 8 /* pstmt */
            invokeinterface java.sql.PreparedStatement.close:()V
       153: .line 630
      StackMap locals:
      StackMap stack:
            getstatic org.hsqldb.test.JDBCBench.transactions:Z
            ifeq 155
       154: .line 631
            aload 4 /* Conn */
            invokeinterface java.sql.Connection.commit:()V
       155: .line 634
      StackMap locals:
      StackMap stack:
            getstatic org.hsqldb.test.JDBCBench.prepared_stmt:Z
            ifeq 158
       156: .line 635
            ldc "INSERT INTO tellers(Tid,Bid,Tbalance) VALUES (?,?,0)"
            astore 7 /* Query */
       157: .line 636
            aload 4 /* Conn */
            aload 7 /* Query */
            invokeinterface java.sql.Connection.prepareStatement:(Ljava/lang/String;)Ljava/sql/PreparedStatement;
            astore 8 /* pstmt */
       158: .line 639
      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: .line 641
            iconst_0
            istore 9 /* i */
        start local 9 // int i
       160: goto 174
       161: .line 642
      StackMap locals: int
      StackMap stack:
            getstatic org.hsqldb.test.JDBCBench.prepared_stmt:Z
            ifeq 167
       162: .line 643
            aload 8 /* pstmt */
            iconst_1
            iload 9 /* i */
            invokeinterface java.sql.PreparedStatement.setInt:(II)V
       163: .line 644
            aload 8 /* pstmt */
            iconst_2
            iload 9 /* i */
            getstatic org.hsqldb.test.JDBCBench.ntellers:I
            idiv
            invokeinterface java.sql.PreparedStatement.setInt:(II)V
       164: .line 645
            aload 8 /* pstmt */
            invokeinterface java.sql.PreparedStatement.executeUpdate:()I
            pop
       165: .line 646
            aload 8 /* pstmt */
            invokeinterface java.sql.PreparedStatement.clearWarnings:()V
       166: .line 647
            goto 171
       167: .line 648
      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: .line 649
            iload 9 /* i */
            invokevirtual java.lang.StringBuilder.append:(I)Ljava/lang/StringBuilder;
            ldc ","
            invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
            iload 9 /* i */
            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: .line 648
            invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
            astore 7 /* Query */
       170: .line 651
            aload 6 /* Stmt */
            aload 7 /* Query */
            invokeinterface java.sql.Statement.executeUpdate:(Ljava/lang/String;)I
            pop
       171: .line 654
      StackMap locals:
      StackMap stack:
            iload 9 /* i */
            bipush 100
            irem
            ifne 173
            getstatic org.hsqldb.test.JDBCBench.transactions:Z
            ifeq 173
       172: .line 655
            aload 4 /* Conn */
            invokeinterface java.sql.Connection.commit:()V
       173: .line 641
      StackMap locals:
      StackMap stack:
            iinc 9 /* i */ 1
      StackMap locals:
      StackMap stack:
       174: iload 9 /* i */
            getstatic org.hsqldb.test.JDBCBench.ntellers:I
            getstatic org.hsqldb.test.JDBCBench.tps:I
            imul
            if_icmplt 161
        end local 9 // int i
       175: .line 659
            getstatic org.hsqldb.test.JDBCBench.prepared_stmt:Z
            ifeq 177
       176: .line 660
            aload 8 /* pstmt */
            invokeinterface java.sql.PreparedStatement.close:()V
       177: .line 663
      StackMap locals:
      StackMap stack:
            getstatic org.hsqldb.test.JDBCBench.transactions:Z
            ifeq 179
       178: .line 664
            aload 4 /* Conn */
            invokeinterface java.sql.Connection.commit:()V
       179: .line 667
      StackMap locals:
      StackMap stack:
            getstatic org.hsqldb.test.JDBCBench.prepared_stmt:Z
            ifeq 183
       180: .line 669
            ldc "INSERT INTO accounts(Aid,Bid,Abalance) VALUES (?,?,0)"
       181: .line 668
            astore 7 /* Query */
       182: .line 670
            aload 4 /* Conn */
            aload 7 /* Query */
            invokeinterface java.sql.Connection.prepareStatement:(Ljava/lang/String;)Ljava/sql/PreparedStatement;
            astore 8 /* pstmt */
       183: .line 673
      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: .line 675
            iconst_0
            istore 9 /* i */
        start local 9 // int i
       185: goto 201
       186: .line 676
      StackMap locals: int
      StackMap stack:
            getstatic org.hsqldb.test.JDBCBench.prepared_stmt:Z
            ifeq 192
       187: .line 677
            aload 8 /* pstmt */
            iconst_1
            iload 9 /* i */
            invokeinterface java.sql.PreparedStatement.setInt:(II)V
       188: .line 678
            aload 8 /* pstmt */
            iconst_2
            iload 9 /* i */
            getstatic org.hsqldb.test.JDBCBench.naccounts:I
            idiv
            invokeinterface java.sql.PreparedStatement.setInt:(II)V
       189: .line 679
            aload 8 /* pstmt */
            invokeinterface java.sql.PreparedStatement.executeUpdate:()I
            pop
       190: .line 680
            aload 8 /* pstmt */
            invokeinterface java.sql.PreparedStatement.clearWarnings:()V
       191: .line 681
            goto 196
       192: .line 682
      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: .line 683
            iload 9 /* i */
            invokevirtual java.lang.StringBuilder.append:(I)Ljava/lang/StringBuilder;
            ldc ","
            invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
            iload 9 /* i */
            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: .line 682
            invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
            astore 7 /* Query */
       195: .line 685
            aload 6 /* Stmt */
            aload 7 /* Query */
            invokeinterface java.sql.Statement.executeUpdate:(Ljava/lang/String;)I
            pop
       196: .line 688
      StackMap locals:
      StackMap stack:
            iload 9 /* i */
            sipush 10000
            irem
            ifne 198
            getstatic org.hsqldb.test.JDBCBench.transactions:Z
            ifeq 198
       197: .line 689
            aload 4 /* Conn */
            invokeinterface java.sql.Connection.commit:()V
       198: .line 692
      StackMap locals:
      StackMap stack:
            iload 9 /* i */
            ifle 200
            iload 9 /* i */
            sipush 10000
            irem
            ifne 200
       199: .line 693
            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 /* i */
            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: .line 675
      StackMap locals:
      StackMap stack:
            iinc 9 /* i */ 1
      StackMap locals:
      StackMap stack:
       201: iload 9 /* i */
            getstatic org.hsqldb.test.JDBCBench.naccounts:I
            getstatic org.hsqldb.test.JDBCBench.tps:I
            imul
            if_icmplt 186
        end local 9 // int i
       202: .line 697
            getstatic org.hsqldb.test.JDBCBench.prepared_stmt:Z
            ifeq 204
       203: .line 698
            aload 8 /* pstmt */
            invokeinterface java.sql.PreparedStatement.close:()V
       204: .line 701
      StackMap locals:
      StackMap stack:
            getstatic org.hsqldb.test.JDBCBench.transactions:Z
            ifeq 206
       205: .line 702
            aload 4 /* Conn */
            invokeinterface java.sql.Connection.commit:()V
       206: .line 705
      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: .line 706
            ldc "\t records inserted"
            invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
            invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
       208: .line 705
            invokevirtual java.io.PrintStream.println:(Ljava/lang/String;)V
       209: .line 709
            getstatic org.hsqldb.test.JDBCBench.ShutdownCommand:Ljava/lang/String;
            invokevirtual java.lang.String.length:()I
            ifle 211
       210: .line 710
            aload 6 /* Stmt */
            getstatic org.hsqldb.test.JDBCBench.ShutdownCommand:Ljava/lang/String;
            invokeinterface java.sql.Statement.execute:(Ljava/lang/String;)Z
            pop
       211: .line 713
      StackMap locals:
      StackMap stack:
            aload 6 /* Stmt */
            invokeinterface java.sql.Statement.close:()V
        end local 8 // java.sql.PreparedStatement pstmt
        end local 7 // java.lang.String Query
        end local 6 // java.sql.Statement Stmt
       212: .line 714
            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 /* E */
        start local 6 // java.lang.Exception E
       214: .line 715
            getstatic java.lang.System.out:Ljava/io/PrintStream;
            aload 6 /* E */
            invokevirtual java.lang.Exception.toString:()Ljava/lang/String;
            invokevirtual java.io.PrintStream.println:(Ljava/lang/String;)V
       215: .line 716
            aload 6 /* E */
            invokevirtual java.lang.Exception.printStackTrace:()V
        end local 6 // java.lang.Exception E
       216: .line 719
      StackMap locals:
      StackMap stack:
            aload 4 /* Conn */
            invokestatic org.hsqldb.test.JDBCBench.connectClose:(Ljava/sql/Connection;)V
       217: .line 720
            return
        end local 5 // java.lang.String s
        end local 4 // java.sql.Connection Conn
        end local 3 // java.lang.String password
        end local 2 // java.lang.String user
        end local 1 // java.lang.String url
        end local 0 // org.hsqldb.test.JDBCBench this
      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 // int lo
        start local 1 // int hi
         0: .line 724
            iconst_0
            istore 2 /* ret */
        start local 2 // int ret
         1: .line 726
            invokestatic java.lang.Math.random:()D
            iload 1 /* hi */
            iload 0 /* lo */
            isub
            iconst_1
            iadd
            i2d
            dmul
            d2i
            istore 2 /* ret */
         2: .line 727
            iload 2 /* ret */
            iload 0 /* lo */
            iadd
            istore 2 /* ret */
         3: .line 729
            iload 2 /* ret */
            ireturn
        end local 2 // int ret
        end local 1 // int hi
        end local 0 // int lo
      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 // int type
         0: .line 734
            iconst_0
            istore 1 /* min */
        start local 1 // int min
         1: .line 735
            iconst_0
            istore 2 /* max */
        start local 2 // int max
         2: .line 737
            iload 0 /* type */
            tableswitch { // 0 - 2
                    0: 3
                    1: 5
                    2: 7
              default: 8
          }
         3: .line 740
      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 /* max */
         4: .line 741
            goto 8
         5: .line 744
      StackMap locals:
      StackMap stack:
            getstatic org.hsqldb.test.JDBCBench.nbranches:I
            getstatic org.hsqldb.test.JDBCBench.tps:I
            imul
            iconst_1
            isub
            istore 2 /* max */
         6: .line 745
            goto 8
         7: .line 748
      StackMap locals:
      StackMap stack:
            getstatic org.hsqldb.test.JDBCBench.naccounts:I
            getstatic org.hsqldb.test.JDBCBench.tps:I
            imul
            iconst_1
            isub
            istore 2 /* max */
         8: .line 752
      StackMap locals:
      StackMap stack:
            iload 1 /* min */
            iload 2 /* max */
            invokestatic org.hsqldb.test.JDBCBench.getRandomInt:(II)I
            ireturn
        end local 2 // int max
        end local 1 // int min
        end local 0 // int type
      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 // java.lang.String DBUrl
        start local 1 // java.lang.String DBUser
        start local 2 // java.lang.String DBPassword
         0: .line 759
            aload 0 /* DBUrl */
            aload 1 /* DBUser */
         1: .line 760
            aload 2 /* DBPassword */
         2: .line 759
            invokestatic java.sql.DriverManager.getConnection:(Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;)Ljava/sql/Connection;
            astore 3 /* conn */
        start local 3 // java.sql.Connection conn
         3: .line 762
            aload 3 /* conn */
         4: areturn
        end local 3 // java.sql.Connection conn
         5: .line 763
      StackMap locals:
      StackMap stack: java.lang.Exception
            astore 3 /* E */
        start local 3 // java.lang.Exception E
         6: .line 764
            getstatic java.lang.System.out:Ljava/io/PrintStream;
            aload 3 /* E */
            invokevirtual java.lang.Exception.toString:()Ljava/lang/String;
            invokevirtual java.io.PrintStream.println:(Ljava/lang/String;)V
         7: .line 765
            aload 3 /* E */
            invokevirtual java.lang.Exception.printStackTrace:()V
        end local 3 // java.lang.Exception E
         8: .line 768
            aconst_null
            areturn
        end local 2 // java.lang.String DBPassword
        end local 1 // java.lang.String DBUser
        end local 0 // java.lang.String DBUrl
      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 // java.sql.Connection c
         0: .line 773
            aload 0 /* c */
            ifnonnull 2
         1: .line 774
            return
         2: .line 778
      StackMap locals:
      StackMap stack:
            aload 0 /* c */
            invokeinterface java.sql.Connection.close:()V
         3: .line 779
            goto 7
      StackMap locals:
      StackMap stack: java.lang.Exception
         4: astore 1 /* E */
        start local 1 // java.lang.Exception E
         5: .line 780
            getstatic java.lang.System.out:Ljava/io/PrintStream;
            aload 1 /* E */
            invokevirtual java.lang.Exception.toString:()Ljava/lang/String;
            invokevirtual java.io.PrintStream.println:(Ljava/lang/String;)V
         6: .line 781
            aload 1 /* E */
            invokevirtual java.lang.Exception.printStackTrace:()V
        end local 1 // java.lang.Exception E
         7: .line 783
      StackMap locals:
      StackMap stack:
            return
        end local 0 // java.sql.Connection c
      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 // org.hsqldb.test.JDBCBench this
        start local 1 // java.sql.Connection conn
         0: .line 787
            aconst_null
            astore 2 /* st1 */
        start local 2 // java.sql.Statement st1
         1: .line 788
            aconst_null
            astore 3 /* rs */
        start local 3 // java.sql.ResultSet rs
         2: .line 795
            aload 1 /* conn */
            invokeinterface java.sql.Connection.createStatement:()Ljava/sql/Statement;
            astore 2 /* st1 */
         3: .line 796
            aload 2 /* st1 */
            ldc "select sum(bbalance) from branches"
            invokeinterface java.sql.Statement.executeQuery:(Ljava/lang/String;)Ljava/sql/ResultSet;
            astore 3 /* rs */
         4: .line 798
            aload 3 /* rs */
            invokeinterface java.sql.ResultSet.next:()Z
            pop
         5: .line 800
            aload 3 /* rs */
            iconst_1
            invokeinterface java.sql.ResultSet.getInt:(I)I
            istore 4 /* bbalancesum */
        start local 4 // int bbalancesum
         6: .line 802
            aload 3 /* rs */
            invokeinterface java.sql.ResultSet.close:()V
         7: .line 804
            aload 2 /* st1 */
            ldc "select sum(tbalance) from tellers"
            invokeinterface java.sql.Statement.executeQuery:(Ljava/lang/String;)Ljava/sql/ResultSet;
            astore 3 /* rs */
         8: .line 806
            aload 3 /* rs */
            invokeinterface java.sql.ResultSet.next:()Z
            pop
         9: .line 808
            aload 3 /* rs */
            iconst_1
            invokeinterface java.sql.ResultSet.getInt:(I)I
            istore 5 /* tbalancesum */
        start local 5 // int tbalancesum
        10: .line 810
            aload 3 /* rs */
            invokeinterface java.sql.ResultSet.close:()V
        11: .line 812
            aload 2 /* st1 */
            ldc "select sum(abalance) from accounts"
            invokeinterface java.sql.Statement.executeQuery:(Ljava/lang/String;)Ljava/sql/ResultSet;
            astore 3 /* rs */
        12: .line 814
            aload 3 /* rs */
            invokeinterface java.sql.ResultSet.next:()Z
            pop
        13: .line 816
            aload 3 /* rs */
            iconst_1
            invokeinterface java.sql.ResultSet.getInt:(I)I
            istore 6 /* abalancesum */
        start local 6 // int abalancesum
        14: .line 818
            aload 3 /* rs */
            invokeinterface java.sql.ResultSet.close:()V
        15: .line 820
            aload 2 /* st1 */
            ldc "select sum(delta) from history"
            invokeinterface java.sql.Statement.executeQuery:(Ljava/lang/String;)Ljava/sql/ResultSet;
            astore 3 /* rs */
        16: .line 822
            aload 3 /* rs */
            invokeinterface java.sql.ResultSet.next:()Z
            pop
        17: .line 824
            aload 3 /* rs */
            iconst_1
            invokeinterface java.sql.ResultSet.getInt:(I)I
            istore 7 /* deltasum */
        start local 7 // int deltasum
        18: .line 826
            aload 3 /* rs */
            invokeinterface java.sql.ResultSet.close:()V
        19: .line 828
            aconst_null
            astore 3 /* rs */
        20: .line 830
            aload 2 /* st1 */
            invokeinterface java.sql.Statement.close:()V
        21: .line 832
            aconst_null
            astore 2 /* st1 */
        22: .line 834
            iload 6 /* abalancesum */
            iload 4 /* bbalancesum */
            if_icmpne 24
            iload 4 /* bbalancesum */
            iload 5 /* tbalancesum */
            if_icmpne 24
        23: .line 835
            iload 5 /* tbalancesum */
            iload 7 /* deltasum */
            if_icmpeq 26
        24: .line 836
      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: .line 837
            goto 27
        26: .line 838
      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: .line 841
      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 /* abalancesum */
            invokevirtual java.lang.StringBuilder.append:(I)Ljava/lang/StringBuilder;
            ldc " B "
            invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
            iload 4 /* bbalancesum */
            invokevirtual java.lang.StringBuilder.append:(I)Ljava/lang/StringBuilder;
        28: .line 842
            ldc " T "
            invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
            iload 5 /* tbalancesum */
            invokevirtual java.lang.StringBuilder.append:(I)Ljava/lang/StringBuilder;
            ldc " H "
            invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
            iload 7 /* deltasum */
            invokevirtual java.lang.StringBuilder.append:(I)Ljava/lang/StringBuilder;
            invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
        29: .line 841
            invokevirtual java.io.PrintStream.println:(Ljava/lang/String;)V
        30: .line 843
            goto 35
        end local 7 // int deltasum
        end local 6 // int abalancesum
        end local 5 // int tbalancesum
        end local 4 // int bbalancesum
      StackMap locals: org.hsqldb.test.JDBCBench java.sql.Connection java.sql.Statement java.sql.ResultSet
      StackMap stack: java.lang.Throwable
        31: astore 8
        32: .line 844
            aload 2 /* st1 */
            ifnull 34
        33: .line 845
            aload 2 /* st1 */
            invokeinterface java.sql.Statement.close:()V
        34: .line 847
      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 // int bbalancesum
        start local 5 // int tbalancesum
        start local 6 // int abalancesum
        start local 7 // int deltasum
        35: .line 844
      StackMap locals: org.hsqldb.test.JDBCBench java.sql.Connection java.sql.Statement java.sql.ResultSet int int int int
      StackMap stack:
            aload 2 /* st1 */
            ifnull 37
        36: .line 845
            aload 2 /* st1 */
            invokeinterface java.sql.Statement.close:()V
        37: .line 848
      StackMap locals:
      StackMap stack:
            return
        end local 7 // int deltasum
        end local 6 // int abalancesum
        end local 5 // int tbalancesum
        end local 4 // int bbalancesum
        end local 3 // java.sql.ResultSet rs
        end local 2 // java.sql.Statement st1
        end local 1 // java.sql.Connection conn
        end local 0 // org.hsqldb.test.JDBCBench this
      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