class org.hsqldb.util.OracleTransferHelper extends org.hsqldb.util.TransferHelper
minor version: 0
major version: 59
flags: flags: (0x0020) ACC_SUPER
this_class: org.hsqldb.util.OracleTransferHelper
super_class: org.hsqldb.util.TransferHelper
{
private final int ORACLE;
descriptor: I
flags: (0x0012) ACC_PRIVATE, ACC_FINAL
ConstantValue: 0
private final int HSQLDB;
descriptor: I
flags: (0x0012) ACC_PRIVATE, ACC_FINAL
ConstantValue: 1
java.lang.String[][] Funcs;
descriptor: [[Ljava/lang/String;
flags: (0x0000)
void <init>();
descriptor: ()V
flags: (0x0000)
Code:
stack=8, locals=1, args_size=1
start local 0 0: aload 0
invokespecial org.hsqldb.util.TransferHelper.<init>:()V
1: aload 0
iconst_0
putfield org.hsqldb.util.OracleTransferHelper.ORACLE:I
2: aload 0
iconst_1
putfield org.hsqldb.util.OracleTransferHelper.HSQLDB:I
3: aload 0
iconst_1
anewarray java.lang.String[]
dup
iconst_0
4: iconst_2
anewarray java.lang.String
dup
iconst_0
5: ldc "now()"
aastore
dup
iconst_1
ldc "'now'"
aastore
aastore
putfield org.hsqldb.util.OracleTransferHelper.Funcs:[[Ljava/lang/String;
6: getstatic java.lang.System.out:Ljava/io/PrintStream;
ldc "simple init of OracleTransferHelper"
invokevirtual java.io.PrintStream.println:(Ljava/lang/String;)V
7: return
end local 0 LocalVariableTable:
Start End Slot Name Signature
0 8 0 this Lorg/hsqldb/util/OracleTransferHelper;
void <init>(org.hsqldb.util.TransferDb, org.hsqldb.util.Traceable, java.lang.String);
descriptor: (Lorg/hsqldb/util/TransferDb;Lorg/hsqldb/util/Traceable;Ljava/lang/String;)V
flags: (0x0000)
Code:
stack=8, locals=4, args_size=4
start local 0 start local 1 start local 2 start local 3 0: aload 0
aload 1
aload 2
aload 3
invokespecial org.hsqldb.util.TransferHelper.<init>:(Lorg/hsqldb/util/TransferDb;Lorg/hsqldb/util/Traceable;Ljava/lang/String;)V
1: aload 0
iconst_0
putfield org.hsqldb.util.OracleTransferHelper.ORACLE:I
2: aload 0
iconst_1
putfield org.hsqldb.util.OracleTransferHelper.HSQLDB:I
3: aload 0
iconst_1
anewarray java.lang.String[]
dup
iconst_0
4: iconst_2
anewarray java.lang.String
dup
iconst_0
5: ldc "now()"
aastore
dup
iconst_1
ldc "'now'"
aastore
aastore
putfield org.hsqldb.util.OracleTransferHelper.Funcs:[[Ljava/lang/String;
6: return
end local 3 end local 2 end local 1 end local 0 LocalVariableTable:
Start End Slot Name Signature
0 7 0 this Lorg/hsqldb/util/OracleTransferHelper;
0 7 1 database Lorg/hsqldb/util/TransferDb;
0 7 2 t Lorg/hsqldb/util/Traceable;
0 7 3 q Ljava/lang/String;
MethodParameters:
Name Flags
database
t
q
void set(org.hsqldb.util.TransferDb, org.hsqldb.util.Traceable, java.lang.String);
descriptor: (Lorg/hsqldb/util/TransferDb;Lorg/hsqldb/util/Traceable;Ljava/lang/String;)V
flags: (0x0000)
Code:
stack=4, locals=6, args_size=4
start local 0 start local 1 start local 2 start local 3 0: aload 0
aload 1
aload 2
aload 3
invokespecial org.hsqldb.util.TransferHelper.set:(Lorg/hsqldb/util/TransferDb;Lorg/hsqldb/util/Traceable;Ljava/lang/String;)V
1: ldc "ALTER SESSION SET NLS_DATE_FORMAT = 'YYYY-MM-DD HH24:MI:SS'"
2: astore 4
start local 4 3: getstatic java.lang.System.out:Ljava/io/PrintStream;
new java.lang.StringBuilder
dup
ldc "dateFormatStmnt: "
invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
aload 4
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
4: aload 0
getfield org.hsqldb.util.OracleTransferHelper.tracer:Lorg/hsqldb/util/Traceable;
new java.lang.StringBuilder
dup
ldc "Executing "
invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
aload 4
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
invokeinterface org.hsqldb.util.Traceable.trace:(Ljava/lang/String;)V
5: aload 1
aload 4
invokevirtual org.hsqldb.util.TransferDb.execute:(Ljava/lang/String;)Z
pop
6: goto 10
StackMap locals: org.hsqldb.util.OracleTransferHelper org.hsqldb.util.TransferDb org.hsqldb.util.Traceable java.lang.String java.lang.String
StackMap stack: java.lang.Exception
7: astore 5
start local 5 8: aload 0
getfield org.hsqldb.util.OracleTransferHelper.tracer:Lorg/hsqldb/util/Traceable;
new java.lang.StringBuilder
dup
ldc "Ignoring error "
invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
aload 5
invokevirtual java.lang.Exception.getMessage:()Ljava/lang/String;
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
invokeinterface org.hsqldb.util.Traceable.trace:(Ljava/lang/String;)V
9: getstatic java.lang.System.out:Ljava/io/PrintStream;
new java.lang.StringBuilder
dup
ldc "Ignoring error "
invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
aload 5
invokevirtual java.lang.Exception.getMessage:()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
end local 5 10: StackMap locals:
StackMap stack:
return
end local 4 end local 3 end local 2 end local 1 end local 0 LocalVariableTable:
Start End Slot Name Signature
0 11 0 this Lorg/hsqldb/util/OracleTransferHelper;
0 11 1 database Lorg/hsqldb/util/TransferDb;
0 11 2 t Lorg/hsqldb/util/Traceable;
0 11 3 q Ljava/lang/String;
3 11 4 dateFormatStmnt Ljava/lang/String;
8 10 5 e Ljava/lang/Exception;
Exception table:
from to target type
4 6 7 Class java.lang.Exception
MethodParameters:
Name Flags
database
t
q
java.lang.String fixupColumnDefRead(org.hsqldb.util.TransferTable, java.sql.ResultSetMetaData, java.lang.String, java.sql.ResultSet, int);
descriptor: (Lorg/hsqldb/util/TransferTable;Ljava/sql/ResultSetMetaData;Ljava/lang/String;Ljava/sql/ResultSet;I)Ljava/lang/String;
flags: (0x0000)
Code:
stack=6, locals=6, args_size=6
start local 0 start local 1 start local 2 start local 3 start local 4 start local 5 0: aload 0
aload 1
getfield org.hsqldb.util.TransferTable.Stmts:Lorg/hsqldb/util/SQLStatements;
getfield org.hsqldb.util.SQLStatements.sDestTable:Ljava/lang/String;
aload 2
aload 3
1: aload 4
iload 5
2: invokevirtual org.hsqldb.util.OracleTransferHelper.fixupColumnDefRead:(Ljava/lang/String;Ljava/sql/ResultSetMetaData;Ljava/lang/String;Ljava/sql/ResultSet;I)Ljava/lang/String;
areturn
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 3 0 this Lorg/hsqldb/util/OracleTransferHelper;
0 3 1 t Lorg/hsqldb/util/TransferTable;
0 3 2 meta Ljava/sql/ResultSetMetaData;
0 3 3 columnType Ljava/lang/String;
0 3 4 columnDesc Ljava/sql/ResultSet;
0 3 5 columnIndex I
Exceptions:
throws java.sql.SQLException
MethodParameters:
Name Flags
t
meta
columnType
columnDesc
columnIndex
java.lang.String fixupColumnDefWrite(org.hsqldb.util.TransferTable, java.sql.ResultSetMetaData, java.lang.String, java.sql.ResultSet, int);
descriptor: (Lorg/hsqldb/util/TransferTable;Ljava/sql/ResultSetMetaData;Ljava/lang/String;Ljava/sql/ResultSet;I)Ljava/lang/String;
flags: (0x0000)
Code:
stack=5, locals=10, args_size=6
start local 0 start local 1 start local 2 start local 3 start local 4 start local 5 0: aload 3
ldc "SERIAL"
invokevirtual java.lang.String.equals:(Ljava/lang/Object;)Z
ifeq 13
1: new java.lang.String
dup
new java.lang.StringBuilder
dup
ldc "_"
invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
aload 4
iconst_4
invokeinterface java.sql.ResultSet.getString:(I)Ljava/lang/String;
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
2: ldc "_seq"
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
3: invokespecial java.lang.String.<init>:(Ljava/lang/String;)V
astore 6
start local 6 4: bipush 31
aload 6
invokevirtual java.lang.String.length:()I
isub
istore 7
start local 7 5: aload 1
getfield org.hsqldb.util.TransferTable.Stmts:Lorg/hsqldb/util/SQLStatements;
getfield org.hsqldb.util.SQLStatements.sDestTable:Ljava/lang/String;
invokevirtual java.lang.String.length:()I
iload 7
if_icmple 10
6: new java.lang.StringBuilder
dup
aload 1
getfield org.hsqldb.util.TransferTable.Stmts:Lorg/hsqldb/util/SQLStatements;
getfield org.hsqldb.util.SQLStatements.sDestTable:Ljava/lang/String;
iconst_0
iload 7
invokevirtual java.lang.String.substring:(II)Ljava/lang/String;
invokestatic java.lang.String.valueOf:(Ljava/lang/Object;)Ljava/lang/String;
invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
7: aload 6
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
8: invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
astore 6
9: goto 11
10: StackMap locals: java.lang.String int
StackMap stack:
new java.lang.StringBuilder
dup
aload 1
getfield org.hsqldb.util.TransferTable.Stmts:Lorg/hsqldb/util/SQLStatements;
getfield org.hsqldb.util.SQLStatements.sDestTable:Ljava/lang/String;
invokestatic java.lang.String.valueOf:(Ljava/lang/Object;)Ljava/lang/String;
invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
aload 6
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
astore 6
11: StackMap locals:
StackMap stack:
new java.lang.StringBuilder
dup
ldc "DROP SEQUENCE "
invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
aload 6
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
ldc ";"
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
astore 8
start local 8 12: aload 1
getfield org.hsqldb.util.TransferTable.Stmts:Lorg/hsqldb/util/SQLStatements;
dup
getfield org.hsqldb.util.SQLStatements.sDestDrop:Ljava/lang/String;
new java.lang.StringBuilder
dup_x1
swap
invokestatic java.lang.String.valueOf:(Ljava/lang/Object;)Ljava/lang/String;
invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
aload 8
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
putfield org.hsqldb.util.SQLStatements.sDestDrop:Ljava/lang/String;
end local 8 end local 7 end local 6 13: StackMap locals:
StackMap stack:
iconst_0
istore 6
start local 6 14: goto 25
15: StackMap locals: int
StackMap stack:
aload 0
getfield org.hsqldb.util.OracleTransferHelper.Funcs:[[Ljava/lang/String;
iload 6
aaload
iconst_1
aaload
astore 7
start local 7 16: aload 3
aload 7
invokevirtual java.lang.String.indexOf:(Ljava/lang/String;)I
istore 8
start local 8 17: iload 8
iflt 24
18: aload 3
iconst_0
iload 8
invokevirtual java.lang.String.substring:(II)Ljava/lang/String;
astore 9
start local 9 19: new java.lang.StringBuilder
dup
aload 9
invokestatic java.lang.String.valueOf:(Ljava/lang/Object;)Ljava/lang/String;
invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
aload 0
getfield org.hsqldb.util.OracleTransferHelper.Funcs:[[Ljava/lang/String;
iload 6
aaload
iconst_0
aaload
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
astore 9
20: new java.lang.StringBuilder
dup
aload 9
invokestatic java.lang.String.valueOf:(Ljava/lang/Object;)Ljava/lang/String;
invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
aload 3
iload 8
21: aload 7
invokevirtual java.lang.String.length:()I
iadd
22: invokevirtual java.lang.String.substring:(I)Ljava/lang/String;
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
astore 9
23: aload 9
astore 3
end local 9 end local 8 end local 7 24: StackMap locals:
StackMap stack:
iinc 6 1
StackMap locals:
StackMap stack:
25: iload 6
aload 0
getfield org.hsqldb.util.OracleTransferHelper.Funcs:[[Ljava/lang/String;
arraylength
if_icmplt 15
end local 6 26: aload 3
areturn
end local 5 end local 4 end local 3 end local 2 end local 1 end local 0 LocalVariableTable:
Start End Slot Name Signature
0 27 0 this Lorg/hsqldb/util/OracleTransferHelper;
0 27 1 t Lorg/hsqldb/util/TransferTable;
0 27 2 meta Ljava/sql/ResultSetMetaData;
0 27 3 columnType Ljava/lang/String;
0 27 4 columnDesc Ljava/sql/ResultSet;
0 27 5 columnIndex I
4 13 6 SeqName Ljava/lang/String;
5 13 7 spaceleft I
12 13 8 DropSequence Ljava/lang/String;
14 26 6 Idx I
16 24 7 HSQLDB_func Ljava/lang/String;
17 24 8 iStartPos I
19 24 9 NewColumnType Ljava/lang/String;
Exceptions:
throws java.sql.SQLException
MethodParameters:
Name Flags
t
meta
columnType
columnDesc
columnIndex
void beginDataTransfer();
descriptor: ()V
flags: (0x0000)
Code:
stack=2, locals=1, args_size=1
start local 0 0: aload 0
getfield org.hsqldb.util.OracleTransferHelper.db:Lorg/hsqldb/util/TransferDb;
iconst_0
invokevirtual org.hsqldb.util.TransferDb.setAutoCommit:(Z)V
1: goto 3
StackMap locals:
StackMap stack: java.lang.Exception
2: pop
3: StackMap locals:
StackMap stack:
return
end local 0 LocalVariableTable:
Start End Slot Name Signature
0 4 0 this Lorg/hsqldb/util/OracleTransferHelper;
Exception table:
from to target type
0 1 2 Class java.lang.Exception
void endDataTransfer();
descriptor: ()V
flags: (0x0000)
Code:
stack=1, locals=1, args_size=1
start local 0 0: aload 0
getfield org.hsqldb.util.OracleTransferHelper.db:Lorg/hsqldb/util/TransferDb;
invokevirtual org.hsqldb.util.TransferDb.commit:()V
1: goto 3
StackMap locals:
StackMap stack: java.lang.Exception
2: pop
3: StackMap locals:
StackMap stack:
return
end local 0 LocalVariableTable:
Start End Slot Name Signature
0 4 0 this Lorg/hsqldb/util/OracleTransferHelper;
Exception table:
from to target type
0 1 2 Class java.lang.Exception
java.lang.String fixupColumnDefRead(java.lang.String, java.sql.ResultSetMetaData, java.lang.String, java.sql.ResultSet, int);
descriptor: (Ljava/lang/String;Ljava/sql/ResultSetMetaData;Ljava/lang/String;Ljava/sql/ResultSet;I)Ljava/lang/String;
flags: (0x0000)
Code:
stack=5, locals=13, args_size=6
start local 0 start local 1 start local 2 start local 3 start local 4 start local 5 0: new java.lang.String
dup
new java.lang.StringBuilder
dup
ldc "_"
invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
aload 4
iconst_4
invokeinterface java.sql.ResultSet.getString:(I)Ljava/lang/String;
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
ldc "_seq"
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
invokespecial java.lang.String.<init>:(Ljava/lang/String;)V
astore 6
start local 6 1: bipush 31
aload 6
invokevirtual java.lang.String.length:()I
isub
istore 7
start local 7 2: aload 1
invokevirtual java.lang.String.length:()I
iload 7
if_icmple 5
3: new java.lang.StringBuilder
dup
aload 1
iconst_0
iload 7
invokevirtual java.lang.String.substring:(II)Ljava/lang/String;
invokestatic java.lang.String.valueOf:(Ljava/lang/Object;)Ljava/lang/String;
invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
aload 6
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
astore 6
4: goto 6
5: StackMap locals: java.lang.String int
StackMap stack:
new java.lang.StringBuilder
dup
aload 1
invokestatic java.lang.String.valueOf:(Ljava/lang/Object;)Ljava/lang/String;
invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
aload 6
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
astore 6
6: StackMap locals:
StackMap stack:
new java.lang.StringBuilder
dup
ldc "nextval('\""
invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
aload 6
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
ldc "\"'"
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
astore 8
start local 8 7: aload 3
aload 8
invokevirtual java.lang.String.indexOf:(Ljava/lang/String;)I
iflt 9
8: ldc "SERIAL"
astore 3
9: StackMap locals: java.lang.String
StackMap stack:
iconst_0
istore 9
start local 9 10: goto 21
11: StackMap locals: int
StackMap stack:
aload 0
getfield org.hsqldb.util.OracleTransferHelper.Funcs:[[Ljava/lang/String;
iload 9
aaload
iconst_0
aaload
astore 10
start local 10 12: aload 3
aload 10
invokevirtual java.lang.String.indexOf:(Ljava/lang/String;)I
istore 11
start local 11 13: iload 11
iflt 20
14: aload 3
iconst_0
iload 11
invokevirtual java.lang.String.substring:(II)Ljava/lang/String;
astore 12
start local 12 15: new java.lang.StringBuilder
dup
aload 12
invokestatic java.lang.String.valueOf:(Ljava/lang/Object;)Ljava/lang/String;
invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
aload 0
getfield org.hsqldb.util.OracleTransferHelper.Funcs:[[Ljava/lang/String;
iload 9
aaload
iconst_1
aaload
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
astore 12
16: new java.lang.StringBuilder
dup
aload 12
invokestatic java.lang.String.valueOf:(Ljava/lang/Object;)Ljava/lang/String;
invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
aload 3
iload 11
17: aload 10
invokevirtual java.lang.String.length:()I
iadd
18: invokevirtual java.lang.String.substring:(I)Ljava/lang/String;
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
astore 12
19: aload 12
astore 3
end local 12 end local 11 end local 10 20: StackMap locals:
StackMap stack:
iinc 9 1
StackMap locals:
StackMap stack:
21: iload 9
aload 0
getfield org.hsqldb.util.OracleTransferHelper.Funcs:[[Ljava/lang/String;
arraylength
if_icmplt 11
end local 9 22: aload 3
areturn
end local 8 end local 7 end local 6 end local 5 end local 4 end local 3 end local 2 end local 1 end local 0 LocalVariableTable:
Start End Slot Name Signature
0 23 0 this Lorg/hsqldb/util/OracleTransferHelper;
0 23 1 aTableName Ljava/lang/String;
0 23 2 meta Ljava/sql/ResultSetMetaData;
0 23 3 columnType Ljava/lang/String;
0 23 4 columnDesc Ljava/sql/ResultSet;
0 23 5 columnIndex I
1 23 6 SeqName Ljava/lang/String;
2 23 7 spaceleft I
7 23 8 CompareString Ljava/lang/String;
10 22 9 Idx I
12 20 10 ORACLE_func Ljava/lang/String;
13 20 11 iStartPos I
15 20 12 NewColumnType Ljava/lang/String;
Exceptions:
throws java.sql.SQLException
MethodParameters:
Name Flags
aTableName
meta
columnType
columnDesc
columnIndex
}
SourceFile: "OracleTransferHelper.java"