palio.connectors
Interface SQLConnectable

All Known Subinterfaces:

PalioConnectable, SQLConnectableExt

All Known Implementing Classes:

DB2SQLConnector, HibernateConnector, MSSQL2k5Connector, MSSQL2kConnector, MSSQLConnector, MySQLConnector, PostgreSQLConnector, SQLConnector, SQLPalioConnector, SybaseConnector

public interface SQLConnectable

Author:

Krzysztof Synowiec

Nested Class Summary

static class

SQLConnectable.QueryReader

Field Summary

static int	DB2
static int	GENERIC
static int	HIBERNATE
static int	HSQL
static int	MSSQL
static int	MYSQL
static int	ORACLE
static int	PALIO
static int	POSTGRESQL
static int	SYBASE

Method Summary

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()
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, groovy.lang.Closure code)
void	read(java.lang.String query, java.lang.Long start, java.lang.Integer count, groovy.lang.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, groovy.lang.Closure code)
void	read(java.lang.String query, java.lang.Object[] params, java.lang.Long start, java.lang.Integer count, groovy.lang.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, groovy.lang.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, groovy.lang.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, palio.compiler.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, palio.compiler.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, palio.compiler.PalioCode code)
void	read(java.lang.String rowParamName, java.lang.String query, java.lang.Object[] params, java.lang.Object[] outTypeParams, palio.compiler.PalioCode code)
void	read(java.lang.String rowParamName, java.lang.String query, java.lang.Object[] params, palio.compiler.PalioCode code)
void	read(java.lang.String rowParamName, java.lang.String query, palio.compiler.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	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)

Field Detail

PALIO

static final int PALIO

See Also:

Constant Field Values

GENERIC

static final int GENERIC

See Also:

Constant Field Values

ORACLE

static final int ORACLE

See Also:

Constant Field Values

POSTGRESQL

static final int POSTGRESQL

See Also:

Constant Field Values

MSSQL

static final int MSSQL

See Also:

Constant Field Values

HSQL

static final int HSQL

See Also:

Constant Field Values

HIBERNATE

static final int HIBERNATE

See Also:

Constant Field Values

DB2

static final int DB2

See Also:

Constant Field Values

SYBASE

static final int SYBASE

See Also:

Constant Field Values

MYSQL

static final int MYSQL

See Also:

Constant Field Values

Method Detail

read

java.util.LinkedList read(java.lang.String query)
                          throws palio.PalioException

Throws:

palio.PalioException

read

java.util.LinkedList read(java.lang.String query,
                          java.lang.Object[] params)
                          throws palio.PalioException

Throws:

palio.PalioException

read

java.util.LinkedList read(java.lang.String query,
                          java.lang.Object[] params,
                          java.lang.Object[] outTypeParams)
                          throws palio.PalioException

Throws:

palio.PalioException

read

@Deprecated
java.util.LinkedList read(java.lang.String query,
                                     java.lang.Long start,
                                     java.lang.Integer count,
                                     java.lang.String paramNameRowCount)
                          throws palio.PalioException

Deprecated.

Throws:

palio.PalioException

read

@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 palio.PalioException

Deprecated.

Throws:

palio.PalioException

read

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 palio.PalioException

Throws:

palio.PalioException

read

@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 palio.PalioException

Deprecated.

Throws:

palio.PalioException

read

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 palio.PalioException

Throws:

palio.PalioException

readAsMaps

java.util.LinkedList readAsMaps(java.lang.String query)
                                throws palio.PalioException

Throws:

palio.PalioException

readAsMaps

java.util.LinkedList readAsMaps(java.lang.String query,
                                java.lang.Object[] params)
                                throws palio.PalioException

Throws:

palio.PalioException

readAsMaps

java.util.LinkedList readAsMaps(java.lang.String query,
                                java.lang.Object[] params,
                                java.lang.Object[] outTypeParams)
                                throws palio.PalioException

Throws:

palio.PalioException

readAsMaps

@Deprecated
java.util.LinkedList readAsMaps(java.lang.String query,
                                           java.lang.Long start,
                                           java.lang.Integer count,
                                           java.lang.String paramNameRowCount)
                                throws palio.PalioException

Deprecated.

Throws:

palio.PalioException

readAsMaps

@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 palio.PalioException

Deprecated.

Throws:

palio.PalioException

readAsMaps

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 palio.PalioException

Throws:

palio.PalioException

readAsMaps

@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 palio.PalioException

Deprecated.

Throws:

palio.PalioException

read

void read(java.lang.String rowParamName,
          java.lang.String query,
          palio.compiler.PalioCode code)
          throws palio.PalioException

Throws:

palio.PalioException

read

void read(java.lang.String rowParamName,
          java.lang.String query,
          java.lang.Object[] params,
          palio.compiler.PalioCode code)
          throws palio.PalioException

Throws:

palio.PalioException

read

void read(java.lang.String rowParamName,
          java.lang.String query,
          java.lang.Object[] params,
          java.lang.Object[] outTypeParams,
          palio.compiler.PalioCode code)
          throws palio.PalioException

Throws:

palio.PalioException

read

@Deprecated
void read(java.lang.String rowParamName,
                     java.lang.String query,
                     java.lang.Long start,
                     java.lang.Integer count,
                     palio.compiler.PalioCode code)
          throws palio.PalioException

Deprecated.

Throws:

palio.PalioException

read

@Deprecated
void read(java.lang.String rowParamName,
                     java.lang.String query,
                     java.lang.Object[] params,
                     java.lang.Long start,
                     java.lang.Integer count,
                     palio.compiler.PalioCode code)
          throws palio.PalioException

