Ingres JDBC Learn
From Ingres Community Wiki
This page will provide you with both the latest news on the Ingres JDBC Driver as well as everything you need to learn about JDBC and become proficient in using it to build Ingres applications.
Contents |
Overview
The Ingres JDBC Driver is a pure Java implementation of the JDBC 3.0 API - see below for Java version support. The driver supports application, applet, and servlet access to Ingres data sources through the Ingres Data Access Server (DAS). The Ingres JDBC Driver is delivered as a single Java archive file, named iijdbc.jar, located in the library directory (lib) of the Ingres instance. Depending on the Java environment used, access to the driver requires adding the Java archive to the CLASSPATH environment setting or as a resource in the appropriate utility. For browser/applet access, the Java archive must be copied to the Web Server directories.
The Ingres JDBC driver enables JDBC-enabled applications to access Ingres RDBMS, Ingres Enterprise Access and Ingres EDBC databases.
Sun Java 2 SDK Version Support
Ingres 2006r2 (9.1.x) supports Java 1.4 and higher. Ingres 9.2.x supports Java 1.5 and higher.
Architecture
Specifications
On-Line Documentation
The Ingres JDBC Driver is documented in the Ingres Connectivity Guide available online at Docs. In addition, the Ingres SQL Reference Guide documents SQL Statements available with the Ingres JDBC Driver.
Articles
Articles dealing with the Ingres JDBC Driver and Integration with other technologies can be found at Articles
Examples
Example code can be found in Code Samples.
Presentations
Here are links to webinars that have been previously given. You can download the presentations and webinar replays. Note that replaying any of the webinars requires that you first install the WebEx ARF media player. Of course, you need Adobe Acrobat Reader for PDF files and InfoZip is a nice open source utility for handling ZIP files.
- Connecting With Ingres Architecture
- Configuring an Application Server with Ingres (VIP Webinar). This webinar describes how to configure a J2EE Application Server with Ingres. You can download the presentation (pdf) and and replay the DOWNLOAD ZIP
- Comparing INGRES-based data-access logic
- Spring with JPA Session (VIP Webinar). The Java Persistence API was introduced to simplify Java applications that use data persistence. The aim of Spring, the leading full-stack Java/JEE application framework, is to make enterprise Java easier to use and promote good programming practice. By offering comprehensive support for JPA, Spring provides a compelling programming model for modern enterprise Java. This webinar helps you to explore building enterprise applications with Spring on an Ingres database, learn about dependency injection and amaze your friends and colleagues with load-time weaving. You can download the presentation (pdf) and and replay the DOWNLOAD
