AbstractJdbc2Statement

java.lang.Object
- org.postgresql.jdbc2.AbstractJdbc2Statement

All Implemented Interfaces:

java.lang.AutoCloseable, java.sql.Statement, java.sql.Wrapper, BaseStatement, PGStatement

Direct Known Subclasses:

AbstractJdbc3Statement
```
public abstract class AbstractJdbc2Statement
extends java.lang.Object
implements BaseStatement
```
This class defines methods of the jdbc2 specification. The real Statement class (for jdbc2) is org.postgresql.jdbc2.Jdbc2Statement

Nested Class Summary

Nested Classes
Modifier and Type Class and Description

class AbstractJdbc2Statement.StatementResultHandler

Nested Classes
Modifier and Type	Class and Description
`class`	`AbstractJdbc2Statement.StatementResultHandler`

Field Summary

Fields
Modifier and Type	Field and Description
`protected boolean`	`adjustIndex` used to differentiate between new function call logic and old function call logic will be set to true if the server is < 8.1 or if we are using v2 protocol There is an exception to this where we are using v3, and the call does not have an out parameter before the call
`protected java.util.ArrayList`	`batchParameters`
`protected java.util.ArrayList`	`batchStatements`
`protected java.lang.Object[]`	`callResult`
`protected int`	`concurrency`
`protected BaseConnection`	`connection`
`protected int`	`fetchdirection`
`protected int`	`fetchSize` Number of rows to get in a batch.
`protected ResultWrapper`	`firstUnclosedResult` The first unclosed result.
`protected ResultWrapper`	`generatedKeys` Results returned by a statement that wants generated keys.
`protected boolean`	`isClosed`
`protected Query`	`lastSimpleQuery`
`protected java.sql.SQLWarning`	`lastWarning` The last warning of the warning chain.
`protected int`	`m_prepareThreshold`
`protected int`	`m_useCount`
`protected int`	`maxfieldSize`
`protected int`	`maxrows` Maximum number of rows to return, 0 = unlimited
`protected boolean`	`outParmBeforeFunc`
`protected ParameterList`	`preparedParameters`
`protected Query`	`preparedQuery`
`protected boolean`	`replaceProcessingEnabled`
`protected ResultWrapper`	`result` The current results.
`protected int`	`resultsettype`
`protected int`	`timeout` Timeout (in seconds) for a query (not used)
`boolean`	`wantsGeneratedKeysAlways` Was this PreparedStatement created to return generated keys for every execution?
`protected boolean`	`wantsGeneratedKeysOnce` Does the caller of execute/executeUpdate want generated keys for this execution?
`protected java.sql.SQLWarning`	`warnings` The warnings chain.

Fields inherited from interface org.postgresql.PGStatement
DATE_NEGATIVE_INFINITY, DATE_POSITIVE_INFINITY

Fields inherited from interface java.sql.Statement
CLOSE_ALL_RESULTS, CLOSE_CURRENT_RESULT, EXECUTE_FAILED, KEEP_CURRENT_RESULT, NO_GENERATED_KEYS, RETURN_GENERATED_KEYS, SUCCESS_NO_INFO

Constructor Summary

Constructors
Constructor and Description
`AbstractJdbc2Statement(AbstractJdbc2Connection c, int rsType, int rsConcurrency)`
`AbstractJdbc2Statement(AbstractJdbc2Connection connection, java.lang.String sql, boolean isCallable, int rsType, int rsConcurrency)`

Method Summary

