JRC stands for Java Relational Combinator.
It is a pure Java solution for cross-dbms SQL. It allows easy code reuse of SQL code and dbms neutrality.
Features of JRC include:
- Capability of combining simple relation objects to create more sophisticated relation object, for example:
- Provide enhanced dbms neutral SQL support. For example, one can use functions and enhanced features and the SQL will be translated to the SQL extension on the target dbms. For example: This SQL will be translated to Microsoft Transact-SQL as: As you shown in the example, jrc functions will be translated into the corresponding function in the target dbms. Enhanced sql features such as group comparison is also translated. Therefore one can write dbms neutral SQL code and still be able to use features not defined in the ANSI SQL standard.