org.pentaho.di.core.jdbc

Class ThinPreparedStatement

java.lang.Object

org.pentaho.di.core.jdbc.ThinStatement

org.pentaho.di.core.jdbc.ThinPreparedStatement

All Implemented Interfaces:

AutoCloseable, PreparedStatement, Statement, Wrapper

public class ThinPreparedStatement
extends ThinStatement
implements PreparedStatement

Field Summary

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
ThinPreparedStatement(ThinConnection connection, String sql)

Method Summary

Methods

Modifier and Type	Method and Description
void	addBatch()
void	analyzeSql()
void	clearParameters()
boolean	execute()
ResultSet	executeQuery()
int	executeUpdate()
ResultSetMetaData	getMetaData()
Object[]	getParamData()
ParameterMetaData	getParameterMetaData()
ValueMetaInterface[]	getParamMeta()
String	getSql()
String	replaceSql()
void	setArray(int nr, Array value)
void	setAsciiStream(int nr, InputStream value)
void	setAsciiStream(int nr, InputStream value, int arg2)
void	setAsciiStream(int nr, InputStream value, long arg2)
void	setBigDecimal(int nr, BigDecimal value)
void	setBinaryStream(int nr, InputStream value)
void	setBinaryStream(int nr, InputStream value, int arg2)
void	setBinaryStream(int nr, InputStream value, long arg2)
void	setBlob(int nr, Blob value)
void	setBlob(int nr, InputStream value)
void	setBlob(int nr, InputStream value, long arg2)
void	setBoolean(int nr, boolean value)
void	setByte(int nr, byte value)
void	setBytes(int nr, byte[] value)
void	setCharacterStream(int nr, Reader value)
void	setCharacterStream(int nr, Reader value, int arg2)
void	setCharacterStream(int nr, Reader value, long arg2)
void	setClob(int nr, Clob value)
void	setClob(int nr, Reader value)
void	setClob(int nr, Reader value, long arg2)
void	setDate(int nr, Date value)
void	setDate(int nr, Date value, Calendar calendar)
void	setDouble(int nr, double value)
void	setFloat(int nr, float value)
void	setInt(int nr, int value)
void	setLong(int nr, long value)
void	setNCharacterStream(int nr, Reader value)
void	setNCharacterStream(int nr, Reader value, long arg2)
void	setNClob(int nr, NClob value)
void	setNClob(int nr, Reader value)
void	setNClob(int nr, Reader value, long arg2)
void	setNString(int nr, String value)
void	setNull(int nr, int sqlType)
void	setNull(int nr, int value, String arg2)
void	setObject(int nr, Object value)
void	setObject(int nr, Object value, int arg2)
void	setObject(int nr, Object value, int arg2, int arg3)
void	setRef(int nr, Ref value)
void	setRowId(int nr, RowId value)
void	setShort(int nr, short value)
void	setSql(String sql)
void	setSQLXML(int nr, SQLXML value)
void	setString(int nr, String value)
void	setTime(int nr, Time value)
void	setTime(int nr, Time value, Calendar arg2)
void	setTimestamp(int nr, Timestamp value)
void	setTimestamp(int nr, Timestamp value, Calendar arg2)
void	setUnicodeStream(int nr, InputStream value, int arg2) Deprecated.
void	setURL(int nr, URL value)

Methods inherited from class org.pentaho.di.core.jdbc.ThinStatement

addBatch, cancel, clearBatch, clearWarnings, close, closeOnCompletion, execute, execute, execute, execute, executeBatch, executeQuery, executeUpdate, executeUpdate, executeUpdate, executeUpdate, getConnection, getFetchDirection, getFetchSize, getGeneratedKeys, getMaxFieldSize, getMaxRows, getMoreResults, getMoreResults, getQueryTimeout, getResultSet, getResultSetConcurrency, getResultSetHoldability, getResultSetType, getUpdateCount, getWarnings, isClosed, isCloseOnCompletion, isPoolable, isWrapperFor, setCursorName, setEscapeProcessing, setFetchDirection, setFetchSize, setMaxFieldSize, setMaxRows, setPoolable, setQueryTimeout, unwrap

Methods inherited from class java.lang.Object

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

Methods inherited from interface java.sql.Statement

addBatch, cancel, clearBatch, clearWarnings, close, closeOnCompletion, execute, execute, execute, execute, executeBatch, executeQuery, executeUpdate, executeUpdate, executeUpdate, executeUpdate, getConnection, getFetchDirection, getFetchSize, getGeneratedKeys, getMaxFieldSize, getMaxRows, getMoreResults, getMoreResults, getQueryTimeout, getResultSet, getResultSetConcurrency, getResultSetHoldability, getResultSetType, getUpdateCount, getWarnings, isClosed, isCloseOnCompletion, isPoolable, setCursorName, setEscapeProcessing, setFetchDirection, setFetchSize, setMaxFieldSize, setMaxRows, setPoolable, setQueryTimeout

Methods inherited from interface java.sql.Wrapper