Deprecated.

Throws:

palio.PalioException

read

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,
          palio.compiler.PalioCode code)
          throws palio.PalioException

Throws:

palio.PalioException

read

void read(java.lang.String query,
          groovy.lang.Closure code)
          throws palio.PalioException

Throws:

palio.PalioException

read

void read(java.lang.String query,
          java.lang.Object[] params,
          groovy.lang.Closure code)
          throws palio.PalioException

Throws:

palio.PalioException

read

void read(java.lang.String query,
          java.lang.Object[] params,
          java.lang.Object[] outTypeParams,
          groovy.lang.Closure code)
          throws palio.PalioException

Throws:

palio.PalioException

read

@Deprecated
void read(java.lang.String query,
                     java.lang.Long start,
                     java.lang.Integer count,
                     groovy.lang.Closure code)
          throws palio.PalioException

Deprecated.

Throws:

palio.PalioException

read

@Deprecated
void read(java.lang.String query,
                     java.lang.Object[] params,
                     java.lang.Long start,
                     java.lang.Integer count,
                     groovy.lang.Closure code)
          throws palio.PalioException

Deprecated.

Throws:

palio.PalioException

read

void read(java.lang.String query,
          java.lang.Object[] params,
          java.lang.Object[] outTypeParams,
          java.lang.Long start,
          java.lang.Long count,
          groovy.lang.Closure code)
          throws palio.PalioException

Throws:

palio.PalioException

fastRead

int fastRead(SQLConnectable.QueryReader reader,
             java.lang.String query,
             java.lang.Object... params)
             throws palio.PalioException

Throws:

palio.PalioException

read

int read(SQLConnectable.QueryReader reader,
         java.lang.String query,
         java.lang.Object... params)
         throws palio.PalioException

Throws:

palio.PalioException

readLine

java.lang.Object[] readLine(java.lang.String query)
                            throws palio.PalioException

Throws:

palio.PalioException

readLine

java.lang.Object[] readLine(java.lang.String query,
                            java.lang.Object[] params)
                            throws palio.PalioException

Throws:

palio.PalioException

readLine

java.lang.Object[] readLine(java.lang.String query,
                            java.lang.Object[] params,
                            java.lang.Object[] outTypeParams)
                            throws palio.PalioException

Throws:

palio.PalioException

readLineAsMap

java.util.HashMap readLineAsMap(java.lang.String query)
                                throws palio.PalioException

Throws:

palio.PalioException

readLineAsMap

java.util.HashMap readLineAsMap(java.lang.String query,
                                java.lang.Object[] params)
                                throws palio.PalioException

Throws:

palio.PalioException

readLineAsMap

java.util.HashMap readLineAsMap(java.lang.String query,
                                java.lang.Object[] params,
                                java.lang.Object[] outTypeParams)
                                throws palio.PalioException

Throws:

palio.PalioException

write

java.lang.Integer write(java.lang.String query)
                        throws palio.PalioException

Throws:

palio.PalioException

write

java.lang.Integer write(java.lang.String query,
                        java.lang.Object[] params)
                        throws palio.PalioException

Throws:

palio.PalioException

write

java.lang.Integer[] write(java.lang.Object[] queries)
                          throws palio.PalioException

Throws:

palio.PalioException

executePL_SQL

java.lang.Object[] executePL_SQL(java.lang.String query,
                                 java.lang.Object[] params,
                                 java.lang.Object[] outNrParams)
                                 throws palio.PalioException

Throws:

palio.PalioException

executeFunction

java.lang.Object executeFunction(java.lang.String query,
                                 java.lang.Object[] params,
                                 java.lang.String outType)
                                 throws palio.PalioException

Throws:

palio.PalioException

executeProcedure

java.lang.Object[] executeProcedure(java.lang.String query,
                                    java.lang.Object[] params,
                                    java.lang.Object[] outTypeParams)
                                    throws palio.PalioException

Throws:

palio.PalioException

transactionStart

void transactionStart()
                      throws palio.PalioException

Throws:

palio.PalioException

transactionStop

void transactionStop()
                     throws palio.PalioException

Throws:

palio.PalioException

commit

void commit()
            throws palio.PalioException

Throws:

palio.PalioException

rollback

void rollback()
              throws palio.PalioException

Throws:

palio.PalioException

isTransaction

boolean isTransaction()

isNoTransaction

boolean isNoTransaction()

writeLob

void writeLob(java.lang.String selectClob,
              java.lang.Object body)
              throws palio.PalioException

Throws:

palio.PalioException

writeLob

void writeLob(java.lang.String selectClob,
              java.lang.Object[] selectParams,
              java.lang.Object body)
              throws palio.PalioException

Throws:

palio.PalioException

getSequence

java.lang.Long getSequence(java.lang.String sequenceName)
                           throws palio.PalioException

Throws:

palio.PalioException

getMetaData

java.sql.DatabaseMetaData getMetaData()
                                      throws palio.PalioException

Throws:

palio.PalioException

getResultSet

java.sql.ResultSet getResultSet()
                                throws palio.PalioException

Throws:

palio.PalioException

getResultSetMetaData

java.sql.ResultSetMetaData getResultSetMetaData()
                                                throws palio.PalioException

Throws:

palio.PalioException

getType

int getType()

getName

java.lang.String getName()

getUrl

java.lang.String getUrl()

needWriteLob

boolean needWriteLob()
                     throws palio.PalioException

Throws:

palio.PalioException