public interface SQLConnectable
Modifier and Type | Interface and Description |
---|---|
static class |
SQLConnectable.QueryReader |
Modifier and Type | Field and Description |
---|---|
static int |
ACCESS |
static int |
DB2 |
static int |
GENERIC |
static int |
HIBERNATE |
static int |
HSQL |
static int |
JTDS |
static int |
MSSQL |
static int |
MYSQL |
static int |
ORACLE |
static int |
PALIO |
static int |
POSTGRESQL |
static int |
SYBASE |
Modifier and Type | Method and Description |
---|---|
void |
commit() |
java.lang.Object |
executeFunction(java.lang.String query,
java.lang.Object[] params,
java.lang.String outType) |
java.lang.Object[] |
executePL_SQL(java.lang.String query,
java.lang.Object[] params,
java.lang.Object[] outNrParams) |
java.lang.Object[] |
executeProcedure(java.lang.String query,
java.lang.Object[] params,
java.lang.Object[] outTypeParams) |
int |
fastRead(SQLConnectable.QueryReader reader,
java.lang.String query,
java.lang.Object... params) |
java.sql.DatabaseMetaData |
getMetaData() |
java.lang.String |
getName() |
java.sql.ResultSet |
getResultSet() |
java.sql.ResultSetMetaData |
getResultSetMetaData() |
java.lang.Long |
getSequence(java.lang.String sequenceName) |
int |
getType() |
java.lang.String |
getUrl() |
void |
init() |
boolean |
isNoTransaction() |
boolean |
isTransaction() |
boolean |
needWriteLob() |
int |
read(SQLConnectable.QueryReader reader,
java.lang.String query,
java.lang.Object... params) |
java.util.LinkedList |
read(java.lang.String query) |
void |
read(java.lang.String query,
Closure code) |
void |
read(java.lang.String query,
java.lang.Long start,
java.lang.Integer count,
Closure code)
Deprecated.
|
java.util.LinkedList |
read(java.lang.String query,
java.lang.Long start,
java.lang.Integer count,
java.lang.String paramNameRowCount)
Deprecated.
|
java.util.LinkedList |
read(java.lang.String query,
java.lang.Object[] params) |
void |
read(java.lang.String query,
java.lang.Object[] params,
Closure code) |
void |
read(java.lang.String query,
java.lang.Object[] params,
java.lang.Long start,
java.lang.Integer count,
Closure code)
Deprecated.
|
java.util.LinkedList |
read(java.lang.String query,
java.lang.Object[] params,
java.lang.Long start,
java.lang.Integer count,
java.lang.String paramNameRowCount)
Deprecated.
|
java.util.LinkedList |
read(java.lang.String query,
java.lang.Object[] params,
java.lang.Object[] outTypeParams) |
void |
read(java.lang.String query,
java.lang.Object[] params,
java.lang.Object[] outTypeParams,
Closure code) |
java.util.LinkedList |
read(java.lang.String query,
java.lang.Object[] params,
java.lang.Object[] outTypeParams,
java.lang.Long start,
java.lang.Integer count,
java.lang.String paramNameRowCount)
Deprecated.
|
java.util.LinkedList |
read(java.lang.String query,
java.lang.Object[] params,
java.lang.Object[] outTypeParams,
long start,
int count,
java.lang.String paramNameRowCount) |
void |
read(java.lang.String query,
java.lang.Object[] params,
java.lang.Object[] outTypeParams,
java.lang.Long start,
java.lang.Long count,
Closure code) |
java.util.LinkedList |
read(java.lang.String query,
java.lang.Object[] params,
java.lang.Object[] outTypeParams,
java.lang.Long start,
java.lang.Long count,
java.lang.String paramNameRowCount) |
void |
read(java.lang.String rowParamName,
java.lang.String query,
java.lang.Long start,
java.lang.Integer count,
PalioCode code)
Deprecated.
|
void |
read(java.lang.String rowParamName,
java.lang.String query,
java.lang.Object[] params,
java.lang.Long start,
java.lang.Integer count,
PalioCode code)
Deprecated.
|
void |
read(java.lang.String rowParamName,
java.lang.String query,
java.lang.Object[] params,
java.lang.Object[] outTypeParams,
java.lang.Long start,
java.lang.Long count,
PalioCode code) |
void |
read(java.lang.String rowParamName,
java.lang.String query,
java.lang.Object[] params,
java.lang.Object[] outTypeParams,
PalioCode code) |
void |
read(java.lang.String rowParamName,
java.lang.String query,
java.lang.Object[] params,
PalioCode code) |
void |
read(java.lang.String rowParamName,
java.lang.String query,
PalioCode code) |
java.util.LinkedList |
readAsMaps(java.lang.String query) |
java.util.LinkedList |
readAsMaps(java.lang.String query,
java.lang.Long start,
java.lang.Integer count,
java.lang.String paramNameRowCount)
Deprecated.
|
java.util.LinkedList |
readAsMaps(java.lang.String query,
java.lang.Object[] params) |
java.util.LinkedList |
readAsMaps(java.lang.String query,
java.lang.Object[] params,
java.lang.Long start,
java.lang.Integer count,
java.lang.String paramNameRowCount)
Deprecated.
|
java.util.LinkedList |
readAsMaps(java.lang.String query,
java.lang.Object[] params,
java.lang.Object[] outTypeParams) |
java.util.LinkedList |
readAsMaps(java.lang.String query,
java.lang.Object[] params,
java.lang.Object[] outTypeParams,
java.lang.Long start,
java.lang.Integer count,
java.lang.String paramNameRowCount)
Deprecated.
|
java.util.LinkedList |
readAsMaps(java.lang.String query,
java.lang.Object[] params,
java.lang.Object[] outTypeParams,
java.lang.Long start,
java.lang.Long count,
java.lang.String paramNameRowCount) |
java.lang.Object[] |
readLine(java.lang.String query) |
java.lang.Object[] |
readLine(java.lang.String query,
java.lang.Object[] params) |
java.lang.Object[] |
readLine(java.lang.String query,
java.lang.Object[] params,
java.lang.Object[] outTypeParams) |
java.util.HashMap |
readLineAsMap(java.lang.String query) |
java.util.HashMap |
readLineAsMap(java.lang.String query,
java.lang.Object[] params) |
java.util.HashMap |
readLineAsMap(java.lang.String query,
java.lang.Object[] params,
java.lang.Object[] outTypeParams) |
void |
rollback() |
void |
setInstance(Instance instance) |
void |
transactionStart() |
void |
transactionStop() |
java.lang.Integer[] |
write(java.lang.Object[] queries) |
java.lang.Integer |
write(java.lang.String query) |
java.lang.Integer |
write(java.lang.String query,
java.lang.Object[] params) |
void |
writeLob(java.lang.String selectClob,
java.lang.Object body) |
void |
writeLob(java.lang.String selectClob,
java.lang.Object[] selectParams,
java.lang.Object body) |
static final int PALIO
static final int GENERIC
static final int ORACLE
static final int POSTGRESQL
static final int MSSQL
static final int HSQL
static final int HIBERNATE
static final int DB2
static final int SYBASE
static final int MYSQL
static final int JTDS
static final int ACCESS
void init() throws PalioException
PalioException
void setInstance(Instance instance) throws PalioException
PalioException
java.util.LinkedList read(java.lang.String query) throws PalioException
PalioException
java.util.LinkedList read(java.lang.String query, java.lang.Object[] params) throws PalioException
PalioException
java.util.LinkedList read(java.lang.String query, java.lang.Object[] params, java.lang.Object[] outTypeParams) throws PalioException
PalioException
@Deprecated java.util.LinkedList read(java.lang.String query, java.lang.Long start, java.lang.Integer count, java.lang.String paramNameRowCount) throws PalioException
PalioException
@Deprecated java.util.LinkedList read(java.lang.String query, java.lang.Object[] params, java.lang.Long start, java.lang.Integer count, java.lang.String paramNameRowCount) throws PalioException
PalioException
java.util.LinkedList read(java.lang.String query, java.lang.Object[] params, java.lang.Object[] outTypeParams, java.lang.Long start, java.lang.Long count, java.lang.String paramNameRowCount) throws PalioException
PalioException
@Deprecated java.util.LinkedList read(java.lang.String query, java.lang.Object[] params, java.lang.Object[] outTypeParams, java.lang.Long start, java.lang.Integer count, java.lang.String paramNameRowCount) throws PalioException
PalioException
java.util.LinkedList read(java.lang.String query, java.lang.Object[] params, java.lang.Object[] outTypeParams, long start, int count, java.lang.String paramNameRowCount) throws PalioException
PalioException
java.util.LinkedList readAsMaps(java.lang.String query) throws PalioException
PalioException
java.util.LinkedList readAsMaps(java.lang.String query, java.lang.Object[] params) throws PalioException
PalioException
java.util.LinkedList readAsMaps(java.lang.String query, java.lang.Object[] params, java.lang.Object[] outTypeParams) throws PalioException
PalioException
@Deprecated java.util.LinkedList readAsMaps(java.lang.String query, java.lang.Long start, java.lang.Integer count, java.lang.String paramNameRowCount) throws PalioException
PalioException
@Deprecated java.util.LinkedList readAsMaps(java.lang.String query, java.lang.Object[] params, java.lang.Long start, java.lang.Integer count, java.lang.String paramNameRowCount) throws PalioException
PalioException
java.util.LinkedList readAsMaps(java.lang.String query, java.lang.Object[] params, java.lang.Object[] outTypeParams, java.lang.Long start, java.lang.Long count, java.lang.String paramNameRowCount) throws PalioException
PalioException
@Deprecated java.util.LinkedList readAsMaps(java.lang.String query, java.lang.Object[] params, java.lang.Object[] outTypeParams, java.lang.Long start, java.lang.Integer count, java.lang.String paramNameRowCount) throws PalioException
PalioException
void read(java.lang.String rowParamName, java.lang.String query, PalioCode code) throws PalioException
PalioException
void read(java.lang.String rowParamName, java.lang.String query, java.lang.Object[] params, PalioCode code) throws PalioException
PalioException
void read(java.lang.String rowParamName, java.lang.String query, java.lang.Object[] params, java.lang.Object[] outTypeParams, PalioCode code) throws PalioException
PalioException
@Deprecated void read(java.lang.String rowParamName, java.lang.String query, java.lang.Long start, java.lang.Integer count, PalioCode code) throws PalioException
PalioException
@Deprecated void read(java.lang.String rowParamName, java.lang.String query, java.lang.Object[] params, java.lang.Long start, java.lang.Integer count, PalioCode code) throws PalioException
PalioException
void read(java.lang.String rowParamName, java.lang.String query, java.lang.Object[] params, java.lang.Object[] outTypeParams, java.lang.Long start, java.lang.Long count, PalioCode code) throws PalioException
PalioException
void read(java.lang.String query, Closure code) throws PalioException
PalioException
void read(java.lang.String query, java.lang.Object[] params, Closure code) throws PalioException
PalioException
void read(java.lang.String query, java.lang.Object[] params, java.lang.Object[] outTypeParams, Closure code) throws PalioException
PalioException
@Deprecated void read(java.lang.String query, java.lang.Long start, java.lang.Integer count, Closure code) throws PalioException
PalioException
@Deprecated void read(java.lang.String query, java.lang.Object[] params, java.lang.Long start, java.lang.Integer count, Closure code) throws PalioException
PalioException
void read(java.lang.String query, java.lang.Object[] params, java.lang.Object[] outTypeParams, java.lang.Long start, java.lang.Long count, Closure code) throws PalioException
PalioException
int fastRead(SQLConnectable.QueryReader reader, java.lang.String query, java.lang.Object... params) throws PalioException
PalioException
int read(SQLConnectable.QueryReader reader, java.lang.String query, java.lang.Object... params) throws PalioException
PalioException
java.lang.Object[] readLine(java.lang.String query) throws PalioException
PalioException
java.lang.Object[] readLine(java.lang.String query, java.lang.Object[] params) throws PalioException
PalioException
java.lang.Object[] readLine(java.lang.String query, java.lang.Object[] params, java.lang.Object[] outTypeParams) throws PalioException
PalioException
java.util.HashMap readLineAsMap(java.lang.String query) throws PalioException
PalioException
java.util.HashMap readLineAsMap(java.lang.String query, java.lang.Object[] params) throws PalioException
PalioException
java.util.HashMap readLineAsMap(java.lang.String query, java.lang.Object[] params, java.lang.Object[] outTypeParams) throws PalioException
PalioException
java.lang.Integer write(java.lang.String query) throws PalioException
PalioException
java.lang.Integer write(java.lang.String query, java.lang.Object[] params) throws PalioException
PalioException
java.lang.Integer[] write(java.lang.Object[] queries) throws PalioException
PalioException
java.lang.Object[] executePL_SQL(java.lang.String query, java.lang.Object[] params, java.lang.Object[] outNrParams) throws PalioException
PalioException
java.lang.Object executeFunction(java.lang.String query, java.lang.Object[] params, java.lang.String outType) throws PalioException
PalioException
java.lang.Object[] executeProcedure(java.lang.String query, java.lang.Object[] params, java.lang.Object[] outTypeParams) throws PalioException
PalioException
void transactionStart() throws PalioException
PalioException
void transactionStop() throws PalioException
PalioException
void commit() throws PalioException
PalioException
void rollback() throws PalioException
PalioException
boolean isTransaction()
boolean isNoTransaction()
void writeLob(java.lang.String selectClob, java.lang.Object body) throws PalioException
PalioException
void writeLob(java.lang.String selectClob, java.lang.Object[] selectParams, java.lang.Object body) throws PalioException
PalioException
java.lang.Long getSequence(java.lang.String sequenceName) throws PalioException
PalioException
java.sql.DatabaseMetaData getMetaData() throws PalioException
PalioException
java.sql.ResultSet getResultSet() throws PalioException
PalioException
java.sql.ResultSetMetaData getResultSetMetaData() throws PalioException
PalioException
int getType()
java.lang.String getName()
java.lang.String getUrl()
boolean needWriteLob() throws PalioException
PalioException