All Libraries | This Library | Package | Class | Use | Tree | Deprecated | Index | Grand Index | Help
|  | Components |
PREV CLASS NEXT CLASS | FRAMES NO FRAMES
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD

## com.sas.net.sharenet
Class ShareNetPreparedStatement

    com.sas.net.sharenet.ShareNetPreparedStatement

All Implemented Interfaces:
  java.lang.AutoCloseable, java.sql.PreparedStatement, java.sql.Statement, java.sql.Wrapper

    @SASScope(value="ALL")
    public class ShareNetPreparedStatement

implements java.sql.PreparedStatement

This is the SAS/SHARE Driver for JDBC implementation for java.sql.PreparedStatement.

Field Summary

Fields inherited from class com.sas.net.sharenet.ShareNetStatement
`closed, closeOnCompletion, connection, describe, fetchSize, maxFieldSize, months, msg, snresultset`

Method Summary
`void` | `addBatch()` This method is not supported and will always throw a SQLException.
`void` | `clearParameters()`
`boolean` | `execute()`
`java.sql.ResultSet` | `executeQuery()`
`int` | `executeUpdate()`
`java.sql.ResultSetMetaData` | `getMetaData()`
`java.sql.ParameterMetaData` | `getParameterMetaData()` This method is not supported and will always throw a SQLException.
`java.sql.ResultSetMetaData` | `getResultSetMetaData()` Deprecated.
`void` | `setArray(int parameterIndex, java.sql.Array x)` This method is not supported and will always throw a SQLException.
`void` | `setAsciiStream(int parameterIndex, java.io.InputStream x)` This method is not supported and will always throw a SQLException.
`void` | `setAsciiStream(int parameterIndex, java.io.InputStream x, int length)`
`void` | `setAsciiStream(int parameterIndex, java.io.InputStream x, long length)` This method is not supported and will always throw a SQLException.
`void` | `setBigDecimal(int parameterIndex, java.math.BigDecimal x)`
`void` | `setBinaryStream(int parameterIndex, java.io.InputStream x)` This method is not supported and will always throw a SQLException.
`void` | `setBinaryStream(int parameterIndex, java.io.InputStream x, int length)`
`void` | `setBinaryStream(int parameterIndex, java.io.InputStream x, long length)` This method is not supported and will always throw a SQLException.
`void` | `setBlob(int parameterIndex, java.sql.Blob x)` This method is not supported and will always throw a SQLException.
`void` | `setBlob(int parameterIndex, java.io.InputStream inputStream)` This method is not supported and will always throw a SQLException.
`void` | `setBlob(int parameterIndex, java.io.InputStream inputStream, long length)` This method is not supported and will always throw a SQLException.
`void` | `setBoolean(int parameterIndex, boolean x)` Sets a parameter to a Java Boolean value.
`void` | `setByte(int parameterIndex, byte x)` Sets a parameter to a Java byte value.
`void` | `setBytes(int parameterIndex, byte[] x)`
`void` | `setCharacterStream(int parameterIndex, java.io.Reader reader)` This method is not supported and will always throw a SQLException.
`void` | `setCharacterStream(int parameterIndex, java.io.Reader reader, int length)` This method is not supported and will always throw a SQLException.
`void` | `setCharacterStream(int parameterIndex, java.io.Reader reader, long length)` This method is not supported and will always throw a SQLException.
`void` | `setClob(int parameterIndex, java.sql.Clob x)` This method is not supported and will always throw a SQLException.
`void` | `setClob(int parameterIndex, java.io.Reader reader)` This method is not supported and will always throw a SQLException.
`void` | `setClob(int parameterIndex, java.io.Reader reader, long length)` This method is not supported and will always throw a SQLException.
`void` | `setDate(int parameterIndex, java.sql.Date x)`
`void` | `setDate(int parameterIndex, java.sql.Date x, java.util.Calendar cal)`
`void` | `setDouble(int parameterIndex, double x)`
`void` | `setFloat(int parameterIndex, float x)`
`void` | `setInt(int parameterIndex, int x)`
`void` | `setLong(int parameterIndex, long x)`
`void` | `setNCharacterStream(int parameterIndex, java.io.Reader value)` This method is not supported and will always throw a SQLException.
`void` | `setNCharacterStream(int parameterIndex, java.io.Reader value, long length)` This method is not supported and will always throw a SQLException.
`void` | `setNClob(int parameterIndex, java.sql.NClob value)` This method is not supported and will always throw a SQLException.
`void` | `setNClob(int parameterIndex, java.io.Reader reader)` This method is not supported and will always throw a SQLException.
`void` | `setNClob(int parameterIndex, java.io.Reader reader, long length)` This method is not supported and will always throw a SQLException.
`void` | `setNString(int parameterIndex, java.lang.String value)` This method is not supported and will always throw a SQLException.
`void` | `setNull(int parameterIndex, int sqlType)`
`void` | `setNull(int parameterIndex, int sqlType, java.lang.String x)` This method is not supported and will always throw a SQLException.
`void` | `setObject(int parameterIndex, java.lang.Object x)`
`void` | `setObject(int parameterIndex, java.lang.Object x, int sqlType)`
`void` | `setObject(int parameterIndex, java.lang.Object x, int sqlType, int scale)`
`void` | `setRef(int parameterIndex, java.sql.Ref x)` This method is not supported and will always throw a SQLException.
`void` | `setRowId(int parameterIndex, java.sql.RowId x)` This method is not supported and will always throw a SQLException.
`void` | `setShort(int parameterIndex, short x)` Sets a parameter to a Java short value.
`void` | `setSQLXML(int parameterIndex, java.sql.SQLXML xmlObject)` This method is not supported and will always throw a SQLException.
`void` | `setString(int parameterIndex, java.lang.String x)`
`void` | `setTime(int parameterIndex, java.sql.Time x)`
`void` | `setTime(int parameterIndex, java.sql.Time x, java.util.Calendar cal)`
`void` | `setTimestamp(int parameterIndex, java.sql.Timestamp x)`
`void` | `setTimestamp(int parameterIndex, java.sql.Timestamp x, java.util.Calendar cal)`
`void` | `setUnicodeStream(int parameterIndex, java.io.InputStream x, int length)` Deprecated.
`void` | `setURL(int parameterIndex, java.net.URL x)` This method is not supported and will always throw a SQLException.

