C D E F G H I M N O P S T U W

C

clearError() - Method in class ua.gradsoft.xwikisql.impl.InMemorySqlResult
 
clearError() - Method in class ua.gradsoft.xwikisql.SqlDatabase
 
clearError() - Method in interface ua.gradsoft.xwikisql.SqlErrorable
clear all information about error, so wasError become false.

D

DateParser - Class in ua.gradsoft.xwikisql.imported.jigsaw
Date parser for ISO 8601 format http://www.w3.org/TR/1998/NOTE-datetime-19980827
DateParser() - Constructor for class ua.gradsoft.xwikisql.imported.jigsaw.DateParser
 

E

executeQuery(String) - Method in class ua.gradsoft.xwikisql.SqlDatabase
execute sql query sql .
executeQuery(String, List<Object>) - Method in class ua.gradsoft.xwikisql.SqlDatabase
execute sql query sql with parameters params .
executeUpdate(String) - Method in class ua.gradsoft.xwikisql.SqlDatabase
execute sql statement sql .
executeUpdate(String, List<Object>) - Method in class ua.gradsoft.xwikisql.SqlDatabase
execute sql statement sql with parameters params .

F

flushCache() - Method in class ua.gradsoft.xwikisql.SqlPlugin
Deprecated.  

G

getBigDecimal(String) - Method in class ua.gradsoft.xwikisql.impl.InMemorySqlResultRow
 
getBigDecimal(int) - Method in class ua.gradsoft.xwikisql.impl.InMemorySqlResultRow
 
getBigDecimal(String) - Method in interface ua.gradsoft.xwikisql.SqlResultRow
retrieve object in column with name name as BigDecimal.
getBigDecimal(int) - Method in interface ua.gradsoft.xwikisql.SqlResultRow
retrieve object in column with index i as BigDecimal.
getBoolean(String) - Method in class ua.gradsoft.xwikisql.impl.InMemorySqlResultRow
 
getBoolean(int) - Method in class ua.gradsoft.xwikisql.impl.InMemorySqlResultRow
 
getBoolean(String) - Method in interface ua.gradsoft.xwikisql.SqlResultRow
retrieve object in column with name name as Boolean.
getBoolean(int) - Method in interface ua.gradsoft.xwikisql.SqlResultRow
retrieve object in column with index i as Boolean.
getColumnIndex(String) - Method in class ua.gradsoft.xwikisql.impl.InMemorySqlResult
 
getColumnIndex(String) - Method in interface ua.gradsoft.xwikisql.SqlResult
retrieve column index by name;
getColumnName(int) - Method in class ua.gradsoft.xwikisql.impl.InMemorySqlResult
 
getColumnName(int) - Method in interface ua.gradsoft.xwikisql.SqlResult
get column name if one exists, otherwise handle error.
getColumnType(String) - Method in class ua.gradsoft.xwikisql.impl.InMemorySqlResult
 
getColumnType(int) - Method in class ua.gradsoft.xwikisql.impl.InMemorySqlResult
 
getColumnType(String) - Method in interface ua.gradsoft.xwikisql.SqlResult
retrieve name of column type by column name, as specified in java.sql.Types
getColumnType(int) - Method in interface ua.gradsoft.xwikisql.SqlResult
retrieve name of column type by column index,
getColumnTypeAsInt(String) - Method in class ua.gradsoft.xwikisql.impl.InMemorySqlResult
 
getColumnTypeAsInt(int) - Method in class ua.gradsoft.xwikisql.impl.InMemorySqlResult
 
getColumnTypeAsInt(String) - Method in interface ua.gradsoft.xwikisql.SqlResult
retrieve int value of column type by name, as specified in java.sql.Types
getColumnTypeAsInt(int) - Method in interface ua.gradsoft.xwikisql.SqlResult
retrieve int value of column type by index,
getConfiguration() - Method in class ua.gradsoft.xwikisql.SqlPlugin
 
getDatabase(String) - Method in class ua.gradsoft.xwikisql.SqlPluginApi
get database object.
getDate(String) - Method in class ua.gradsoft.xwikisql.impl.InMemorySqlResultRow
 
getDate(int) - Method in class ua.gradsoft.xwikisql.impl.InMemorySqlResultRow
 
getDate(String) - Method in interface ua.gradsoft.xwikisql.SqlResultRow
retrieve object in column with name name as Date.
getDate(int) - Method in interface ua.gradsoft.xwikisql.SqlResultRow
retrieve object in column with index i as Date.
getDouble(String) - Method in class ua.gradsoft.xwikisql.impl.InMemorySqlResultRow
 
getDouble(int) - Method in class ua.gradsoft.xwikisql.impl.InMemorySqlResultRow
 
