JDBC Tutorials

Single Sign-On With Connect for JDBC Integrated Authentication

Information security has become an increasingly visible and important topic to companies. Driven by a number of highly publicized security breaches and episodes of financial malfeasance, organizations are under pressure to implement the business processes and technical infrastructure necessary to protect their information assets. In most cases, information assets are stored in relational database systems and accessed by customers, partners, and employees using business applications such as financial reporting systems, e-commerce websites, and employee and partner intranets.

Learn More

Boost Your Oracle WebSphere Performance

Improved Performance and Reduced Complexity

Learn More

Introduction to the Connect for JDBC Salesforce.com Driver

Enabling access to enterprise Salesforce.com data via SQL and JDBC, the Connect for JDBC Salesforce.com Driver combines read/write access to Salesforce objects, custom objects, and reports with realtime data caching and Type 5 JDBC driver features.

Learn More

Windows Authentication on Microsoft SQL Server

Microsoft SQL Server offers two types of security authentication: SQL Server authentication and Windows authentication. SQL Server authentication authenticates the user to the database using a database user name and password. Windows authentication is also referred to as "Windows Integrated Security" or a "trusted connection" because it relies on the user being authenticated, or "trusted," by the operating system. Windows authentication is the authentication mode recommended by Microsoft.

Learn More

Understanding JTA - the Java Transaction API

The Java™ Transaction API (JTA) allows applications to perform distributed transactions, that is, transactions that access and update data on two or more networked computer resources. The JTA specifies standard Java interfaces between a transaction manager and the parties involved in a distributed transaction system: the application, the application server, and the resource manager that controls access to the shared resources affected by the transactions. This document provides an overview of that process and how the DataDirect Connect® for JDBC™ drivers relate to it.

Learn More

Interoperability Across Data Access APIs through SQL Up-leveling

SQL up-leveling provides the capability to write a SQL statement that can be executed across multiple databases, regardless of the databases’ SQL implementation. For example, a SQL statement written against Oracle will also be interoperable with DB2. Each of the major database vendors implements certain functionality in a unique proprietary format.

Learn More

Using DataDirect JDBC Drivers with Hibernate

Table of Contents: What is Hibernate? Why Using DataDirect JDBC Drivers Makes This Technology Better Required Components Installation of DataDirect Connect for JDBC Drivers Required Hibernate and DataDirect Connect for JDBC Libraries Implementing an Object Relational Solution with Hibernate and DataDirect Connect for JDBC Drivers Running the Sample Application Useful Links

Learn More

Using DataDirect Connect for JDBC Drivers with JBoss

This document explains the steps required to use the DataDirect Connect® for JDBC® drivers with the JBoss Application Server.

Learn More

EJB 3.0, Java Persistence API with JBoss and Connect for JDBC

This article provides all the information you need to use the Progress DataDirect JDBC drivers with these Java technologies. Java Platform, Enterprise Edition (Java EE) is the industry standard for developing portable, robust, scalable and secure server-side Java applications. Java EE provides web services, component model, management, and communications APIs that make it the industry standard for implementing enterprise-class service-oriented architecture (SOA) and next-generation web applications.

Learn More

Datadirect Connect for JDBC with Oracle RAC

In today's e-business on-demand environment, more companies are turning to a Grid computing infrastructure for distributed computing and data resources such as processing, network bandwidth, and storage. Grids allow companies to pool available resources for scalability and high availability. Built on Oracle Parallel Server (OPS) architecture, Oracle introduced Real Application Clusters (RAC) with Oracle 9i. Oracle RAC also is a key part of the Oracle 10g release. Oracle RAC allows a single physical Oracle database to be accessed by concurrent instances of Oracle running across several different CPUs.

Learn More

DataDirect Connect for JDBC Drivers with Tomcat

This document explains the steps required to use the DataDirect Connect® for JDBC® drivers with the Tomcat JSP/Servlet engine.

Learn More

Using DataDirect Connect for JDBC Drivers with the Sun Java System Application Server

This document explains the steps required to use the DataDirect Connect for JDBC™ drivers with the Sun Java System Application Server.

Learn More

Using DataDirect Connect for JDBC Drivers with WebLogic 8.1

This document explains the steps required to use the DataDirect Connect® for JDBC® drivers with the WebLogic Application Server.

Learn More

Using DataDirect Connect for JDBC Resource Adapters

J2EE Connector Architecture resource adapters are used by application servers to connect to Enterprise Information Systems (EIS), such as mainframe transaction processing systems, database systems, or legacy applications not written in the Java® programming language. The resource adapter communicates with the server to provide the underlying transaction, security, and connection pooling mechanisms. DataDirect Connect for JDBC provides resource adapters as an installable option.

Learn More

Why Open Source Database Drivers Are Not Viable

Open source software is gaining traction in many software infrastructure markets, particularly in the operating system, Web/application server and database server infrastructure areas. Many organizations currently are leveraging open source components or are devising an open source acquisition and management plan. In most cases, organizations are adopting a blended-source approach that leverages both open source and traditionally licensed software.

Learn More

Designing Performance-Optimized JDBC Applications

Developing performance-oriented JDBC applications is not easy. JDBC drivers do not throw exceptions to tell you when your code is running too slow. This document presents some general guidelines for improving JDBC application performance that have been compiled by examining the JDBC implementations of numerous shipping JDBC applications. Following these guidelines can help you solve some common JDBC system performance problems.

Learn More

JDBC Connection Pooling

This document provides information intended to help developers provide a connection pooling strategy for applications that must handle connection pooling. First, this document provides an overview of JDBC connection pooling as specified by the JDBC 3.0 specification. Next, it provides examples of how to use the DataDirect Connection Pool Manager (which is shipped with DataDirect Connect® for JDBC and DataDirect SequeLink® for JDBC) for your applications. Finally, this document provides an example showing performance benchmarks that demonstrate the performance benefit you can achieve by using connection pooling.

Learn More

Testing and Debugging JDBC Applications

You can run DataDirect JDBC Test as an application on both Windows and UNIX. DataDirect JDBC Test can be used with DataDirect SequeLink Java Client and DataDirect Connect for JDBC drivers. This document provides some examples of ways that you can use DataDirect Test to test your JDBC applications.

Learn More