Methods inherited from class com.sas.net.sharenet.ShareNetStatement
`addBatch, addWarning, cancel, clearBatch, clearWarnings, close, closeOnCompletion, describe, destroy, execute, execute, execute, execute, executeBatch, executeQuery, executeUpdate, executeUpdate, executeUpdate, executeUpdate, fieldFormat, fieldNames, fieldType, finalize, findFirstString, getAns, getConnection, getFetchDirection, getFetchSize, getGeneratedKeys, getMaxFieldSize, getMaxRows, getMoreResults, getMoreResults, getQueryTimeout, getResultSet, getResultSetConcurrency, getResultSetHoldability, getResultSetType, getUpdateCount, getVars, getWarnings, isClosed, isCloseOnCompletion, isDescribe, isPoolable, isWrapperFor, numFields, prepare, prepareDescribe, setCursorName, setDescribe, setEscapeProcessing, setFetchDirection, setFetchSize, setMaxFieldSize, setMaxRows, setPoolable, setQueryTimeout, setVars, unwrap`

Method Detail

### executeQuery

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

  Specified by:
    `executeQuery` in interface `java.sql.PreparedStatement`
  Throws:
    `java.sql.SQLException`

### executeUpdate

    public int executeUpdate()
                      throws java.sql.SQLException

  Specified by:
    `executeUpdate` in interface `java.sql.PreparedStatement`
  Throws:
    `java.sql.SQLException`

### setNull

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

  Specified by:
    `setNull` in interface `java.sql.PreparedStatement`
  Throws:
    `java.sql.SQLException`