Methods
Modifier and Type	Method and Description
`void`	`addBatch()`
`void`	`addBatch(java.lang.String p_sql)`
`void`	`addWarning(java.sql.SQLWarning warn)` This adds a warning to the warning chain.
`protected void`	`bindLiteral(int paramIndex, java.lang.String s, int oid)`
`void`	`cancel()`
`protected void`	`checkClosed()`
`protected void`	`checkIndex(int parameterIndex, int type1, int type2, java.lang.String getName)` helperfunction for the getXXX calls to check isFunction and index == 1 Compare BOTH type fields against the return type.
`protected void`	`checkIndex(int parameterIndex, int type, java.lang.String getName)` helperfunction for the getXXX calls to check isFunction and index == 1
`void`	`clearBatch()`
`void`	`clearParameters()`
`void`	`clearWarnings()`
`void`	`close()`
`protected void`	`closeForNextExecution()`
`java.sql.ResultSet`	`createDriverResultSet(Field[] fields, java.util.Vector tuples)` Create a synthetic resultset from data provided by the driver.
`abstract java.sql.ResultSet`	`createResultSet(Query originalQuery, Field[] fields, java.util.Vector tuples, ResultCursor cursor)` Create a resultset from data retrieved from the server.
`protected static java.lang.String`	`escapeFunction(java.lang.String functionName, java.lang.String args, boolean stdStrings)` generate sql for escaped functions
`boolean`	`execute()`
`protected void`	`execute(Query queryToExecute, ParameterList queryParameters, int flags)`
`boolean`	`execute(java.lang.String p_sql)`
`int[]`	`executeBatch()`
`java.sql.ResultSet`	`executeQuery()`
`java.sql.ResultSet`	`executeQuery(java.lang.String p_sql)`
`int`	`executeUpdate()`
`int`	`executeUpdate(java.lang.String p_sql)`
`boolean`	`executeWithFlags(int flags)` Execute a prepared query, passing additional query flags.
`boolean`	`executeWithFlags(java.lang.String p_sql, int flags)` Execute a query, passing additional query flags.
`protected void`	`finalize()` This finalizer ensures that statements that have allocated server-side resources free them when they become unreferenced.
`java.sql.Array`	`getArray(int i)`
`java.math.BigDecimal`	`getBigDecimal(int parameterIndex)`
`java.math.BigDecimal`	`getBigDecimal(int parameterIndex, int scale)`
`java.sql.Blob`	`getBlob(int i)`
`boolean`	`getBoolean(int parameterIndex)`
`byte`	`getByte(int parameterIndex)`
`byte[]`	`getBytes(int parameterIndex)`
`java.sql.Clob`	`getClob(int i)`
`java.sql.Connection`	`getConnection()`
`java.sql.Date`	`getDate(int parameterIndex)`
`java.sql.Date`	`getDate(int i, java.util.Calendar cal)`
`double`	`getDouble(int parameterIndex)`
`int`	`getFetchDirection()`
`java.lang.String`	`getFetchingCursorName()`
`int`	`getFetchSize()`
`float`	`getFloat(int parameterIndex)`
`int`	`getInsertedOID()`
`int`	`getInt(int parameterIndex)`
`long`	`getLastOID()` Returns the Last inserted/updated oid.
`long`	`getLong(int parameterIndex)`
`int`	`getMaxFieldSize()`
`int`	`getMaxRows()`
`java.sql.ResultSetMetaData`	`getMetaData()`
`boolean`	`getMoreResults()`
`java.lang.Object`	`getObject(int parameterIndex)`
`java.lang.Object`	`getObjectImpl(int i, java.util.Map map)`
`BaseConnection`	`getPGConnection()`
`int`	`getPrepareThreshold()` Gets the server-side prepare reuse threshold in use for this statement.
`int`	`getQueryTimeout()`
`java.sql.Ref`	`getRef(int i)`
`java.sql.ResultSet`	`getResultSet()`
`int`	`getResultSetConcurrency()`
`int`	`getResultSetType()`
`short`	`getShort(int parameterIndex)`
`java.lang.String`	`getString(int parameterIndex)`
`java.sql.Time`	`getTime(int parameterIndex)`
`java.sql.Time`	`getTime(int i, java.util.Calendar cal)`
`java.sql.Timestamp`	`getTimestamp(int parameterIndex)`
`java.sql.Timestamp`	`getTimestamp(int i, java.util.Calendar cal)`
`int`	`getUpdateCount()`
`java.sql.SQLWarning`	`getWarnings()`
`boolean`	`isUseServerPrepare()` Checks if this statement will be executed as a server-prepared statement.
`protected static int`	`parseSql(java.lang.String p_sql, int i, java.lang.StringBuffer newsql, boolean stopOnComma, boolean stdStrings)` parse the given sql from index i, appending it to the gven buffer until we hit an unmatched right parentheses or end of string.
`void`	`registerOutParameter(int parameterIndex, int sqlType, boolean setPreparedParameters)`
`void`	`registerOutParameter(int parameterIndex, int sqlType, int scale, boolean setPreparedParameters)`
`void`	`registerOutParameter(int parameterIndex, int sqlType, java.lang.String typeName)`
`protected java.lang.String`	`replaceProcessing(java.lang.String p_sql)`
`void`	`setArray(int i, java.sql.Array x)`
`void`	`setAsciiStream(int parameterIndex, java.io.InputStream x, int length)`
`void`	`setBigDecimal(int parameterIndex, java.math.BigDecimal x)`
`void`	`setBinaryStream(int parameterIndex, java.io.InputStream x, int length)`
`void`	`setBlob(int i, java.sql.Blob x)`
`void`	`setBoolean(int parameterIndex, boolean x)`
`void`	`setByte(int parameterIndex, byte x)`
`void`	`setBytes(int parameterIndex, byte[] x)`
`void`	`setCharacterStream(int i, java.io.Reader x, int length)`
`void`	`setClob(int i, java.sql.Clob x)`
`void`	`setCursorName(java.lang.String name)`
`void`	`setDate(int parameterIndex, java.sql.Date x)`
`void`	`setDate(int i, java.sql.Date d, java.util.Calendar cal)`
`void`	`setDouble(int parameterIndex, double x)`
`void`	`setEscapeProcessing(boolean enable)`
`void`	`setFetchDirection(int direction)`
`void`	`setFetchSize(int rows)`
`void`	`setFloat(int parameterIndex, float x)`
`void`	`setInt(int parameterIndex, int x)`
`void`	`setLong(int parameterIndex, long x)`
`void`	`setMaxFieldSize(int max)`
`void`	`setMaxRows(int max)`
`void`	`setNull(int parameterIndex, int sqlType)`
`void`	`setNull(int i, int t, java.lang.String s)`
`void`	`setObject(int parameterIndex, java.lang.Object x)`
`void`	`setObject(int parameterIndex, java.lang.Object x, int targetSqlType)`
`void`	`setObject(int parameterIndex, java.lang.Object in, int targetSqlType, int scale)`
`void`	`setPrepareThreshold(int newThreshold)` Sets the reuse threshold for using server-prepared statements.
`void`	`setQueryTimeout(int seconds)`
`void`	`setRef(int i, java.sql.Ref x)`
`void`	`setShort(int parameterIndex, short x)`
`void`	`setString(int parameterIndex, java.lang.String x)`
`protected void`	`setString(int parameterIndex, java.lang.String x, int oid)`
`void`	`setTime(int parameterIndex, java.sql.Time x)`
`void`	`setTime(int i, java.sql.Time t, java.util.Calendar cal)`
`void`	`setTimestamp(int parameterIndex, java.sql.Timestamp x)`
`void`	`setTimestamp(int i, java.sql.Timestamp t, java.util.Calendar cal)`
`void`	`setUnicodeStream(int parameterIndex, java.io.InputStream x, int length)`
`void`	`setUseServerPrepare(boolean flag)` Turn on the use of prepared statements in the server (server side prepared statements are unrelated to jdbc PreparedStatements) As of build 302, this method is equivalent to `setPrepareThreshold(1)`.
`java.lang.String`	`toString()`
`protected boolean`	`wantsHoldableResultSet()`
`protected boolean`	`wantsScrollableResultSet()`
`boolean`	`wasNull()`

