This chapter contains these topics:
The JD Edwards World JDBC driver (JDBC driver) provides the ability for non-JD Edwards World applications to access JD Edwards World data while maintaining the level of security and the flexibility built into the JD Edwards World software.
While the JD Edwards World JDBC driver adheres to the Java™ JDBC™ 4.0 specification interface, it is not a completely functional JDBC driver. The JDBC driver does provide great flexibility in selecting, formatting, and presenting JD Edwards World data to outside applications. The JDBC driver provides the features listed in this section.
The JDBC driver provides the following security features for the user profile that logs into JD Edwards World via JD Edwards World JDBC driver:
Restricts SQL to SELECT, INSERT, UPDATE, and DELETE statements only.
Restricts access to only those tables in the JD Edwards World user library list.
Applies JD Edwards World Action Code Security to control access to SELECT, INSERT, UPDATE, and DELETE SQL statements.
Applies JD Edwards World Business Unit Security.
Recognizes JD Edwards World Column Security based on World Writer Column Security definitions.
Continues to take full advantage of IBM® object security. Each IBM database connection is based on the connected user credentials.
The JDBC driver provides the following additional features:
Works with JD Edwards World software releases from A7.3 forward.
Installs easily (less than 1 Mb jar file) and is dependent only on the JT400.jar file from the IBM JTOpen Toolbox for Java (version 6.1 or later).
Performs basic JD Edwards World data transformations (decimal position, date format) based on JD Edwards World Data Dictionary definitions of the table column.
Supports presumptive joins for the following JD Edwards World tables:
User Defined Codes
Company Constants
Currency Codes
Payment Terms
Supports customized JD Edwards World and third-party data tables.
SQL statements that identify transaction boundaries are also supported.
The following table contains synonymous terms that you find in SQL and the IBM i file system:
| SQL | IBM i File System |
|---|---|
| Database | Server |
| Schema | Library |
| Table | File |
| Column | Field |
Note:
In this document, the name IBM i includes IBM servers named AS/400, eServer iSeries, System i5, System i, or Power Servers running the IBM i for Business operating system.