com.ibm.jtopenlite.database.jdbc

Class JDBCStatement

  • java.lang.Object
    • com.ibm.jtopenlite.database.jdbc.JDBCStatement
    • Constructor Detail

      • JDBCStatement

        public JDBCStatement(JDBCConnection conn,
                     java.lang.String statementName,
                     java.lang.String cursorName,
                     int rpbID)
                      throws java.sql.SQLException
        Throws:
        java.sql.SQLException
    >
    • Method Detail

      • getStatementType

        public static int getStatementType(java.lang.String sql)
                                    throws java.sql.SQLException
        Throws:
        java.sql.SQLException
      • addBatch

        public void addBatch(java.lang.String sql)
                      throws java.sql.SQLException
        Not implemented.
        Specified by:
        addBatch in interface java.sql.Statement
        Throws:
        java.sql.SQLException
      • cancel

        public void cancel()
                    throws java.sql.SQLException
        Not implemented.
        Specified by:
        cancel in interface java.sql.Statement
        Throws:
        java.sql.SQLException
      • clearBatch

        public void clearBatch()
                        throws java.sql.SQLException
        Not implemented.
        Specified by:
        clearBatch in interface java.sql.Statement
        Throws:
        java.sql.SQLException
      • clearWarnings

        public void clearWarnings()
                           throws java.sql.SQLException
        Warning are not supported. This is a noop.
        Specified by:
        clearWarnings in interface java.sql.Statement
        Throws:
        java.sql.SQLException
      • close

        public void close()
                   throws java.sql.SQLException
        Specified by:
        close in interface java.sql.Statement
        Throws:
        java.sql.SQLException
      • execute

        public boolean execute(java.lang.String sql)
                        throws java.sql.SQLException
        Specified by:
        execute in interface java.sql.Statement
        Throws:
        java.sql.SQLException
      • execute

        public boolean execute(java.lang.String sql,
                      int autoGeneratedKeys)
                        throws java.sql.SQLException
        Specified by:
        execute in interface java.sql.Statement
        Throws:
        java.sql.SQLException
      • execute

        public boolean execute(java.lang.String sql,
                      int[] columnIndices)
                        throws java.sql.SQLException
        Not implemented.
        Specified by:
        execute in interface java.sql.Statement
        Throws:
        java.sql.SQLException
      • execute

        public boolean execute(java.lang.String sql,
                      java.lang.String[] columnNames)
                        throws java.sql.SQLException
        Not implemented.
        Specified by:
        execute in interface java.sql.Statement
        Throws:
        java.sql.SQLException
      • executeBatch

        public int[] executeBatch()
                           throws java.sql.SQLException
        Not implemented.
        Specified by:
        executeBatch in interface java.sql.Statement
        Throws:
        java.sql.SQLException
      • executeQuery

        public java.sql.ResultSet executeQuery(java.lang.String sql)
                                        throws java.sql.SQLException
        Specified by:
        executeQuery in interface java.sql.Statement
        Throws:
        java.sql.SQLException
      • executeUpdate

        public int executeUpdate(java.lang.String sql)
                          throws java.sql.SQLException
        Specified by:
        executeUpdate in interface java.sql.Statement
        Throws:
        java.sql.SQLException
      • executeUpdate

        public int executeUpdate(java.lang.String sql,
                        int autoGeneratedKeys)
                          throws java.sql.SQLException
        Specified by:
        executeUpdate in interface java.sql.Statement
        Throws:
        java.sql.SQLException
      • executeUpdate

        public int executeUpdate(java.lang.String sql,
                        int[] columnIndices)
                          throws java.sql.SQLException
        Not implemented.
        Specified by:
        executeUpdate in interface java.sql.Statement
        Throws:
        java.sql.SQLException
      • executeUpdate

        public int executeUpdate(java.lang.String sql,
                        java.lang.String[] columnNames)
                          throws java.sql.SQLException
        Not implemented.
        Specified by:
        executeUpdate in interface java.sql.Statement
        Throws:
        java.sql.SQLException
      • getConnection

        public java.sql.Connection getConnection()
                                          throws java.sql.SQLException
        Specified by:
        getConnection in interface java.sql.Statement
        Throws:
        java.sql.SQLException
      • getFetchDirection

        public int getFetchDirection()
                              throws java.sql.SQLException
        Specified by:
        getFetchDirection in interface java.sql.Statement
        Throws:
        java.sql.SQLException
      • getFetchSize

        public int getFetchSize()
                         throws java.sql.SQLException
        Specified by:
        getFetchSize in interface java.sql.Statement
        Throws:
        java.sql.SQLException
      • getGeneratedKeys

        public java.sql.ResultSet getGeneratedKeys()
                                            throws java.sql.SQLException
        Specified by:
        getGeneratedKeys in interface java.sql.Statement
        Throws:
        java.sql.SQLException
      • getMaxFieldSize

        public int getMaxFieldSize()
                            throws java.sql.SQLException
        Retrieves the maximum number of bytes that can be returned for character and binary column values in a ResultSet object produced by this Statement object.
        Specified by:
        getMaxFieldSize in interface java.sql.Statement
        Throws:
        java.sql.SQLException
      • getMaxRows

        public int getMaxRows()
                       throws java.sql.SQLException
        Retrieves the maximum number of rows that a ResultSet object produced by this Statement object can contain.
        Specified by:
        getMaxRows in interface java.sql.Statement
        Returns:
        0 -- there is no limit
        Throws:
        java.sql.SQLException
      • getMoreResults

        public boolean getMoreResults()
                               throws java.sql.SQLException
        Not implemented.
        Specified by:
        getMoreResults in interface java.sql.Statement
        Throws:
        java.sql.SQLException
      • getMoreResults

        public boolean getMoreResults(int current)
                               throws java.sql.SQLException
        Not implemented.
        Specified by:
        getMoreResults in interface java.sql.Statement
        Throws:
        java.sql.SQLException
      • getQueryTimeout

        public int getQueryTimeout()
                            throws java.sql.SQLException
        Retrieves the number of seconds the driver will wait for a Statement object to execute
        Specified by:
        getQueryTimeout in interface java.sql.Statement
        Returns:
        0: This driver does not support query timeout. .
        Throws:
        java.sql.SQLException
      • getResultSet

        public java.sql.ResultSet getResultSet()
                                        throws java.sql.SQLException
        Specified by:
        getResultSet in interface java.sql.Statement
        Throws:
        java.sql.SQLException
      • getResultSetConcurrency

        public int getResultSetConcurrency()
                                    throws java.sql.SQLException
        Retrieves the result set concurrency for ResultSet objects generated by this Statement object.
        Specified by:
        getResultSetConcurrency in interface java.sql.Statement
        Returns:
        ResultSet.CONCUR_READ_ONLY: This driver only supports READ_ONLY cursors.
        Throws:
        java.sql.SQLException
      • getResultSetHoldability

        public int getResultSetHoldability()
                                    throws java.sql.SQLException
        Retrieves the result set holdability for ResultSet objects generated by this Statement object. returns ResultSet.HOLD_CURSORS_OVER_COMMIT
        Specified by:
        getResultSetHoldability in interface java.sql.Statement
        Throws:
        java.sql.SQLException
      • getResultSetType

        public int getResultSetType()
                             throws java.sql.SQLException
        Specified by:
        getResultSetType in interface java.sql.Statement
        Throws:
        java.sql.SQLException
      • getUpdateCount

        public int getUpdateCount()
                           throws java.sql.SQLException
        Specified by:
        getUpdateCount in interface java.sql.Statement
        Throws:
        java.sql.SQLException
      • getWarnings

        public java.sql.SQLWarning getWarnings()
                                        throws java.sql.SQLException
        Not implemented, but we return null to avoid problems with existing applications
        Specified by:
        getWarnings in interface java.sql.Statement
        Throws:
        java.sql.SQLException
      • setCursorName

        public void setCursorName(java.lang.String name)
                           throws java.sql.SQLException
        Not implemented.
        Specified by:
        setCursorName in interface java.sql.Statement
        Throws:
        java.sql.SQLException
      • setEscapeProcessing

        public void setEscapeProcessing(boolean enable)
                                 throws java.sql.SQLException
        Not implemented.
        Specified by:
        setEscapeProcessing in interface java.sql.Statement
        Throws:
        java.sql.SQLException
      • setFetchDirection

        public void setFetchDirection(int direction)
                               throws java.sql.SQLException
        Not implemented.
        Specified by:
        setFetchDirection in interface java.sql.Statement
        Throws:
        java.sql.SQLException
      • setFetchSize

        public void setFetchSize(int rows)
                          throws java.sql.SQLException
        Specified by:
        setFetchSize in interface java.sql.Statement
        Throws:
        java.sql.SQLException
      • setMaxFieldSize

        public void setMaxFieldSize(int max)
                             throws java.sql.SQLException
        Not implemented.
        Specified by:
        setMaxFieldSize in interface java.sql.Statement
        Throws:
        java.sql.SQLException
      • setMaxRows

        public void setMaxRows(int max)
                        throws java.sql.SQLException
        Not implemented.
        Specified by:
        setMaxRows in interface java.sql.Statement
        Throws:
        java.sql.SQLException
      • setQueryTimeout

        public void setQueryTimeout(int seconds)
                             throws java.sql.SQLException
        Not implemented.
        Specified by:
        setQueryTimeout in interface java.sql.Statement
        Throws:
        java.sql.SQLException
      • isClosed

        public boolean isClosed()
        Specified by:
        isClosed in interface java.sql.Statement
      • setCursorNameInternal

        protected void setCursorNameInternal(java.lang.String cursorName)
      • isPoolable

        public boolean isPoolable()
                           throws java.sql.SQLException
        Specified by:
        isPoolable in interface java.sql.Statement
        Throws:
        java.sql.SQLException
      • setPoolable

        public void setPoolable(boolean poolable)
                         throws java.sql.SQLException
        Specified by:
        setPoolable in interface java.sql.Statement
        Throws:
        java.sql.SQLException
      • setCatalog

        public void setCatalog(java.lang.String catalog)