Where can I get products and services for Postgres (PostgreSQL)?
Estimated Reading Time: 1 MinutesisCOBOL supports Postgres (PostgreSQL) in two ways:
- Through a built-in COBOL/ESQL compiler which translates EXEC SQL statements to JDBC
- Through isCOBOL ESQL Generator which creates bridge programs that route COBOL indexed file I/O statements to Postgres through JDBC
For each of these methods you'll need the JDBC url and driver. The syntax for the jdbc url is:
jdbc:postgresql://For example::<Port>/<DatabaseName>?user=<UserName>&password=<Password>
iscobol.jdbc.driver=org.postgresql.Driver iscobol.jdbc.url=jdbc:postgresql://localhost/postgres?user=postgres&password=managerPostgreSQL can be downloaded from here: https://www.postgresql.org/download/ or here: https://www.enterprisedb.com/software-downloads-postgres
The PostgreSQL JDBC driver can be downloaded from http://jdbc.postgresql.org/download.html
The Postgres JDBC jar file must be in the CLASSPATH. The easiest way to do this is to put it into the %ISCOBOL%jar folder, which the runtime checks automatically
To create a test database, run pgAdmin III from "Start Menu" > "PostgreSQL 9.0". Right-click on the server "PostgreSQL 9.0" and Connect. Right-click on Databases and select "New Database...". Name the database "test" and take all of the defaults.
You can find Postgres products and services here: https://www.postgresql.org/