Methods inherited from class java.lang.Object
clone, equals, getClass, hashCode, notify, notifyAll, wait, wait, wait

Methods inherited from interface java.sql.Statement
closeOnCompletion, execute, execute, execute, executeUpdate, executeUpdate, executeUpdate, getGeneratedKeys, getMoreResults, getResultSetHoldability, isClosed, isCloseOnCompletion, isPoolable, setPoolable

Methods inherited from interface java.sql.Wrapper
isWrapperFor, unwrap

Field Detail
- batchStatements
```
protected java.util.ArrayList batchStatements
```
- batchParameters
```
protected java.util.ArrayList batchParameters
```
- resultsettype
```
protected final int resultsettype
```
- concurrency
```
protected final int concurrency
```
- fetchdirection
```
protected int fetchdirection
```
- wantsGeneratedKeysOnce
```
protected boolean wantsGeneratedKeysOnce
```
  Does the caller of execute/executeUpdate want generated keys for this execution? This is set by Statement methods that have generated keys arguments and cleared after execution is complete.
- wantsGeneratedKeysAlways
```
public boolean wantsGeneratedKeysAlways
```
  Was this PreparedStatement created to return generated keys for every execution? This is set at creation time and never cleared by execution.
- connection
```
protected BaseConnection connection
```
- warnings
```
protected java.sql.SQLWarning warnings
```
  The warnings chain.
- lastWarning
```
protected java.sql.SQLWarning lastWarning
```
  The last warning of the warning chain.
- maxrows
```
protected int maxrows
```
  Maximum number of rows to return, 0 = unlimited
- fetchSize
```
protected int fetchSize
```
  Number of rows to get in a batch.
- timeout
```
protected int timeout
```
  Timeout (in seconds) for a query (not used)
- replaceProcessingEnabled
```
protected boolean replaceProcessingEnabled
```
- result
```
protected ResultWrapper result
```
  The current results.
- firstUnclosedResult
```
protected ResultWrapper firstUnclosedResult
```
  The first unclosed result.
- generatedKeys
```
protected ResultWrapper generatedKeys
```
  Results returned by a statement that wants generated keys.
- adjustIndex
```
protected boolean adjustIndex
```
  used to differentiate between new function call logic and old function call logic will be set to true if the server is < 8.1 or if we are using v2 protocol There is an exception to this where we are using v3, and the call does not have an out parameter before the call
- outParmBeforeFunc
```
protected boolean outParmBeforeFunc
```
- preparedQuery
```
protected final Query preparedQuery
```
- preparedParameters
```
protected final ParameterList preparedParameters
```
- lastSimpleQuery
```
protected Query lastSimpleQuery
```
- m_prepareThreshold
```
protected int m_prepareThreshold
```
- m_useCount
```
protected int m_useCount
```
- callResult
```
protected java.lang.Object[] callResult
```
- maxfieldSize
```
protected int maxfieldSize
```
- isClosed
```
protected boolean isClosed
```

