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
based on the orginal esql.xsl
- Version:
- CVS $Id: EsqlConnection.java,v 1.6.2.5 2002/11/21 15:06:48 sylvain Exp $
- Author:
- Torsten Curdt
Fields inherited from interface java.sql.Connection |
TRANSACTION_NONE, TRANSACTION_READ_COMMITTED, TRANSACTION_READ_UNCOMMITTED, TRANSACTION_REPEATABLE_READ, TRANSACTION_SERIALIZABLE |
Method Summary |
void |
clearWarnings()
|
void |
close()
|
void |
commit()
|
java.sql.Statement |
createStatement()
|
java.sql.Statement |
createStatement(int i1,
int i2)
|
java.sql.Statement |
createStatement(int resulSetType,
int resultSetConcurrency,
int resultSetHoldability)
|
boolean |
getAutoCommit()
|
java.lang.String |
getCatalog()
|
int |
getHoldability()
|
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()
|
boolean |
multipleResults()
|
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.CallableStatement |
prepareCall(java.lang.String sql,
int resulSetType,
int resultSetConcurrency,
int resultSetHoldability)
|
java.sql.PreparedStatement |
prepareStatement(java.lang.String s)
|
java.sql.PreparedStatement |
prepareStatement(java.lang.String sql,
int autoGeneratedKeys)
|
java.sql.PreparedStatement |
prepareStatement(java.lang.String sql,
int[] columnIndexes)
|
java.sql.PreparedStatement |
prepareStatement(java.lang.String s,
int i1,
int i2)
|
java.sql.PreparedStatement |
prepareStatement(java.lang.String sql,
int resulSetType,
int resultSetConcurrency,
int resultSetHoldability)
|
java.sql.PreparedStatement |
prepareStatement(java.lang.String sql,
java.lang.String[] columnNames)
|
void |
releaseSavepoint(java.sql.Savepoint savepoint)
|
void |
rollback()
|
void |
rollback(java.sql.Savepoint savepoint)
|
void |
setAutoCommit(boolean autocommit)
|
void |
setCatalog(java.lang.String s)
|
void |
setHoldability(int holdability)
|
void |
setLimitMethod(java.lang.String method)
|
void |
setMultipleResults(java.lang.String value)
It appears that some commercial DBMSs like Oracle and Informix
are broken in that they don't follow the JDBC standard and
calls to getUpdateCount after getMoreResults result either in
an exception (Informix) or return the same value (i.e. not -1) (Oracle).
|
void |
setPassword(java.lang.String password)
|
void |
setProperty(java.lang.String name,
java.lang.Object value)
|
void |
setReadOnly(boolean b)
|
java.sql.Savepoint |
setSavepoint()
|
java.sql.Savepoint |
setSavepoint(java.lang.String savepoint)
|
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 |
LIMIT_METHOD_NOLIMIT
public static final int LIMIT_METHOD_NOLIMIT
- See Also:
- Constant Field Values
LIMIT_METHOD_POSTGRESQL
public static final int LIMIT_METHOD_POSTGRESQL
- See Also:
- Constant Field Values
LIMIT_METHOD_MYSQL
public static final int LIMIT_METHOD_MYSQL
- See Also:
- Constant Field Values
LIMIT_METHOD_JDBC
public static final int LIMIT_METHOD_JDBC
- See Also:
- Constant Field Values
connection
public java.sql.Connection connection
EsqlConnection
public EsqlConnection()
multipleResults
public boolean multipleResults()
setMultipleResults
public void setMultipleResults(java.lang.String value)
- It appears that some commercial DBMSs like Oracle and Informix
are broken in that they don't follow the JDBC standard and
calls to getUpdateCount after getMoreResults result either in
an exception (Informix) or return the same value (i.e. not -1) (Oracle).
In addition, this feature is only useful with stored procedures.
Hence we disable it per default.
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
java.sql.SQLException
createStatement
public java.sql.Statement createStatement(int i1,
int i2)
throws java.sql.SQLException
- Specified by:
createStatement
in interface java.sql.Connection
java.sql.SQLException
prepareStatement
public java.sql.PreparedStatement prepareStatement(java.lang.String s)
throws java.sql.SQLException
- Specified by:
prepareStatement
in interface java.sql.Connection
java.sql.SQLException
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
java.sql.SQLException
close
public void close()
throws java.sql.SQLException
- Specified by:
close
in interface java.sql.Connection
java.sql.SQLException
commit
public void commit()
throws java.sql.SQLException
- Specified by:
commit
in interface java.sql.Connection
java.sql.SQLException
rollback
public void rollback()
throws java.sql.SQLException
- Specified by:
rollback
in interface java.sql.Connection
java.sql.SQLException
getAutoCommit
public boolean getAutoCommit()
throws java.sql.SQLException
- Specified by:
getAutoCommit
in interface java.sql.Connection
java.sql.SQLException
setAutoCommit
public void setAutoCommit(boolean autocommit)
throws java.sql.SQLException
- Specified by:
setAutoCommit
in interface java.sql.Connection
java.sql.SQLException
setTransactionIsolation
public void setTransactionIsolation(int i)
throws java.sql.SQLException
- Specified by:
setTransactionIsolation
in interface java.sql.Connection
java.sql.SQLException
getTransactionIsolation
public int getTransactionIsolation()
throws java.sql.SQLException
- Specified by:
getTransactionIsolation
in interface java.sql.Connection
java.sql.SQLException
getCatalog
public java.lang.String getCatalog()
throws java.sql.SQLException
- Specified by:
getCatalog
in interface java.sql.Connection
java.sql.SQLException
getWarnings
public java.sql.SQLWarning getWarnings()
throws java.sql.SQLException
- Specified by:
getWarnings
in interface java.sql.Connection
java.sql.SQLException
getTypeMap
public java.util.Map getTypeMap()
throws java.sql.SQLException
- Specified by:
getTypeMap
in interface java.sql.Connection
java.sql.SQLException
isClosed
public boolean isClosed()
throws java.sql.SQLException
- Specified by:
isClosed
in interface java.sql.Connection
java.sql.SQLException
getMetaData
public java.sql.DatabaseMetaData getMetaData()
throws java.sql.SQLException
- Specified by:
getMetaData
in interface java.sql.Connection
java.sql.SQLException
setCatalog
public void setCatalog(java.lang.String s)
throws java.sql.SQLException
- Specified by:
setCatalog
in interface java.sql.Connection
java.sql.SQLException
setTypeMap
public void setTypeMap(java.util.Map m)
throws java.sql.SQLException
- Specified by:
setTypeMap
in interface java.sql.Connection
java.sql.SQLException
setReadOnly
public void setReadOnly(boolean b)
throws java.sql.SQLException
- Specified by:
setReadOnly
in interface java.sql.Connection
java.sql.SQLException
clearWarnings
public void clearWarnings()
throws java.sql.SQLException
- Specified by:
clearWarnings
in interface java.sql.Connection
java.sql.SQLException
isReadOnly
public boolean isReadOnly()
throws java.sql.SQLException
- Specified by:
isReadOnly
in interface java.sql.Connection
java.sql.SQLException
nativeSQL
public java.lang.String nativeSQL(java.lang.String s)
throws java.sql.SQLException
- Specified by:
nativeSQL
in interface java.sql.Connection
java.sql.SQLException
prepareCall
public java.sql.CallableStatement prepareCall(java.lang.String s)
throws java.sql.SQLException
- Specified by:
prepareCall
in interface java.sql.Connection
java.sql.SQLException
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
java.sql.SQLException
setHoldability
public void setHoldability(int holdability)
throws java.sql.SQLException
- Specified by:
setHoldability
in interface java.sql.Connection
java.sql.SQLException
getHoldability
public int getHoldability()
throws java.sql.SQLException
- Specified by:
getHoldability
in interface java.sql.Connection
java.sql.SQLException
setSavepoint
public java.sql.Savepoint setSavepoint()
throws java.sql.SQLException
- Specified by:
setSavepoint
in interface java.sql.Connection
java.sql.SQLException
setSavepoint
public java.sql.Savepoint setSavepoint(java.lang.String savepoint)
throws java.sql.SQLException
- Specified by:
setSavepoint
in interface java.sql.Connection
java.sql.SQLException
rollback
public void rollback(java.sql.Savepoint savepoint)
throws java.sql.SQLException
- Specified by:
rollback
in interface java.sql.Connection
java.sql.SQLException
releaseSavepoint
public void releaseSavepoint(java.sql.Savepoint savepoint)
throws java.sql.SQLException
- Specified by:
releaseSavepoint
in interface java.sql.Connection
java.sql.SQLException
createStatement
public java.sql.Statement createStatement(int resulSetType,
int resultSetConcurrency,
int resultSetHoldability)
throws java.sql.SQLException
- Specified by:
createStatement
in interface java.sql.Connection
java.sql.SQLException
prepareStatement
public java.sql.PreparedStatement prepareStatement(java.lang.String sql,
int resulSetType,
int resultSetConcurrency,
int resultSetHoldability)
throws java.sql.SQLException
- Specified by:
prepareStatement
in interface java.sql.Connection
java.sql.SQLException
prepareCall
public java.sql.CallableStatement prepareCall(java.lang.String sql,
int resulSetType,
int resultSetConcurrency,
int resultSetHoldability)
throws java.sql.SQLException
- Specified by:
prepareCall
in interface java.sql.Connection
java.sql.SQLException
prepareStatement
public java.sql.PreparedStatement prepareStatement(java.lang.String sql,
int autoGeneratedKeys)
throws java.sql.SQLException
- Specified by:
prepareStatement
in interface java.sql.Connection
java.sql.SQLException
prepareStatement
public java.sql.PreparedStatement prepareStatement(java.lang.String sql,
int[] columnIndexes)
throws java.sql.SQLException
- Specified by:
prepareStatement
in interface java.sql.Connection
java.sql.SQLException
prepareStatement
public java.sql.PreparedStatement prepareStatement(java.lang.String sql,
java.lang.String[] columnNames)
throws java.sql.SQLException
- Specified by:
prepareStatement
in interface java.sql.Connection
java.sql.SQLException
Copyright © 1999-2002 Apache Software Foundation. All Rights Reserved.