### setBoolean

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

  Sets a parameter to a Java Boolean value. This method is not supported.

  Specified by:
    `setBoolean` in interface `java.sql.PreparedStatement`
  Throws:
    `java.sql.SQLException` - This exception is always thrown because SAS software does not support the SQL type BIT.

### setByte

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

  Sets a parameter to a Java byte value. This method is not supported.

  Specified by:
    `setByte` in interface `java.sql.PreparedStatement`
  Throws:
    `java.sql.SQLException` - This exception is always thrown because SAS software does not support SQL type TINYINT.

### setShort

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

  Sets a parameter to a Java short value. This method is not supported.

  Specified by:
    `setShort` in interface `java.sql.PreparedStatement`
  Throws:
    `java.sql.SQLException` - This exception is always thrown because SAS software does not support SQL type SMALLINT.

### setInt

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

  Specified by:
    `setInt` in interface `java.sql.PreparedStatement`
  Throws:
    `java.sql.SQLException`

### setLong

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

  Specified by:
    `setLong` in interface `java.sql.PreparedStatement`
  Throws:
    `java.sql.SQLException`

### setFloat

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

  Specified by:
    `setFloat` in interface `java.sql.PreparedStatement`
  Throws:
    `java.sql.SQLException`

### setDouble

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

  Specified by:
    `setDouble` in interface `java.sql.PreparedStatement`
  Throws:
    `java.sql.SQLException`

### setBigDecimal

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

  Specified by:
    `setBigDecimal` in interface `java.sql.PreparedStatement`
  Throws:
    `java.sql.SQLException`

### setString

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

  Specified by:
    `setString` in interface `java.sql.PreparedStatement`
  Throws:
    `java.sql.SQLException`

### setBytes

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

  Specified by:
    `setBytes` in interface `java.sql.PreparedStatement`
  Throws:
    `java.sql.SQLException`

### setDate

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

  Specified by:
    `setDate` in interface `java.sql.PreparedStatement`
  Throws:
    `java.sql.SQLException`

### setTime

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

  Specified by:
    `setTime` in interface `java.sql.PreparedStatement`
  Throws:
    `java.sql.SQLException`

### setTimestamp

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

  Specified by:
    `setTimestamp` in interface `java.sql.PreparedStatement`
  Throws:
    `java.sql.SQLException`

### setAsciiStream

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

  Specified by:
    `setAsciiStream` in interface `java.sql.PreparedStatement`
  Throws:
    `java.sql.SQLException`

### setUnicodeStream

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

  Deprecated.

  Specified by:
    `setUnicodeStream` in interface `java.sql.PreparedStatement`
  Throws:
    `java.sql.SQLException`

### setBinaryStream

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

  Specified by:
    `setBinaryStream` in interface `java.sql.PreparedStatement`
  Throws:
    `java.sql.SQLException`

### clearParameters

    public void clearParameters()
                         throws java.sql.SQLException

  Specified by:
    `clearParameters` in interface `java.sql.PreparedStatement`
  Throws:
    `java.sql.SQLException`

### setObject

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

  Specified by:
    `setObject` in interface `java.sql.PreparedStatement`
  Throws:
    `java.sql.SQLException`

### setObject

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

  Specified by:
    `setObject` in interface `java.sql.PreparedStatement`
  Throws:
    `java.sql.SQLException`

### setObject

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

  Specified by:
    `setObject` in interface `java.sql.PreparedStatement`
  Throws:
    `java.sql.SQLException`

### execute

    public boolean execute()
                    throws java.sql.SQLException

  Specified by:
    `execute` in interface `java.sql.PreparedStatement`
  Throws:
    `java.sql.SQLException`

### getResultSetMetaData

    @Deprecated
    public java.sql.ResultSetMetaData getResultSetMetaData()
                                                    throws java.sql.SQLException

  Deprecated.

  deprecated, use #getMetaData instead

  Throws:
    `java.sql.SQLException`

### addBatch

    public void addBatch()
                  throws java.sql.SQLException

  This method is not supported and will always throw a SQLException.

  Specified by:
    `addBatch` in interface `java.sql.PreparedStatement`
  Throws:
    `java.sql.SQLException`