Constructor Detail

AbstractJdbc2Statement

public AbstractJdbc2Statement(AbstractJdbc2Connection c,
                      int rsType,
                      int rsConcurrency)
                       throws java.sql.SQLException

Throws:: java.sql.SQLException

AbstractJdbc2Statement

public AbstractJdbc2Statement(AbstractJdbc2Connection connection,
                      java.lang.String sql,
                      boolean isCallable,
                      int rsType,
                      int rsConcurrency)
                       throws java.sql.SQLException

Throws:: java.sql.SQLException

Method Detail

createDriverResultSet
```
public java.sql.ResultSet createDriverResultSet(Field[] fields,
                                       java.util.Vector tuples)
                                         throws java.sql.SQLException
```
Description copied from interface: BaseStatement

Create a synthetic resultset from data provided by the driver.

Specified by:

createDriverResultSet in interface BaseStatement

Parameters:
fields - the column metadata for the resultset
tuples - the resultset data

Returns:
the new ResultSet

Throws:

java.sql.SQLException - if something goes wrong

createResultSet
```
public abstract java.sql.ResultSet createResultSet(Query originalQuery,
                                 Field[] fields,
                                 java.util.Vector tuples,
                                 ResultCursor cursor)
                                            throws java.sql.SQLException
```
Description copied from interface: BaseStatement

Create a resultset from data retrieved from the server.

Specified by:

createResultSet in interface BaseStatement

Parameters:
originalQuery - the query that generated this resultset; used when dealing with updateable resultsets
fields - the column metadata for the resultset
tuples - the resultset data
cursor - the cursor to use to retrieve more data from the server; if null, no additional data is present.

Returns:
the new ResultSet

Throws:

java.sql.SQLException - if something goes wrong

getPGConnection

public BaseConnection getPGConnection()

getFetchingCursorName

public java.lang.String getFetchingCursorName()

getFetchSize
```
public int getFetchSize()
```
Specified by:

getFetchSize in interface java.sql.Statement

wantsScrollableResultSet

protected boolean wantsScrollableResultSet()

wantsHoldableResultSet

protected boolean wantsHoldableResultSet()

executeQuery

public java.sql.ResultSet executeQuery(java.lang.String p_sql)
                                throws java.sql.SQLException

Specified by:: executeQuery in interface java.sql.Statement
Throws:: java.sql.SQLException

executeQuery

public java.sql.ResultSet executeQuery()
                                throws java.sql.SQLException

Throws:: java.sql.SQLException

executeUpdate

public int executeUpdate(java.lang.String p_sql)
                  throws java.sql.SQLException

Specified by:: executeUpdate in interface java.sql.Statement
Throws:: java.sql.SQLException

executeUpdate

public int executeUpdate()
                  throws java.sql.SQLException

Throws:: java.sql.SQLException

execute

public boolean execute(java.lang.String p_sql)
                throws java.sql.SQLException

Specified by:: execute in interface java.sql.Statement
Throws:: java.sql.SQLException

executeWithFlags
```
public boolean executeWithFlags(java.lang.String p_sql,
                       int flags)
                         throws java.sql.SQLException
```
Description copied from interface: BaseStatement

Execute a query, passing additional query flags.

Specified by:

executeWithFlags in interface BaseStatement

Parameters:
p_sql - the query to execute
flags - additional QueryExecutor flags for execution; these are bitwise-ORed into the default flags.

Throws:

java.sql.SQLException - if something goes wrong.

execute

public boolean execute()
                throws java.sql.SQLException

Throws:: java.sql.SQLException

executeWithFlags
```
public boolean executeWithFlags(int flags)
                         throws java.sql.SQLException
```
Description copied from interface: BaseStatement

Execute a prepared query, passing additional query flags.

Specified by:

executeWithFlags in interface BaseStatement

Parameters:
flags - additional QueryExecutor flags for execution; these are bitwise-ORed into the default flags.

Throws:

java.sql.SQLException - if something goes wrong.

closeForNextExecution

protected void closeForNextExecution()
                              throws java.sql.SQLException

Throws:: java.sql.SQLException

execute

protected void execute(Query queryToExecute,
           ParameterList queryParameters,
           int flags)
                throws java.sql.SQLException

Throws:: java.sql.SQLException

setCursorName

public void setCursorName(java.lang.String name)
                   throws java.sql.SQLException

Specified by:: setCursorName in interface java.sql.Statement
Throws:: java.sql.SQLException

getUpdateCount
```
public int getUpdateCount()
                   throws java.sql.SQLException
```
Specified by:

getUpdateCount in interface java.sql.Statement

Throws:

java.sql.SQLException

