DataDirect's JDBC Developer Center
The JDBC Developer Center serves as the clearing house for the most current, developer-oriented JDBC data connectivity information available in the industry.
DataDirect Technologies is a pioneer in JDBC. We partnered with Sun Microsystems to develop the original JDBC standard and have participated on the JDBC Expert Panel since its inception. This site contains in-depth technical articles on improving JDBC performance and using our JDBC drivers with leading-edge development platforms including the Java Transaction API.
Popular JDBC Developer Center Topics:Interoperability |
 |
|
You'll also find:Introduction to JDBC Basics |
Review These Popular JDBC Developer Center Topics:
Interoperability
Achieving Database Interoperability through SQL Leveling Across Data Access APIs
Open data access standards, such as ODBC, JDBC and ADO.NET have given developers a means of achieving application portability between databases. However, there are still instances where the SQL standard is not portable between databases. DataDirect Technologies delivers this interoperability between databases and across APIs through SQL Leveling. More...
Optimizing Performance
Designing Performance-Optimized JDBC Applications
Covers the major factors in coding for JDBC application performance: connecting to the database, getting metadata, executing statements, inserting data, reading data, and committing changes. More...
Boost Your Oracle WebSphere Performance
Overcome application issues relating to Oracle-WebSphere applications. Why hinder your investment by utilizing a sub-optimal Oracle JDBC driver?
The Oracle Thin JDBC driver (from Oracle) is known to suffer from reliability and performance shortcomings. These WebSphere performance problems manifest themselves in application and performance failures, resulting in application downtime and user satisfaction issues. More...
JDBC Connection Pooling
Establishing JDBC connections is resource-expensive, especially in a middle-tier server environment. JDBC connection pooling provides a significant improvement on performance by reusing connections rather than creating a new connection for each connection request, without requiring changes in your JDBC application code. More...
Achieving Optimal Security
Enterprise Security Features in DataDirect Connect — Secure Architecture, Kerberos, and SSL
Learn more about the security features in the DataDirect Connect product line and read the independent security report by The Internet Security Advisors Group (ISAG), an international information security firm specializing in security assessment. The report also provides important information if you’re looking to implement Single Sign-on (SSO) or data encryption. More...
Enabling Single Sign-On Using DataDirect Connect for JDBC Integrated Authentication
This whitepaper explains how DataDirect Connect for JDBC can be used to enable Single Sign-on, which results in stronger application security, improved end-user usability, and lower IT management costs. It addresses the industry drivers (regulatory compliance, highly public corporate malfeasance, and internet-based collaboration) that are motivating organizations to bolster their security infrastructure. It provides an introduction into the technical capabilities provided by DataDirect Connect for JDBC including support for Kerberos and NTLM protocols, credential delegation and DataDirect's authentication "Pass Through" mode. More...
Windows Authentication on Microsoft SQL Server
Microsoft SQL Server offers two types of security authentication: SQL Server Authentication and Windows Authentication. 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. It is the authentication mode recommended by Microsoft. This article provides an overview of Windows Authentication and the configuration required to use Windows Authentication with DataDirect Connect for JDBC drivers. More...
Testing and Debugging JDBC Applications
Testing and Debugging JDBC Applications
DataDirect Test is a free tool included with our JDBC drivers for debugging JDBC applications. It can also help you learn the JDBC API. It works by displaying the results of all JDBC function calls with sample Java JDBC code (including comments). More...
Distributed Transaction Support
Understanding JTA - the Java Transaction API
The Java Transaction API allows applications to perform distributed transactions, that is, transactions that access and update data on two or more networked computer resources. The Java Transaction API 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 paper provides an overview of that process and how the DataDirect Connect for JDBC drivers relate to it. More...
JDBC Specification Support
Important New Features in JDBC 3.0
The JDBC 3.0 specification shipped as part of the J2SE 1.4 release early this year. The key goals of the JDBC Expert Panel were to align with the most important features of SQL99, to combine all of the previous JDBC specifications into a single document, to provide a standard way to take advantage of native DBMS functionality, and to improve scalability. The 3.0 specification contains a number of useful new features for JDBC users. More...
Important Announcements
Support for 2007 Daylight Saving Time (DST) in JDBC products
This document explains the support provided by Connect for JDBC for the Daylight Saving Time (DST) change implemented by the United States government in 2007. More...
Support for 2007 Daylight Saving Time (DST) Change in DataDirect SequeLink
Important New Features in JDBC 3.0
The JDBC 3.0 specification shipped as part of the J2SE 1.4 release early this year. The key goals of the JDBC Expert Panel were to align with the most important features of SQL99, to combine all of the previous JDBC specifications into a single document, to provide a standard way to take advantage of native DBMS functionality, and to improve scalability. The 3.0 specification contains a number of useful new features for JDBC users. More...
Open Source Considerations
Why Open Source Database Drivers Are Not Viable
This article explains the risks associated with the use of an open source database driver. These risks are not limited to potential technical difficulties, since the problems could severely affect the day-to-day workings of the business. The risks are associated with inferior product quality, non-existent technical support, and the complete assumption of legal liability.
This article distinguishes between the approach taken by a commercially supported open source offering (e.g., RedHat) vs. the fledgling effort of a project-based open source database driver. It also contrasts the organizational approach used by open source database driver providers with DataDirect's industry-leading, database connectivity solutions, which are production viable and commercially supported. More...
Using DataDirect Connect for JDBC Drivers with JBoss
This article explains the steps required to use the DataDirect Connect for JDBC drivers with the JBoss Application Server. More...
Using DataDirect Connect for JDBC Drivers with Tomcat
This article explains the steps required to use DataDirect Connect for JDBC drivers with the Tomcat JSP/Servlet engine. More...
JDBC “How To” Guides
Using DataDirect JDBC Drivers with Hibernate
This article gives you all the information you need to use DataDirect JDBC drivers with Hibernate, which is an open source project that provides an object-relational mapping solution for Java applications. (Includes sample code to download.)
Using Enterprise JavaBeans 3.0 and the Java Persistence API with JBoss and DataDirect Connect for JDBC
This article gives you all the information you need to use DataDirect JDBC drivers with these Java technologies.
Using DataDirect Connect for JDBC with Oracle RAC
Oracle RAC provides applications with many advantages such as connection failover and load balancing. This article explains how you can take advantage of these Oracle RAC features using the DataDirect Connect for JDBC Oracle driver. More...
Boost Your Oracle WebSphere Performance
Overcome application issues relating to Oracle-WebSphere applications. Why hinder your investment by utilizing a sub-optimal Oracle JDBC driver?
The Oracle Thin JDBC driver (from Oracle) is known to suffer from reliability and performance shortcomings. These WebSphere performance problems manifest themselves in application and performance failures, resulting in application downtime and user satisfaction issues. More...
Using DataDirect Connect for JDBC Drivers with JBoss
This article explains the steps required to use the DataDirect Connect for JDBC drivers with the JBoss Application Server. More...
Using DataDirect Connect for JDBC Drivers with Tomcat
This article explains the steps required to use DataDirect Connect for JDBC drivers with the Tomcat JSP/Servlet engine. More...
Using DataDirect Connect for JDBC Drivers with the Sun Java System Application Server
This article explains the steps required to use the DataDirect Connect for JDBC drivers with the Sun Java System Application Server, including installing the drivers, creating and validating a JDBC Connection Pool, creating a JDBC Resource, generating a JSP test page and deploying and running the test application. 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. More...
Using DataDirect Connect for JDBC Resource Adapters
J2EE Connector Architecture resource adapters are used by application servers to connect to Enterprise Information Systems (EISs), 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. More...
Buy | 
| Learn More
