public class SQLUtilities
extends java.lang.Object
Modifier and Type | Field and Description |
---|---|
static java.lang.String[] |
allDataTypesColumnNames |
private static java.lang.String[][] |
allDataTypesSQLData |
static java.lang.String |
NULL_VALUE |
static java.lang.String[] |
SQLTypes |
static java.lang.String |
VALID_DATE_STRING |
static java.lang.String |
VALID_TIME_STRING |
static java.lang.String |
VALID_TIMESTAMP_STRING |
Constructor and Description |
---|
SQLUtilities() |
Modifier and Type | Method and Description |
---|---|
static void |
createAndPopulateAllDataTypesTable(java.sql.Statement s)
Create a table AllDataTypesTable and populate with data
|
static RuntimeStatisticsParser |
executeAndGetRuntimeStatistics(java.sql.Connection conn,
java.lang.String sql) |
static RuntimeStatisticsParser |
getRuntimeStatisticsParser(java.sql.Statement s)
Assumes user previously executed
"call SYSCS_UTIL.SYSCS_SET_RUNTIMESTATISTICS(1)";
|
public static java.lang.String VALID_DATE_STRING
public static java.lang.String VALID_TIME_STRING
public static java.lang.String VALID_TIMESTAMP_STRING
public static java.lang.String NULL_VALUE
public static java.lang.String[] allDataTypesColumnNames
private static java.lang.String[][] allDataTypesSQLData
public static java.lang.String[] SQLTypes
public static void createAndPopulateAllDataTypesTable(java.sql.Statement s) throws java.sql.SQLException
s
- java.sql.SQLException
public static RuntimeStatisticsParser getRuntimeStatisticsParser(java.sql.Statement s) throws java.sql.SQLException
s
- Statement to use for calling runtime statistics functionjava.sql.SQLException
public static RuntimeStatisticsParser executeAndGetRuntimeStatistics(java.sql.Connection conn, java.lang.String sql) throws java.sql.SQLException
java.sql.SQLException
Apache Derby V10.13 Internals - Copyright © 2004,2016 The Apache Software Foundation. All Rights Reserved.