getDouble(String) - Method in interface ua.gradsoft.xwikisql.SqlResultRow
retrieve object in column with name name as Double.
getDouble(int) - Method in interface ua.gradsoft.xwikisql.SqlResultRow
retrieve object in column with index i as Double.
getInitialContextPrefix() - Method in class ua.gradsoft.xwikisql.SqlPluginConfiguration
get initialContextPrefix property.
getInteger(String) - Method in class ua.gradsoft.xwikisql.impl.InMemorySqlResultRow
 
getInteger(int) - Method in class ua.gradsoft.xwikisql.impl.InMemorySqlResultRow
 
getInteger(String) - Method in interface ua.gradsoft.xwikisql.SqlResultRow
retrieve object in column with name name as integer.
getInteger(int) - Method in interface ua.gradsoft.xwikisql.SqlResultRow
retrieve object in column with index i as long.
getIsoDate(Date) - Static method in class ua.gradsoft.xwikisql.imported.jigsaw.DateParser
Generate a ISO 8601 date
getIsoDateNoMillis(Date) - Static method in class ua.gradsoft.xwikisql.imported.jigsaw.DateParser
Generate a ISO 8601 date
getLastException() - Method in class ua.gradsoft.xwikisql.impl.InMemorySqlResult
 
getLastException() - Method in class ua.gradsoft.xwikisql.SqlDatabase
 
getLastException() - Method in interface ua.gradsoft.xwikisql.SqlErrorable
get last Exception
getLogEnabled() - Method in class ua.gradsoft.xwikisql.impl.InMemorySqlResult
 
getLogEnabled() - Method in class ua.gradsoft.xwikisql.SqlDatabase
 
getLogEnabled() - Method in interface ua.gradsoft.xwikisql.SqlErrorable
when this propery is set to true - do logging according with settings in xwiki configurations, otherwise - complete disable one.
getLogEnabled() - Method in class ua.gradsoft.xwikisql.SqlPluginConfiguration
when property is enabled (by default) do logging according with settings of xwiki log system.
getLogSql() - Method in class ua.gradsoft.xwikisql.SqlPluginConfiguration
when property is enabled, log executed sql statements.
getLong(String) - Method in class ua.gradsoft.xwikisql.impl.InMemorySqlResultRow
 
getLong(int) - Method in class ua.gradsoft.xwikisql.impl.InMemorySqlResultRow
 
getLong(String) - Method in interface ua.gradsoft.xwikisql.SqlResultRow
retrieve object in column with name name as long.
getLong(int) - Method in interface ua.gradsoft.xwikisql.SqlResultRow
retrieve object in column with index i as long.
getMaxRowsRetrieved() - Method in class ua.gradsoft.xwikisql.SqlPluginConfiguration
get maximum number of rows, which can be retrieved in one sql query.
getName() - Method in class ua.gradsoft.xwikisql.SqlPlugin
"sql"
getNativeConnection() - Method in class ua.gradsoft.xwikisql.SqlDatabase
direct access to native Java connection.
getNColumns() - Method in class ua.gradsoft.xwikisql.impl.InMemorySqlResult
 
getNColumns() - Method in interface ua.gradsoft.xwikisql.SqlResult
get number of columns
getNRows() - Method in class ua.gradsoft.xwikisql.impl.InMemorySqlResult
 
getNRows() - Method in interface ua.gradsoft.xwikisql.SqlResult
get number of rows.
getNullAsEmptyString() - Method in class ua.gradsoft.xwikisql.SqlPluginConfiguration
when property is enabled, SqlResultRow.getString(String columnName) and SqlResultRow.getString(int columnIndex) methods return empty string instead null, when appropriative column value is null.
getObject(String) - Method in class ua.gradsoft.xwikisql.impl.InMemorySqlResultRow
 
getObject(int) - Method in class ua.gradsoft.xwikisql.impl.InMemorySqlResultRow
 
getObject(String) - Method in interface ua.gradsoft.xwikisql.SqlResultRow
retrieve object in column with name name
getObject(int) - Method in interface ua.gradsoft.xwikisql.SqlResultRow
retrieve object in column with index i
getPluginApi(XWikiPluginInterface, XWikiContext) - Method in class ua.gradsoft.xwikisql.SqlPlugin
 
getSqlPlugin() - Method in class ua.gradsoft.xwikisql.SqlPluginApi
give access to implemtation class of sql plugin.
getSqlPluginApi() - Method in class ua.gradsoft.xwikisql.SqlDatabase
 
getString(String) - Method in class ua.gradsoft.xwikisql.impl.InMemorySqlResultRow
 