### setCharacterStream

    public void setCharacterStream(int parameterIndex,
                                   java.io.Reader reader,
                                   int length)
                            throws java.sql.SQLException

  This method is not supported and will always throw a SQLException.

  Specified by:
    `setCharacterStream` in interface `java.sql.PreparedStatement`
  Throws:
    `java.sql.SQLException`

### setRef

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

  This method is not supported and will always throw a SQLException.

  Specified by:
    `setRef` in interface `java.sql.PreparedStatement`
  Throws:
    `java.sql.SQLException`

### setBlob

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

  This method is not supported and will always throw a SQLException.

  Specified by:
    `setBlob` in interface `java.sql.PreparedStatement`
  Throws:
    `java.sql.SQLException`

### setClob

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

  This method is not supported and will always throw a SQLException.

  Specified by:
    `setClob` in interface `java.sql.PreparedStatement`
  Throws:
    `java.sql.SQLException`

### setArray

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

  This method is not supported and will always throw a SQLException.

  Specified by:
    `setArray` in interface `java.sql.PreparedStatement`
  Throws:
    `java.sql.SQLException`

### getMetaData

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

  Specified by:
    `getMetaData` in interface `java.sql.PreparedStatement`
  Throws:
    `java.sql.SQLException`

### setDate

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

  Specified by:
    `setDate` in interface `java.sql.PreparedStatement`
  Throws:
    `java.sql.SQLException`

### setTime

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

  Specified by:
    `setTime` in interface `java.sql.PreparedStatement`
  Throws:
    `java.sql.SQLException`

### setTimestamp

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

  Specified by:
    `setTimestamp` in interface `java.sql.PreparedStatement`
  Throws:
    `java.sql.SQLException`

### setNull

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

  This method is not supported and will always throw a SQLException.

  Specified by:
    `setNull` in interface `java.sql.PreparedStatement`
  Throws:
    `java.sql.SQLException`

### setURL

    public void setURL(int parameterIndex,
                       java.net.URL x)
                throws java.sql.SQLException

  This method is not supported and will always throw a SQLException.

  Specified by:
    `setURL` in interface `java.sql.PreparedStatement`
  Throws:
    `java.sql.SQLException`

### getParameterMetaData

    public java.sql.ParameterMetaData getParameterMetaData()
                                                    throws java.sql.SQLException

  This method is not supported and will always throw a SQLException.

  Specified by:
    `getParameterMetaData` in interface `java.sql.PreparedStatement`
  Throws:
    `java.sql.SQLException`

### setRowId

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

  This method is not supported and will always throw a SQLException.

  Specified by:
    `setRowId` in interface `java.sql.PreparedStatement`
  Throws:
    `java.sql.SQLException`

### setNString

    public void setNString(int parameterIndex,
                           java.lang.String value)
                    throws java.sql.SQLException

  This method is not supported and will always throw a SQLException.

  Specified by:
    `setNString` in interface `java.sql.PreparedStatement`
  Throws:
    `java.sql.SQLException`

### setNCharacterStream

    public void setNCharacterStream(int parameterIndex,
                                    java.io.Reader value,
                                    long length)
                             throws java.sql.SQLException

  This method is not supported and will always throw a SQLException.

  Specified by:
    `setNCharacterStream` in interface `java.sql.PreparedStatement`
  Throws:
    `java.sql.SQLException`

### setNClob

    public void setNClob(int parameterIndex,
                         java.sql.NClob value)
                  throws java.sql.SQLException

  This method is not supported and will always throw a SQLException.

  Specified by:
    `setNClob` in interface `java.sql.PreparedStatement`
  Throws:
    `java.sql.SQLException`

### setClob

    public void setClob(int parameterIndex,
                        java.io.Reader reader,
                        long length)
                 throws java.sql.SQLException

  This method is not supported and will always throw a SQLException.

  Specified by:
    `setClob` in interface `java.sql.PreparedStatement`
  Throws:
    `java.sql.SQLException`

