JDBC Driver Development with the DataDirect OpenAccess SDK

OpenAccess SDK provides the toolkit and the run-time software components needed to implement a JDBC driver for your data source within days — easily enable your data source to plug and play with applications written in Java. The toolkit is used to build an Interface Provider (IP) to your data source through the implementation of a defined API consisting of 12 functions. Alternatively, you can replace the OpenAccess SQL engine with your own SQL engine by implementing what we call a SQL IP that handles SQL execution.

OpenAccess SDK is suited for making desktop or server based data sources accessible through JDBC. It provides 99% of the code that is required to open up a database. The other 1% of the code resides between our SQL engine and your database. This is the code you write to take information from the SQL engine and to use it to process rows of data from your database. Whether implementing a local or client/server solution, you write your code with very little concern for the JDBC interface, SQL, networking, optimization, data types, and many other issues. You need only be concerned about taking a request to process data for which we provide you all the information you need to do it optimally. The 1% code you write can be written in C, C++, Java, or a .NET language and this code is the same regardless of whether you want to support ODBC, JDBC, OLE DB, or ADO.NET.

| Buy | Product Data Sheet

Using our SQL Engine
Click Graphic for a full-sized image


Using your SQL Engine
Click Graphic for a full-sized image

Product Highlights

• Simply implement 12 functions to integrate your data source with our SQL engine. Alternatively, you can replace the OpenAccess SQL engine with your own SQL engine by implementing what we call a SQL IP that handles SQL execution.
  
  
• Supports JDBC 2.0 specifications.
  
  
• Runs on Windows, UNIX, and Linux and available in 32-bit and 64-bit.
  
  
• OpenAccess' JDBC implementation offers a high level of compliance to the JDBC specification. This guarantees compatibility with any application written to the JDBC specification and with applications that are compatible with SQL Server, Oracle, Sybase, DB2, and other commercial RDBMS.
  
  
• Supports interfacing to data sources using C/C++, Java, or .NET. You can implement a JDBC driver by writing the custom portion in C or .NET!
  
  
• The finished driver can be completely customized with the driver name, error message pre-fix, error messages, and configuration dialog boxes.
  
  
• All supplied components are fully tested using our extensive test suite. All you have to do is test the custom code you write.

Additional Information

Features and Benefits
Platform Support
SQL Support
Application Notes
OpenAccess Use Cases
Release History