Skip to content
This repository was archived by the owner on Sep 9, 2024. It is now read-only.
This repository was archived by the owner on Sep 9, 2024. It is now read-only.

Support JDBC "execute" #38

@JasonPierce

Description

@JasonPierce

Presently, node-teradata supports executeQuery via read() and readPreparedStatement(), and executeUpdate via write() and writePreparedStatement(). The JDBC API has a third method for executing statements called execute.

  • executeQuery: executes SELECT statements
  • executeUpdate: executes non-SELECT statements (e.g., INSERT, UPDATE, DELETE)
  • execute: executes SELECT and non-SELECT statements. But, more importantly, it can execute multiple statements, which is something neither of the other methods support

Acceptance Criteria

  1. New method execute executes one or more (read and/or write) statements within the query
  2. New method executePreparedStatement executes one or more (read and/or write) statements within the query, using prepared statements
  3. execute and executePreparedStatement returns an array of results:
    • One result for each statement within the query
    • Results are indexed by order of statement execution
  4. Documentation is updated with examples

Metadata

Metadata

Assignees

No one assigned

    Type

    No type

    Projects

    No projects

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions