Table of Contents

Search

  1. Preface
  2. Introduction to PowerExchange for JDBC V2
  3. PowerExchange for JDBC V2 Configuration Overview
  4. JDBC V2 Connections
  5. PowerExchange for JDBC V2 Data Objects
  6. JDBC V2 Mappings
  7. PowerExchange for JDBC V2 Dynamic Mappings
  8. JDBC V2 Lookup
  9. JDBC V2 Run-Time Processing
  10. JDBC V2 Datatype Reference

PowerExchange for JDBC V2 User Guide

PowerExchange for JDBC V2 User Guide

Rules and Guidelines for JDBC V2 Data Objects

Rules and Guidelines for JDBC V2 Data Objects

When you use the JDBC V2 connection, some rules and guidelines apply while you import data or configure queries.
Consider the following rules and guidelines for JDBC V2 data objects:
  • When you import the JDBC V2 object metadata, you cannot import synonyms.
  • You cannot select the JDBC V2 connection from the Connection Explorer.
  • When you add resources while importing the JDBC V2 data object, the advanced search is disabled. Type the table name in the
    Name
    field in the
    Add Resources
    dialog box to search the table.
  • If the schema of the tables is modified in the JDBC V2 database, you cannot synchronize the data objects. The synchronize option for the data object in the object explorer is disabled.
  • Insert and truncate queries configured for data objects in mappings that run on the Spark engine are not logged in the Spark logs.

0 COMMENTS

We’d like to hear from you!