getMoreResults
```
public boolean getMoreResults()
                       throws java.sql.SQLException
```
Specified by:

getMoreResults in interface java.sql.Statement

Throws:

java.sql.SQLException

getMaxRows
```
public int getMaxRows()
               throws java.sql.SQLException
```
Specified by:

getMaxRows in interface java.sql.Statement

Throws:

java.sql.SQLException

setMaxRows
```
public void setMaxRows(int max)
                throws java.sql.SQLException
```
Specified by:

setMaxRows in interface java.sql.Statement

Throws:

java.sql.SQLException

setEscapeProcessing
```
public void setEscapeProcessing(boolean enable)
                         throws java.sql.SQLException
```
Specified by:

setEscapeProcessing in interface java.sql.Statement

Throws:

java.sql.SQLException

getQueryTimeout
```
public int getQueryTimeout()
                    throws java.sql.SQLException
```
Specified by:

getQueryTimeout in interface java.sql.Statement

Throws:

java.sql.SQLException

setQueryTimeout
```
public void setQueryTimeout(int seconds)
                     throws java.sql.SQLException
```
Specified by:

setQueryTimeout in interface java.sql.Statement

Throws:

java.sql.SQLException

addWarning
```
public void addWarning(java.sql.SQLWarning warn)
```
This adds a warning to the warning chain. We track the tail of the warning chain as well to avoid O(N) behavior for adding a new warning to an existing chain. Some server functions which RAISE NOTICE (or equivalent) produce a ton of warnings.

Parameters:
warn - warning to add

getWarnings

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

Specified by:: getWarnings in interface java.sql.Statement
Throws:: java.sql.SQLException

getMaxFieldSize
```
public int getMaxFieldSize()
                    throws java.sql.SQLException
```
Specified by:

getMaxFieldSize in interface java.sql.Statement

Throws:

java.sql.SQLException

setMaxFieldSize
```
public void setMaxFieldSize(int max)
                     throws java.sql.SQLException
```
Specified by:

setMaxFieldSize in interface java.sql.Statement

Throws:

java.sql.SQLException

clearWarnings
```
public void clearWarnings()
                   throws java.sql.SQLException
```
Specified by:

clearWarnings in interface java.sql.Statement

Throws:

java.sql.SQLException

getResultSet

public java.sql.ResultSet getResultSet()
                                throws java.sql.SQLException

Specified by:: getResultSet in interface java.sql.Statement
Throws:: java.sql.SQLException

close
```
public void close()
           throws java.sql.SQLException
```
Specified by:

close in interface java.lang.AutoCloseable

Specified by:

close in interface java.sql.Statement

Throws:

java.sql.SQLException

finalize
```
protected void finalize()
```
This finalizer ensures that statements that have allocated server-side resources free them when they become unreferenced.

Overrides:

finalize in class java.lang.Object

replaceProcessing

protected java.lang.String replaceProcessing(java.lang.String p_sql)
                                      throws java.sql.SQLException

Throws:: java.sql.SQLException

parseSql
```
protected static int parseSql(java.lang.String p_sql,
           int i,
           java.lang.StringBuffer newsql,
           boolean stopOnComma,
           boolean stdStrings)
                       throws java.sql.SQLException
```
parse the given sql from index i, appending it to the gven buffer until we hit an unmatched right parentheses or end of string. When the stopOnComma flag is set we also stop processing when a comma is found in sql text that isn't inside nested parenthesis.

Parameters:
p_sql - the original query text
i - starting position for replacing
newsql - where to write the replaced output
stopOnComma - should we stop after hitting the first comma in sql text?
stdStrings - whether standard_conforming_strings is on

Returns:
the position we stopped processing at

Throws:

java.sql.SQLException

escapeFunction

protected static java.lang.String escapeFunction(java.lang.String functionName,
                              java.lang.String args,
                              boolean stdStrings)
                                          throws java.sql.SQLException

generate sql for escaped functions

Parameters:: functionName - the escaped function name; args - the arguments for this functin; stdStrings - whether standard_conforming_strings is on
Returns:: the right postgreSql sql
Throws:: java.sql.SQLException

getInsertedOID

public int getInsertedOID()
                   throws java.sql.SQLException

Throws:: java.sql.SQLException

getLastOID
```
public long getLastOID()
                throws java.sql.SQLException
```
Description copied from interface: PGStatement

Returns the Last inserted/updated oid.

Specified by:

getLastOID in interface PGStatement

Returns:
OID of last insert

Throws:

java.sql.SQLException

setNull

public void setNull(int parameterIndex,
           int sqlType)
             throws java.sql.SQLException

Throws:: java.sql.SQLException

setBoolean

public void setBoolean(int parameterIndex,
              boolean x)
                throws java.sql.SQLException

Throws:: java.sql.SQLException

setByte

