Java Doc for PreparedStatement.java in  » Database-DBMS » db-derby-10.2 » org » apache » derby » client » am » Java Source Code / Java DocumentationJava Source Code and Java Documentation

Java Source Code / Java Documentation 1.  6.0 JDK Core 2.  6.0 JDK Modules 3.  6.0 JDK Modules com.sun 4.  6.0 JDK Modules com.sun.java 5.  6.0 JDK Modules sun 6.  6.0 JDK Platform 7.  Ajax 8.  Apache Harmony Java SE 9.  Aspect oriented 10.  Authentication Authorization 11.  Blogger System 12.  Build 13.  Byte Code 14.  Cache 15.  Chart 16.  Chat 17.  Code Analyzer 18.  Collaboration 19.  Content Management System 20.  Database Client 21.  Database DBMS 22.  Database JDBC Connection Pool 23.  Database ORM 24.  Development 25.  EJB Server geronimo 26.  EJB Server GlassFish 27.  EJB Server JBoss 4.2.1 28.  EJB Server resin 3.1.5 29.  ERP CRM Financial 30.  ESB 31.  Forum 32.  GIS 33.  Graphic Library 34.  Groupware 35.  HTML Parser 36.  IDE 37.  IDE Eclipse 38.  IDE Netbeans 39.  Installer 40.  Internationalization Localization 41.  Inversion of Control 42.  Issue Tracking 43.  J2EE 44.  JBoss 45.  JMS 46.  JMX 47.  Library 48.  Mail Clients 49.  Net 50.  Parser 51.  PDF 52.  Portal 53.  Profiler 54.  Project Management 55.  Report 56.  RSS RDF 57.  Rule Engine 58.  Science 59.  Scripting 60.  Search Engine 61.  Security 62.  Sevlet Container 63.  Source Control 64.  Swing Library 65.  Template Engine 66.  Test Coverage 67.  Testing 68.  UML 69.  Web Crawler 70.  Web Framework 71.  Web Mail 72.  Web Server 73.  Web Services 74.  Web Services apache cxf 2.0.1 75.  Web Services AXIS2 76.  Wiki Engine 77.  Workflow Engines 78.  XML 79.  XML UI Java Java Tutorial Java Open Source Jar File Download Java Articles Java Products Java by API Photoshop Tutorials Maya Tutorials Flash Tutorials 3ds-Max Tutorials Illustrator Tutorials GIMP Tutorials C# / C Sharp C# / CSharp Tutorial C# / CSharp Open Source ASP.Net ASP.NET Tutorial JavaScript DHTML JavaScript Tutorial JavaScript Reference HTML / CSS HTML CSS Reference C / ANSI-C C Tutorial C++ C++ Tutorial Ruby PHP Python Python Tutorial Python Open Source SQL Server / T-SQL SQL Server / T-SQL Tutorial Oracle PL / SQL Oracle PL/SQL Tutorial PostgreSQL SQL / MySQL MySQL Tutorial VB.Net VB.Net Tutorial Flash / Flex / ActionScript VBA / Excel / Access / Word XML XML Tutorial Microsoft Office PowerPoint 2007 Tutorial Microsoft Office Excel 2007 Tutorial Microsoft Office Word 2007 Tutorial

