Postgre odata

, , ,
1

Detailed explanation of the problem:

Hi, i’m trying to create an OData services attached to a postgreSQL.

I configured my connection like this and the connection is enabled :

image
image476×596 18.6 KB

I created my odataServices successfully :
image

But an error ocurred :

image
image1910×239 31.7 KB

It looks like the request isn’t well formed postgre need double quotes like this :
select hi.“ID_INTERACTION” from “SCH_HIST_INT”.“HIST_INTERACTIONS” hi order by 1 offset 0 fetch next 10 rows only
rather than :
select ID_INTERACTION from SCH_HIST_INT.HIST_INTERACTIONS hi order by 1 offset 0 fetch next 10 rows only

I found this information
webMethods Adapter for JDBC Documentation (softwareag.com)

And try the parameter at true and false with no change.

Do you have any idea what i am missing?

Product/components used and version/fix level:

IS 10.11
DBB : POSTGRE 9.4
Driver : postgresql-42.7.1.jar

2

Is there any fix applied to your JDBC driver and/or IS? These kind of bugs are usually fixed after installing the latest fixes unless the version very recent. I recommend installing the latest fixes and check if it solves your issue.

3

Any reason to use such an ancient version of PostgreSQL? It has been EOL for a few years now with v12 being the oldest that is still supported.

4

Thank you for your answers.

I tried with new database with postgre V16
I tried with an IS updated with recent fixe.

But i still have the same behaviour.

The connection in the jdbc adapter seems to ignore the attribute, that should enclose with quote the element of the request.
image

5

I may be totally wrong here. But doesn’t the mixed upper/lower-case nature of the error indicate that case sensitivity should actually be turned off?

Edit: Besides it is my understanding that PostgreSQL is by default case-sensitive.