public void setByte(int parameterIndex,
           byte x)
             throws java.sql.SQLException

Throws:: java.sql.SQLException

setShort

public void setShort(int parameterIndex,
            short x)
              throws java.sql.SQLException

Throws:: java.sql.SQLException

setInt

public void setInt(int parameterIndex,
          int x)
            throws java.sql.SQLException

Throws:: java.sql.SQLException

setLong

public void setLong(int parameterIndex,
           long x)
             throws java.sql.SQLException

Throws:: java.sql.SQLException

setFloat

public void setFloat(int parameterIndex,
            float x)
              throws java.sql.SQLException

Throws:: java.sql.SQLException

setDouble

public void setDouble(int parameterIndex,
             double x)
               throws java.sql.SQLException

Throws:: java.sql.SQLException

setBigDecimal

public void setBigDecimal(int parameterIndex,
                 java.math.BigDecimal x)
                   throws java.sql.SQLException

Throws:: java.sql.SQLException

setString

public void setString(int parameterIndex,
             java.lang.String x)
               throws java.sql.SQLException

Throws:: java.sql.SQLException

setString

protected void setString(int parameterIndex,
             java.lang.String x,
             int oid)
                  throws java.sql.SQLException

Throws:: java.sql.SQLException

setBytes

public void setBytes(int parameterIndex,
            byte[] x)
              throws java.sql.SQLException

Throws:: java.sql.SQLException

setDate

public void setDate(int parameterIndex,
           java.sql.Date x)
             throws java.sql.SQLException

Throws:: java.sql.SQLException

setTime

public void setTime(int parameterIndex,
           java.sql.Time x)
             throws java.sql.SQLException

Throws:: java.sql.SQLException

setTimestamp

public void setTimestamp(int parameterIndex,
                java.sql.Timestamp x)
                  throws java.sql.SQLException

Throws:: java.sql.SQLException

setAsciiStream

public void setAsciiStream(int parameterIndex,
                  java.io.InputStream x,
                  int length)
                    throws java.sql.SQLException

Throws:: java.sql.SQLException

setUnicodeStream

public void setUnicodeStream(int parameterIndex,
                    java.io.InputStream x,
                    int length)
                      throws java.sql.SQLException

Throws:: java.sql.SQLException

setBinaryStream

public void setBinaryStream(int parameterIndex,
                   java.io.InputStream x,
                   int length)
                     throws java.sql.SQLException

Throws:: java.sql.SQLException

clearParameters

public void clearParameters()
                     throws java.sql.SQLException

Throws:: java.sql.SQLException

setObject

public void setObject(int parameterIndex,
             java.lang.Object in,
             int targetSqlType,
             int scale)
               throws java.sql.SQLException

Throws:: java.sql.SQLException

setObject

public void setObject(int parameterIndex,
             java.lang.Object x,
             int targetSqlType)
               throws java.sql.SQLException

Throws:: java.sql.SQLException

setObject

public void setObject(int parameterIndex,
             java.lang.Object x)
               throws java.sql.SQLException

Throws:: java.sql.SQLException

registerOutParameter

public void registerOutParameter(int parameterIndex,
                        int sqlType,
                        boolean setPreparedParameters)
                          throws java.sql.SQLException

Throws:: java.sql.SQLException

registerOutParameter

public void registerOutParameter(int parameterIndex,
                        int sqlType,
                        int scale,
                        boolean setPreparedParameters)
                          throws java.sql.SQLException

Throws:: java.sql.SQLException

wasNull

public boolean wasNull()
                throws java.sql.SQLException

Throws:: java.sql.SQLException

getString

public java.lang.String getString(int parameterIndex)
                           throws java.sql.SQLException

Throws:: java.sql.SQLException

getBoolean

public boolean getBoolean(int parameterIndex)
                   throws java.sql.SQLException

Throws:: java.sql.SQLException

getByte

public byte getByte(int parameterIndex)
             throws java.sql.SQLException

Throws:: java.sql.SQLException

getShort

public short getShort(int parameterIndex)
               throws java.sql.SQLException

Throws:: java.sql.SQLException

getInt

public int getInt(int parameterIndex)
           throws java.sql.SQLException

Throws:: java.sql.SQLException

getLong

public long getLong(int parameterIndex)
             throws java.sql.SQLException

Throws:: java.sql.SQLException

getFloat

public float getFloat(int parameterIndex)
               throws java.sql.SQLException

Throws:: java.sql.SQLException

getDouble

public double getDouble(int parameterIndex)
                 throws java.sql.SQLException

Throws:: java.sql.SQLException

getBigDecimal

public java.math.BigDecimal getBigDecimal(int parameterIndex,
                                 int scale)
                                   throws java.sql.SQLException

Throws:: java.sql.SQLException

getBytes

public byte[] getBytes(int parameterIndex)
                throws java.sql.SQLException