### setBlob

    public void setBlob(int parameterIndex,
                        java.io.InputStream inputStream,
                        long length)
                 throws java.sql.SQLException

  This method is not supported and will always throw a SQLException.

  Specified by:
    `setBlob` in interface `java.sql.PreparedStatement`
  Throws:
    `java.sql.SQLException`

### setNClob

    public void setNClob(int parameterIndex,
                         java.io.Reader reader,
                         long length)
                  throws java.sql.SQLException

  This method is not supported and will always throw a SQLException.

  Specified by:
    `setNClob` in interface `java.sql.PreparedStatement`
  Throws:
    `java.sql.SQLException`

### setSQLXML

    public void setSQLXML(int parameterIndex,
                          java.sql.SQLXML xmlObject)
                   throws java.sql.SQLException

  This method is not supported and will always throw a SQLException.

  Specified by:
    `setSQLXML` in interface `java.sql.PreparedStatement`
  Throws:
    `java.sql.SQLException`

### setAsciiStream

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

  This method is not supported and will always throw a SQLException.

  Specified by:
    `setAsciiStream` in interface `java.sql.PreparedStatement`
  Throws:
    `java.sql.SQLException`

### setBinaryStream

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

  This method is not supported and will always throw a SQLException.

  Specified by:
    `setBinaryStream` in interface `java.sql.PreparedStatement`
  Throws:
    `java.sql.SQLException`

### setCharacterStream

    public void setCharacterStream(int parameterIndex,
                                   java.io.Reader reader,
                                   long length)
                            throws java.sql.SQLException

  This method is not supported and will always throw a SQLException.

  Specified by:
    `setCharacterStream` in interface `java.sql.PreparedStatement`
  Throws:
    `java.sql.SQLException`

### setAsciiStream

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

  This method is not supported and will always throw a SQLException.

  Specified by:
    `setAsciiStream` in interface `java.sql.PreparedStatement`
  Throws:
    `java.sql.SQLException`

### setBinaryStream

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

  This method is not supported and will always throw a SQLException.

  Specified by:
    `setBinaryStream` in interface `java.sql.PreparedStatement`
  Throws:
    `java.sql.SQLException`

### setCharacterStream

    public void setCharacterStream(int parameterIndex,
                                   java.io.Reader reader)
                            throws java.sql.SQLException

  This method is not supported and will always throw a SQLException.

  Specified by:
    `setCharacterStream` in interface `java.sql.PreparedStatement`
  Throws:
    `java.sql.SQLException`

### setNCharacterStream

    public void setNCharacterStream(int parameterIndex,
                                    java.io.Reader value)
                             throws java.sql.SQLException

  This method is not supported and will always throw a SQLException.

  Specified by:
    `setNCharacterStream` in interface `java.sql.PreparedStatement`
  Throws:
    `java.sql.SQLException`

### setClob

    public void setClob(int parameterIndex,
                        java.io.Reader reader)
                 throws java.sql.SQLException

  This method is not supported and will always throw a SQLException.

  Specified by:
    `setClob` in interface `java.sql.PreparedStatement`
  Throws:
    `java.sql.SQLException`

### setBlob

    public void setBlob(int parameterIndex,
                        java.io.InputStream inputStream)
                 throws java.sql.SQLException

  This method is not supported and will always throw a SQLException.

  Specified by:
    `setBlob` in interface `java.sql.PreparedStatement`
  Throws:
    `java.sql.SQLException`

### setNClob

    public void setNClob(int parameterIndex,
                         java.io.Reader reader)
                  throws java.sql.SQLException

  This method is not supported and will always throw a SQLException.

  Specified by:
    `setNClob` in interface `java.sql.PreparedStatement`
  Throws:
    `java.sql.SQLException`

All Libraries | This Library | Package | Class | Use | Tree | Deprecated | Index | Grand Index | Help
|  | Components |
PREV CLASS NEXT CLASS | FRAMES NO FRAMES
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD

Copyright © 2009 SAS Institute Inc. All Rights Reserved.