getString(int) - Method in class ua.gradsoft.xwikisql.impl.InMemorySqlResultRow
 
getString(String) - Method in interface ua.gradsoft.xwikisql.SqlResultRow
retrieve object in column with name name as string.
getString(int) - Method in interface ua.gradsoft.xwikisql.SqlResultRow
retrieve object in column with index i as string.
getThrowExceptions() - Method in class ua.gradsoft.xwikisql.impl.InMemorySqlResult
 
getThrowExceptions() - Method in class ua.gradsoft.xwikisql.SqlDatabase
 
getThrowExceptions() - Method in interface ua.gradsoft.xwikisql.SqlErrorable
when this property is set to true, than engine throws exception on error, otherwise - method usially return null and exceptions are saved for further retrieving.
getThrowExceptions() - Method in class ua.gradsoft.xwikisql.SqlPluginConfiguration
get policy of error handling.
getTypeByName(String) - Static method in class ua.gradsoft.xwikisql.SqlTypes
 

H

handleError(String, String, Exception) - Method in class ua.gradsoft.xwikisql.impl.InMemorySqlResult
 
handleError(String, String, Exception) - Method in class ua.gradsoft.xwikisql.SqlDatabase
 
handleError(String, String, Exception) - Method in interface ua.gradsoft.xwikisql.SqlErrorable
also set own last exception and wasError to appropriative values.
handleError(SqlErrorable, String, String, Exception) - Method in class ua.gradsoft.xwikisql.SqlPlugin
 
hasColumnName(String) - Method in class ua.gradsoft.xwikisql.impl.InMemorySqlResult
 
hasColumnName(String) - Method in interface ua.gradsoft.xwikisql.SqlResult
check if name is one of column names.
hasMoreElements() - Method in class ua.gradsoft.xwikisql.impl.InMemorySqlResult
 

I

init(XWikiContext) - Method in class ua.gradsoft.xwikisql.SqlPlugin
 
InMemorySqlResult - Class in ua.gradsoft.xwikisql.impl
SQLResult, which holds all in memory
InMemorySqlResult(SqlDatabase, ResultSet) - Constructor for class ua.gradsoft.xwikisql.impl.InMemorySqlResult
 
InMemorySqlResultRow - Class in ua.gradsoft.xwikisql.impl
SQLResultRow in memory.
InvalidDateException - Exception in ua.gradsoft.xwikisql.imported.jigsaw
Invalid parse
InvalidDateException(String) - Constructor for exception ua.gradsoft.xwikisql.imported.jigsaw.InvalidDateException
 
isNotAllRows() - Method in class ua.gradsoft.xwikisql.impl.InMemorySqlResult
 
isNotAllRows() - Method in interface ua.gradsoft.xwikisql.SqlResult
Indicate situation, where we does not retrieve all rows.
isNull(String) - Method in class ua.gradsoft.xwikisql.impl.InMemorySqlResultRow
 
isNull(int) - Method in class ua.gradsoft.xwikisql.impl.InMemorySqlResultRow
 
isNull(String) - Method in interface ua.gradsoft.xwikisql.SqlResultRow
true is object in appropriative column is null.
isNull(int) - Method in interface ua.gradsoft.xwikisql.SqlResultRow
true is object in appropriative column is null.

M

main(String[]) - Static method in class ua.gradsoft.xwikisql.imported.jigsaw.DateParser
 

N

nextElement() - Method in class ua.gradsoft.xwikisql.impl.InMemorySqlResult
 

O

objectToBigDecimal(SqlErrorable, Object) - Static method in class ua.gradsoft.xwikisql.SqlTypes
 
objectToBoolean(SqlErrorable, Object) - Static method in class ua.gradsoft.xwikisql.SqlTypes
 
objectToDate(SqlErrorable, Object) - Static method in class ua.gradsoft.xwikisql.SqlTypes
 
objectToDouble(SqlErrorable, Object) - Static method in class ua.gradsoft.xwikisql.SqlTypes
 
objectToInteger(SqlErrorable, Object) - Static method in class ua.gradsoft.xwikisql.SqlTypes
 
objectToLong(SqlErrorable, Object) - Static method in class ua.gradsoft.xwikisql.SqlTypes
 
objectToString(SqlPlugin, SqlErrorable, Object) - Static method in class ua.gradsoft.xwikisql.SqlTypes
 

P

parse(String) - Static method in class ua.gradsoft.xwikisql.imported.jigsaw.DateParser
Parse the given string in ISO 8601 format and build a Date object.

S

setInitalContextPrefix(String) - Method in class ua.gradsoft.xwikisql.SqlPluginConfiguration
set initialContextPrefix property to value value
setLastException(Exception) - Method in class ua.gradsoft.xwikisql.impl.InMemorySqlResult
 