Throws:: java.sql.SQLException

getDate

public java.sql.Date getDate(int parameterIndex)
                      throws java.sql.SQLException

Throws:: java.sql.SQLException

getTime

public java.sql.Time getTime(int parameterIndex)
                      throws java.sql.SQLException

Throws:: java.sql.SQLException

getTimestamp

public java.sql.Timestamp getTimestamp(int parameterIndex)
                                throws java.sql.SQLException

Throws:: java.sql.SQLException

getObject

public java.lang.Object getObject(int parameterIndex)
                           throws java.sql.SQLException

Throws:: java.sql.SQLException

toString
```
public java.lang.String toString()
```
Overrides:

toString in class java.lang.Object

bindLiteral

protected void bindLiteral(int paramIndex,
               java.lang.String s,
               int oid)
                    throws java.sql.SQLException

Throws:: java.sql.SQLException

checkIndex

protected void checkIndex(int parameterIndex,
              int type1,
              int type2,
              java.lang.String getName)
                   throws java.sql.SQLException

helperfunction for the getXXX calls to check isFunction and index == 1 Compare BOTH type fields against the return type.

Throws:: java.sql.SQLException

checkIndex

protected void checkIndex(int parameterIndex,
              int type,
              java.lang.String getName)
                   throws java.sql.SQLException

helperfunction for the getXXX calls to check isFunction and index == 1

Throws:: java.sql.SQLException

setPrepareThreshold
```
public void setPrepareThreshold(int newThreshold)
                         throws java.sql.SQLException
```
Description copied from interface: PGStatement

Sets the reuse threshold for using server-prepared statements.
If threshold is a non-zero value N, the Nth and subsequent reuses of a PreparedStatement will use server-side prepare.
If threshold is zero, server-side prepare will not be used.
The reuse threshold is only used by PreparedStatement and CallableStatement objects; it is ignored for plain Statements.

Specified by:

setPrepareThreshold in interface PGStatement

Parameters:
newThreshold - the new threshold for this statement

Throws:

java.sql.SQLException - if an exception occurs while changing the threshold

getPrepareThreshold
```
public int getPrepareThreshold()
```
Description copied from interface: PGStatement

Gets the server-side prepare reuse threshold in use for this statement.

Specified by:

getPrepareThreshold in interface PGStatement

Returns:
the current threshold
See Also:
PGStatement.setPrepareThreshold(int)

setUseServerPrepare
```
public void setUseServerPrepare(boolean flag)
                         throws java.sql.SQLException
```
Description copied from interface: PGStatement

Turn on the use of prepared statements in the server (server side prepared statements are unrelated to jdbc PreparedStatements) As of build 302, this method is equivalent to setPrepareThreshold(1).

Specified by:

setUseServerPrepare in interface PGStatement

Throws:

java.sql.SQLException

isUseServerPrepare
```
public boolean isUseServerPrepare()
```
Description copied from interface: PGStatement

Checks if this statement will be executed as a server-prepared statement. A return value of true indicates that the next execution of the statement will be done as a server-prepared statement, assuming the underlying protocol supports it.

Specified by:

isUseServerPrepare in interface PGStatement

Returns:
true if the next reuse of this statement will use a server-prepared statement

checkClosed

protected void checkClosed()
                    throws java.sql.SQLException

Throws:: java.sql.SQLException

addBatch

public void addBatch(java.lang.String p_sql)
              throws java.sql.SQLException

Specified by:: addBatch in interface java.sql.Statement
Throws:: java.sql.SQLException

clearBatch
```
public void clearBatch()
                throws java.sql.SQLException
```
Specified by:

clearBatch in interface java.sql.Statement

Throws:

java.sql.SQLException

executeBatch
```
public int[] executeBatch()
                   throws java.sql.SQLException
```
Specified by:

executeBatch in interface java.sql.Statement

Throws:

java.sql.SQLException

cancel
```
public void cancel()
            throws java.sql.SQLException
```
Specified by:

cancel in interface java.sql.Statement

Throws:

java.sql.SQLException

getConnection

public java.sql.Connection getConnection()
                                  throws java.sql.SQLException

Specified by:: getConnection in interface java.sql.Statement
Throws:: java.sql.SQLException

getFetchDirection
```
public int getFetchDirection()
```
Specified by:

getFetchDirection in interface java.sql.Statement

getResultSetConcurrency
```
public int getResultSetConcurrency()
```
Specified by:

getResultSetConcurrency in interface java.sql.Statement

getResultSetType
```
public int getResultSetType()
```
Specified by:

getResultSetType in interface java.sql.Statement

setFetchDirection
```
public void setFetchDirection(int direction)
                       throws java.sql.SQLException
```
Specified by:

setFetchDirection in interface java.sql.Statement

Throws:

java.sql.SQLException

setFetchSize
```
public void setFetchSize(int rows)
                  throws java.sql.SQLException
```
Specified by:

