org.apache.cocoon.components.language.markup.xsp
Class EsqlConnection

java.lang.Object
  |
  +--org.apache.cocoon.components.language.markup.xsp.EsqlConnection

All Implemented Interfaces:

java.sql.Connection

Direct Known Subclasses:

EsqlConnectionCocoon2

public class EsqlConnection

extends java.lang.Object

implements java.sql.Connection

This is wrapper to extend a java.sql.Conncetion implementation for easier paging / limit facilities

Author:

Torsten Curdt based on the orginal esql.xsl

Field Summary

java.sql.Connection	connection
static int	LIMIT_METHOD_JDBC
static int	LIMIT_METHOD_MYSQL
static int	LIMIT_METHOD_NOLIMIT
static int	LIMIT_METHOD_POSTGRESQL

Fields inherited from interface java.sql.Connection

TRANSACTION_NONE, TRANSACTION_READ_COMMITTED, TRANSACTION_READ_UNCOMMITTED, TRANSACTION_REPEATABLE_READ, TRANSACTION_SERIALIZABLE

Constructor Summary

EsqlConnection()

Method Summary

void	clearWarnings()
void	close()
void	commit()
java.sql.Statement	createStatement()
java.sql.Statement	createStatement(int i1, int i2)
boolean	getAutoCommit()
java.lang.String	getCatalog()
java.util.Properties	getInfo()
int	getLimitMethod()
java.sql.DatabaseMetaData	getMetaData()
int	getTransactionIsolation()
java.util.Map	getTypeMap()
java.lang.String	getUrl()
java.sql.SQLWarning	getWarnings()
boolean	isClosed()
boolean	isReadOnly()
java.lang.String	nativeSQL(java.lang.String s)
java.sql.CallableStatement	prepareCall(java.lang.String s)
java.sql.CallableStatement	prepareCall(java.lang.String s, int i1, int i2)
java.sql.PreparedStatement	prepareStatement(java.lang.String s)
java.sql.PreparedStatement	prepareStatement(java.lang.String s, int i1, int i2)
void	rollback()
void	setAutoCommit(boolean autocommit)
void	setCatalog(java.lang.String s)
void	setLimitMethod(java.lang.String method)
void	setPassword(java.lang.String password)
void	setProperty(java.lang.String name, java.lang.Object value)
void	setReadOnly(boolean b)
void	setTransactionIsolation(int i)
void	setTypeMap(java.util.Map m)
void	setUrl(java.lang.String url)
void	setUser(java.lang.String user)

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Field Detail

LIMIT_METHOD_NOLIMIT

public static final int LIMIT_METHOD_NOLIMIT

LIMIT_METHOD_POSTGRESQL

public static final int LIMIT_METHOD_POSTGRESQL

LIMIT_METHOD_MYSQL

public static final int LIMIT_METHOD_MYSQL

LIMIT_METHOD_JDBC

public static final int LIMIT_METHOD_JDBC

connection

public java.sql.Connection connection

Constructor Detail

EsqlConnection

public EsqlConnection()

Method Detail

getInfo

public java.util.Properties getInfo()

getUrl

public java.lang.String getUrl()

setUrl

public void setUrl(java.lang.String url)

setProperty

public void setProperty(java.lang.String name,
                        java.lang.Object value)

setUser

public void setUser(java.lang.String user)

setPassword

public void setPassword(java.lang.String password)

getLimitMethod

public int getLimitMethod()

setLimitMethod

public void setLimitMethod(java.lang.String method)

createStatement

public java.sql.Statement createStatement()
                                   throws java.sql.SQLException

Specified by:

createStatement in interface java.sql.Connection

createStatement

public java.sql.Statement createStatement(int i1,
                                          int i2)
                                   throws java.sql.SQLException

Specified by:

createStatement in interface java.sql.Connection

prepareStatement

public java.sql.PreparedStatement prepareStatement(java.lang.String s)
                                            throws java.sql.SQLException

Specified by:

prepareStatement in interface java.sql.Connection

prepareStatement

public java.sql.PreparedStatement prepareStatement(java.lang.String s,
                                                   int i1,
                                                   int i2)
                                            throws java.sql.SQLException

Specified by:

prepareStatement in interface java.sql.Connection

close

public void close()
           throws java.sql.SQLException

Specified by:

close in interface java.sql.Connection

commit

public void commit()
            throws java.sql.SQLException

Specified by:

commit in interface java.sql.Connection

rollback

public void rollback()
              throws java.sql.SQLException

Specified by:

rollback in interface java.sql.Connection

getAutoCommit

public boolean getAutoCommit()
                      throws java.sql.SQLException

Specified by:

getAutoCommit in interface java.sql.Connection

setAutoCommit

public void setAutoCommit(boolean autocommit)
                   throws java.sql.SQLException

Specified by:

setAutoCommit in interface java.sql.Connection

setTransactionIsolation

public void setTransactionIsolation(int i)
                             throws java.sql.SQLException

Specified by:

setTransactionIsolation in interface java.sql.Connection

getTransactionIsolation

public int getTransactionIsolation()
                            throws java.sql.SQLException

Specified by:

getTransactionIsolation in interface java.sql.Connection

getCatalog

public java.lang.String getCatalog()
                            throws java.sql.SQLException

Specified by:

getCatalog in interface java.sql.Connection

getWarnings

public java.sql.SQLWarning getWarnings()
                                throws java.sql.SQLException

Specified by:

getWarnings in interface java.sql.Connection

getTypeMap

public java.util.Map getTypeMap()
                         throws java.sql.SQLException

Specified by:

getTypeMap in interface java.sql.Connection

isClosed

public boolean isClosed()
                 throws java.sql.SQLException

Specified by:

isClosed in interface java.sql.Connection

getMetaData

public java.sql.DatabaseMetaData getMetaData()
                                      throws java.sql.SQLException

Specified by:

getMetaData in interface java.sql.Connection

setCatalog

public void setCatalog(java.lang.String s)
                throws java.sql.SQLException

Specified by:

setCatalog in interface java.sql.Connection

setTypeMap

public void setTypeMap(java.util.Map m)
                throws java.sql.SQLException

Specified by:

setTypeMap in interface java.sql.Connection

setReadOnly

public void setReadOnly(boolean b)
                 throws java.sql.SQLException

Specified by:

setReadOnly in interface java.sql.Connection

clearWarnings

public void clearWarnings()
                   throws java.sql.SQLException

Specified by:

clearWarnings in interface java.sql.Connection

isReadOnly

public boolean isReadOnly()
                   throws java.sql.SQLException

Specified by:

isReadOnly in interface java.sql.Connection

nativeSQL

public java.lang.String nativeSQL(java.lang.String s)
                           throws java.sql.SQLException

Specified by:

nativeSQL in interface java.sql.Connection

prepareCall

public java.sql.CallableStatement prepareCall(java.lang.String s)
                                       throws java.sql.SQLException

Specified by:

prepareCall in interface java.sql.Connection

prepareCall

public java.sql.CallableStatement prepareCall(java.lang.String s,
                                              int i1,
                                              int i2)
                                       throws java.sql.SQLException

Specified by:

prepareCall in interface java.sql.Connection