public class SQLTool
extends java.lang.Object
Modifier and Type | Class and Description |
---|---|
class |
SQLTool.Metrics
LogSQL metrics
|
class |
SQLTool.TopSQL |
Constructor and Description |
---|
SQLTool() |
Modifier and Type | Method and Description |
---|---|
static void |
clearStatistics() |
static double |
getAvgTime()
Average of SQL times in milliseconds
|
static long |
getCountTotal()
Requests counter
|
static SQLTool.Metrics |
getMetrics()
Get the SQL metrics for the period
|
static java.lang.String |
getSequenceName(int dbvendor,
java.lang.String table,
java.lang.String col) |
static java.lang.String |
getString(java.sql.ResultSet rs,
int type,
int index)
Get a String in a result
|
static int |
getTopSize() |
static java.util.List<SQLTool.TopSQL> |
getTopSQL()
Get the top SQL long requests
|
static double |
getTotalTime()
Total of SQL times in milliseconds
|
static void |
insertTopSQL(int index,
java.lang.String date,
java.lang.String sql,
long ms,
java.lang.String logId) |
static boolean |
rebuildSequence(java.lang.String datasource,
java.lang.String table)
Rebuild sequence associated with an internal table
|
static void |
setTopSize(int size) |
static void |
statistics(java.lang.String sql,
java.util.List<ObjectField> host,
long begin,
java.lang.String login)
Manage SQL statistics (time average, long requests...)
|
static void |
statistics(java.lang.String sql,
long begin,
java.lang.String login)
SQL statistics
|
public static java.lang.String getString(java.sql.ResultSet rs, int type, int index)
public static void setTopSize(int size)
public static int getTopSize()
public static java.util.List<SQLTool.TopSQL> getTopSQL()
public static long getCountTotal()
public static double getAvgTime()
public static double getTotalTime()
public static SQLTool.Metrics getMetrics()
public static void statistics(java.lang.String sql, long begin, java.lang.String login)
sql
- Querybegin
- Start time (ms)public static void statistics(java.lang.String sql, java.util.List<ObjectField> host, long begin, java.lang.String login)
sql
- Queryhost
- Host values to tracebegin
- Start time (ms)public static void insertTopSQL(int index, java.lang.String date, java.lang.String sql, long ms, java.lang.String logId)
public static void clearStatistics()
public static java.lang.String getSequenceName(int dbvendor, java.lang.String table, java.lang.String col)
public static boolean rebuildSequence(java.lang.String datasource, java.lang.String table)
datasource
- Datasource nametable
- Table name (with a row_id primary key)Copyright (c)2006-2015 Simplicite Software. All Rights Reserved.