isWrapperFor, unwrap

Constructor Detail

ThinPreparedStatement

public ThinPreparedStatement(ThinConnection connection,
                     String sql)
                      throws SQLException

Throws:

SQLException

Method Detail

analyzeSql

public void analyzeSql()
                throws SQLException

Throws:

SQLException

replaceSql

public String replaceSql()
                  throws SQLException

Throws:

SQLException

addBatch

public void addBatch()
              throws SQLException

Specified by:

addBatch in interface PreparedStatement

Throws:

SQLException

clearParameters

public void clearParameters()
                     throws SQLException

Specified by:

clearParameters in interface PreparedStatement

Throws:

SQLException

execute

public boolean execute()
                throws SQLException

Specified by:

execute in interface PreparedStatement

Throws:

SQLException

executeQuery

public ResultSet executeQuery()
                       throws SQLException

Specified by:

executeQuery in interface PreparedStatement

Throws:

SQLException

executeUpdate

public int executeUpdate()
                  throws SQLException

Specified by:

executeUpdate in interface PreparedStatement

Throws:

SQLException

getMetaData

public ResultSetMetaData getMetaData()
                              throws SQLException

Specified by:

getMetaData in interface PreparedStatement

Throws:

SQLException

getParameterMetaData

public ParameterMetaData getParameterMetaData()
                                       throws SQLException

Specified by:

getParameterMetaData in interface PreparedStatement

Throws:

SQLException

setArray

public void setArray(int nr,
            Array value)
              throws SQLException

Specified by:

setArray in interface PreparedStatement

Throws:

SQLException

setAsciiStream

public void setAsciiStream(int nr,
                  InputStream value)
                    throws SQLException

Specified by:

setAsciiStream in interface PreparedStatement

Throws:

SQLException

setAsciiStream

public void setAsciiStream(int nr,
                  InputStream value,
                  int arg2)
                    throws SQLException

Specified by:

setAsciiStream in interface PreparedStatement

Throws:

SQLException

setAsciiStream

public void setAsciiStream(int nr,
                  InputStream value,
                  long arg2)
                    throws SQLException

Specified by:

setAsciiStream in interface PreparedStatement

Throws:

SQLException

setBigDecimal

public void setBigDecimal(int nr,
                 BigDecimal value)
                   throws SQLException

Specified by:

setBigDecimal in interface PreparedStatement

Throws:

SQLException

setBinaryStream

public void setBinaryStream(int nr,
                   InputStream value)
                     throws SQLException

Specified by:

setBinaryStream in interface PreparedStatement

Throws:

SQLException

setBinaryStream

public void setBinaryStream(int nr,
                   InputStream value,
                   int arg2)
                     throws SQLException

Specified by:

setBinaryStream in interface PreparedStatement

Throws:

SQLException

setBinaryStream

public void setBinaryStream(int nr,
                   InputStream value,
                   long arg2)
                     throws SQLException

Specified by:

setBinaryStream in interface PreparedStatement

Throws:

SQLException

setBlob

public void setBlob(int nr,
           Blob value)
             throws SQLException

Specified by:

setBlob in interface PreparedStatement

Throws:

SQLException

setBlob

public void setBlob(int nr,
           InputStream value)
             throws SQLException

Specified by:

setBlob in interface PreparedStatement

Throws:

SQLException

setBlob

public void setBlob(int nr,
           InputStream value,
           long arg2)
             throws SQLException

Specified by:

setBlob in interface PreparedStatement

Throws:

SQLException

setBoolean

public void setBoolean(int nr,
              boolean value)
                throws SQLException

Specified by:

setBoolean in interface PreparedStatement

Throws:

SQLException

setByte

public void setByte(int nr,
           byte value)
             throws SQLException

Specified by:

setByte in interface PreparedStatement

Throws:

SQLException

setBytes

public void setBytes(int nr,
            byte[] value)
              throws SQLException

Specified by:

setBytes in interface PreparedStatement

Throws:

SQLException

setCharacterStream

public void setCharacterStream(int nr,
                      Reader value)
                        throws SQLException

Specified by:

setCharacterStream in interface PreparedStatement

Throws:

SQLException

setCharacterStream

public void setCharacterStream(int nr,
                      Reader value,
                      int arg2)
                        throws SQLException

Specified by:

setCharacterStream in interface PreparedStatement

Throws:

SQLException

setCharacterStream

public void setCharacterStream(int nr,
                      Reader value,
                      long arg2)
                        throws SQLException

Specified by:

setCharacterStream in interface PreparedStatement

Throws:

SQLException

setClob

public void setClob(int nr,
           Clob value)
             throws SQLException

Specified by:

setClob in interface PreparedStatement

Throws:

SQLException

setClob

public void setClob(int nr,
           Reader value)
             throws SQLException

Specified by:

setClob in interface PreparedStatement

Throws:

SQLException

setClob

public void setClob(int nr,
           Reader value,
           long arg2)
             throws SQLException

Specified by:

setClob in interface PreparedStatement

