Java developers

Overview for using FairCom products as a Java developer

Java developers should first try FairCom’s JSON DB API, which is optimized for microservices and n-tier application development.

Installation and error codes

Section	Description
Install FairCom products	Quick and advanced installation guides.
Error codes	Complete list of FairCom error codes.

JSON APIs for Java

Section	Description
JSON DB concepts	Guide for using the JSON DB API.
JSON DB API	Reference guide to use the JSON DB API.
jsonAction API	Core JSON API pattern that is used in FairCom APIs.

SQL for Java

Section	Description
JDBC quick start	Tutorials for using FairCom's JDBC driver in Java.
JDBC developer guide	Guide for using the JDBC driver with FairCom DBSQL in order to use SQL in Java applications (ideal for client-server applications that run in the same data center as the database).
Java stored procedures	Tutorial for using Java to implement SQL stored procedures and triggers in .
SQL stored procedures	Guide for using Java and C# to implement SQL stored procedures and triggers.
SQL reference	Language elements that are common to many FairCom DBSQL statements.
Full text search	Guide for using the full-text search.
ISQL tutorial	Tutorials for using FairCom's interactive SQL command line utility (iSQL).
ISQL CLI	Guide for automating database operations using FairCom's iSQL command line utility and for importing and exporting data using variable-length and fixed-length flat files — such as CSV.
SQL operations	Advanced FairCom SQL features, options, and utilities.
SQL error codes	Complete list of SQL error codes.

Record Buffer APIs for Java

FairCom provides advanced APIs that allow low-level control over all aspects of data processing. You can build solutions that are unrivaled in capability and performance because they allow your code to directly control all aspects of the FairCom DBengine. These APIs retrieve record buffers from disk or cache and directly load them into application memory. This approach is exceptionally fast and works best for applications that run on the same computer as the FairCom DBserver.

Section	Description
Java CTDB quick start	Tutorials for working with record buffers using the JTDB API.
Java CTDB API	Reference guide for using the c-tree Database in Java — this API is called JTDB.
JPA Hibernate Tutorial	Tutorials for using the JPA and Hibernate to build Java applications using FairCom's JDTB API.
Full text search	Guide for using the full-text search.
Troubleshooting tips	Answers to common problems.

FairCom offers a suite of JSON-based APIs designed for Java developers to streamline database integration and management. JSON API Overview: JSON DB Concepts – Guide to understanding and using the JSON DB API. JSON DB API – Reference for working with FairCom’s JSON-based database API. jsonAction API – Core pattern used across FairCom APIs for managing data and integration. JSON DB Tutorial – A step-by-step guide tailored for Java developers. SQL for Java Developers: JDBC Quick Start – Tutorials for using FairCom’s JDBC driver in Java. JDBC Developer Guide – Best practices for integrating FairCom DB SQL into Java applications. Stored Procedures – Guides for implementing SQL stored procedures and triggers using Java and C#. SQL Operations – Advanced SQL features, utilities, and optimizations. Record Buffer APIs for Java: FairCom’s JTDB API allows low-level data control for high-performance applications: Java CTDB Quick Start – Guide to working with record buffers. Java CTDB API – Reference for FairCom’s c-tree Database API in Java. JPA Hibernate Tutorial – Instructions for building Java applications using JPA and Hibernate.

Java JSON DB API: JSON-based database management, structured queries, schema-less data handling jsonAction API: Core API pattern for database operations and data integration JDBC & SQL: Java connectivity, SQL queries, stored procedures, triggers Record Buffer APIs: Low-level data control, CTDB API, JTDB API, high-performance processing JPA & Hibernate: Object-relational mapping, Java database application development Installation & Troubleshooting: FairCom installation guides, SQL error codes, performance tuning