class org.hsqldb.test.JDBCBench$ClientThread extends java.lang.Thread
minor version: 0
major version: 59
flags: flags: (0x0020) ACC_SUPER
this_class: org.hsqldb.test.JDBCBench$ClientThread
super_class: java.lang.Thread
{
int ntrans;
descriptor: I
flags: (0x0000)
java.sql.Connection Conn;
descriptor: Ljava/sql/Connection;
flags: (0x0000)
java.sql.PreparedStatement pstmt1;
descriptor: Ljava/sql/PreparedStatement;
flags: (0x0000)
java.sql.PreparedStatement pstmt2;
descriptor: Ljava/sql/PreparedStatement;
flags: (0x0000)
java.sql.PreparedStatement pstmt3;
descriptor: Ljava/sql/PreparedStatement;
flags: (0x0000)
java.sql.PreparedStatement pstmt4;
descriptor: Ljava/sql/PreparedStatement;
flags: (0x0000)
java.sql.PreparedStatement pstmt5;
descriptor: Ljava/sql/PreparedStatement;
flags: (0x0000)
final org.hsqldb.test.JDBCBench this$0;
descriptor: Lorg/hsqldb/test/JDBCBench;
flags: (0x1010) ACC_FINAL, ACC_SYNTHETIC
public void <init>(org.hsqldb.test.JDBCBench, int, java.lang.String, java.lang.String, java.lang.String, int);
descriptor: (Lorg/hsqldb/test/JDBCBench;ILjava/lang/String;Ljava/lang/String;Ljava/lang/String;I)V
flags: (0x0001) ACC_PUBLIC
Code:
stack=4, locals=8, args_size=7
start local 0 start local 2 start local 3 start local 4 start local 5 start local 6 0: aload 0
aload 1
putfield org.hsqldb.test.JDBCBench$ClientThread.this$0:Lorg/hsqldb/test/JDBCBench;
1: aload 0
invokespecial java.lang.Thread.<init>:()V
2: aload 0
iconst_0
putfield org.hsqldb.test.JDBCBench$ClientThread.ntrans:I
3: aload 0
aconst_null
putfield org.hsqldb.test.JDBCBench$ClientThread.pstmt1:Ljava/sql/PreparedStatement;
4: aload 0
aconst_null
putfield org.hsqldb.test.JDBCBench$ClientThread.pstmt2:Ljava/sql/PreparedStatement;
5: aload 0
aconst_null
putfield org.hsqldb.test.JDBCBench$ClientThread.pstmt3:Ljava/sql/PreparedStatement;
6: aload 0
aconst_null
putfield org.hsqldb.test.JDBCBench$ClientThread.pstmt4:Ljava/sql/PreparedStatement;
7: aload 0
aconst_null
putfield org.hsqldb.test.JDBCBench$ClientThread.pstmt5:Ljava/sql/PreparedStatement;
8: getstatic java.lang.System.out:Ljava/io/PrintStream;
iload 2
invokevirtual java.io.PrintStream.println:(I)V
9: aload 0
iload 2
putfield org.hsqldb.test.JDBCBench$ClientThread.ntrans:I
10: aload 0
aload 3
aload 4
aload 5
invokestatic org.hsqldb.test.JDBCBench.connect:(Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;)Ljava/sql/Connection;
putfield org.hsqldb.test.JDBCBench$ClientThread.Conn:Ljava/sql/Connection;
11: aload 0
getfield org.hsqldb.test.JDBCBench$ClientThread.Conn:Ljava/sql/Connection;
ifnonnull 13
12: return
13: StackMap locals: org.hsqldb.test.JDBCBench$ClientThread org.hsqldb.test.JDBCBench int java.lang.String java.lang.String java.lang.String int
StackMap stack:
getstatic org.hsqldb.test.JDBCBench.transactions:Z
ifeq 15
14: aload 0
getfield org.hsqldb.test.JDBCBench$ClientThread.Conn:Ljava/sql/Connection;
iconst_0
invokeinterface java.sql.Connection.setAutoCommit:(Z)V
15: StackMap locals:
StackMap stack:
aload 0
getfield org.hsqldb.test.JDBCBench$ClientThread.Conn:Ljava/sql/Connection;
iload 6
invokeinterface java.sql.Connection.setTransactionIsolation:(I)V
16: getstatic org.hsqldb.test.JDBCBench.prepared_stmt:Z
ifeq 40
17: ldc "UPDATE accounts "
astore 7
start local 7 18: new java.lang.StringBuilder
dup
aload 7
invokestatic java.lang.String.valueOf:(Ljava/lang/Object;)Ljava/lang/String;
invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
ldc "SET Abalance = Abalance + ? "
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
astore 7
19: new java.lang.StringBuilder
dup
aload 7
invokestatic java.lang.String.valueOf:(Ljava/lang/Object;)Ljava/lang/String;
invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
ldc "WHERE Aid = ?"
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
astore 7
20: aload 0
aload 0
getfield org.hsqldb.test.JDBCBench$ClientThread.Conn:Ljava/sql/Connection;
aload 7
invokeinterface java.sql.Connection.prepareStatement:(Ljava/lang/String;)Ljava/sql/PreparedStatement;
putfield org.hsqldb.test.JDBCBench$ClientThread.pstmt1:Ljava/sql/PreparedStatement;
21: ldc "SELECT Abalance "
astore 7
22: new java.lang.StringBuilder
dup
aload 7
invokestatic java.lang.String.valueOf:(Ljava/lang/Object;)Ljava/lang/String;
invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
ldc "FROM accounts "
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
astore 7
23: new java.lang.StringBuilder
dup
aload 7
invokestatic java.lang.String.valueOf:(Ljava/lang/Object;)Ljava/lang/String;
invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
ldc "WHERE Aid = ?"
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
astore 7
24: aload 0
aload 0
getfield org.hsqldb.test.JDBCBench$ClientThread.Conn:Ljava/sql/Connection;
aload 7
invokeinterface java.sql.Connection.prepareStatement:(Ljava/lang/String;)Ljava/sql/PreparedStatement;
putfield org.hsqldb.test.JDBCBench$ClientThread.pstmt2:Ljava/sql/PreparedStatement;
25: ldc "UPDATE tellers "
astore 7
26: new java.lang.StringBuilder
dup
aload 7
invokestatic java.lang.String.valueOf:(Ljava/lang/Object;)Ljava/lang/String;
invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
ldc "SET Tbalance = Tbalance + ? "
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
astore 7
27: new java.lang.StringBuilder
dup
aload 7
invokestatic java.lang.String.valueOf:(Ljava/lang/Object;)Ljava/lang/String;
invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
ldc "WHERE Tid = ?"
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
astore 7
28: aload 0
aload 0
getfield org.hsqldb.test.JDBCBench$ClientThread.Conn:Ljava/sql/Connection;
aload 7
invokeinterface java.sql.Connection.prepareStatement:(Ljava/lang/String;)Ljava/sql/PreparedStatement;
putfield org.hsqldb.test.JDBCBench$ClientThread.pstmt3:Ljava/sql/PreparedStatement;
29: ldc "UPDATE branches "
astore 7
30: new java.lang.StringBuilder
dup
aload 7
invokestatic java.lang.String.valueOf:(Ljava/lang/Object;)Ljava/lang/String;
invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
ldc "SET Bbalance = Bbalance + ? "
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
astore 7
31: new java.lang.StringBuilder
dup
aload 7
invokestatic java.lang.String.valueOf:(Ljava/lang/Object;)Ljava/lang/String;
invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
ldc "WHERE Bid = ?"
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
astore 7
32: aload 0
aload 0
getfield org.hsqldb.test.JDBCBench$ClientThread.Conn:Ljava/sql/Connection;
aload 7
invokeinterface java.sql.Connection.prepareStatement:(Ljava/lang/String;)Ljava/sql/PreparedStatement;
putfield org.hsqldb.test.JDBCBench$ClientThread.pstmt4:Ljava/sql/PreparedStatement;
33: ldc "INSERT INTO history(Tid, Bid, Aid, delta) "
astore 7
34: new java.lang.StringBuilder
dup
aload 7
invokestatic java.lang.String.valueOf:(Ljava/lang/Object;)Ljava/lang/String;
invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
ldc "VALUES (?,?,?,?)"
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
astore 7
35: aload 0
aload 0
getfield org.hsqldb.test.JDBCBench$ClientThread.Conn:Ljava/sql/Connection;
aload 7
invokeinterface java.sql.Connection.prepareStatement:(Ljava/lang/String;)Ljava/sql/PreparedStatement;
putfield org.hsqldb.test.JDBCBench$ClientThread.pstmt5:Ljava/sql/PreparedStatement;
end local 7 36: goto 40
StackMap locals:
StackMap stack: java.lang.Exception
37: astore 7
start local 7 38: getstatic java.lang.System.out:Ljava/io/PrintStream;
aload 7
invokevirtual java.lang.Exception.toString:()Ljava/lang/String;
invokevirtual java.io.PrintStream.println:(Ljava/lang/String;)V
39: aload 7
invokevirtual java.lang.Exception.printStackTrace:()V
end local 7 40: StackMap locals:
StackMap stack:
return
end local 6 end local 5 end local 4 end local 3 end local 2 end local 0 LocalVariableTable:
Start End Slot Name Signature
0 41 0 this Lorg/hsqldb/test/JDBCBench$ClientThread;
0 41 2 number_of_txns I
0 41 3 url Ljava/lang/String;
0 41 4 user Ljava/lang/String;
0 41 5 password Ljava/lang/String;
0 41 6 transactionMode I
18 36 7 Query Ljava/lang/String;
38 40 7 E Ljava/lang/Exception;
Exception table:
from to target type
13 36 37 Class java.lang.Exception
MethodParameters:
Name Flags
this$0 final
number_of_txns
url
user
password
transactionMode
public void run();
descriptor: ()V
flags: (0x0001) ACC_PUBLIC
Code:
stack=5, locals=5, args_size=1
start local 0 0: goto 7
1: StackMap locals:
StackMap stack:
iconst_2
invokestatic org.hsqldb.test.JDBCBench.getRandomID:(I)I
istore 1
start local 1 2: iconst_1
invokestatic org.hsqldb.test.JDBCBench.getRandomID:(I)I
istore 2
start local 2 3: iconst_0
invokestatic org.hsqldb.test.JDBCBench.getRandomID:(I)I
istore 3
start local 3 4: iconst_0
sipush 1000
invokestatic org.hsqldb.test.JDBCBench.getRandomInt:(II)I
istore 4
start local 4 5: aload 0
iload 2
iload 3
iload 1
iload 4
invokevirtual org.hsqldb.test.JDBCBench$ClientThread.doOne:(IIII)I
pop
6: aload 0
getfield org.hsqldb.test.JDBCBench$ClientThread.this$0:Lorg/hsqldb/test/JDBCBench;
invokevirtual org.hsqldb.test.JDBCBench.incrementTransactionCount:()V
end local 4 end local 3 end local 2 end local 1 7: StackMap locals:
StackMap stack:
aload 0
dup
getfield org.hsqldb.test.JDBCBench$ClientThread.ntrans:I
dup_x1
iconst_1
isub
putfield org.hsqldb.test.JDBCBench$ClientThread.ntrans:I
ifgt 1
8: getstatic org.hsqldb.test.JDBCBench.prepared_stmt:Z
ifeq 23
9: aload 0
getfield org.hsqldb.test.JDBCBench$ClientThread.pstmt1:Ljava/sql/PreparedStatement;
ifnull 11
10: aload 0
getfield org.hsqldb.test.JDBCBench$ClientThread.pstmt1:Ljava/sql/PreparedStatement;
invokeinterface java.sql.PreparedStatement.close:()V
11: StackMap locals:
StackMap stack:
aload 0
getfield org.hsqldb.test.JDBCBench$ClientThread.pstmt2:Ljava/sql/PreparedStatement;
ifnull 13
12: aload 0
getfield org.hsqldb.test.JDBCBench$ClientThread.pstmt2:Ljava/sql/PreparedStatement;
invokeinterface java.sql.PreparedStatement.close:()V
13: StackMap locals:
StackMap stack:
aload 0
getfield org.hsqldb.test.JDBCBench$ClientThread.pstmt3:Ljava/sql/PreparedStatement;
ifnull 15
14: aload 0
getfield org.hsqldb.test.JDBCBench$ClientThread.pstmt3:Ljava/sql/PreparedStatement;
invokeinterface java.sql.PreparedStatement.close:()V
15: StackMap locals:
StackMap stack:
aload 0
getfield org.hsqldb.test.JDBCBench$ClientThread.pstmt4:Ljava/sql/PreparedStatement;
ifnull 17
16: aload 0
getfield org.hsqldb.test.JDBCBench$ClientThread.pstmt4:Ljava/sql/PreparedStatement;
invokeinterface java.sql.PreparedStatement.close:()V
17: StackMap locals:
StackMap stack:
aload 0
getfield org.hsqldb.test.JDBCBench$ClientThread.pstmt5:Ljava/sql/PreparedStatement;
ifnull 23
18: aload 0
getfield org.hsqldb.test.JDBCBench$ClientThread.pstmt5:Ljava/sql/PreparedStatement;
invokeinterface java.sql.PreparedStatement.close:()V
19: goto 23
StackMap locals:
StackMap stack: java.lang.Exception
20: astore 1
start local 1 21: getstatic java.lang.System.out:Ljava/io/PrintStream;
aload 1
invokevirtual java.lang.Exception.toString:()Ljava/lang/String;
invokevirtual java.io.PrintStream.println:(Ljava/lang/String;)V
22: aload 1
invokevirtual java.lang.Exception.printStackTrace:()V
end local 1 23: StackMap locals:
StackMap stack:
aload 0
getfield org.hsqldb.test.JDBCBench$ClientThread.Conn:Ljava/sql/Connection;
invokestatic org.hsqldb.test.JDBCBench.connectClose:(Ljava/sql/Connection;)V
24: aload 0
aconst_null
putfield org.hsqldb.test.JDBCBench$ClientThread.Conn:Ljava/sql/Connection;
25: return
end local 0 LocalVariableTable:
Start End Slot Name Signature
0 26 0 this Lorg/hsqldb/test/JDBCBench$ClientThread;
2 7 1 account I
3 7 2 branch I
4 7 3 teller I
5 7 4 delta I
21 23 1 E Ljava/lang/Exception;
Exception table:
from to target type
9 19 20 Class java.lang.Exception
int doOne(int, int, int, int);
descriptor: (IIII)I
flags: (0x0000)
Code:
stack=4, locals=9, args_size=5
start local 0 start local 1 start local 2 start local 3 start local 4 0: iconst_0
istore 5
start local 5 1: aload 0
getfield org.hsqldb.test.JDBCBench$ClientThread.Conn:Ljava/sql/Connection;
ifnonnull 4
2: aload 0
getfield org.hsqldb.test.JDBCBench$ClientThread.this$0:Lorg/hsqldb/test/JDBCBench;
invokevirtual org.hsqldb.test.JDBCBench.incrementFailedTransactionCount:()V
3: iconst_0
ireturn
4: StackMap locals: int
StackMap stack:
getstatic org.hsqldb.test.JDBCBench.prepared_stmt:Z
ifeq 30
5: aload 0
getfield org.hsqldb.test.JDBCBench$ClientThread.pstmt1:Ljava/sql/PreparedStatement;
iconst_1
iload 4
invokeinterface java.sql.PreparedStatement.setInt:(II)V
6: aload 0
getfield org.hsqldb.test.JDBCBench$ClientThread.pstmt1:Ljava/sql/PreparedStatement;
iconst_2
iload 3
invokeinterface java.sql.PreparedStatement.setInt:(II)V
7: aload 0
getfield org.hsqldb.test.JDBCBench$ClientThread.pstmt1:Ljava/sql/PreparedStatement;
invokeinterface java.sql.PreparedStatement.executeUpdate:()I
pop
8: aload 0
getfield org.hsqldb.test.JDBCBench$ClientThread.pstmt1:Ljava/sql/PreparedStatement;
invokeinterface java.sql.PreparedStatement.clearWarnings:()V
9: aload 0
getfield org.hsqldb.test.JDBCBench$ClientThread.pstmt2:Ljava/sql/PreparedStatement;
iconst_1
iload 3
invokeinterface java.sql.PreparedStatement.setInt:(II)V
10: aload 0
getfield org.hsqldb.test.JDBCBench$ClientThread.pstmt2:Ljava/sql/PreparedStatement;
invokeinterface java.sql.PreparedStatement.executeQuery:()Ljava/sql/ResultSet;
astore 6
start local 6 11: aload 0
getfield org.hsqldb.test.JDBCBench$ClientThread.pstmt2:Ljava/sql/PreparedStatement;
invokeinterface java.sql.PreparedStatement.clearWarnings:()V
12: goto 14
13: StackMap locals: java.sql.ResultSet
StackMap stack:
aload 6
iconst_1
invokeinterface java.sql.ResultSet.getInt:(I)I
istore 5
14: StackMap locals:
StackMap stack:
aload 6
invokeinterface java.sql.ResultSet.next:()Z
ifne 13
15: aload 0
getfield org.hsqldb.test.JDBCBench$ClientThread.pstmt3:Ljava/sql/PreparedStatement;
iconst_1
iload 4
invokeinterface java.sql.PreparedStatement.setInt:(II)V
16: aload 0
getfield org.hsqldb.test.JDBCBench$ClientThread.pstmt3:Ljava/sql/PreparedStatement;
iconst_2
iload 2
invokeinterface java.sql.PreparedStatement.setInt:(II)V
17: aload 0
getfield org.hsqldb.test.JDBCBench$ClientThread.pstmt3:Ljava/sql/PreparedStatement;
invokeinterface java.sql.PreparedStatement.executeUpdate:()I
pop
18: aload 0
getfield org.hsqldb.test.JDBCBench$ClientThread.pstmt3:Ljava/sql/PreparedStatement;
invokeinterface java.sql.PreparedStatement.clearWarnings:()V
19: aload 0
getfield org.hsqldb.test.JDBCBench$ClientThread.pstmt4:Ljava/sql/PreparedStatement;
iconst_1
iload 4
invokeinterface java.sql.PreparedStatement.setInt:(II)V
20: aload 0
getfield org.hsqldb.test.JDBCBench$ClientThread.pstmt4:Ljava/sql/PreparedStatement;
iconst_2
iload 1
invokeinterface java.sql.PreparedStatement.setInt:(II)V
21: aload 0
getfield org.hsqldb.test.JDBCBench$ClientThread.pstmt4:Ljava/sql/PreparedStatement;
invokeinterface java.sql.PreparedStatement.executeUpdate:()I
pop
22: aload 0
getfield org.hsqldb.test.JDBCBench$ClientThread.pstmt4:Ljava/sql/PreparedStatement;
invokeinterface java.sql.PreparedStatement.clearWarnings:()V
23: aload 0
getfield org.hsqldb.test.JDBCBench$ClientThread.pstmt5:Ljava/sql/PreparedStatement;
iconst_1
iload 2
invokeinterface java.sql.PreparedStatement.setInt:(II)V
24: aload 0
getfield org.hsqldb.test.JDBCBench$ClientThread.pstmt5:Ljava/sql/PreparedStatement;
iconst_2
iload 1
invokeinterface java.sql.PreparedStatement.setInt:(II)V
25: aload 0
getfield org.hsqldb.test.JDBCBench$ClientThread.pstmt5:Ljava/sql/PreparedStatement;
iconst_3
iload 3
invokeinterface java.sql.PreparedStatement.setInt:(II)V
26: aload 0
getfield org.hsqldb.test.JDBCBench$ClientThread.pstmt5:Ljava/sql/PreparedStatement;
iconst_4
iload 4
invokeinterface java.sql.PreparedStatement.setInt:(II)V
27: aload 0
getfield org.hsqldb.test.JDBCBench$ClientThread.pstmt5:Ljava/sql/PreparedStatement;
invokeinterface java.sql.PreparedStatement.executeUpdate:()I
pop
28: aload 0
getfield org.hsqldb.test.JDBCBench$ClientThread.pstmt5:Ljava/sql/PreparedStatement;
invokeinterface java.sql.PreparedStatement.clearWarnings:()V
end local 6 29: goto 63
30: StackMap locals:
StackMap stack:
aload 0
getfield org.hsqldb.test.JDBCBench$ClientThread.Conn:Ljava/sql/Connection;
invokeinterface java.sql.Connection.createStatement:()Ljava/sql/Statement;
astore 6
start local 6 31: ldc "UPDATE accounts "
astore 7
start local 7 32: new java.lang.StringBuilder
dup
aload 7
invokestatic java.lang.String.valueOf:(Ljava/lang/Object;)Ljava/lang/String;
invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
ldc "SET Abalance = Abalance + "
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
iload 4
invokevirtual java.lang.StringBuilder.append:(I)Ljava/lang/StringBuilder;
ldc " "
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
astore 7
33: new java.lang.StringBuilder
dup
aload 7
invokestatic java.lang.String.valueOf:(Ljava/lang/Object;)Ljava/lang/String;
invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
ldc "WHERE Aid = "
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
iload 3
invokevirtual java.lang.StringBuilder.append:(I)Ljava/lang/StringBuilder;
invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
astore 7
34: aload 6
aload 7
invokeinterface java.sql.Statement.executeUpdate:(Ljava/lang/String;)I
pop
35: aload 6
invokeinterface java.sql.Statement.clearWarnings:()V
36: ldc "SELECT Abalance "
astore 7
37: new java.lang.StringBuilder
dup
aload 7
invokestatic java.lang.String.valueOf:(Ljava/lang/Object;)Ljava/lang/String;
invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
ldc "FROM accounts "
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
astore 7
38: new java.lang.StringBuilder
dup
aload 7
invokestatic java.lang.String.valueOf:(Ljava/lang/Object;)Ljava/lang/String;
invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
ldc "WHERE Aid = "
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
iload 3
invokevirtual java.lang.StringBuilder.append:(I)Ljava/lang/StringBuilder;
invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
astore 7
39: aload 6
aload 7
invokeinterface java.sql.Statement.executeQuery:(Ljava/lang/String;)Ljava/sql/ResultSet;
astore 8
start local 8 40: aload 6
invokeinterface java.sql.Statement.clearWarnings:()V
41: goto 43
42: StackMap locals: java.sql.Statement java.lang.String java.sql.ResultSet
StackMap stack:
aload 8
iconst_1
invokeinterface java.sql.ResultSet.getInt:(I)I
istore 5
43: StackMap locals:
StackMap stack:
aload 8
invokeinterface java.sql.ResultSet.next:()Z
ifne 42
44: ldc "UPDATE tellers "
astore 7
45: new java.lang.StringBuilder
dup
aload 7
invokestatic java.lang.String.valueOf:(Ljava/lang/Object;)Ljava/lang/String;
invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
ldc "SET Tbalance = Tbalance + "
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
iload 4
invokevirtual java.lang.StringBuilder.append:(I)Ljava/lang/StringBuilder;
ldc " "
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
astore 7
46: new java.lang.StringBuilder
dup
aload 7
invokestatic java.lang.String.valueOf:(Ljava/lang/Object;)Ljava/lang/String;
invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
ldc "WHERE Tid = "
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
iload 2
invokevirtual java.lang.StringBuilder.append:(I)Ljava/lang/StringBuilder;
invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
astore 7
47: aload 6
aload 7
invokeinterface java.sql.Statement.executeUpdate:(Ljava/lang/String;)I
pop
48: aload 6
invokeinterface java.sql.Statement.clearWarnings:()V
49: ldc "UPDATE branches "
astore 7
50: new java.lang.StringBuilder
dup
aload 7
invokestatic java.lang.String.valueOf:(Ljava/lang/Object;)Ljava/lang/String;
invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
ldc "SET Bbalance = Bbalance + "
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
iload 4
invokevirtual java.lang.StringBuilder.append:(I)Ljava/lang/StringBuilder;
ldc " "
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
astore 7
51: new java.lang.StringBuilder
dup
aload 7
invokestatic java.lang.String.valueOf:(Ljava/lang/Object;)Ljava/lang/String;
invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
ldc "WHERE Bid = "
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
iload 1
invokevirtual java.lang.StringBuilder.append:(I)Ljava/lang/StringBuilder;
invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
astore 7
52: aload 6
aload 7
invokeinterface java.sql.Statement.executeUpdate:(Ljava/lang/String;)I
pop
53: aload 6
invokeinterface java.sql.Statement.clearWarnings:()V
54: ldc "INSERT INTO history(Tid, Bid, Aid, delta) "
astore 7
55: new java.lang.StringBuilder
dup
aload 7
invokestatic java.lang.String.valueOf:(Ljava/lang/Object;)Ljava/lang/String;
invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
ldc "VALUES ("
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
astore 7
56: new java.lang.StringBuilder
dup
aload 7
invokestatic java.lang.String.valueOf:(Ljava/lang/Object;)Ljava/lang/String;
invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
iload 2
invokevirtual java.lang.StringBuilder.append:(I)Ljava/lang/StringBuilder;
ldc ","
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
astore 7
57: new java.lang.StringBuilder
dup
aload 7
invokestatic java.lang.String.valueOf:(Ljava/lang/Object;)Ljava/lang/String;
invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
iload 1
invokevirtual java.lang.StringBuilder.append:(I)Ljava/lang/StringBuilder;
ldc ","
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
astore 7
58: new java.lang.StringBuilder
dup
aload 7
invokestatic java.lang.String.valueOf:(Ljava/lang/Object;)Ljava/lang/String;
invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
iload 3
invokevirtual java.lang.StringBuilder.append:(I)Ljava/lang/StringBuilder;
ldc ","
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
astore 7
59: new java.lang.StringBuilder
dup
aload 7
invokestatic java.lang.String.valueOf:(Ljava/lang/Object;)Ljava/lang/String;
invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
iload 4
invokevirtual java.lang.StringBuilder.append:(I)Ljava/lang/StringBuilder;
ldc ")"
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
astore 7
60: aload 6
aload 7
invokeinterface java.sql.Statement.executeUpdate:(Ljava/lang/String;)I
pop
61: aload 6
invokeinterface java.sql.Statement.clearWarnings:()V
62: aload 6
invokeinterface java.sql.Statement.close:()V
end local 8 end local 7 end local 6 63: StackMap locals:
StackMap stack:
getstatic org.hsqldb.test.JDBCBench.transactions:Z
ifeq 65
64: aload 0
getfield org.hsqldb.test.JDBCBench$ClientThread.Conn:Ljava/sql/Connection;
invokeinterface java.sql.Connection.commit:()V
65: StackMap locals:
StackMap stack:
iload 5
66: ireturn
67: StackMap locals:
StackMap stack: java.lang.Exception
astore 6
start local 6 68: getstatic org.hsqldb.test.JDBCBench.verbose:Z
ifeq 73
69: getstatic java.lang.System.out:Ljava/io/PrintStream;
new java.lang.StringBuilder
dup
ldc "Transaction failed: "
invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
70: aload 6
invokevirtual java.lang.Exception.toString:()Ljava/lang/String;
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
71: invokevirtual java.io.PrintStream.println:(Ljava/lang/String;)V
72: aload 6
invokevirtual java.lang.Exception.printStackTrace:()V
73: StackMap locals: java.lang.Exception
StackMap stack:
aload 0
getfield org.hsqldb.test.JDBCBench$ClientThread.this$0:Lorg/hsqldb/test/JDBCBench;
invokevirtual org.hsqldb.test.JDBCBench.incrementFailedTransactionCount:()V
74: getstatic org.hsqldb.test.JDBCBench.transactions:Z
ifeq 78
75: aload 0
getfield org.hsqldb.test.JDBCBench$ClientThread.Conn:Ljava/sql/Connection;
invokeinterface java.sql.Connection.rollback:()V
76: goto 78
StackMap locals:
StackMap stack: java.sql.SQLException
77: pop
end local 6 78: StackMap locals:
StackMap stack:
iconst_0
ireturn
end local 5 end local 4 end local 3 end local 2 end local 1 end local 0 LocalVariableTable:
Start End Slot Name Signature
0 79 0 this Lorg/hsqldb/test/JDBCBench$ClientThread;
0 79 1 bid I
0 79 2 tid I
0 79 3 aid I
0 79 4 delta I
1 79 5 aBalance I
11 29 6 RS Ljava/sql/ResultSet;
31 63 6 Stmt Ljava/sql/Statement;
32 63 7 Query Ljava/lang/String;
40 63 8 RS Ljava/sql/ResultSet;
68 78 6 E Ljava/lang/Exception;
Exception table:
from to target type
4 66 67 Class java.lang.Exception
75 76 77 Class java.sql.SQLException
MethodParameters:
Name Flags
bid
tid
aid
delta
}
SourceFile: "JDBCBench.java"
NestHost: org.hsqldb.test.JDBCBench
InnerClasses:
ClientThread = org.hsqldb.test.JDBCBench$ClientThread of org.hsqldb.test.JDBCBench