Throws:

SQLException

setDate

public void setDate(int nr,
           Date value)
             throws SQLException

Specified by:

setDate in interface PreparedStatement

Throws:

SQLException

setDate

public void setDate(int nr,
           Date value,
           Calendar calendar)
             throws SQLException

Specified by:

setDate in interface PreparedStatement

Throws:

SQLException

setDouble

public void setDouble(int nr,
             double value)
               throws SQLException

Specified by:

setDouble in interface PreparedStatement

Throws:

SQLException

setFloat

public void setFloat(int nr,
            float value)
              throws SQLException

Specified by:

setFloat in interface PreparedStatement

Throws:

SQLException

setInt

public void setInt(int nr,
          int value)
            throws SQLException

Specified by:

setInt in interface PreparedStatement

Throws:

SQLException

setLong

public void setLong(int nr,
           long value)
             throws SQLException

Specified by:

setLong in interface PreparedStatement

Throws:

SQLException

setNCharacterStream

public void setNCharacterStream(int nr,
                       Reader value)
                         throws SQLException

Specified by:

setNCharacterStream in interface PreparedStatement

Throws:

SQLException

setNCharacterStream

public void setNCharacterStream(int nr,
                       Reader value,
                       long arg2)
                         throws SQLException

Specified by:

setNCharacterStream in interface PreparedStatement

Throws:

SQLException

setNClob

public void setNClob(int nr,
            NClob value)
              throws SQLException

Specified by:

setNClob in interface PreparedStatement

Throws:

SQLException

setNClob

public void setNClob(int nr,
            Reader value)
              throws SQLException

Specified by:

setNClob in interface PreparedStatement

Throws:

SQLException

setNClob

public void setNClob(int nr,
            Reader value,
            long arg2)
              throws SQLException

Specified by:

setNClob in interface PreparedStatement

Throws:

SQLException

setNString

public void setNString(int nr,
              String value)
                throws SQLException

Specified by:

setNString in interface PreparedStatement

Throws:

SQLException

setNull

public void setNull(int nr,
           int sqlType)
             throws SQLException

Specified by:

setNull in interface PreparedStatement

Throws:

SQLException

setNull

public void setNull(int nr,
           int value,
           String arg2)
             throws SQLException

Specified by:

setNull in interface PreparedStatement

Throws:

SQLException

setObject

public void setObject(int nr,
             Object value)
               throws SQLException

Specified by:

setObject in interface PreparedStatement

Throws:

SQLException

setObject

public void setObject(int nr,
             Object value,
             int arg2)
               throws SQLException

Specified by:

setObject in interface PreparedStatement

Throws:

SQLException

setObject

public void setObject(int nr,
             Object value,
             int arg2,
             int arg3)
               throws SQLException

Specified by:

setObject in interface PreparedStatement

Throws:

SQLException

setRef

public void setRef(int nr,
          Ref value)
            throws SQLException

Specified by:

setRef in interface PreparedStatement

Throws:

SQLException

setRowId

public void setRowId(int nr,
            RowId value)
              throws SQLException

Specified by:

setRowId in interface PreparedStatement

Throws:

SQLException

setSQLXML

public void setSQLXML(int nr,
             SQLXML value)
               throws SQLException

Specified by:

setSQLXML in interface PreparedStatement

Throws:

SQLException

setShort

public void setShort(int nr,
            short value)
              throws SQLException

Specified by:

setShort in interface PreparedStatement

Throws:

SQLException

setString

public void setString(int nr,
             String value)
               throws SQLException

Specified by:

setString in interface PreparedStatement

Throws:

SQLException

setTime

public void setTime(int nr,
           Time value)
             throws SQLException

Specified by:

setTime in interface PreparedStatement

Throws:

SQLException

setTime

public void setTime(int nr,
           Time value,
           Calendar arg2)
             throws SQLException

Specified by:

setTime in interface PreparedStatement

Throws:

SQLException

setTimestamp

public void setTimestamp(int nr,
                Timestamp value)
                  throws SQLException

Specified by:

setTimestamp in interface PreparedStatement

Throws:

SQLException

setTimestamp

public void setTimestamp(int nr,
                Timestamp value,
                Calendar arg2)
                  throws SQLException

Specified by:

setTimestamp in interface PreparedStatement

Throws:

SQLException

setURL

public void setURL(int nr,
          URL value)
            throws SQLException

Specified by:

setURL in interface PreparedStatement

Throws:

SQLException

setUnicodeStream

@Deprecated
public void setUnicodeStream(int nr,
                               InputStream value,
                               int arg2)
                      throws SQLException

Deprecated.

Specified by:

setUnicodeStream in interface PreparedStatement

Throws:

SQLException

getSql

public String getSql()

Returns:

the sql

setSql

public void setSql(String sql)

Parameters:

sql - the sql to set

getParamMeta

public ValueMetaInterface[] getParamMeta()

Returns:

the paramMeta

getParamData

public Object[] getParamData()

Returns:

the paramData