At one point I was running Posgress 11 but my Infor Application location point failed with a JDBC exception. At Infor's recommendation I downgraded to Postgress 10. The Grid and Enterprise Connector have clean installs, the Grid service starts. I defined a database and generate the "cor" tables. The Infor Applicatoin point Tests OK. However, when I use the Application Connection point in a Data Flow, the excepton returns
Event Type
|
Delivery failed, retry started
|
|
Event Description
|
See the error reason below.
|
|
Event Date-Time
|
Nov 13, 2019, 10:00:26 AM
|
|
Error Reason
|
Could not open JDBC Connection for transaction; nested exception is java.lang.RuntimeException: Cannot create PoolableConnectionFactory (This ResultSet is closed.)
|
|
There are 3 different drivers in play here....grid application Enterprise Connector and Messaging Service use inconsistent drivers , then the runtime is considerably higher. According to Postgress If you are using Java 8 or newer then you should use the JDBC 4.2 version. The application drivers appear to be lagging. I will consider escalating this matter to the community and see if there are others running Postgress 10 or 11.
c:Program FilesInforIONEnterpriseConnectorgridapplicationsIONEnterpriseConnectorappdatalib
11/13/2019 06:47 AM 587,064 postgresql-9.3-1100-jdbc41.jar
c:Program FilesInforIONEnterpriseConnectorgridapplicationsIONMessagingServiceappdatalib
11/13/2019 06:47 AM 648,601 postgresql-9.4.1208.jar
c:Program FilesInforIONEnterpriseConnector
untimes2.0.20190823-102958driverspostgresql
08/22/2019 02:04 AM 825,943 postgresql-42.2.5.jar
Does anoyone have Postgress 10 or 11 Infor Applicatoin or Database connection point working in a Data Flow ?
