support: Customer Portal
Focused on delivering choice, investment protection and flexibility to organizations with valuable COBOL assets
 

Veryant Knowledge Base
Home > All Categories > Data Access > RDBMS > Where can I get products and services for Postgres (PostgreSQL)?
Question Title Where can I get products and services for Postgres (PostgreSQL)?

isCOBOL supports Postgres (PostgreSQL) in two ways:

  1. Through a built-in COBOL/ESQL compiler which translates EXEC SQL statements to JDBC
  2. Through isCOBOL ESQL Generator which creates bridge programs that route COBOL indexed file I/O statements to Postgres through JDBC
For sample programs see the samples installed with your SDK. An example of #1 above is here: $ISCOBOL%sampledata-accessesql and an example of #2 is here: %ISCOBOL%sampleeasydbpostgres
For each of these methods you'll need the JDBC url and driver. The syntax for the jdbc url is:
   jdbc:postgresql://:<Port>/<DatabaseName>?user=<UserName>&password=<Password>
For example:
   iscobol.jdbc.driver=org.postgresql.Driver
   iscobol.jdbc.url=jdbc:postgresql://localhost/postgres?user=postgres&password=manager
PostgreSQL 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/

Authored by: Veryant Support This question has been viewed 8665 times so far.
Click Here to View all the questions in RDBMS category.
File Attachments File Attachments
There are no attachment file(s) related to this question.
How helpful was this article to you?
User Comments User Comments Add Comment
There are no user comments for this question. Be the first to post a comment. Click Here
Related Questions Related Questions
  1. How do I set up JDBC to communicate with Oracle database?
  2. Where is the Microsoft SQL Server 2005 JDBC Driver?
  3. Trying to work with MS SQL I get the error "JRE (Java Runtime Environment) version 1.7 is not supported by this driver. use classlibrary sqljdbc4.jar witch supports JDBC 4.0".
  4. Does Oracle Pro*COBOL work with isCOBOL?
  5. Can isCOBOL access Oracle, MS SQL and other RDBMS?
  6. How to manage a large COBOL OCCURS on a Database with Database Bridge
Article Information Additional Information
Article Number: 155
Created: 2010-11-09 2:58 PM
Rating: 1 Star
 
Article Options Article Options
Print Question Print this Question
Email Question Email Question to Friend
Export to Adobe PDF Export to PDF File
Export to MS Word Export to MS Word
Bookmark Article
Subscribe to Article Subscribe to Article
 
Search Knowledge Base Search Knowledge Base



 
 

© Veryant - All Rights Reserved
Veryant and isCOBOL are trademarks or registered marks of Veryant in the United States and other countries. All other marks are the property of their respective owners.