public final class com.mchange.v2.c3p0.test.PSLoadPoolBackedDataSource
minor version: 0
major version: 59
flags: flags: (0x0031) ACC_PUBLIC, ACC_FINAL, ACC_SUPER
this_class: com.mchange.v2.c3p0.test.PSLoadPoolBackedDataSource
super_class: java.lang.Object
{
static final java.lang.String INSERT_STMT;
descriptor: Ljava/lang/String;
flags: (0x0018) ACC_STATIC, ACC_FINAL
ConstantValue: "INSERT INTO testpbds VALUES ( ? , ? )"
static final java.lang.String SELECT_STMT;
descriptor: Ljava/lang/String;
flags: (0x0018) ACC_STATIC, ACC_FINAL
ConstantValue: "SELECT count(*) FROM testpbds"
static final java.lang.String DELETE_STMT;
descriptor: Ljava/lang/String;
flags: (0x0018) ACC_STATIC, ACC_FINAL
ConstantValue: "DELETE FROM testpbds"
static javax.sql.DataSource ds;
descriptor: Ljavax/sql/DataSource;
flags: (0x0008) ACC_STATIC
public void <init>();
descriptor: ()V
flags: (0x0001) ACC_PUBLIC
Code:
stack=1, locals=1, args_size=1
start local 0 0: aload 0
invokespecial java.lang.Object.<init>:()V
return
end local 0 LocalVariableTable:
Start End Slot Name Signature
0 1 0 this Lcom/mchange/v2/c3p0/test/PSLoadPoolBackedDataSource;
public static void main(java.lang.String[]);
descriptor: ([Ljava/lang/String;)V
flags: (0x0009) ACC_PUBLIC, ACC_STATIC
Code:
stack=4, locals=6, args_size=1
start local 0 0: aload 0
arraylength
ifle 5
1: getstatic java.lang.System.err:Ljava/io/PrintStream;
new java.lang.StringBuilder
dup
ldc Lcom/mchange/v2/c3p0/test/PSLoadPoolBackedDataSource;
invokevirtual java.lang.Class.getName:()Ljava/lang/String;
invokestatic java.lang.String.valueOf:(Ljava/lang/Object;)Ljava/lang/String;
invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
2: ldc " now requires no args. Please set everything in standard c3p0 config files."
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
3: invokevirtual java.io.PrintStream.println:(Ljava/lang/String;)V
4: return
5: StackMap locals:
StackMap stack:
invokestatic com.mchange.v2.c3p0.DataSources.unpooledDataSource:()Ljavax/sql/DataSource;
astore 1
start local 1 6: aload 1
invokestatic com.mchange.v2.c3p0.DataSources.pooledDataSource:(Ljavax/sql/DataSource;)Ljavax/sql/DataSource;
putstatic com.mchange.v2.c3p0.test.PSLoadPoolBackedDataSource.ds:Ljavax/sql/DataSource;
7: aconst_null
astore 2
start local 2 8: aconst_null
astore 3
start local 3 9: aload 1
invokeinterface javax.sql.DataSource.getConnection:()Ljava/sql/Connection;
astore 2
10: aload 2
invokeinterface java.sql.Connection.createStatement:()Ljava/sql/Statement;
astore 3
11: aload 3
ldc "CREATE TABLE testpbds ( a varchar(16), b varchar(16) )"
invokeinterface java.sql.Statement.executeUpdate:(Ljava/lang/String;)I
pop
12: goto 22
13: StackMap locals: java.lang.String[] javax.sql.DataSource java.sql.Connection java.sql.Statement
StackMap stack: java.sql.SQLException
astore 4
start local 4 14: aload 4
invokevirtual java.sql.SQLException.printStackTrace:()V
15: getstatic java.lang.System.err:Ljava/io/PrintStream;
ldc "relation testpbds already exists, or something bad happened."
invokevirtual java.io.PrintStream.println:(Ljava/lang/String;)V
end local 4 16: aload 3
invokestatic com.mchange.v1.db.sql.StatementUtils.attemptClose:(Ljava/sql/Statement;)Z
pop
17: aload 2
invokestatic com.mchange.v1.db.sql.ConnectionUtils.attemptClose:(Ljava/sql/Connection;)Z
pop
goto 24
18: StackMap locals:
StackMap stack: java.lang.Throwable
astore 5
19: aload 3
invokestatic com.mchange.v1.db.sql.StatementUtils.attemptClose:(Ljava/sql/Statement;)Z
pop
20: aload 2
invokestatic com.mchange.v1.db.sql.ConnectionUtils.attemptClose:(Ljava/sql/Connection;)Z
pop
21: aload 5
athrow
22: StackMap locals:
StackMap stack:
aload 3
invokestatic com.mchange.v1.db.sql.StatementUtils.attemptClose:(Ljava/sql/Statement;)Z
pop
23: aload 2
invokestatic com.mchange.v1.db.sql.ConnectionUtils.attemptClose:(Ljava/sql/Connection;)Z
pop
24: StackMap locals:
StackMap stack:
iconst_0
istore 4
start local 4 25: goto 31
26: StackMap locals: int
StackMap stack:
new com.mchange.v2.c3p0.test.PSLoadPoolBackedDataSource$ChurnThread
dup
invokespecial com.mchange.v2.c3p0.test.PSLoadPoolBackedDataSource$ChurnThread.<init>:()V
astore 5
start local 5 27: aload 5
invokevirtual java.lang.Thread.start:()V
28: getstatic java.lang.System.out:Ljava/io/PrintStream;
new java.lang.StringBuilder
dup
ldc "THREAD MADE ["
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;
invokevirtual java.io.PrintStream.println:(Ljava/lang/String;)V
29: ldc 500
invokestatic java.lang.Thread.sleep:(J)V
end local 5 30: iinc 4 1
StackMap locals:
StackMap stack:
31: iload 4
bipush 100
if_icmplt 26
end local 4 end local 3 end local 2 end local 1 32: goto 35
33: StackMap locals: java.lang.String[]
StackMap stack: java.lang.Exception
astore 1
start local 1 34: aload 1
invokevirtual java.lang.Exception.printStackTrace:()V
end local 1 35: StackMap locals:
StackMap stack:
return
end local 0 LocalVariableTable:
Start End Slot Name Signature
0 36 0 argv [Ljava/lang/String;
6 32 1 ds_unpooled Ljavax/sql/DataSource;
8 32 2 con Ljava/sql/Connection;
9 32 3 stmt Ljava/sql/Statement;
14 16 4 e Ljava/sql/SQLException;
25 32 4 i I
27 30 5 t Ljava/lang/Thread;
34 35 1 e Ljava/lang/Exception;
Exception table:
from to target type
9 12 13 Class java.sql.SQLException
9 16 18 any
5 32 33 Class java.lang.Exception
MethodParameters:
Name Flags
argv
static void executeInsert(java.sql.Connection, java.util.Random);
descriptor: (Ljava/sql/Connection;Ljava/util/Random;)V
flags: (0x0008) ACC_STATIC
Code:
stack=3, locals=4, args_size=2
start local 0 start local 1 0: aconst_null
astore 2
start local 2 1: aload 0
ldc "INSERT INTO testpbds VALUES ( ? , ? )"
invokeinterface java.sql.Connection.prepareStatement:(Ljava/lang/String;)Ljava/sql/PreparedStatement;
astore 2
2: aload 2
iconst_1
aload 1
invokevirtual java.util.Random.nextInt:()I
invokeinterface java.sql.PreparedStatement.setInt:(II)V
3: aload 2
iconst_2
aload 1
invokevirtual java.util.Random.nextInt:()I
invokeinterface java.sql.PreparedStatement.setInt:(II)V
4: aload 2
invokeinterface java.sql.PreparedStatement.executeUpdate:()I
pop
5: getstatic java.lang.System.out:Ljava/io/PrintStream;
ldc "INSERTION"
invokevirtual java.io.PrintStream.println:(Ljava/lang/String;)V
6: goto 10
7: StackMap locals: java.sql.Connection java.util.Random java.sql.PreparedStatement
StackMap stack: java.lang.Throwable
astore 3
8: aload 2
invokestatic com.mchange.v1.db.sql.StatementUtils.attemptClose:(Ljava/sql/Statement;)Z
pop
9: aload 3
athrow
10: StackMap locals:
StackMap stack:
aload 2
invokestatic com.mchange.v1.db.sql.StatementUtils.attemptClose:(Ljava/sql/Statement;)Z
pop
11: return
end local 2 end local 1 end local 0 LocalVariableTable:
Start End Slot Name Signature
0 12 0 con Ljava/sql/Connection;
0 12 1 random Ljava/util/Random;
1 12 2 pstmt Ljava/sql/PreparedStatement;
Exception table:
from to target type
1 7 7 any
Exceptions:
throws java.sql.SQLException
MethodParameters:
Name Flags
con
random
static void executeSelect(java.sql.Connection, java.util.Random);
descriptor: (Ljava/sql/Connection;Ljava/util/Random;)V
flags: (0x0008) ACC_STATIC
Code:
stack=6, locals=7, args_size=2
start local 0 start local 1 0: invokestatic java.lang.System.currentTimeMillis:()J
lstore 2
start local 2 1: aconst_null
astore 4
start local 4 2: aconst_null
astore 5
start local 5 3: aload 0
ldc "SELECT count(*) FROM testpbds"
invokeinterface java.sql.Connection.prepareStatement:(Ljava/lang/String;)Ljava/sql/PreparedStatement;
astore 4
4: aload 4
invokeinterface java.sql.PreparedStatement.executeQuery:()Ljava/sql/ResultSet;
astore 5
5: aload 5
invokeinterface java.sql.ResultSet.next:()Z
pop
6: getstatic java.lang.System.out:Ljava/io/PrintStream;
new java.lang.StringBuilder
dup
ldc "SELECT [count="
invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
aload 5
iconst_1
invokeinterface java.sql.ResultSet.getInt:(I)I
invokevirtual java.lang.StringBuilder.append:(I)Ljava/lang/StringBuilder;
ldc ", time="
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
7: invokestatic java.lang.System.currentTimeMillis:()J
lload 2
lsub
invokevirtual java.lang.StringBuilder.append:(J)Ljava/lang/StringBuilder;
ldc " msecs]"
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
8: invokevirtual java.io.PrintStream.println:(Ljava/lang/String;)V
9: goto 14
10: StackMap locals: java.sql.Connection java.util.Random long java.sql.PreparedStatement java.sql.ResultSet
StackMap stack: java.lang.Throwable
astore 6
11: aload 5
invokestatic com.mchange.v1.db.sql.ResultSetUtils.attemptClose:(Ljava/sql/ResultSet;)Z
pop
12: aload 4
invokestatic com.mchange.v1.db.sql.StatementUtils.attemptClose:(Ljava/sql/Statement;)Z
pop
13: aload 6
athrow
14: StackMap locals:
StackMap stack:
aload 5
invokestatic com.mchange.v1.db.sql.ResultSetUtils.attemptClose:(Ljava/sql/ResultSet;)Z
pop
15: aload 4
invokestatic com.mchange.v1.db.sql.StatementUtils.attemptClose:(Ljava/sql/Statement;)Z
pop
16: return
end local 5 end local 4 end local 2 end local 1 end local 0 LocalVariableTable:
Start End Slot Name Signature
0 17 0 con Ljava/sql/Connection;
0 17 1 random Ljava/util/Random;
1 17 2 l J
2 17 4 pstmt Ljava/sql/PreparedStatement;
3 17 5 rs Ljava/sql/ResultSet;
Exception table:
from to target type
3 10 10 any
Exceptions:
throws java.sql.SQLException
MethodParameters:
Name Flags
con
random
static void executeDelete(java.sql.Connection, java.util.Random);
descriptor: (Ljava/sql/Connection;Ljava/util/Random;)V
flags: (0x0008) ACC_STATIC
Code:
stack=4, locals=6, args_size=2
start local 0 start local 1 0: aconst_null
astore 2
start local 2 1: aconst_null
astore 3
start local 3 2: aload 0
ldc "DELETE FROM testpbds"
invokeinterface java.sql.Connection.prepareStatement:(Ljava/lang/String;)Ljava/sql/PreparedStatement;
astore 2
3: aload 2
invokeinterface java.sql.PreparedStatement.executeUpdate:()I
istore 4
start local 4 4: getstatic java.lang.System.out:Ljava/io/PrintStream;
new java.lang.StringBuilder
dup
ldc "DELETE ["
invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
iload 4
invokevirtual java.lang.StringBuilder.append:(I)Ljava/lang/StringBuilder;
ldc " rows]"
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
end local 4 5: goto 10
6: StackMap locals: java.sql.Connection java.util.Random java.sql.PreparedStatement java.sql.ResultSet
StackMap stack: java.lang.Throwable
astore 5
7: aload 3
invokestatic com.mchange.v1.db.sql.ResultSetUtils.attemptClose:(Ljava/sql/ResultSet;)Z
pop
8: aload 2
invokestatic com.mchange.v1.db.sql.StatementUtils.attemptClose:(Ljava/sql/Statement;)Z
pop
9: aload 5
athrow
10: StackMap locals:
StackMap stack:
aload 3
invokestatic com.mchange.v1.db.sql.ResultSetUtils.attemptClose:(Ljava/sql/ResultSet;)Z
pop
11: aload 2
invokestatic com.mchange.v1.db.sql.StatementUtils.attemptClose:(Ljava/sql/Statement;)Z
pop
12: return
end local 3 end local 2 end local 1 end local 0 LocalVariableTable:
Start End Slot Name Signature
0 13 0 con Ljava/sql/Connection;
0 13 1 random Ljava/util/Random;
1 13 2 pstmt Ljava/sql/PreparedStatement;
2 13 3 rs Ljava/sql/ResultSet;
4 5 4 deleted I
Exception table:
from to target type
2 6 6 any
Exceptions:
throws java.sql.SQLException
MethodParameters:
Name Flags
con
random
}
SourceFile: "PSLoadPoolBackedDataSource.java"
NestMembers:
com.mchange.v2.c3p0.test.PSLoadPoolBackedDataSource$ChurnThread
InnerClasses:
ChurnThread = com.mchange.v2.c3p0.test.PSLoadPoolBackedDataSource$ChurnThread of com.mchange.v2.c3p0.test.PSLoadPoolBackedDataSource