Open COBOL ESQL 4j

Open COBOL ESQL 4j (OCESQL 4j) consits of open-source Embedded SQL pre-compiler and run time libraries for opensource COBOL 4j.

Requirements

• Open-source database. OCESQL 4j currently supports PostgreSQL database only.

• opensource COBOL 4j v1.0.2 or later.

• sbt(Optional).

Installation

Install the pre-compiler:

Run the following commands.

./configure
make
make install

Install runtime libraries:

JDBC driver

Download the PostgreSQL JDBC driver and add the path to $CLASSPATH.

ocesql4j.jar

Download the runtime library ocesql4j.jar in Release page and add the path to $CLASSPATH.

Build ocesql4j.jar from source codes (Optional)

1. Put the libcobj.jar (runtime library of opensource COBOL 4j) into dblibj/lib/.
2. Move to dblibj directory and launch sbt.
3. Run assembly command to create dblibj/target/scala-2.13/ocesql4j.jar.

Usage

Usage manuals is under construction. See test cases or sample programs.

TODO

• Implement Prepared Statement.
• Support other COBOL data types (COMP5, Japanese, ... etc).
• Add test cases.
  • tests for SQL CA(communication area).
  • tests for SQL data types.
• Set up test environments using Github Actions.
• Create docker images.