Java Source Code / Java Documentation » Database DBMS » db derby 10.2 » org.apache.derby.client.am   Source Cross Reference   Class Diagram   Java Document (Java Doc)   java.lang.Object    org.apache.derby.client.am.Statement       org.apache.derby.client.am.PreparedStatement All known Subclasses:   org.apache.derby.client.am.PreparedStatement40,  org.apache.derby.client.am.CallableStatement, PreparedStatement public class PreparedStatement extends Statement implements java.sql.PreparedStatement,PreparedStatementCallbackInterface(Code) Field Summary  boolean listenToUnitOfWork_      public  MaterialPreparedStatement materialPreparedStatement_      public  boolean outputRegistered_      public  ColumnMetaData parameterMetaData_       boolean[] parameterRegistered_       boolean[] parameterSet_      public  Object[] parameters_      final protected  ClientPooledConnection pooledConnection_       String positionedUpdateCursorName_      public  String sql_      Constructor Summary public   PreparedStatement(Agent agent, Connection connection, String sql, Section section, ClientPooledConnection cpc)      The PreparedStatement constructor used for JDBC 2 positioned update statements. public   PreparedStatement(Agent agent, Connection connection, String sql, int type, int concurrency, int holdability, int autoGeneratedKeys, String[] columnNames, ClientPooledConnection cpc)      The PreparedStatementConstructor used for jdbc 2 prepared statements with scroll attributes. Method Summary public  void addBatch()       void checkForValidParameterIndex(int parameterIndex)       void checkForValidScale(int scale)       void checkScaleForINOUTDecimal(int parameterIndex, int registerOutScale)      public  void clearParameters()      public  void completeDescribeInput(ColumnMetaData parameterMetaData, Sqlca sqlca)      public  void completeDescribeOutput(ColumnMetaData resultSetMetaData, Sqlca sqlca)      public  void completeLocalCommit(java.util.Iterator listenerIterator)      public  void completeLocalRollback(java.util.Iterator listenerIterator)       void completePrepareDescribe()      public  boolean execute(String sql)      public  boolean execute()      public  boolean execute(String sql, int autoGeneratedKeys)      public  boolean execute(String sql, String[] columnNames)      public  boolean execute(String sql, int[] columnIndexes)      public  int[] executeBatch()      public  int[] executeBatchX(boolean supportsQueryBatchRequest)      public  java.sql.ResultSet executeQuery(String sql)      public  java.sql.ResultSet executeQuery()       ResultSet executeQueryX()      public  int executeUpdate(String sql)      public  int executeUpdate()      public  int executeUpdate(String sql, int autoGeneratedKeys)      public  int executeUpdate(String sql, String[] columnNames)      public  int executeUpdate(String sql, int[] columnIndexes)       boolean executeX()       void flowExecute(int executeType)       void flowPrepareDescribeInputOutput()       void flowPrepareForSelectFromInsert()      protected  String getJdbcStatementInterfaceName()      Returns the name of the java.sql interface implemented by this class. public  java.sql.ResultSetMetaData getMetaData()      public  java.sql.ParameterMetaData getParameterMetaData()      protected  void initResetPreparedStatement()      public  void listenToUnitOfWork()      protected  void markClosed(boolean removeListener)       void prepare()      public  void readDescribeInput()      public  void readDescribeOutput()      public  void readExecute()       void readPrepareDescribeInput()       void readPrepareDescribeInputOutput()      public  void reset(boolean fullReset)      public  void resetPreparedStatement(Agent agent, Connection connection, String sql, Section section)      public  void resetPreparedStatement(Agent agent, Connection connection, String sql, int type, int concurrency, int holdability, int autoGeneratedKeys, String[] columnNames)      public  void resetPreparedStatement(Agent agent, Connection connection, String sql, Section section, ColumnMetaData parameterMetaData, ColumnMetaData resultSetMetaData)      public  void setArray(int parameterIndex, java.sql.Array x)      public  void setAsciiStream(int parameterIndex, java.io.InputStream x, long length)      We do this inefficiently and read it all in here. public  void setAsciiStream(int parameterIndex, java.io.InputStream x, int length)      We do this inefficiently and read it all in here. public  void setAsciiStream(int parameterIndex, InputStream x)      Sets the designated parameter to the given input stream. When a very large ASCII value is input to a LONGVARCHAR parameter, it may be more practical to send it via a java.io.InputStream. public  void setBigDecimal(int parameterIndex, java.math.BigDecimal x)      public  void setBinaryStream(int parameterIndex, java.io.InputStream x, long length)      public  void setBinaryStream(int parameterIndex, java.io.InputStream x, int length)      public  void setBinaryStream(int parameterIndex, InputStream x)      Sets the designated parameter to the given input stream. When a very large binary value is input to a LONGVARBINARY parameter, it may be more practical to send it via a java.io.InputStream object. protected  void setBinaryStreamX(int parameterIndex, java.io.InputStream x, int length)      public  void setBlob(int parameterIndex, java.sql.Blob x)      public  void setBlob(int parameterIndex, InputStream inputStream)      Sets the designated parameter to a InputStream object. This method differs from the setBinaryStream(int, InputStream) method because it informs the driver that the parameter value should be sent to the server as a BLOB. public  void setBlob(int parameterIndex, InputStream inputStream, long length)      Sets the designated parameter to a InputStream object. public  void setBlobX(int parameterIndex, java.sql.Blob x)      public  void setBoolean(int parameterIndex, boolean x)      public  void setByte(int parameterIndex, byte x)      public  void setBytes(int parameterIndex, byte[] x)      public  void setBytesX(int parameterIndex, byte[] x)      public  void setCharacterStream(int parameterIndex, Reader x)      Sets the designated parameter to the given Reader object. When a very large UNICODE value is input to a LONGVARCHAR parameter, it may be more practical to send it via a java.io.Reader object. public  void setCharacterStream(int parameterIndex, java.io.Reader x, long length)      Sets the designated parameter to the given Reader, which will have the specified number of bytes. public  void setCharacterStream(int parameterIndex, java.io.Reader x, int length)      Sets the designated parameter to the given Reader, which will have the specified number of bytes. public  void setClob(int parameterIndex, java.sql.Clob x)      public  void setClob(int parameterIndex, Reader reader)      Sets the designated parameter to a Reader object. Parameters:   parameterIndex - index of the first parameter is 1, the second is 2, ... Parameters:   reader - an object that contains the data to set the parametervalue to. public  void setClob(int parameterIndex, Reader reader, long length)      Sets the designated parameter to a Reader object.  void setClobX(int parameterIndex, java.sql.Clob x)      public  void setDate(int parameterIndex, java.sql.Date x)      public  void setDate(int parameterIndex, java.sql.Date x, java.util.Calendar calendar)      public  void setDouble(int parameterIndex, double x)      public  void setFloat(int parameterIndex, float x)       void setInput(int parameterIndex, Object input)      public  void setInt(int parameterIndex, int x)       void setIntX(int parameterIndex, int x)      public  void setLong(int parameterIndex, long x)      public  void setNull(int parameterIndex, int jdbcType)      public  void setNull(int parameterIndex, int jdbcType, String typeName)       void setNullX(int parameterIndex, int jdbcType)      public  void setObject(int parameterIndex, Object x)      public  void setObject(int parameterIndex, Object x, int targetJdbcType)      public  void setObject(int parameterIndex, Object x, int targetJdbcType, int scale)      public  void setRef(int parameterIndex, java.sql.Ref x)      public  void setShort(int parameterIndex, short x)       void setShortX(int parameterIndex, short x)      public  void setString(int parameterIndex, String x)       void setStringX(int parameterIndex, String x)      public  void setTime(int parameterIndex, java.sql.Time x)      public  void setTime(int parameterIndex, java.sql.Time x, java.util.Calendar calendar)      public  void setTimestamp(int parameterIndex, java.sql.Timestamp x)      public  void setTimestamp(int parameterIndex, java.sql.Timestamp x, java.util.Calendar calendar)      public  void setURL(int parameterIndex, java.net.URL x)      public  void setUnicodeStream(int parameterIndex, java.io.InputStream x, int length)      Sets the specified parameter to the given input stream. public  void writeDescribeInput(Section section)      public  void writeDescribeOutput(Section section)      public  void writeExecute(Section section, ColumnMetaData parameterMetaData, Object[] inputs, int numInputColumns, boolean outputExpected, boolean chainedWritesFollowingSetLob)      public  void writeOpenQuery(Section section, int fetchSize, int resultSetType, int numInputColumns, ColumnMetaData parameterMetaData, Object[] inputs)       void writePrepareDescribeInput()       void writePrepareDescribeInputOutput()       void writePrepareDescribeInputOutput(String sql, Section section)      Field Detail listenToUnitOfWork_ boolean listenToUnitOfWork_(Code) materialPreparedStatement_ public MaterialPreparedStatement materialPreparedStatement_(Code) outputRegistered_ public boolean outputRegistered_(Code) parameterMetaData_ public ColumnMetaData parameterMetaData_(Code) parameterRegistered_ boolean[] parameterRegistered_(Code) parameterSet_ boolean[] parameterSet_(Code) parameters_ public Object[] parameters_(Code) pooledConnection_ final protected ClientPooledConnection pooledConnection_(Code) positionedUpdateCursorName_ String positionedUpdateCursorName_(Code) sql_ public String sql_(Code) Constructor Detail PreparedStatement public PreparedStatement(Agent agent, Connection connection, String sql, Section section, ClientPooledConnection cpc) throws SqlException(Code) The PreparedStatement constructor used for JDBC 2 positioned update statements. Called by material statement constructors. It has the ClientPooledConnection as one of its parameters this is used to raise the Statement Events when the prepared statement is closed Parameters:   agent - The instance of NetAgent associated with thisCallableStatement object. Parameters:   connection - The connection object associated with thisPreparedStatement Object. Parameters:   sql - A String object that is the SQL statement to be sentto the database. Parameters:   section - Section Parameters:   cpc - The ClientPooledConnection wraps the underlying physicalconnection associated with this prepared statement.It is used to pass the Statement closed and the Statementerror occurred events that occur back to theClientPooledConnection. throws:   SqlException - PreparedStatement public PreparedStatement(Agent agent, Connection connection, String sql, int type, int concurrency, int holdability, int autoGeneratedKeys, String[] columnNames, ClientPooledConnection cpc) throws SqlException(Code) The PreparedStatementConstructor used for jdbc 2 prepared statements with scroll attributes. Called by material statement constructors. It has the ClientPooledConnection as one of its parameters this is used to raise the Statement Events when the prepared statement is closed Parameters:   agent - The instance of NetAgent associated with thisCallableStatement object. Parameters:   connection - The connection object associated with thisPreparedStatement Object. Parameters:   sql - A String object that is the SQL statementto be sent to the database. Parameters:   type - One of the ResultSet type constants. Parameters:   concurrency - One of the ResultSet concurrency constants. Parameters:   holdability - One of the ResultSet holdability constants. Parameters:   autoGeneratedKeys - a flag indicating whether auto-generatedkeys should be returned. Parameters:   columnNames - an array of column names indicating the columns thatshould be returned from the inserted row or rows. Parameters:   cpc - The ClientPooledConnection wraps the underlying physicalconnection associated with this prepared statementit is used to pass the Statement closed and the Statementerror occurred events that occur back to theClientPooledConnection. throws:   SqlException - Method Detail addBatch public void addBatch() throws SQLException(Code) checkForValidParameterIndex void checkForValidParameterIndex(int parameterIndex) throws SqlException(Code) checkForValidScale void checkForValidScale(int scale) throws SqlException(Code) checkScaleForINOUTDecimal void checkScaleForINOUTDecimal(int parameterIndex, int registerOutScale) throws SqlException(Code) clearParameters public void clearParameters() throws SQLException(Code) completeDescribeInput public void completeDescribeInput(ColumnMetaData parameterMetaData, Sqlca sqlca)(Code) completeDescribeOutput public void completeDescribeOutput(ColumnMetaData resultSetMetaData, Sqlca sqlca)(Code) completeLocalCommit public void completeLocalCommit(java.util.Iterator listenerIterator)(Code) completeLocalRollback public void completeLocalRollback(java.util.Iterator listenerIterator)(Code) completePrepareDescribe void completePrepareDescribe()(Code) execute public boolean execute(String sql) throws SQLException(Code) execute public boolean execute() throws SQLException(Code) execute public boolean execute(String sql, int autoGeneratedKeys) throws SQLException(Code) execute public boolean execute(String sql, String[] columnNames) throws SQLException(Code) execute public boolean execute(String sql, int[] columnIndexes) throws SQLException(Code) executeBatch public int[] executeBatch() throws SQLException, BatchUpdateException(Code) executeBatchX public int[] executeBatchX(boolean supportsQueryBatchRequest) throws SqlException, SQLException, BatchUpdateException(Code) executeQuery public java.sql.ResultSet executeQuery(String sql) throws SQLException(Code) executeQuery public java.sql.ResultSet executeQuery() throws SQLException(Code) executeQueryX ResultSet executeQueryX() throws SqlException(Code) executeUpdate public int executeUpdate(String sql) throws SQLException(Code) executeUpdate public int executeUpdate() throws SQLException(Code) executeUpdate public int executeUpdate(String sql, int autoGeneratedKeys) throws SQLException(Code) executeUpdate public int executeUpdate(String sql, String[] columnNames) throws SQLException(Code) executeUpdate public int executeUpdate(String sql, int[] columnIndexes) throws SQLException(Code) executeX boolean executeX() throws SqlException(Code) flowExecute void flowExecute(int executeType) throws SqlException(Code) flowPrepareDescribeInputOutput void flowPrepareDescribeInputOutput() throws SqlException(Code) flowPrepareForSelectFromInsert void flowPrepareForSelectFromInsert() throws SqlException(Code) getJdbcStatementInterfaceName protected String getJdbcStatementInterfaceName()(Code) Returns the name of the java.sql interface implemented by this class. name of java.sql interface getMetaData public java.sql.ResultSetMetaData getMetaData() throws SQLException(Code) getParameterMetaData public java.sql.ParameterMetaData getParameterMetaData() throws SQLException(Code) initResetPreparedStatement protected void initResetPreparedStatement()(Code) listenToUnitOfWork public void listenToUnitOfWork()(Code) markClosed protected void markClosed(boolean removeListener)(Code) prepare void prepare() throws SqlException(Code) readDescribeInput public void readDescribeInput() throws SqlException(Code) readDescribeOutput public void readDescribeOutput() throws SqlException(Code) readExecute public void readExecute() throws SqlException(Code) readPrepareDescribeInput void readPrepareDescribeInput() throws SqlException(Code) readPrepareDescribeInputOutput void readPrepareDescribeInputOutput() throws SqlException(Code) reset public void reset(boolean fullReset) throws SqlException(Code) resetPreparedStatement public void resetPreparedStatement(Agent agent, Connection connection, String sql, Section section) throws SqlException(Code) resetPreparedStatement public void resetPreparedStatement(Agent agent, Connection connection, String sql, int type, int concurrency, int holdability, int autoGeneratedKeys, String[] columnNames) throws SqlException(Code) resetPreparedStatement public void resetPreparedStatement(Agent agent, Connection connection, String sql, Section section, ColumnMetaData parameterMetaData, ColumnMetaData resultSetMetaData) throws SqlException(Code) setArray public void setArray(int parameterIndex, java.sql.Array x) throws SQLException(Code) setAsciiStream public void setAsciiStream(int parameterIndex, java.io.InputStream x, long length) throws SQLException(Code) We do this inefficiently and read it all in here. The target type is assumed to be a String. Parameters:   parameterIndex - the first parameter is 1, the second is 2, ... Parameters:   x - the java input stream which contains the ASCII parameter value Parameters:   length - the number of bytes in the stream exception:   SQLException - thrown on failure. setAsciiStream public void setAsciiStream(int parameterIndex, java.io.InputStream x, int length) throws SQLException(Code) We do this inefficiently and read it all in here. The target type is assumed to be a String. Parameters:   parameterIndex - the first parameter is 1, the second is 2, ... Parameters:   x - the java input stream which contains the ASCII parameter value Parameters:   length - the number of bytes in the stream exception:   SQLException - thrown on failure. setAsciiStream public void setAsciiStream(int parameterIndex, InputStream x) throws SQLException(Code) Sets the designated parameter to the given input stream. When a very large ASCII value is input to a LONGVARCHAR parameter, it may be more practical to send it via a java.io.InputStream. Data will be read from the stream as needed until end-of-file is reached. The JDBC driver will do any necessary conversion from ASCII to the database char format. Parameters:   parameterIndex - the first parameter is 1, the second is 2, ... Parameters:   x - the Java input stream that contains the ASCII parameter value throws:   SQLException - if a database access error occurs or this method iscalled on a closed PreparedStatement setBigDecimal public void setBigDecimal(int parameterIndex, java.math.BigDecimal x) throws SQLException(Code) setBinaryStream public void setBinaryStream(int parameterIndex, java.io.InputStream x, long length) throws SQLException(Code) sets the parameter to the Binary Stream object Parameters:   parameterIndex - the first parameter is 1, the second is 2, ... Parameters:   x - the java input stream which contains the binary parameter value Parameters:   length - the number of bytes in the stream exception:   SQLException - thrown on failure. setBinaryStream public void setBinaryStream(int parameterIndex, java.io.InputStream x, int length) throws SQLException(Code) sets the parameter to the Binary Stream object Parameters:   parameterIndex - the first parameter is 1, the second is 2, ... Parameters:   x - the java input stream which contains the binary parameter value Parameters:   length - the number of bytes in the stream exception:   SQLException - thrown on failure. setBinaryStream public void setBinaryStream(int parameterIndex, InputStream x) throws SQLException(Code) Sets the designated parameter to the given input stream. When a very large binary value is input to a LONGVARBINARY parameter, it may be more practical to send it via a java.io.InputStream object. The data will be read from the stream as needed until end-of-file is reached. Parameters:   parameterIndex - the first parameter is 1, the second is 2, ... Parameters:   x - the java input stream which contains the binary parameter value throws:   SQLException - if a database access error occurs or this method iscalled on a closed PreparedStatement setBinaryStreamX protected void setBinaryStreamX(int parameterIndex, java.io.InputStream x, int length) throws SqlException(Code) setBlob public void setBlob(int parameterIndex, java.sql.Blob x) throws SQLException(Code) setBlob public void setBlob(int parameterIndex, InputStream inputStream) throws SQLException(Code) Sets the designated parameter to a InputStream object. This method differs from the setBinaryStream(int, InputStream) method because it informs the driver that the parameter value should be sent to the server as a BLOB. When the setBinaryStream method is used, the driver may have to do extra work to determine whether the parameter data should be sent to the server as a LONGVARBINARY or a BLOB Parameters:   parameterIndex - index of the first parameter is 1, the second is2, ... Parameters:   inputStream - an object that contains the data to set the parametervalue to. throws:   SQLException - if a database access error occurs, this method iscalled on a closed PreparedStatement or ifparameterIndex does not correspond to a parametermarker in the SQL statement setBlob public void setBlob(int parameterIndex, InputStream inputStream, long length) throws SQLException(Code) Sets the designated parameter to a InputStream object. Parameters:   parameterIndex - index of the first parameter is 1,the second is 2, ... Parameters:   inputStream - An object that contains the data to set the parametervalue to. Parameters:   length - the number of bytes in the parameter data. throws:   SQLException - if parameterIndex does not correspondto a parameter marker in the SQL statement, if the length specifiedis less than zero or if the number of bytes in the inputstream does not matchthe specfied length. setBlobX public void setBlobX(int parameterIndex, java.sql.Blob x) throws SqlException(Code) setBoolean public void setBoolean(int parameterIndex, boolean x) throws SQLException(Code) setByte public void setByte(int parameterIndex, byte x) throws SQLException(Code) setBytes public void setBytes(int parameterIndex, byte[] x) throws SQLException(Code) setBytesX public void setBytesX(int parameterIndex, byte[] x) throws SqlException(Code) setCharacterStream public void setCharacterStream(int parameterIndex, Reader x) throws SQLException(Code) Sets the designated parameter to the given Reader object. When a very large UNICODE value is input to a LONGVARCHAR parameter, it may be more practical to send it via a java.io.Reader object. The data will be read from the stream as needed until end-of-file is reached. The JDBC driver will do any necessary conversion from UNICODE to the database char format. Parameters:   parameterIndex - the first parameter is 1, the second is 2, ... Parameters:   x - the java.io.Reader object that contains theUnicode data throws:   SQLException - if a database access error occurs or this method iscalled on a closed PreparedStatement setCharacterStream public void setCharacterStream(int parameterIndex, java.io.Reader x, long length) throws SQLException(Code) Sets the designated parameter to the given Reader, which will have the specified number of bytes. Parameters:   parameterIndex - the index of the parameter to which this setmethod is applied Parameters:   x - the java Reader which contains the UNICODE value Parameters:   length - the number of bytes in the stream exception:   SQLException - thrown on failure. setCharacterStream public void setCharacterStream(int parameterIndex, java.io.Reader x, int length) throws SQLException(Code) Sets the designated parameter to the given Reader, which will have the specified number of bytes. Parameters:   parameterIndex - the index of the parameter to which thisset method is applied Parameters:   x - the java Reader which contains the UNICODE value Parameters:   length - the number of bytes in the stream exception:   SQLException - thrown on failure. setClob public void setClob(int parameterIndex, java.sql.Clob x) throws SQLException(Code) setClob public void setClob(int parameterIndex, Reader reader) throws SQLException(Code) Sets the designated parameter to a Reader object. Parameters:   parameterIndex - index of the first parameter is 1, the second is 2, ... Parameters:   reader - an object that contains the data to set the parametervalue to. throws:   SQLException - if parameterIndex does not correspond to a parameter marker in the SQL statement; if a database access erroroccurs; this method is called on a closed PreparedStatementor ifparameterIndex does not correspond to a parameter marker in the SQLstatement setClob public void setClob(int parameterIndex, Reader reader, long length) throws SQLException(Code) Sets the designated parameter to a Reader object. Parameters:   parameterIndex - index of the first parameter is 1, the second is 2, ... Parameters:   reader - An object that contains the data to set the parameter value to. Parameters:   length - the number of characters in the parameter data. throws:   SQLException - if parameterIndex does not correspond to a parametermarker in the SQL statement, or if the length specified is less than zero. setClobX void setClobX(int parameterIndex, java.sql.Clob x) throws SqlException(Code) setDate public void setDate(int parameterIndex, java.sql.Date x) throws SQLException(Code) setDate public void setDate(int parameterIndex, java.sql.Date x, java.util.Calendar calendar) throws SQLException(Code) setDouble public void setDouble(int parameterIndex, double x) throws SQLException(Code) setFloat public void setFloat(int parameterIndex, float x) throws SQLException(Code) setInput void setInput(int parameterIndex, Object input)(Code) setInt public void setInt(int parameterIndex, int x) throws SQLException(Code) setIntX void setIntX(int parameterIndex, int x) throws SqlException(Code) setLong public void setLong(int parameterIndex, long x) throws SQLException(Code) setNull public void setNull(int parameterIndex, int jdbcType) throws SQLException(Code) setNull public void setNull(int parameterIndex, int jdbcType, String typeName) throws SQLException(Code) setNullX void setNullX(int parameterIndex, int jdbcType) throws SqlException(Code) setObject public void setObject(int parameterIndex, Object x) throws SQLException(Code) setObject public void setObject(int parameterIndex, Object x, int targetJdbcType) throws SQLException(Code) setObject public void setObject(int parameterIndex, Object x, int targetJdbcType, int scale) throws SQLException(Code) setRef public void setRef(int parameterIndex, java.sql.Ref x) throws SQLException(Code) setShort public void setShort(int parameterIndex, short x) throws SQLException(Code) setShortX void setShortX(int parameterIndex, short x) throws SqlException(Code) setString public void setString(int parameterIndex, String x) throws SQLException(Code) setStringX void setStringX(int parameterIndex, String x) throws SqlException(Code) setTime public void setTime(int parameterIndex, java.sql.Time x) throws SQLException(Code) setTime public void setTime(int parameterIndex, java.sql.Time x, java.util.Calendar calendar) throws SQLException(Code) setTimestamp public void setTimestamp(int parameterIndex, java.sql.Timestamp x) throws SQLException(Code) setTimestamp public void setTimestamp(int parameterIndex, java.sql.Timestamp x, java.util.Calendar calendar) throws SQLException(Code) setURL public void setURL(int parameterIndex, java.net.URL x) throws SQLException(Code) setUnicodeStream public void setUnicodeStream(int parameterIndex, java.io.InputStream x, int length) throws SQLException(Code) Sets the specified parameter to the given input stream. Deprecated in JDBC 3.0 and this method will always just throw a feature not implemented exception. Parameters:   parameterIndex - the first parameter is 1, the second is 2, ... Parameters:   x - the java input stream which contains the UNICODE parametervalue Parameters:   length - the number of bytes in the stream exception:   SQLException - throws feature not implemented. writeDescribeInput public void writeDescribeInput(Section section) throws SqlException(Code) writeDescribeOutput public void writeDescribeOutput(Section section) throws SqlException(Code) writeExecute public void writeExecute(Section section, ColumnMetaData parameterMetaData, Object[] inputs, int numInputColumns, boolean outputExpected, boolean chainedWritesFollowingSetLob) throws SqlException(Code) writeOpenQuery public void writeOpenQuery(Section section, int fetchSize, int resultSetType, int numInputColumns, ColumnMetaData parameterMetaData, Object[] inputs) throws SqlException(Code) writePrepareDescribeInput void writePrepareDescribeInput() throws SqlException(Code) writePrepareDescribeInputOutput void writePrepareDescribeInputOutput() throws SqlException(Code) writePrepareDescribeInputOutput void writePrepareDescribeInputOutput(String sql, Section section) throws SqlException(Code) Fields inherited from org.apache.derby.client.am.Statement final public static int CLOSE_ALL_RESULTS(Code)(Java Doc) final public static int CLOSE_CURRENT_RESULT(Code)(Java Doc) final public static int KEEP_CURRENT_RESULT(Code)(Java Doc) final protected static String TIMEOUT_STATEMENT(Code)(Java Doc) public Agent agent_(Code)(Java Doc) public int autoGeneratedKeys_(Code)(Java Doc) java.util.ArrayList batch_(Code)(Java Doc) public Cursor cachedCursor_(Code)(Java Doc) public Cursor cachedSingletonRowData_(Code)(Java Doc) public Connection connection_(Code)(Java Doc) public String cursorAttributesToSendOnPrepare_(Code)(Java Doc) String cursorName_(Code)(Java Doc) public DatabaseMetaData databaseMetaData_(Code)(Java Doc) protected boolean doWriteTimeout(Code)(Java Doc) boolean escapedProcedureCallWithResult_(Code)(Java Doc) final static int executeMethod__(Code)(Java Doc) final static int executeQueryMethod__(Code)(Java Doc) final static int executeUpdateMethod__(Code)(Java Doc) public int fetchDirection_(Code)(Java Doc) public int fetchSize_(Code)(Java Doc) public String[] generatedKeysColumnNames_(Code)(Java Doc) public ResultSet generatedKeysResultSet_(Code)(Java Doc) protected int indexOfCurrentResultSet_(Code)(Java Doc) public boolean isAutoCommittableStatement_(Code)(Java Doc) final static int isCall__(Code)(Java Doc) public boolean isCallableStatement_(Code)(Java Doc) boolean isCatalogQuery_(Code)(Java Doc) final public static int isCommitSql__(Code)(Java Doc) final static int isDeleteSql__(Code)(Java Doc) final static int isInsertSql__(Code)(Java Doc) protected boolean isPoolable(Code)(Java Doc) final static int isPositionedUpdateDeleteSql__(Code)(Java Doc) public boolean isPreparedStatement_(Code)(Java Doc) final static int isQuery__(Code)(Java Doc) final public static int isRollbackSql__(Code)(Java Doc) final static int isUpdateSql__(Code)(Java Doc) final static int isUpdate__(Code)(Java Doc) public MaterialStatement materialStatement_(Code)(Java Doc) int maxFieldSize_(Code)(Java Doc) int maxRows_(Code)(Java Doc) public int numInvisibleRS_(Code)(Java Doc) boolean openOnClient_(Code)(Java Doc) boolean openOnServer_(Code)(Java Doc) public PreparedStatement preparedStatementForAutoGeneratedKeys_(Code)(Java Doc) public int resultSetConcurrency_(Code)(Java Doc) public int resultSetHoldability_(Code)(Java Doc) ResultSet[] resultSetList_(Code)(Java Doc) public ColumnMetaData resultSetMetaData_(Code)(Java Doc) public int resultSetType_(Code)(Java Doc) public ResultSet resultSet_(Code)(Java Doc) int returnValueFromProcedure_(Code)(Java Doc) public Section section_(Code)(Java Doc) public Cursor singletonRowData_(Code)(Java Doc) protected int sqlMode_(Code)(Java Doc) public int sqlUpdateMode_(Code)(Java Doc) protected java.util.ArrayList timeoutArrayList(Code)(Java Doc) int timeout_(Code)(Java Doc) int updateCount_(Code)(Java Doc) Methods inherited from org.apache.derby.client.am.Statement public void accumulateWarning(SqlWarning e)(Code)(Java Doc) public void addBatch(String sql) throws SQLException(Code)(Java Doc) String cacheCursorAttributesToSendOnPrepare() throws SqlException(Code)(Java Doc) public void cancel() throws SQLException(Code)(Java Doc) void checkAutoGeneratedKeysParameters() throws SqlException(Code)(Java Doc) void checkForAppropriateSqlMode(int executeType, int sqlMode) throws SqlException(Code)(Java Doc) void checkForClosedStatement() throws SqlException(Code)(Java Doc) protected void checkForDuplicateCursorName() throws SqlException(Code)(Java Doc) void checkForInvalidBatchedSql(String sql) throws SqlException(Code)(Java Doc) final protected void checkForStoredProcResultSetCount(int executeType) throws SqlException(Code)(Java Doc) public void clearBatch() throws SQLException(Code)(Java Doc) public void clearWarnings() throws SQLException(Code)(Java Doc) public void clearWarningsX()(Code)(Java Doc) public void close() throws SQLException(Code)(Java Doc) public void closeX() throws SqlException(Code)(Java Doc) public void completeExecute(Sqlca sqlca)(Code)(Java Doc) public void completeExecuteCall(Sqlca sqlca, Cursor singletonParams, ResultSet[] resultSets)(Code)(Java Doc) public void completeExecuteCall(Sqlca sqlca, Cursor singletonParams)(Code)(Java Doc) public void completeExecuteCallOpenQuery(Sqlca sqlca, ResultSet resultSet, ColumnMetaData resultSetMetaData, Section generatedSection)(Code)(Java Doc) public void completeExecuteImmediate(Sqlca sqlca)(Code)(Java Doc) public void completeExecuteSetStatement(Sqlca sqlca)(Code)(Java Doc) public void completeLocalCommit(java.util.Iterator listenerIterator)(Code)(Java Doc) public void completeLocalRollback(java.util.Iterator listenerIterator)(Code)(Java Doc) public void completeOpenQuery(Sqlca sqlca, ResultSet resultSet)(Code)(Java Doc) public void completePrepare(Sqlca sqlca)(Code)(Java Doc) public void completePrepareDescribeOutput(ColumnMetaData resultSetMetaData, Sqlca sqlca)(Code)(Java Doc) public int completeSqlca(Sqlca sqlca)(Code)(Java Doc) protected String constructSelectFromInsertSQL(String sql)(Code)(Java Doc) String escape(String sql) throws SqlException(Code)(Java Doc) public boolean execute(String sql) throws SQLException(Code)(Java Doc) public boolean execute(String sql, int autoGeneratedKeys) throws SQLException(Code)(Java Doc) public boolean execute(String sql, int columnIndexes) throws SQLException(Code)(Java Doc) public boolean execute(String sql, String columnNames) throws SQLException(Code)(Java Doc) public int[] executeBatch() throws SQLException, BatchUpdateException(Code)(Java Doc) public java.sql.ResultSet executeQuery(String sql) throws SQLException(Code)(Java Doc) public int executeUpdate(String sql) throws SQLException(Code)(Java Doc) public int executeUpdate(String sql, int autoGeneratedKeys) throws SQLException(Code)(Java Doc) public int executeUpdate(String sql, int columnIndexes) throws SQLException(Code)(Java Doc) public int executeUpdate(String sql, String columnNames) throws SQLException(Code)(Java Doc) boolean executeX(String sql) throws SqlException(Code)(Java Doc) String[] extractCursorNameFromWhereCurrentOf(String sql)(Code)(Java Doc) protected void finalize() throws java.lang.Throwable(Code)(Java Doc) void flowExecuteBatch(int[] updateCounts) throws SqlException, BatchUpdateException(Code)(Java Doc) public java.sql.Connection getConnection() throws SQLException(Code)(Java Doc) public ConnectionCallbackInterface getConnectionCallbackInterface()(Code)(Java Doc) public int getFetchDirection() throws SQLException(Code)(Java Doc) public int getFetchSize() throws SQLException(Code)(Java Doc) public java.sql.ResultSet getGeneratedKeys() throws SQLException(Code)(Java Doc) public ColumnMetaData getGuessedResultSetMetaData()(Code)(Java Doc) protected String getJdbcStatementInterfaceName()(Code)(Java Doc) public int getMaxFieldSize() throws SQLException(Code)(Java Doc) public int getMaxRows() throws SQLException(Code)(Java Doc) public boolean getMoreResults() throws SQLException(Code)(Java Doc) public boolean getMoreResults(int current) throws SQLException(Code)(Java Doc) void getPreparedStatementForAutoGeneratedKeys() throws SqlException(Code)(Java Doc) String getProcedureName(String sql) throws SqlException(Code)(Java Doc) public int getQueryTimeout() throws SQLException(Code)(Java Doc) public java.sql.ResultSet getResultSet() throws SQLException(Code)(Java Doc) public int getResultSetConcurrency() throws SQLException(Code)(Java Doc) public int getResultSetHoldability() throws SQLException(Code)(Java Doc) public int getResultSetType() throws SQLException(Code)(Java Doc) protected SqlWarning getSqlWarnings()(Code)(Java Doc) public int getUpdateCount() throws SQLException(Code)(Java Doc) public java.sql.SQLWarning getWarnings() throws SQLException(Code)(Java Doc) protected void initResetPreparedStatement()(Code)(Java Doc) public boolean isClosed() throws SQLException(Code)(Java Doc) public boolean isPoolable() throws SQLException(Code)(Java Doc) public boolean isQueryMode()(Code)(Java Doc) public boolean isWrapperFor(Class iface) throws SQLException(Code)(Java Doc) protected SQLException jdbc3FeatureNotSupported(boolean checkStatement) throws SQLException(Code)(Java Doc) protected SQLException jdbc3FeatureNotSupported() throws SQLException(Code)(Java Doc) public void listenToUnitOfWork()(Code)(Java Doc) void mapCursorNameToResultSet()(Code)(Java Doc) public void markAutoCommitted()(Code)(Java Doc) void markClosed()(Code)(Java Doc) void markClosed(boolean removeListener)(Code)(Java Doc) void markClosedOnServer()(Code)(Java Doc) void markPreparedStatementForAutoGeneratedKeysClosed()(Code)(Java Doc) void markResultSetsClosed()(Code)(Java Doc) void markResultSetsClosed(boolean removeListener)(Code)(Java Doc) void parseSqlAndSetSqlModes(String sql) throws SqlException(Code)(Java Doc) void parseStorProcReturnedScrollableRowset() throws SqlException(Code)(Java Doc) void prepareAutoGeneratedKeysStatement() throws SqlException(Code)(Java Doc) final void readClose(boolean allowAutoCommits) throws SqlException(Code)(Java Doc) void readCloseResultSets(boolean allowAutoCommits) throws SqlException(Code)(Java Doc) void readCloseResultSets(int number, boolean allowAutoCommits) throws SqlException(Code)(Java Doc) public void readExecuteCall() throws SqlException(Code)(Java Doc) public void readExecuteImmediate() throws SqlException(Code)(Java Doc) public void readExecuteImmediateForBatch(String sql) throws SqlException(Code)(Java Doc) public void readOpenQuery() throws SqlException(Code)(Java Doc) public void readPrepare() throws SqlException(Code)(Java Doc) void readPrepareAutoGeneratedKeysStatement() throws SqlException(Code)(Java Doc) public void readPrepareDescribeOutput() throws SqlException(Code)(Java Doc) public void readSetSpecialRegister() throws SqlException(Code)(Java Doc) protected void removeClientCursorNameFromCache()(Code)(Java Doc) public void reset(boolean fullReset) throws SqlException(Code)(Java Doc) void resetCursorNameAndRemoveFromWhereCurrentOfMappings()(Code)(Java Doc) public void resetStatement(Agent agent, Connection connection) throws SqlException(Code)(Java Doc) public void resetStatement(Agent agent, Connection connection, int type, int concurrency, int holdability, int autoGeneratedKeys, String[] columnNames) throws SqlException(Code)(Java Doc) public void resultSetCommitting(ResultSet closingRS) throws SqlException(Code)(Java Doc) public boolean resultSetCommitting(ResultSet closingRS, boolean writeChain) throws SqlException(Code)(Java Doc) public void setCursorName(String name) throws SQLException(Code)(Java Doc) public void setEscapeProcessing(boolean enable) throws SQLException(Code)(Java Doc) public void setFetchDirection(int direction) throws SQLException(Code)(Java Doc) public void setFetchSize(int rows) throws SQLException(Code)(Java Doc) public void setMaxFieldSize(int max) throws SQLException(Code)(Java Doc) public void setMaxRows(int maxRows) throws SQLException(Code)(Java Doc) public void setPoolable(boolean poolable) throws SQLException(Code)(Java Doc) public void setQueryTimeout(int seconds) throws SQLException(Code)(Java Doc) public void setUpdateCount(int updateCount)(Code)(Java Doc) protected void setupCursorNameCacheAndMappings()(Code)(Java Doc) protected String substituteClientCursorNameWithServerCursorName(String sql, Section section) throws SqlException(Code)(Java Doc) public static String upperCaseProcedureName(String procedureName) throws SqlException(Code)(Java Doc) final void writeClose(boolean allowAutoCommits) throws SqlException(Code)(Java Doc) boolean writeCloseResultSets(boolean allowAutoCommits) throws SqlException(Code)(Java Doc) boolean writeCloseResultSets(int number, boolean allowAutoCommits) throws SqlException(Code)(Java Doc) public void writeExecuteCall(boolean outputExpected, String procedureName, Section section, int fetchSize, boolean suppressResultSets, int resultSetType, ColumnMetaData parameterMetaData, Object[] inputs) throws SqlException(Code)(Java Doc) public void writeExecuteImmediate(String sql, Section section) throws SqlException(Code)(Java Doc) public void writeOpenQuery(Section section, int fetchSize, int resultSetType) throws SqlException(Code)(Java Doc) public void writePrepare(String sql, Section section) throws SqlException(Code)(Java Doc) public void writePrepareDescribeOutput(String sql, Section section) throws SqlException(Code)(Java Doc) public void writeSetSpecialRegister(java.util.ArrayList sqlsttList) throws SqlException(Code)(Java Doc) Methods inherited from java.lang.Object native protected Object clone() throws CloneNotSupportedException(Code)(Java Doc) public boolean equals(Object obj)(Code)(Java Doc) protected void finalize() throws Throwable(Code)(Java Doc) final native public Class getClass()(Code)(Java Doc) native public int hashCode()(Code)(Java Doc) final native public void notify()(Code)(Java Doc) final native public void notifyAll()(Code)(Java Doc) public String toString()(Code)(Java Doc) final native public void wait(long timeout) throws InterruptedException(Code)(Java Doc) final public void wait(long timeout, int nanos) throws InterruptedException(Code)(Java Doc) final public void wait() throws InterruptedException(Code)(Java Doc)