|
||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
java.lang.Objectorg.apache.hadoop.hive.jdbc.HivePreparedStatement
public class HivePreparedStatement
HivePreparedStatement.
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 | |
---|---|
HivePreparedStatement(HiveInterface client,
String sql)
|
Method Summary | ||
---|---|---|
void |
addBatch()
|
|
void |
addBatch(String sql)
|
|
void |
cancel()
|
|
void |
clearBatch()
|
|
void |
clearParameters()
|
|
void |
clearWarnings()
|
|
void |
close()
Closes the prepared statement. |
|
boolean |
execute()
Invokes executeQuery(sql) using the sql provided to the constructor. |
|
boolean |
execute(String sql)
|
|
boolean |
execute(String sql,
int autoGeneratedKeys)
|
|
boolean |
execute(String sql,
int[] columnIndexes)
|
|
boolean |
execute(String sql,
String[] columnNames)
|
|
int[] |
executeBatch()
|
|
protected ResultSet |
executeImmediate(String sql)
Executes the SQL statement. |
|
ResultSet |
executeQuery()
Invokes executeQuery(sql) using the sql provided to the constructor. |
|
ResultSet |
executeQuery(String sql)
|
|
int |
executeUpdate()
|
|
int |
executeUpdate(String sql)
|
|
int |
executeUpdate(String sql,
int autoGeneratedKeys)
|
|
int |
executeUpdate(String sql,
int[] columnIndexes)
|
|
int |
executeUpdate(String sql,
String[] columnNames)
|
|
Connection |
getConnection()
|
|
int |
getFetchDirection()
|
|
int |
getFetchSize()
|
|
ResultSet |
getGeneratedKeys()
|
|
int |
getMaxFieldSize()
|
|
int |
getMaxRows()
|
|
ResultSetMetaData |
getMetaData()
|
|
boolean |
getMoreResults()
|
|
boolean |
getMoreResults(int current)
|
|
ParameterMetaData |
getParameterMetaData()
|
|
int |
getQueryTimeout()
|
|
ResultSet |
getResultSet()
|
|
int |
getResultSetConcurrency()
|
|
int |
getResultSetHoldability()
|
|
int |
getResultSetType()
|
|
int |
getUpdateCount()
|
|
SQLWarning |
getWarnings()
|
|
boolean |
isClosed()
|
|
boolean |
isPoolable()
|
|
boolean |
isWrapperFor(Class<?> iface)
|
|
void |
setArray(int i,
Array x)
|
|
void |
setAsciiStream(int parameterIndex,
InputStream x)
|
|
void |
setAsciiStream(int parameterIndex,
InputStream x,
int length)
|
|
void |
setAsciiStream(int parameterIndex,
InputStream x,
long length)
|
|
void |
setBigDecimal(int parameterIndex,
BigDecimal x)
|
|
void |
setBinaryStream(int parameterIndex,
InputStream x)
|
|
void |
setBinaryStream(int parameterIndex,
InputStream x,
int length)
|
|
void |
setBinaryStream(int parameterIndex,
InputStream x,
long length)
|
|
void |
setBlob(int i,
Blob x)
|
|
void |
setBlob(int parameterIndex,
InputStream inputStream)
|
|
void |
setBlob(int parameterIndex,
InputStream inputStream,
long length)
|
|
void |
setBoolean(int parameterIndex,
boolean x)
|
|
void |
setByte(int parameterIndex,
byte x)
|
|
void |
setBytes(int parameterIndex,
byte[] x)
|
|
void |
setCharacterStream(int parameterIndex,
Reader reader)
|
|
void |
setCharacterStream(int parameterIndex,
Reader reader,
int length)
|
|
void |
setCharacterStream(int parameterIndex,
Reader reader,
long length)
|
|
void |
setClob(int i,
Clob x)
|
|
void |
setClob(int parameterIndex,
Reader reader)
|
|
void |
setClob(int parameterIndex,
Reader reader,
long length)
|
|
void |
setCursorName(String name)
|
|
void |
setDate(int parameterIndex,
Date x)
|
|
void |
setDate(int parameterIndex,
Date x,
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 |
setNCharacterStream(int parameterIndex,
Reader value)
|
|
void |
setNCharacterStream(int parameterIndex,
Reader value,
long length)
|
|
void |
setNClob(int parameterIndex,
NClob value)
|
|
void |
setNClob(int parameterIndex,
Reader reader)
|
|
void |
setNClob(int parameterIndex,
Reader reader,
long length)
|
|
void |
setNString(int parameterIndex,
String value)
|
|
void |
setNull(int parameterIndex,
int sqlType)
|
|
void |
setNull(int paramIndex,
int sqlType,
String typeName)
|
|
void |
setObject(int parameterIndex,
Object x)
|
|
void |
setObject(int parameterIndex,
Object x,
int targetSqlType)
|
|
void |
setObject(int parameterIndex,
Object x,
int targetSqlType,
int scale)
|
|
void |
setPoolable(boolean poolable)
|
|
void |
setQueryTimeout(int seconds)
|
|
void |
setRef(int i,
Ref x)
|
|
void |
setRowId(int parameterIndex,
RowId x)
|
|
void |
setShort(int parameterIndex,
short x)
|
|
void |
setSQLXML(int parameterIndex,
SQLXML xmlObject)
|
|
void |
setString(int parameterIndex,
String x)
|
|
void |
setTime(int parameterIndex,
Time x)
|
|
void |
setTime(int parameterIndex,
Time x,
Calendar cal)
|
|
void |
setTimestamp(int parameterIndex,
Timestamp x)
|
|
void |
setTimestamp(int parameterIndex,
Timestamp x,
Calendar cal)
|
|
void |
setUnicodeStream(int parameterIndex,
InputStream x,
int length)
|
|
void |
setURL(int parameterIndex,
URL x)
|
|
|
unwrap(Class<T> iface)
|
Methods inherited from class java.lang.Object |
---|
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait |
Constructor Detail |
---|
public HivePreparedStatement(HiveInterface client, String sql)
Method Detail |
---|
public void addBatch() throws SQLException
addBatch
in interface PreparedStatement
SQLException
public void clearParameters() throws SQLException
clearParameters
in interface PreparedStatement
SQLException
public boolean execute() throws SQLException
execute
in interface PreparedStatement
SQLException
public ResultSet executeQuery() throws SQLException
executeQuery
in interface PreparedStatement
SQLException
public int executeUpdate() throws SQLException
executeUpdate
in interface PreparedStatement
SQLException
protected ResultSet executeImmediate(String sql) throws SQLException
sql
- The sql, as a string, to execute
SQLException
- if the prepared statement is closed or there is a database error.
caught Exceptions are thrown as SQLExceptions with the description
"08S01".public ResultSetMetaData getMetaData() throws SQLException
getMetaData
in interface PreparedStatement
SQLException
public ParameterMetaData getParameterMetaData() throws SQLException
getParameterMetaData
in interface PreparedStatement
SQLException
public void setArray(int i, Array x) throws SQLException
setArray
in interface PreparedStatement
SQLException
public void setAsciiStream(int parameterIndex, InputStream x) throws SQLException
setAsciiStream
in interface PreparedStatement
SQLException
public void setAsciiStream(int parameterIndex, InputStream x, int length) throws SQLException
setAsciiStream
in interface PreparedStatement
SQLException
public void setAsciiStream(int parameterIndex, InputStream x, long length) throws SQLException
setAsciiStream
in interface PreparedStatement
SQLException
public void setBigDecimal(int parameterIndex, BigDecimal x) throws SQLException
setBigDecimal
in interface PreparedStatement
SQLException
public void setBinaryStream(int parameterIndex, InputStream x) throws SQLException
setBinaryStream
in interface PreparedStatement
SQLException
public void setBinaryStream(int parameterIndex, InputStream x, int length) throws SQLException
setBinaryStream
in interface PreparedStatement
SQLException
public void setBinaryStream(int parameterIndex, InputStream x, long length) throws SQLException
setBinaryStream
in interface PreparedStatement
SQLException
public void setBlob(int i, Blob x) throws SQLException
setBlob
in interface PreparedStatement
SQLException
public void setBlob(int parameterIndex, InputStream inputStream) throws SQLException
setBlob
in interface PreparedStatement
SQLException
public void setBlob(int parameterIndex, InputStream inputStream, long length) throws SQLException
setBlob
in interface PreparedStatement
SQLException
public void setBoolean(int parameterIndex, boolean x) throws SQLException
setBoolean
in interface PreparedStatement
SQLException
public void setByte(int parameterIndex, byte x) throws SQLException
setByte
in interface PreparedStatement
SQLException
public void setBytes(int parameterIndex, byte[] x) throws SQLException
setBytes
in interface PreparedStatement
SQLException
public void setCharacterStream(int parameterIndex, Reader reader) throws SQLException
setCharacterStream
in interface PreparedStatement
SQLException
public void setCharacterStream(int parameterIndex, Reader reader, int length) throws SQLException
setCharacterStream
in interface PreparedStatement
SQLException
public void setCharacterStream(int parameterIndex, Reader reader, long length) throws SQLException
setCharacterStream
in interface PreparedStatement
SQLException
public void setClob(int i, Clob x) throws SQLException
setClob
in interface PreparedStatement
SQLException
public void setClob(int parameterIndex, Reader reader) throws SQLException
setClob
in interface PreparedStatement
SQLException
public void setClob(int parameterIndex, Reader reader, long length) throws SQLException
setClob
in interface PreparedStatement
SQLException
public void setDate(int parameterIndex, Date x) throws SQLException
setDate
in interface PreparedStatement
SQLException
public void setDate(int parameterIndex, Date x, Calendar cal) throws SQLException
setDate
in interface PreparedStatement
SQLException
public void setDouble(int parameterIndex, double x) throws SQLException
setDouble
in interface PreparedStatement
SQLException
public void setFloat(int parameterIndex, float x) throws SQLException
setFloat
in interface PreparedStatement
SQLException
public void setInt(int parameterIndex, int x) throws SQLException
setInt
in interface PreparedStatement
SQLException
public void setLong(int parameterIndex, long x) throws SQLException
setLong
in interface PreparedStatement
SQLException
public void setNCharacterStream(int parameterIndex, Reader value) throws SQLException
setNCharacterStream
in interface PreparedStatement
SQLException
public void setNCharacterStream(int parameterIndex, Reader value, long length) throws SQLException
setNCharacterStream
in interface PreparedStatement
SQLException
public void setNClob(int parameterIndex, NClob value) throws SQLException
setNClob
in interface PreparedStatement
SQLException
public void setNClob(int parameterIndex, Reader reader) throws SQLException
setNClob
in interface PreparedStatement
SQLException
public void setNClob(int parameterIndex, Reader reader, long length) throws SQLException
setNClob
in interface PreparedStatement
SQLException
public void setNString(int parameterIndex, String value) throws SQLException
setNString
in interface PreparedStatement
SQLException
public void setNull(int parameterIndex, int sqlType) throws SQLException
setNull
in interface PreparedStatement
SQLException
public void setNull(int paramIndex, int sqlType, String typeName) throws SQLException
setNull
in interface PreparedStatement
SQLException
public void setObject(int parameterIndex, Object x) throws SQLException
setObject
in interface PreparedStatement
SQLException
public void setObject(int parameterIndex, Object x, int targetSqlType) throws SQLException
setObject
in interface PreparedStatement
SQLException
public void setObject(int parameterIndex, Object x, int targetSqlType, int scale) throws SQLException
setObject
in interface PreparedStatement
SQLException
public void setRef(int i, Ref x) throws SQLException
setRef
in interface PreparedStatement
SQLException
public void setRowId(int parameterIndex, RowId x) throws SQLException
setRowId
in interface PreparedStatement
SQLException
public void setSQLXML(int parameterIndex, SQLXML xmlObject) throws SQLException
setSQLXML
in interface PreparedStatement
SQLException
public void setShort(int parameterIndex, short x) throws SQLException
setShort
in interface PreparedStatement
SQLException
public void setString(int parameterIndex, String x) throws SQLException
setString
in interface PreparedStatement
SQLException
public void setTime(int parameterIndex, Time x) throws SQLException
setTime
in interface PreparedStatement
SQLException
public void setTime(int parameterIndex, Time x, Calendar cal) throws SQLException
setTime
in interface PreparedStatement
SQLException
public void setTimestamp(int parameterIndex, Timestamp x) throws SQLException
setTimestamp
in interface PreparedStatement
SQLException
public void setTimestamp(int parameterIndex, Timestamp x, Calendar cal) throws SQLException
setTimestamp
in interface PreparedStatement
SQLException
public void setURL(int parameterIndex, URL x) throws SQLException
setURL
in interface PreparedStatement
SQLException
public void setUnicodeStream(int parameterIndex, InputStream x, int length) throws SQLException
setUnicodeStream
in interface PreparedStatement
SQLException
public void addBatch(String sql) throws SQLException
addBatch
in interface Statement
SQLException
public void cancel() throws SQLException
cancel
in interface Statement
SQLException
public void clearBatch() throws SQLException
clearBatch
in interface Statement
SQLException
public void clearWarnings() throws SQLException
clearWarnings
in interface Statement
SQLException
public void close() throws SQLException
close
in interface Statement
SQLException
public boolean execute(String sql) throws SQLException
execute
in interface Statement
SQLException
public boolean execute(String sql, int autoGeneratedKeys) throws SQLException
execute
in interface Statement
SQLException
public boolean execute(String sql, int[] columnIndexes) throws SQLException
execute
in interface Statement
SQLException
public boolean execute(String sql, String[] columnNames) throws SQLException
execute
in interface Statement
SQLException
public int[] executeBatch() throws SQLException
executeBatch
in interface Statement
SQLException
public ResultSet executeQuery(String sql) throws SQLException
executeQuery
in interface Statement
SQLException
public int executeUpdate(String sql) throws SQLException
executeUpdate
in interface Statement
SQLException
public int executeUpdate(String sql, int autoGeneratedKeys) throws SQLException
executeUpdate
in interface Statement
SQLException
public int executeUpdate(String sql, int[] columnIndexes) throws SQLException
executeUpdate
in interface Statement
SQLException
public int executeUpdate(String sql, String[] columnNames) throws SQLException
executeUpdate
in interface Statement
SQLException
public Connection getConnection() throws SQLException
getConnection
in interface Statement
SQLException
public int getFetchDirection() throws SQLException
getFetchDirection
in interface Statement
SQLException
public int getFetchSize() throws SQLException
getFetchSize
in interface Statement
SQLException
public ResultSet getGeneratedKeys() throws SQLException
getGeneratedKeys
in interface Statement
SQLException
public int getMaxFieldSize() throws SQLException
getMaxFieldSize
in interface Statement
SQLException
public int getMaxRows() throws SQLException
getMaxRows
in interface Statement
SQLException
public boolean getMoreResults() throws SQLException
getMoreResults
in interface Statement
SQLException
public boolean getMoreResults(int current) throws SQLException
getMoreResults
in interface Statement
SQLException
public int getQueryTimeout() throws SQLException
getQueryTimeout
in interface Statement
SQLException
public ResultSet getResultSet() throws SQLException
getResultSet
in interface Statement
SQLException
public int getResultSetConcurrency() throws SQLException
getResultSetConcurrency
in interface Statement
SQLException
public int getResultSetHoldability() throws SQLException
getResultSetHoldability
in interface Statement
SQLException
public int getResultSetType() throws SQLException
getResultSetType
in interface Statement
SQLException
public int getUpdateCount() throws SQLException
getUpdateCount
in interface Statement
SQLException
public SQLWarning getWarnings() throws SQLException
getWarnings
in interface Statement
SQLException
public boolean isClosed() throws SQLException
isClosed
in interface Statement
SQLException
public boolean isPoolable() throws SQLException
isPoolable
in interface Statement
SQLException
public void setCursorName(String name) throws SQLException
setCursorName
in interface Statement
SQLException
public void setEscapeProcessing(boolean enable) throws SQLException
setEscapeProcessing
in interface Statement
SQLException
public void setFetchDirection(int direction) throws SQLException
setFetchDirection
in interface Statement
SQLException
public void setFetchSize(int rows) throws SQLException
setFetchSize
in interface Statement
SQLException
public void setMaxFieldSize(int max) throws SQLException
setMaxFieldSize
in interface Statement
SQLException
public void setMaxRows(int max) throws SQLException
setMaxRows
in interface Statement
SQLException
public void setPoolable(boolean poolable) throws SQLException
setPoolable
in interface Statement
SQLException
public void setQueryTimeout(int seconds) throws SQLException
setQueryTimeout
in interface Statement
SQLException
public boolean isWrapperFor(Class<?> iface) throws SQLException
isWrapperFor
in interface Wrapper
SQLException
public <T> T unwrap(Class<T> iface) throws SQLException
unwrap
in interface Wrapper
SQLException
|
||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |