Buy Download Contact Us

Linked InTwitterFacebookBlogFeedYouTube

Chinese Website
Japanese Website



Database Connectivity Overview

pdfPDF
Case Studies

case studiesView
Download

HiT JDBC productsJDBC Products


Purchase

USA and Canada
sales@hitsw.com
+1-408-345-4001
 
Asia
Australia
Europe
Latin America

as/400 iseries odbc driver for sql server : db2 connectivity

ODBC driver for IBM i, iSeries and AS/400  


JDBC Connectivity
for IBM DB2 for Linux, UNIX, Windows, z/OS

Overview of HiT JDBC Products

HiT JDBC/DB2 and HiT JDBC/400 are compact, 100% Pure Java type 4 middleware for DB2 SQL access from custom applications and third party products. HiT JDBC middleware implements standard Java Database Connectivity (JDBC) function calls and communicates with the DB2 server to retrieve, update, and insert DB2 data. Leveraging standard IBM DB2 access protocols, including Distributed Relational Database Architecture (DRDA) and OS/400 Optimized Database Server protocol, both HiT JDBC products communicate with native IBM server programs and do not require any additional programs installed on the DB2 host system. Support is also included for the most common DB2 single and double-byte character sets. Importantly, all communication with the DB2 server can also be optionally encrypted and authenticated via SSL v3.0 support.

HiT JDBC/DB2 and HiT JDBC/400 support IBM WebSphere and can be configured as connection pooling or XA data sources and, thereafter, referenced by application modules and beans. HiT JDBC middleware can be used with all major Java application development tools. DB2 LUW for z/OS and OS/390, OS/400, as well as other DB2 LUW servers, are supported. HiT JDBC/DB2 and HiT JDBC/400 work with any operating system running JVM 1.02 or later, including Windows, Unix, Linux, IBM OS/400 and IBM OS/390 platforms, IBM DB2 for i, iSeries and AS/400.

HiT JDBC products can be used with all major Java application development tools. HiT JDBC is extremely reliable and has evolved a robust feature set. Multi-threading support ensures high performance for all applications. For high-security applications, data encryption and authentication services can be enabled using HiT SSL Server, a secure server that uses the Secure Sockets Layer Protocol.

HiT JDBC products integrate seamlessly with application servers including BEA/Weblogic, WebSphere and others.

Advantages

  • Small footprint for flexible deployment
  • High performance
  • Implement native DB2 protocols and do not require additional software installed
    on the DB2 host
  • Support for stored procedures, multiple result sets, Static SQL and packages
  • Secure data transmission when used with HiT Software's SafeConduct Server
  • Tools for fast diagnostics
  • Support for double-byte character sets (including Far East and Middle East language support)


HiT JDBC SQL Server Java Driver for IBM DB2

Key Features   Benefits
100% Pure Java Type 4 driver   Performance
JDBC level 1.x, 2.x, and 3.x conformance   J2EE high performance applications support
Stored procedures and multiple results
sets support
 
Static SQL/package support
  Fast data access
 
 
 
Distributed Transaction Support
 
  Complex transactions support over multiple databases
Multi-threading support   Performance and scalability
SSL v3.x encryption and authentication
support
  Secure data transmission
 
Multiple OS/400 version support (HiT JDBC/400
only)
  Flexible deployment
 
Multiple DB2 Server version support
(HiT JDBC/DB2 only)
  Flexible deployment
 
TCP/IP connectivity support   Common network transport
Double-byte and Middle Eastern
language support
  International DB2 server access
 
DRDA Native protocol support   Server Stability


HiT JDBC/400

HiT JDBC/400 (for IBM i, iSeries and AS/400) accepts standard Java Database Connectivity (JDBC) function calls and communicates between the Java application and the AS/400 server to retrieve, update, and insert DB2 data (type 4 driver). HiT JDBC/400 can be installed on any operating system running JVM 1.02 or later, including Windows, Unix, Linux, AIX, IBM OS/400 and IBM OS/390.

