The Java EE architecture allows for the creation and distribution of enterprise applications on any platform. The CONNX component that fits into the Java EE architecture is a pure Java JDBC driver that provides access to non-relational and relational data alike.
CONNX makes non-relational data sources, like RMS, Oracle Rdb, Oracle Codasyl DBMS, C-ISAM, D-ISAM, Micro Focus, VSAM, IMS and Dataflex files, appear as true relational databases. A significant component of the Java EE is the Connector. The Connector is a method of wrapping data access and business rules into a single component. This component is the front door to the underlying business object. The creation of Connector components eventually requires access to the actual data.
CONNX provides a pure Java method of accessing the actual data through JDBC. Most JDBC drivers provide access to relational databases, such as SQL Server, Oracle, and DB2. CONNX not only provides access to those common databases, but also to non-relational databases.
Unifying SQL
A key feature in CONNX is its unifying SQL technology. Even though most relational databases support ANSI SQL, there are subtle (and, sometimes, not so subtle) differences in the SQL supported between major relational databases, such as Oracle, DB2, and SQL Server.
CONNX provides a unified ANSI SQL syntax that works across all databases, and even across those data sources that do not support SQL at all. This enables JAVA EE developer’s true database-independent data access. CONNX automatically translates the standard ANSI SQL syntax to the native database syntax. This has the advantage of portability, and provides the performance of using native SQL.
Additionally, CONNX enables you to pass true native SQL directly through to the relational database, providing the best of both worlds.
Connection Pooling and Connection Sharing
When creating enterprise applications, scalability is a key factor in the performance and success of the application. CONNX provides two technologies through JDBC that lead to increased scalability: Connection Pooling and Connection Sharing.
Connection Pooling keeps previously used connections in a “pool” for a configurable period of time. This eliminates the overhead of creating a new connection every time one is needed. Connection Sharing enables multiple users to “share” a single physical connection resource.
CONNX provides configuration options to control the number of logical users that share a single physical connection. By using these two options together, it is possible to create JAVA EE applications that support thousands of users with excellent performance.
Summary
CONNX for JAVA EE enables organisations to create high performance enterprise-wide applications. By taking advantage of the CONNX portability and scalability features, organisations spend more time on addressing business needs and less time on the technical details of the implementation and rollout.
Back to all blog posts