setLastException(Exception) - Method in class ua.gradsoft.xwikisql.SqlDatabase
 
setLastException(Exception) - Method in interface ua.gradsoft.xwikisql.SqlErrorable
set last Exception
setLogEnabled(boolean) - Method in class ua.gradsoft.xwikisql.impl.InMemorySqlResult
 
setLogEnabled(boolean) - Method in class ua.gradsoft.xwikisql.SqlDatabase
 
setLogEnabled(boolean) - Method in interface ua.gradsoft.xwikisql.SqlErrorable
set logEnabled property,
setLogEnabled(boolean) - Method in class ua.gradsoft.xwikisql.SqlPluginConfiguration
set logEnabled property
setLogSql(boolean) - Method in class ua.gradsoft.xwikisql.SqlPluginConfiguration
set logSql property
setMaxRowsRetrieved(int) - Method in class ua.gradsoft.xwikisql.SqlPluginConfiguration
 
setNullAsEmptyString(boolean) - Method in class ua.gradsoft.xwikisql.SqlPluginConfiguration
set nullAsEmptyString property to value value
setThrowExceptions(boolean) - Method in class ua.gradsoft.xwikisql.impl.InMemorySqlResult
 
setThrowExceptions(boolean) - Method in class ua.gradsoft.xwikisql.SqlDatabase
 
setThrowExceptions(boolean) - Method in interface ua.gradsoft.xwikisql.SqlErrorable
set throwExceptions property,
setThrowExceptions(boolean) - Method in class ua.gradsoft.xwikisql.SqlPluginConfiguration
set throwExceptions property
SqlDatabase - Class in ua.gradsoft.xwikisql
Object, which holds name of connection pool and can evaluate sql statements on it.
SqlErrorable - Interface in ua.gradsoft.xwikisql
Generic interface for objects, which can track sql errors.
SqlPlugin - Class in ua.gradsoft.xwikisql
XWiki sql plugin
SqlPlugin(String, String, XWikiContext) - Constructor for class ua.gradsoft.xwikisql.SqlPlugin
 
SqlPluginApi - Class in ua.gradsoft.xwikisql
API Object
SqlPluginApi(SqlPlugin, XWikiContext) - Constructor for class ua.gradsoft.xwikisql.SqlPluginApi
 
SqlPluginConfiguration - Class in ua.gradsoft.xwikisql
Object, which holds configuration information.
SqlPluginConfiguration() - Constructor for class ua.gradsoft.xwikisql.SqlPluginConfiguration
 
SqlResult - Interface in ua.gradsoft.xwikisql
Assess object for results of query execution.
SqlResultRow - Interface in ua.gradsoft.xwikisql
Temporary object, which used for navigation accross query results in velocity #foreach loops.
SqlRuntimeException - Exception in ua.gradsoft.xwikisql
Runtime exception, which denote errors inside SQL.
SqlRuntimeException(String) - Constructor for exception ua.gradsoft.xwikisql.SqlRuntimeException
 
SqlRuntimeException(String, Exception) - Constructor for exception ua.gradsoft.xwikisql.SqlRuntimeException
 
SqlRuntimeException(Exception) - Constructor for exception ua.gradsoft.xwikisql.SqlRuntimeException
 
SqlTypes - Class in ua.gradsoft.xwikisql
static class for work with sql types.
SqlTypes() - Constructor for class ua.gradsoft.xwikisql.SqlTypes
 

T

test(String) - Static method in class ua.gradsoft.xwikisql.imported.jigsaw.DateParser
 
test(Date) - Static method in class ua.gradsoft.xwikisql.imported.jigsaw.DateParser
 
typeName(int) - Static method in class ua.gradsoft.xwikisql.SqlTypes
 

U

ua.gradsoft.xwikisql - package ua.gradsoft.xwikisql
XWikiSQL - plugin which allows us to query foreigh relational databases from velocity pages.
ua.gradsoft.xwikisql.impl - package ua.gradsoft.xwikisql.impl
Implemetation specific files, which can be changed.
ua.gradsoft.xwikisql.imported.jigsaw - package ua.gradsoft.xwikisql.imported.jigsaw
classes for parsing/printing Date in ISO8601 format, imported fron w3 jigsaw with minimal changes (changed package name).

W

wasError() - Method in class ua.gradsoft.xwikisql.impl.InMemorySqlResult
 
wasError() - Method in class ua.gradsoft.xwikisql.SqlDatabase
 
wasError() - Method in interface ua.gradsoft.xwikisql.SqlErrorable
true if error was handled (and later not cleared) during some previous operations on this object

C D E F G H I M N O P S T U W