HiT JDBC/400 (for System i, i5 or AS/400) supports full SQL functionality (via JDBC level 3.0 conformance) for maximum application performance including stored procedures, multiple result sets, and static SQL/packages. Multi-threading support ensures high performance for applications. JDBC level 3 compliance offers Java developers powerful new data access techniques including scrollable result sets, batch updates, savepoints, connection pool configuration, retrieval of parameter metadata, retrieval of auto-generated keys, database metadata APIs, holdable cursor support, ARRAY, REF and boolean data types, international Unicode and time zone support, and updatable BLOB/CLOB fields.

HiT JDBC/400 v3.x should be used with JDK 1.2 and later, and it supports both JDBC 2.0 and 3.0.

download : includes full support during trial

HiT JDBC/DB2

Leveraging the IBM Distributed Relational Database Architecture (DRDA) protocol standard, HiT JDBC/DB2 uses native IBM server programs and does not require any additional DB2 server software to run. DB2 LUW for z/OS and OS/390 as well as other DB2 LUW servers are supported.

HiT JDBC/DB2 can be installed on any operating system running JVM 1.02 or later, including Windows, Unix, Linux, AIX, IBM OS/400 and IBM OS/390.

HiT JDBC/DB2 supports full SQL functionality for maximum application performance including stored procedures, multiple result sets, static SQL/packages, and distributed transaction support. Multi-threading support ensures high performance for applications. JDBC level 3 compliance offers Java developers powerful new data access techniques including scrollable result sets, batch updates, savepoints, connectionpool configuration, retrieval of parameter metadata, holdable cursor support, boolean data types, international Unicode and time zone support, and updatable BLOB/CLOB fields. For users of DB2 v. 9 and above, JDBC/DB2 supports IBM's PureXML feature with an XML datatype, allowing data access via SQL or XQuery statements.

HiT JDBC/DB2 v3.x should be used with JDK 1.2 and later. HiT JDBC/DB2 v1.x should be used with JDK v1.1 and earlier.

Security

HiT JDBC products can be used with HiT SSL Server, an all-Java, standards-based encryption and authentication server to secure SQL data flows over TCP/IP networks. It prevents unauthorized access to data by transparently enabling the Secure Socket Layer (SSL) protocol between HiT JDBC products and the system where HiT SSL Server is installed.
 

System Requirements:
    HiT JDBC/400
(IBM DB2 for i platforms)
 
  HiT JDBC/DB2
(Linux, UNIX, Windows, z/OS platforms)
 
Platforms   Java-enabled platform JVM 1.02
  or higher
 
  Java-enabled platform JVM 1.02
  or later
 
Installation
Requirements

  OS/400 or IBM i operating system
  V3R7 or higher
  DB2 LUW: DB2 v5 or later
DB2 for zOS/OS390: DB2 for OS/390
  v5 or later
Connectivity
  TCP/IP connection to the AS/400   TCP/IP connection to DB2 Server
DB2 Server Requirements
  AS/400 or IBM i (i5, System i,
  iSeries) running OS/400 V3R1
  through IBM I 6.1 (i5/OS V6R1)
  OS/390 DB2 LUW v5 or later
MVS Requirements
    DB2 for MVS v2.3 or later
    MVA/XA or MVS/ESA
    VTAM® 3.2 or later
VM Requirements
    SQLDS® v3.4 or later
    VM/SP Release 6 or later
    VM ESA Release 1
    VTAM® 3.2 or later
Windows/OS2/AIX/HP-UX/Linux/Sun
   Solaris DB2 Server
    DB2 LUW v5 or later
OS/400
    DB2 OS/400 v4r2 or later
    TCP/IP supported from OS/400 v4r2
   or later

download : includes full support during trial

2016 HiT Software, Inc., A BackOffice Associates, LLC Company. All Rights Reserved.