Stefan Zeuch
Stefan Zeuch

Reputation: 141

Executing a Progress Database Query (4GL) using JDBC or ODBC

Is there any way to execute a Progress query (4GL) using JDBC or ODBC in a Java project?

I've connected to the database and have to query the database using Progress (4GL). But the JDBC / ODBC only supports SQL queries, so it gives a syntax error.

Open Edge Database Version: 11.3.2

Upvotes: 0

Views: 1067

Answers (1)

Tim Kuehn
Tim Kuehn

Reputation: 3251

JDBC/ODBC is SQL-only.

If you want a Progress style query, you need to make a Webspeed, WSA or REST connection and pass the query string to the server-side software to execute the query.

For a WSA / REST call, this'll require an appserver, with an attendant license. You may be able to get away with using Ganimede or Blue Diamond as a webspeed client if you're doing local dev work.

Upvotes: 1

Related Questions