setFetchSize in interface java.sql.Statement

Throws:

java.sql.SQLException

addBatch

public void addBatch()
              throws java.sql.SQLException

Throws:: java.sql.SQLException

getMetaData

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

Throws:: java.sql.SQLException

setArray

public void setArray(int i,
            java.sql.Array x)
              throws java.sql.SQLException

Throws:: java.sql.SQLException

setBlob

public void setBlob(int i,
           java.sql.Blob x)
             throws java.sql.SQLException

Throws:: java.sql.SQLException

setCharacterStream

public void setCharacterStream(int i,
                      java.io.Reader x,
                      int length)
                        throws java.sql.SQLException

Throws:: java.sql.SQLException

setClob

public void setClob(int i,
           java.sql.Clob x)
             throws java.sql.SQLException

Throws:: java.sql.SQLException

setNull

public void setNull(int i,
           int t,
           java.lang.String s)
             throws java.sql.SQLException

Throws:: java.sql.SQLException

setRef

public void setRef(int i,
          java.sql.Ref x)
            throws java.sql.SQLException

Throws:: java.sql.SQLException

setDate

public void setDate(int i,
           java.sql.Date d,
           java.util.Calendar cal)
             throws java.sql.SQLException

Throws:: java.sql.SQLException

setTime

public void setTime(int i,
           java.sql.Time t,
           java.util.Calendar cal)
             throws java.sql.SQLException

Throws:: java.sql.SQLException

setTimestamp

public void setTimestamp(int i,
                java.sql.Timestamp t,
                java.util.Calendar cal)
                  throws java.sql.SQLException

Throws:: java.sql.SQLException

getArray

public java.sql.Array getArray(int i)
                        throws java.sql.SQLException

Throws:: java.sql.SQLException

getBigDecimal

public java.math.BigDecimal getBigDecimal(int parameterIndex)
                                   throws java.sql.SQLException

Throws:: java.sql.SQLException

getBlob

public java.sql.Blob getBlob(int i)
                      throws java.sql.SQLException

Throws:: java.sql.SQLException

getClob

public java.sql.Clob getClob(int i)
                      throws java.sql.SQLException

Throws:: java.sql.SQLException

getObjectImpl

public java.lang.Object getObjectImpl(int i,
                             java.util.Map map)
                               throws java.sql.SQLException

Throws:: java.sql.SQLException

getRef

public java.sql.Ref getRef(int i)
                    throws java.sql.SQLException

Throws:: java.sql.SQLException

getDate

public java.sql.Date getDate(int i,
                    java.util.Calendar cal)
                      throws java.sql.SQLException

Throws:: java.sql.SQLException

getTime

public java.sql.Time getTime(int i,
                    java.util.Calendar cal)
                      throws java.sql.SQLException

Throws:: java.sql.SQLException

getTimestamp

public java.sql.Timestamp getTimestamp(int i,
                              java.util.Calendar cal)
                                throws java.sql.SQLException

Throws:: java.sql.SQLException

registerOutParameter

public void registerOutParameter(int parameterIndex,
                        int sqlType,
                        java.lang.String typeName)
                          throws java.sql.SQLException

Throws:: java.sql.SQLException

Class AbstractJdbc2Statement

Nested Class Summary

Field Summary

Fields inherited from interface org.postgresql.PGStatement

Fields inherited from interface java.sql.Statement

Constructor Summary

Method Summary

Methods inherited from class java.lang.Object

Methods inherited from interface java.sql.Statement

Methods inherited from interface java.sql.Wrapper

Field Detail

batchStatements

batchParameters

resultsettype

concurrency

fetchdirection

wantsGeneratedKeysOnce

wantsGeneratedKeysAlways

connection

warnings

lastWarning

maxrows

fetchSize

timeout

replaceProcessingEnabled

result

firstUnclosedResult

generatedKeys

adjustIndex

outParmBeforeFunc

preparedQuery

preparedParameters

lastSimpleQuery

m_prepareThreshold

m_useCount

callResult

maxfieldSize

isClosed

Constructor Detail

AbstractJdbc2Statement

AbstractJdbc2Statement

Method Detail

createDriverResultSet

createResultSet

getPGConnection

getFetchingCursorName

getFetchSize

wantsScrollableResultSet

wantsHoldableResultSet

executeQuery

executeQuery

executeUpdate

executeUpdate

execute

executeWithFlags

execute

executeWithFlags

closeForNextExecution

execute

setCursorName

getUpdateCount

getMoreResults

getMaxRows

setMaxRows

setEscapeProcessing

getQueryTimeout

setQueryTimeout

addWarning

getWarnings

getMaxFieldSize

setMaxFieldSize

clearWarnings

getResultSet

close

finalize

replaceProcessing

parseSql

escapeFunction

getInsertedOID

getLastOID